Thanks.<br>I have already logged on to the mysql server and granted all the privileges to the user that was being rejected at kamailio's database authentication... And i still get the same error. <br><br>What i don't understand is that in Kamailio's config file, whether i set the db_url parameter to the "root" user or to the "openser" one:<br>
<br><b>modparam("uri_db", "db_url", "mysql://root:<font size="1"><i><password></i></font>@localhost/openser")</b><br>or<br><b>modparam("uri_db", "db_url", "mysql://openser:<font size="1"><i><password></i></font>@localhost/openser")</b><br>
<br>i get indifferently "<b>Access denied for user '<span style="color: rgb(255, 0, 0);">openser</span>'@'localhost' (using password: YES)</b>".<br><br>I think there is a configuration problem somewhere in kamailio's files, somewhere else than in the kamailio.cfg file... I tried to grep "openser" but got nothing relevant.<br>
<br>Ideas?<br>Thanks in advance.<br><br>Regards,<br>Sara<br><br><br><br><br><div class="gmail_quote">On Mon, Mar 16, 2009 at 11:20 AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com">miconda@gmail.com</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;"><div class="im"><br>
<br>
On 03/11/2009 04:32 PM, Sara EL KABIRI wrote:<br>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
<br><div><div></div><div class="h5">
In fact, the issue is still there.<br>
I explain:<br>
<br>
I had added this line to the config file to set xml-rpc's listening port:<br>
*/modparam("mi-xmlrpc", "port", 8000)/*<br>
And that was when kamailio couldn't start. I removed the said line, and tried to restart kamailio. I got this in return:<br>
*/~$ sudo /etc/init.d/kamailio start<br>
<br>
Listening on<br>
udp: 127.0.0.1 [127.0.0.1]:5065<br>
udp: 192.168.0.99 [192.168.0.99]:5065<br>
tcp: 127.0.0.1 [127.0.0.1]:5065<br>
tcp: 192.168.0.99 [192.168.0.99]:5065<br>
Aliases:<br>
tcp: ims-desktop.local:5065<br>
tcp: localhost:5065<br>
udp: ims-desktop.local:5065<br>
udp: localhost:5065/*<br>
<br>
I thought everything was ok, but it wasn't. I tried */netstat -anp/* to see if the server was really listenning upon port 5065, it wasn't. Then i tried */kamctl moni/* and there was appearently a problem:<br>
*/<br>
~$ sudo kamctl moni<br>
<br>
ERROR: Error opening Kamailio's FIFO /tmp/kamailio_fifo<br>
ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name", "/tmp/kamailio_fifo")' in your config<br>
ERROR: and also have loaded the mi_fifo module./*<br>
<br>
I allowed syslog_error in the config file, and tried to restart kamailio. And here's what i got:<br>
<br>
*/~$ sudo /etc/init.d/kamailio start<br>
<br>
Listening on<br>
udp: 127.0.0.1 [127.0.0.1]:5065<br>
udp: 192.168.0.99 [192.168.0.99]:5065<br>
tcp: 127.0.0.1 [127.0.0.1]:5065<br>
tcp: 192.168.0.99 [192.168.0.99]:5065<br>
Aliases:<br>
tcp: ims-desktop.local:5065<br>
tcp: localhost:5065<br>
udp: ims-desktop.local:5065<br>
udp: localhost:5065<br>
<br>
Mar 11 11:02:20 [11473] INFO:core:init_tcp: using epoll_lt as the TCP io watch method (auto detected)<br>
Mar 11 11:02:20 [11475] NOTICE:core:main: version: kamailio 1.4.3-notls (i386/linux)<br>
Mar 11 11:02:20 [11475] INFO:core:main: using 32 Mb shared memory<br>
Mar 11 11:02:20 [11475] INFO:core:main: using 1 Mb private memory per process<br>
Mar 11 11:02:20 [11475] INFO:sl:mod_init: Initializing StateLess engine<br>
Mar 11 11:02:20 [11475] INFO:tm:mod_init: TM - initializing...<br>
$ Mar 11 11:02:20 [11475] INFO:maxfwd:mod_init: initializing...<br>
Mar 11 11:02:20 [11475] INFO:usrloc:ul_init_locks: locks array size 512<br>
Mar 11 11:02:20 [11475] INFO:registrar:mod_init: initializing...<br>
Mar 11 11:02:20 [11475] INFO:textops:mod_init: initializing...<br>
Mar 11 11:02:20 [11475] INFO:xlog:mod_init: initializing...<br>
Mar 11 11:02:21 [11475] INFO:acc:mod_init: initializing...<br>
Mar 11 11:02:21 [11475] INFO:auth:mod_init: initializing...<br>
Mar 11 11:02:21 [11475] INFO:auth_db:mod_init: initializing...<br>
Mar 11 11:02:21 [11475] NOTICE:presence:mod_init: initializing module ...<br>
Mar 11 11:02:21 [11475] INFO:presence:restore_db_subs: The query returned no result<br>
Mar 11 11:02:21 [11475] ERROR:db_mysql:db_mysql_new_connection: driver error: Access denied for user 'openser'@'localhost' (using password: YES)<br>
Mar 11 11:02:21 [11475] ERROR:core:db_do_init: could not add connection to the poolMar 11 11:02:21 [11475] ERROR:usrloc:register_udomain: failed to open database connection<br>
Mar 11 11:02:21 [11475] ERROR:registrar:domain_fixup: failed to register domain<br>
Mar 11 11:02:21 [11475] ERROR:core:fix_actions: fixing failed (code=-1) at cfg line 324<br>
Mar 11 11:02:21 [11475] CRITICAL:core:fix_expr: fix_actions error<br>
Mar 11 11:02:21 [11475] ERROR:core:main: failed to fix configuration with err code -1<br>
Mar 11 11:02:21 [11475] NOTICE:presence:destroy: destroy module .../*<br>
<br>
<br>
I tried to log on MySQL database as root user, and i got exactly the same error.<br>
I can't understand why it says */"Access denied for user 'openser'@'localhost' (using password: YES)" /*even when i log on as root, <br>
</div></div></blockquote>
<br>
You have to rea the mysdl manual and learn how to grant privileges to users and why this error appears. If someone else installed mysql for you, ask him for the root password and how to legin to the mysql server.<div class="im">
<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
and i don't undestand the meaning of the last line */"Mar 11 11:02:21 [11475] NOTICE:presence:destroy: destroy module .../* " (may i recall that i want to use Kamailio as a presence server).<br>
</blockquote>
<br></div>
This is a notice message that the module is destroying internal structure, it is nothing to worry about.<br>
<br>
Cheers,<br><font color="#888888">
Daniel<br>
<br>
<br>
</font><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">
<br>
<br>
Thanks in advance for your help.<br>
Cheers,<br>
Sara<br>
<br>
<br>
<br></div><div class="im">
On Wed, Mar 11, 2009 at 11:22 AM, Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a> <mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>> wrote:<br>
<br>
Please cc all the time to mailing lists.<br>
<br>
If you reported an issue and solved it, then it is nice to close<br>
the discussion thread by saying what was wrong and how was solved.<br>
Others coming later and reading mailing list archive can learn<br>
from your experience.<br>
<br>
Thanks,<br>
Daniel<br>
<br>
<br>
<br>
On 03/11/2009 10:47 AM, Sara EL KABIRI wrote:<br>
<br>
Hello,<br>
<br>
Thanks a lot for you help.<br>
I've already solved the problem :-)<br>
<br>
Regards,<br>
Sara<br>
<br>
On Wed, Mar 11, 2009 at 8:09 AM, Daniel-Constantin Mierla<br>
<<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a> <mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>><br></div><div><div></div><div class="h5">
<mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a> <mailto:<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>>> wrote:<br>
<br>
Hello,<br>
<br>
<br>
On 03/09/2009 08:48 PM, Sara EL KABIRI wrote:<br>
<br>
<br>
Hello,<br>
<br>
I've installed kamailio 1.4.3 (without tls) on ubuntu by<br>
following the provided INSTALL guide. I want to use it as a<br>
presence server but i've got some problems starting it.<br>
<br>
"kamctl start" returns nothing.<br>
<br>
check the syslog file for errors. There you can get some hint.<br>
<br>
Alternatively, set log_stderror=yes in your config file and run<br>
"kamailio" (/usr/sbin/kamailio or /usr/local/sbin/kamailio if<br>
installed from sources) and see what you get on the screen.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
and "kamctl moni" returns "Error opening kamailio's FIFO<br>
/tmp/kamailio_fifo"<br>
I've checked in my .cfg file and the 'loadmodule' and<br>
'modparam' lines related to mi-fifo module are uncommented.<br>
I've checked also the mi-fifo module was installed indeed<br>
(mi_fifo.so appears in /usr/local/lib/kamailio/modules<br>
directory).<br>
<br>
<br>
Could anyone help please?<br>
<br>
--<br>
Sara<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Kamailio (OpenSER) - Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>><br>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
<mailto:<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a>>><br>
<br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<a href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
-- Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<br>
<br>
<br>
<br>
-- S.<br>
<br>
<br>
-- Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<br>
<br>
<br>
<br>
-- <br>
S.<br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Kamailio (OpenSER) - Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org" target="_blank">Users@lists.kamailio.org</a><br>
</div></div><div class="im"><a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<a href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a><br>
</div></blockquote><div><div></div><div class="h5">
<br>
-- <br>
Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>S.<br>