Hi Bogdan,<br><br>Finally I was able to solve the issue by downloading and installing the no-tls version which is "opensips-1.4.4-notls_src.tar.gz" from <a href="http://opensips.org">opensips.org</a> website. So I feel that scripts located or packaged with "opensips-1.4.4-tls_src.tar.gz" might still have issues. Also I would like to admit that I wanted the no-tls version currently but in future we may need tls version too. Are there any changes w.r.t to opensipsctl and other such scripts between tls version and no-tls version?<br>
<br>Regards,<br>Ranga<br><br><div class="gmail_quote">On Wed, Feb 18, 2009 at 8:29 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
When setting the "DBENGINE=MYSQL ", what is the output on opensipsctl ?<div><div></div><div class="Wj3C7c"><br>
<br>
Regards,<br>
Bogdan<br>
<br>
Ranganath B wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Bogdan,<br>
<br>
I have already configured the DBENGINE=MYSQL in the opensipsctlrc<br>
file. Not sure why these parameters are not being read from that file?<br>
Any pointers?<br>
<br>
Regards,<br>
Ranga<br>
<br>
On 2/18/09, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>> wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Ranga,<br>
<br>
You must not force manually the DBENGINELOADED !! you have to set<br>
DBENGINE=MYSQL in the opensipsctlrc file.<br>
<br>
<br>
Regards,<br>
Bogdan<br>
<br>
Ranganath B wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Bogdan,<br>
<br>
I am using MySQL as the backend DB and I am trying to run the<br>
following commands:<br>
<br>
1) /usr/local/sbin/opensipsctl domain add "<a href="http://opensips.net" target="_blank">opensips.net</a><br>
<<a href="http://opensips.net" target="_blank">http://opensips.net</a>>" - To add domain. Also I found that adding<br>
domain command does not exist anymore.<br>
2) /usr/local/sbin/opensipsctl add alice alice - To add subscriber<br>
"alice" with password "alice"<br>
<br>
But previous to the below mentioned errors I was getting another error<br>
saying that the DBENGINELOADED cannot be read so I did a hardcode in<br>
the opensipsctl file with "DBENGINELOADED=1".<br>
<br>
Please correct me if I am doing something wrong.<br>
<br>
Regards,<br>
Ranga<br>
<br>
<br>
On Tue, Feb 17, 2009 at 10:26 PM, Bogdan-Andrei Iancu<br>
<<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a> <mailto:<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>>> wrote:<br>
<br>
Hi Ranga,<br>
<br>
What DB backend are you using ? MySQL.? Postgres?<br>
<br>
Also, what is the exact command you are running?<br>
<br>
Regard,<br>
Bogdan<br>
<br>
Ranganath B wrote:<br>
<br>
<br>
Hi,<br>
<br>
I installed the opensips version 1.4.4 and when I try to add<br>
subscribers or domain in the database I get the following error<br>
messages respectively:<br>
<br>
/usr/local/sbin/opensipsctl: line 197: select count(*) from<br>
subscriber where username='alice' and domain='<a href="http://opensips.net" target="_blank">opensips.net</a><br>
<<a href="http://opensips.net" target="_blank">http://opensips.net</a>><br>
<<a href="http://opensips.net" target="_blank">http://opensips.net</a>>';: command not found<br>
<br>
INFO: user 'alice' already exists<br>
<br>
/usr/local/sbin/opensipsctl: line 215: select count(*) from<br>
domain<br>
where domain='<a href="http://opensips.net" target="_blank">opensips.net</a> <<a href="http://opensips.net" target="_blank">http://opensips.net</a>><br>
<<a href="http://opensips.net" target="_blank">http://opensips.net</a>>';: command not found<br>
INFO: <a href="http://opensips.net" target="_blank">opensips.net</a> <<a href="http://opensips.net" target="_blank">http://opensips.net</a>><br>
<<a href="http://opensips.net" target="_blank">http://opensips.net</a>> already in domain table<br>
<br>
<br>
I am not able to proceed with the testing, kindly help me in<br>
resolving the issue with opensips.<br>
<br>
For your kind reference I have attached the opensipsctl<br>
file too.<br>
<br>
Thanks in advance,<br>
Ranga<br>
<br>
<br>
<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a> <mailto:<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
<br>
<br>
<br>
</blockquote>
<br>
</blockquote>
<br>
<br>
</blockquote>
<br>
</div></div></blockquote></div><br>