<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 Bogdan-Andrei<br>
<br>
<small>This is not a big issue for me because I added the values
for database connectivity into</small> <small>osipsconsole
script, and it works fine for me.</small> <small>My idea was to
share this so it can be fixed in future revisions (if
necessarry), otherwise I'm fine.</small> <br>
<br>
<small>My OpenSIPS installation is in a lab environment within my
local LAN and it's not accessible from the internet. BUt if you
really want to take a look to try to find the root cause to fix
in </small><small><small>future revisions</small>, then I'm
happy to allow you access to the network.<br>
<br>
Ciao<br>
<br>
Mimi</small><br>
<br>
On 14/12/2012 12:22, Bogdan-Andrei Iancu wrote:<br>
</div>
<blockquote cite="mid:50CB19FA.2060805@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<tt>Strange, I would say .... It may be something really
particular to your setup or so.<br>
<br>
I there any possibility to investigate it directly on the system
?<br>
<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/13/2012 09:30 PM, Mimi Cafe wrote:
<blockquote cite="mid:50CA2CB8.60302@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix"><small><br>
I have looked at my command history and as you can see
below, I pulled version 1.8 from the svn branch (that was
before you fixed the osipsconfig two days ago).<br>
<br>
<br>
640 sudo svn co <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.8">https://opensips.svn.sourceforge.net/svnroot/opensips/branches/1.8</a>
opensips-1.8<br>
641 cd opensips-1.8/<br>
642 sudo make menuconfig<br>
<br>
Also, version info shows reveal the following:<br>
<br>
version: opensips 1.8.2-notls (x86_64/linux)<br>
flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE,
USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC,
FAST_LOCK-ADAPTIVE_WAIT<br>
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144,
MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535<br>
poll method support: poll, epoll_lt, epoll_et, sigio_rt,
select.<br>
svnrevision: 2:9454M<br>
@(#) $Id: main.c 9330 2012-10-16 17:25:38Z bogdan_iancu $<br>
main.c compiled on 11:53:21 Nov 28 2012 with gcc 4.4.6<br>
<br>
<br>
Hope this helps.<br>
<br>
Mimi</small><br>
<br>
<br>
<br>
On 13/12/2012 13:56, Bogdan-Andrei Iancu wrote:<br>
</div>
<blockquote cite="mid:50C9DE85.4080309@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<tt>Hi,<br>
<br>
Just made a test, using "make menuconfig", setting a install
path to "/tmp/foo" -><br>
<br>
$ grep PATH_CTLRC /tmp/foo/sbin/osipsconsole <br>
my $PATH_CTLRC = "/tmp/foo//etc/opensips/";<br>
if ( -e $PATH_CTLRC . "osipsconsolerc" ) {<br>
$OSIPSCONSOLERC = $PATH_CTLRC . "osipsconsolerc";<br>
<br>
It looks like the path to RC was properly set.<br>
<br>
Are you sure you are using the latest 1.8 SVN branch (1.8.2)
?<br>
<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/12/2012 10:12 PM, Mimi Cafe wrote:
<blockquote cite="mid:50C8E51C.90500@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix"><small><small>Hi Bogdan<br>
<br>
I used the graphical interface by executing "make
menuconfig". I then specified the installation path as
"/usr/local/opensips_proxy/" and everything is
installed within /usr/local/opensips_proxy/ and the
config files are in
/usr/local/opensips_proxy/etc/opensips. <br>
<br>
It should be noted that, opensips is able find the
other config files in
/usr/local/opensips_proxy/etc/opensips, but it fails
to find osipconsolerc.<br>
<br>
Mimi<br>
<br>
<br>
</small></small>On 12/12/2012 12:22, Bogdan-Andrei Iancu
wrote:<br>
</div>
<blockquote cite="mid:50C8771D.8040702@opensips.org"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<tt>Mimi, when doing "make install", the osipsconsile </tt><small>$PATH_CTLRC
is automatically updated with the installation path
(prefix variable). So, how did you compile and install
opensips (the exact commands) ?<br>
<br>
Regards,<br>
</small>
<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/12/2012 01:37 PM, Mimi Cafe wrote:
<blockquote cite="mid:50C86C5E.5080909@gmail.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<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>
</blockquote>
</blockquote>
<br>
</blockquote>
</blockquote>
<br>
</blockquote>
</blockquote>
<br>
</body>
</html>