[OpenSIPS-Users] osipsconsole address failed

[Mimi Cafe]

Hi

I have updated osipsconsole via svn and it appears the previous issue is 
resolved, but I now see two more issues.

The mattern below does not match the dot in netmask $cmd[4] !~ 
/^[0-9]+$/. This seem to look for only one octet?

if ( $cmd[4] !~ /^[0-9]+$/ || $cmd[4] < 0 || $cmd[4] > 32 ) {
                                 print "mask '$cmd[4]' is not valid - it 
must be between 0 and 32 (biti)\n";
                                 return;
                         }


The resulting error is:

Control engine FIFO loaded
Used database is mysql
Warn fallback to local workdir ./mysql
mask '255.255.255.255' is not valid - it must be between 0 and 32 (biti)
[sbin]$ sudo ./osipsconsole address add 0 192.168.1.192 255.255.255.0 
5060 UDP
which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)
Control engine FIFO loaded
Used database is mysql
Warn fallback to local workdir ./mysql
mask '255.255.255.0' is not valid - it must be between 0 and 32 (biti)


The other (trivial) issue is that osipsconsole does not use the database 
parameters specified in my osicpsconsolerc. Instead, it attempts to use 
detail values here.

[sbin]$ sudo ./osipsconsole address add 0 192.168.1.192 255.255.255.255 
5060 UDP
which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)
which: no db4.4_dump in (/sbin:/bin:/usr/sbin:/usr/bin)
Control engine FIFO loaded
Used database is mysql
Warn fallback to local workdir ./mysql
Failed to connect the configured Database 
(database=opensips;host=localhost;user=opensips)[babs at mognoreborder 
sbin]$ sudo vim osipsconsole

Mimi


On 10/12/2012 14:38, Bogdan-Andrei Iancu wrote:
> Hi Mimi,
>
> I made some fixes in osipsconsole on SVN (trunk and 1.8 branch) - 
> please update and let me know if now works for you.
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developer
> http://www.opensips-solutions.com
>
>
> On 12/08/2012 11:00 PM, Mimi Cafe wrote:
>> I attempted using osipsconsole to add a gateway address, but it 
>> failed because there is no data in the dbaliases table. How is this 
>> linked to the dbaliases tables? What is the prerequisite to adding a 
>> gateway address in addresses table?
>>
>> osipsconsole address add 0 192.168.18.89 255.255.255.255 5060 UDP
>>
>> Control engine FIFO loaded
>> Used database is mysql
>> Retrieving data from table failedYou have an error in your SQL 
>> syntax; check the manual that corresponds to your MySQL server 
>> version for the right syntax to use near 'WHERE ip='192.168.18.89'' 
>> at line 1
>> Introducing the address rule 0 192.168.18.89 255.255.255.255 5060 UDP 
>> to the database failed
>> You have an error in your SQL syntax; check the manual that 
>> corresponds to your MySQL server version for the right syntax to use 
>> near '( grp, ip, mask, port, proto , context_info ) VALUES ( 0, 
>> '192.168.18.89', '255.' at line 1
>>
>>
>> Mimi
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121211/daa1b12a/attachment-0001.htm>