<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Hi Mimi,<br>
<br>
starting with 1.7 (if I remember correctly), the address mask is
not anymore as 255.255.255.0, but as length 24 (number of bites).
So, the osipsconsole works the same now.<br>
<br>
Simply do: <small>osipsconsole address add 0 192.168.1.192 24
5060 UDP</small><br>
<br>
<br>
Regarrding the DB issue - do you use osipsconsole from the source
tree or installed ? if installed, what is the path of osipsconsole
and what is the path of osipsconsolerc ? BTW, what version of
opensips are you using ?<br>
</tt><tt><br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<br>
On 12/11/2012 11:17 PM, Mimi Cafe wrote:
<blockquote cite="mid:50C7A2EB.9020909@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<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 moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a moz-do-not-send="true" 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>
</blockquote>
</body>
</html>