<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"><small>Thanks for your input. It
explains why I couldn't add the new gateway earlier on. it now
worked fine with 24 bit mask.<br>
<br>
I'm running version 1.8 (sorry I forgit to mention it), and
osipconsole and osipconsolerc are installed in the paths below.<br>
<br>
-rwxr-xr-x. 1 opensips opensips 202930 Dec 11 20:33
/usr/local/opensips_proxy/sbin/osipsconsole<br>
-rw-r--r--. 1 opensips opensips 2978 Dec 8 20:21
/usr/local/opensips_proxy/etc/opensips/osipsconsolerc<br>
<br>
Looking in osipsconsole again, I now realise $PATH_CTLRC =
"./scripts/" could be the reason why the config script is not
found. Is this the case?<br>
<br>
<br>
Cheers<br>
<br>
Mimi</small><br>
<br>
<br>
On 12/12/2012 10:37, Bogdan-Andrei Iancu wrote:<br>
</div>
<blockquote cite="mid:50C85E59.2090707@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
<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 moz-do-not-send="true" 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>
</blockquote>
<br>
</body>
</html>