I answer to myself (and hope it will help others):<br><br>the issue was due to my server MySQL that was bound to <a href="http://127.0.0.1">127.0.0.1</a> !<br><br>-pascal<br><br><div class="gmail_quote">On Thu, Apr 17, 2008 at 2:51 PM, Pascal Maugeri <<a href="mailto:pascal.maugeri1@gmail.com">pascal.maugeri1@gmail.com</a>> 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="Ih2E3d">You're right Bogdan, I changed my configuration to connect to localhost:<br>
<br></div><div class="Ih2E3d">modparam("usrloc", "db_url", "mysql://openser:openserrw</div><div class="Ih2E3d"><div>@localhost/openser")<br>
<br>Thanks for your prompt reply !<br>
<br>Now it works very well.<br><br>just for curiosity, is it important
that the DBHOST in the file openserctl file match the host used in
openser.cfg for db_url ? Are these two parameters independent ?<br><br>Regards,</div><br><br></div><div class="gmail_quote"><div class="Ih2E3d">On Thu, Apr 17, 2008 at 2:32 PM, Bogdan-Andrei Iancu <<a href="mailto:bogdan@voice-system.ro" target="_blank">bogdan@voice-system.ro</a>> wrote:<br>
</div><div><div></div><div class="Wj3C7c"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Pascal,<br>
<br>
try to connect with the mysql client (mysql) from the openser machine to the mysql server machine and see if it works.<br>
<br>
Maybe your mysql server is not configured to listen on <a href="http://192.168.1.4" target="_blank">192.168.1.4</a>, but only on <a href="http://127.0.0.1" target="_blank">127.0.0.1</a> (for local connections).<br>
<br>
Regards,<br>
Bogdan<br>
<br>
Pascal Maugeri wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div>
Hi<br>
I have the following error in connection with MySQL when I enable usrloc to use the DB (db_mode=1):<br>
<br>
[...]<br></div>
Apr 17 14:05:48 [32444] DBG:mysql:db_mysql_init: connection 'mysql://<a href="http://openser:openserrw@192.168.1.4/openser" target="_blank">openser:openserrw@192.168.1.4/openser</a> <<a href="http://openser:openserrw@192.168.1.4/openser" target="_blank">http://openser:openserrw@192.168.1.4/openser</a>>' not found in pool<br>
Apr 17 14:05:48 [32444] DBG:mysql:db_mysql_new_connection: opening connection: mysql://<a href="http://xxxx:xxxx@192.168.1.4/openser" target="_blank">xxxx:xxxx@192.168.1.4/openser</a> <<a href="http://xxxx:xxxx@192.168.1.4/openser" target="_blank">http://xxxx:xxxx@192.168.1.4/openser</a>><br>
Apr 17 14:05:48 [32444] ERROR:mysql:db_mysql_new_connection: driver error: Can't connect to MySQL server on '<a href="http://192.168.1.4" target="_blank">192.168.1.4</a> <<a href="http://192.168.1.4" target="_blank">http://192.168.1.4</a>>' (111)<div>
<br>
Apr 17 14:05:48 [32444] ERROR:usrloc:register_udomain: failed to open database connection<br>
Apr 17 14:05:48 [32444] ERROR:registrar:domain_fixup: failed to register domain<br>
Apr 17 14:05:48 [32444] ERROR:core:fix_actions: fixing failed (code=-1) at cfg line 323<br>
[...]<br>
<br>
My configuration file is:<br>
<br>
loadmodule "mysql.so"<br>
loadmodule "sl.so"<br>
loadmodule "tm.so"<br>
loadmodule "rr.so"<br>
loadmodule "maxfwd.so"<br>
loadmodule "usrloc.so"<br>
[...]<br>
<br>
# ----- usrloc params -----<br>
modparam("usrloc", "db_mode", 1)<br></div>
modparam("usrloc", "db_url", "mysql://<a href="http://openser:openserrw@192.168.1.4/openser" target="_blank">openser:openserrw@192.168.1.4/openser</a> <<a href="http://openser:openserrw@192.168.1.4/openser" target="_blank">http://openser:openserrw@192.168.1.4/openser</a>>")<div>
<br>
<br>
I see that mysql server is started and I've managed at installation to create the openser DB (using openserdbctl create).<br>
<br>
Could you help me doing the troubleshooting of this ? What else should I verify ?<br>
<br>
Regards,<br>
Pascal<br></div>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.openser.org" target="_blank">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
<br>
</blockquote></div></div></div><br>
</blockquote></div><br>