<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi<br>
<br>
<small>I have updated osipsconsole via svn and it appears the
previous issue is resolved, but I now see two more issues.<br>
<br>
The mattern below does not match the dot in netmask $cmd[4] !~
/^[0-9]+$/. This seem to look for only one octet? <br>
<br>
if ( <font color="#ff0000">$cmd[4] !~ /^[0-9]+$/ || $cmd[4]
< 0 || $cmd[4] > 32</font> ) {<br>
print "mask '$cmd[4]' is not
valid - it must be between 0 and 32 (biti)\n";<br>
return;<br>
}<br>
<br>
<br>
The resulting error is:<br>
<br>
Control engine FIFO loaded<br>
Used database is mysql<br>
Warn fallback to local workdir ./mysql<br>
mask '255.255.255.255' is not valid - it must be between 0 and
32 (biti)<br>
[sbin]$ sudo ./osipsconsole address add 0 192.168.1.192
255.255.255.0 5060 UDP<br>
which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)<br>
Control engine FIFO loaded<br>
Used database is mysql<br>
Warn fallback to local workdir ./mysql<br>
mask '255.255.255.0' is not valid - it must be between 0 and 32
(biti)<br>
<br>
<br>
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.<br>
<br>
[sbin]$ sudo ./osipsconsole address add 0 192.168.1.192
255.255.255.255 5060 UDP<br>
which: no md5 in (/sbin:/bin:/usr/sbin:/usr/bin)<br>
which: no db4.4_dump in (/sbin:/bin:/usr/sbin:/usr/bin)<br>
Control engine FIFO loaded<br>
Used database is mysql<br>
Warn fallback to local workdir ./mysql<br>
Failed to connect the configured Database
(database=opensips;host=localhost;user=opensips)[babs@mognoreborder
sbin]$ sudo vim osipsconsole<br>
</small><br>
<small>Mimi</small><br>
<br>
<br>
On 10/12/2012 14:38, Bogdan-Andrei Iancu wrote:<br>
</div>
<blockquote cite="mid:50C5F3E4.50509@opensips.org" type="cite">Hi
Mimi,
<br>
<br>
I made some fixes in osipsconsole on SVN (trunk and 1.8 branch) -
please update and let me know if now works for you.
<br>
<br>
Regards,
<br>
<br>
Bogdan-Andrei Iancu
<br>
OpenSIPS Founder and Developer
<br>
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a>
<br>
<br>
<br>
On 12/08/2012 11:00 PM, Mimi Cafe wrote:
<br>
<blockquote type="cite">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?
<br>
<br>
osipsconsole address add 0 192.168.18.89 255.255.255.255 5060
UDP
<br>
<br>
Control engine FIFO loaded
<br>
Used database is mysql
<br>
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
<br>
Introducing the address rule 0 192.168.18.89 255.255.255.255
5060 UDP to the database failed
<br>
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
<br>
<br>
<br>
Mimi
<br>
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
<br>
<br>
</blockquote>
</blockquote>
<br>
</body>
</html>