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@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
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
