[OpenSIPS-Users] Opensips 1.9 stop working after upgrade

Mon Feb 3 14:59:58 CET 2014

Hello,

I guess you were still using your old database after migrating to 1.9 ?
If yes, you should check out the tips at
     http://www.opensips.org/Documentation/Migration-1-8-0-to-1-9-0

for migrating both DB and script, since 1.9 brings some new columns for 
the subscriber table, which is exactly what OpenSIPS was complaining 
about with those ERROR messages.

Best Regards,

Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com

On 03.02.2014 15:35, Chandra Prakash wrote:
> Hi guys,
>
> Problem is solved, I need to add the extra column 'attr' in aliases table
> and also need to change the version table.
>
> I think it is is a bug, Pls correct me If I'm wrong.
>
> Thanks
>
> -----Original Message-----
> From: Chandra Prakash [mailto:chandraprakash at virtualemployee.com]
> Sent: Monday, February 3, 2014 5:50 PM
> To: 'users at lists.opensips.org'
> Subject: Opensips 1.9 stop working after upgrade
>
> Hi,
>
> I've aupdated the opensips 1.9 after upgrade it stopped working and giving
> this error.
>
> CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1054):
> Unknown column 'attr'                  in 'field list'
> Jan 27 04:56:55 debiansip01 /sbin/opensips[3728]: ERROR:core:db_do_query:
> error while submitting query - [select username,contact,expires,q,cal
> lid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,
> sip_instance,attr from aliases ]
> Jan 27 04:56:55 debiansip01 /sbin/opensips[3728]:
> ERROR:usrloc:preload_udomain: db_query (1) failed Jan 27 04:56:55
> debiansip01 /sbin/opensips[3728]: ERROR:usrloc:child_init: child(1): failed
> to preload domain 'aliases'
> Jan 27 04:56:55 debiansip01 /sbin/opensips[3728]: ERROR:core:init_mod_child:
> failed to initializing module usrloc, rank 1 Jan 27 04:56:55 debiansip01
> /sbin/opensips[3728]: ERROR:core:main_loop: init_child failed for UDP
> listener
>
> Pls help
>
>
> -----Original Message-----
> From: users-bounces at lists.opensips.org
> [mailto:users-bounces at lists.opensips.org] On Behalf Of
> users-request at lists.opensips.org
> Sent: Sunday, February 2, 2014 4:30 PM
> To: users at lists.opensips.org
> Subject: Users Digest, Vol 67, Issue 3
>
> Send Users mailing list submissions to
> 	users at lists.opensips.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
> 	users-request at lists.opensips.org
>
> You can reach the person managing the list at
> 	users-owner at lists.opensips.org
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
>     1. Re: check if ip address belongs to ip and subnet	subscriber
>        (Edwin)
>     2. Re: check if ip address belongs to ip and subnet subscriber
>        (Stefano Pisani)
>     3. Re: check if ip address belongs to ip and subnet	subscriber
>        (Edwin)
>     4. Re: check if ip address belongs to ip and subnet subscriber
>        (Stefano Pisani)
>     5. Re: check if ip address belongs to ip and subnet	subscriber
>        (Edwin)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 1 Feb 2014 08:44:26 -0800 (PST)
> From: Edwin <eahaselhoff at gmail.com>
> Subject: Re: [OpenSIPS-Users] check if ip address belongs to ip and
> 	subnet	subscriber
> To: users at lists.opensips.org
> Message-ID: <1391273066233-7589398.post at n2.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> This helped a bit, so I came up with:
>
> $var(sourceip_net) = $(avp(sourceip_mask){ip.pton}) &
> $(avp(sourceip){ip.pton});
> $var(si_net) = $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton});
>
> if($var(sourceip_net) == $var(si_net))
> {
>      xlog("L_INFO", " ip $si belongs to $au\n"); } else {
>      xlog("L_INFO", " ip $si does not belong to $au\n");
>      sl_send_reply("403", "Forbidden");
>      exit;
> }
>
> But I like to write i like this:
>
> if( [ $(avp(sourceip_mask){ip.pton}) & $(avp(sourceip){ip.pton}) ] == [
> $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton}) ] ) {
>      xlog("L_INFO", " ip $si belongs to $au\n"); } else {
>      xlog("L_INFO", " ip $si does not belong to $au\n");
>      sl_send_reply("403", "Forbidden");
>      exit;
> }
>
> But this gives an error (column 121-123: syntax error, column 121-123: bad
> command!)
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/check-if-ip-address-be
> longs-to-ip-and-subnet-subscriber-tp7589375p7589398.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 01 Feb 2014 17:50:40 +0100
> From: Stefano Pisani <stefano.pisani at omnianet.it>
> Subject: Re: [OpenSIPS-Users] check if ip address belongs to ip and
> 	subnet subscriber
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <52ED25E0.5060006 at omnianet.it>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> why you are using "[]"? use "()" instead.
>
> Il 01/02/2014 17.44, Edwin ha scritto:
>> This helped a bit, so I came up with:
>>
>> $var(sourceip_net) = $(avp(sourceip_mask){ip.pton}) &
>> $(avp(sourceip){ip.pton});
>> $var(si_net) = $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton});
>>
>> if($var(sourceip_net) == $var(si_net)) {
>>       xlog("L_INFO", " ip $si belongs to $au\n"); } else {
>>       xlog("L_INFO", " ip $si does not belong to $au\n");
>>       sl_send_reply("403", "Forbidden");
>>       exit;
>> }
>>
>> But I like to write i like this:
>>
>> if( [ $(avp(sourceip_mask){ip.pton}) & $(avp(sourceip){ip.pton}) ] ==
>> [
>> $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton}) ] ) {
>>       xlog("L_INFO", " ip $si belongs to $au\n"); } else {
>>       xlog("L_INFO", " ip $si does not belong to $au\n");
>>       sl_send_reply("403", "Forbidden");
>>       exit;
>> }
>>
>> But this gives an error (column 121-123: syntax error, column 121-123:
>> bad
>> command!)
>>
>>
>>
>> --
>> View this message in context:
>> http://opensips-open-sip-server.1449251.n2.nabble.com/check-if-ip-addr
>> ess-belongs-to-ip-and-subnet-subscriber-tp7589375p7589398.html
>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 1 Feb 2014 09:15:57 -0800 (PST)
> From: Edwin <eahaselhoff at gmail.com>
> Subject: Re: [OpenSIPS-Users] check if ip address belongs to ip and
> 	subnet	subscriber
> To: users at lists.opensips.org
> Message-ID: <1391274957243-7589400.post at n2.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> I tried () also, but this resulted in an error too ):
>
> For the [] part i followed the docs:
> http://www.opensips.org/Documentation/Script-Operators
> Arithmetic expressions can be used in condition expressions via test
> operator ' [ ... ] '.
>
> But I'm not the expert here, any help is appreciated!
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/check-if-ip-address-be
> longs-to-ip-and-subnet-subscriber-tp7589375p7589400.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 01 Feb 2014 18:37:48 +0100
> From: Stefano Pisani <stefano.pisani at omnianet.it>
> Subject: Re: [OpenSIPS-Users] check if ip address belongs to ip and
> 	subnet subscriber
> To: OpenSIPS users mailling list <users at lists.opensips.org>
> Message-ID: <52ED30EC.7070808 at omnianet.it>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> if( ( $(avp(sourceip_mask){ip.pton}) & $(avp(sourceip){ip.pton}) ) == (
> $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton}) ) ) {
>        xlog("L_INFO", " ip $si belongs to $au\n"); } else {
>        xlog("L_INFO", " ip $si does not belong to $au\n");
>        sl_send_reply("403", "Forbidden");
>        exit;
> }
>
> Why you do not use directly the net address? Why do you need to do
> ($(avp(sourceip_mask){ip.pton}) & $(avp(sourceip){ip.pton})) each time if
> the result is always the same? Put the result in your db instead of
> sourceip.
>
> if( ($(avp(sourceip_mask){ip.pton}) & $(si{ip.pton}) ) ==
> $avp(sourceip_net) ) ...
>
>
>
> Il 01/02/2014 18.15, Edwin ha scritto:
>> I tried () also, but this resulted in an error too ):
>>
>> For the [] part i followed the docs:
>> http://www.opensips.org/Documentation/Script-Operators
>> Arithmetic expressions can be used in condition expressions via test
>> operator ' [ ... ] '.
>>
>> But I'm not the expert here, any help is appreciated!
>>
>>
>>
>> --
>> View this message in context:
>> http://opensips-open-sip-server.1449251.n2.nabble.com/check-if-ip-addr
>> ess-belongs-to-ip-and-subnet-subscriber-tp7589375p7589400.html
>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 1 Feb 2014 14:03:28 -0800 (PST)
> From: Edwin <eahaselhoff at gmail.com>
> Subject: Re: [OpenSIPS-Users] check if ip address belongs to ip and
> 	subnet	subscriber
> To: users at lists.opensips.org
> Message-ID: <1391292208603-7589402.post at n2.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> Stefano,
>
> In fact you have a point. And probably I will put the network address in the
> database.
>
> But still, I hate it when I don't understand why a logical comparison
> doesn't work like I expect it to do.
>
> In this case the output of $(avp(sourceip_mask){ip.pton}) & $(si{ip.pton})
> should be the same as $avp(sourceip_net) and it gives a error.
>
> So, or it is a 'bug' or I do it wrong (sometimes the docs are a little bit
> to summier...)
>
> Is it possible to put == between to ip.xxx statements?
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/check-if-ip-address-be
> longs-to-ip-and-subnet-subscriber-tp7589375p7589402.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> End of Users Digest, Vol 67, Issue 3
> ************************************
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users