<div dir="ltr">Have you granted DB access to Kamailio...?<div><br></div><div><span style="color:rgb(0,0,255);font-family:'times new roman','new york',times,serif;font-size:16px">GRANT ALL ON kamailio.* TO DB_USERNAME@'KAMAIALIO_IP' IDENTIFIED BY 'DBPASSWORD....';</span><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, May 4, 2014 at 2:32 AM, toasterisk <span dir="ltr"><<a href="mailto:toasterisk@gmail.com" target="_blank">toasterisk@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">hello, all of users:<div>I am using this link for kamalio+asterisk+mysql:</div><div><a href="http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb" target="_blank">http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb</a><br>
</div><div>i do everything based on the link, only different thing is I installed Kamalio+mysql at same server, and asterisk in another server.</div><div>currently, my asterisk can connect with the remove MYSQL server, but kamailio can not connect with that.</div>
<div>when start up the kamailio, i got the error message:</div><div>------------------------------------------</div><div><div>0(3739) DEBUG: <core> [sruid.c:100]: root for sruid is [uloc-5365e604-e9b-] (0 / 18)</div>
<div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): ctl</div><div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): mi_rpc</div><div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc</div>
<div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): auth_db</div><div> 0(3739) DEBUG: <core> [db.c:316]: connection 0xb71aab90 not found in pool</div><div> 0(3739) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/asterisk</div>
<div> 0(3739) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asterisk'@'localhost' (using password: YES)</div><div> 0(3739) ERROR: <core> [db.c:320]: could not add connection to the pool 0(3739) ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div> 0(3739) ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib/kamailio/modules_k/auth_db.so)</div><div> 0(3739) ERROR: <core> [main.c:1433]: main_dontfork: init_child failed</div>
<div> 4(3744) INFO: <core> [main.c:851]: INFO: signal 15 received</div><div> 3(3743) INFO: <core> [main.c:851]: INFO: signal 15 received</div><div> 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on</div>
<div> 0(3739) ALERT: <core> [main.c:782]: child process 3743 exited normally, status=0</div><div> 0(3739) ALERT: <core> [main.c:782]: child process 3744 exited normally, status=0</div><div> 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on</div>
<div> 0(3739) DEBUG: <core> [db_pool.c:97]: connection still kept in the pool</div><div> 0(3739) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start</div><div> 0(3739) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash table</div>
<div> 0(3739) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing semaphores</div><div> 0(3739) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying tmcb lists</div><div> 0(3739) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done</div>
<div> 0(3739) DEBUG: <core> [mem/shm_mem.c:242]: shm_mem_destroy</div><div> 0(3739) DEBUG: <core> [mem/shm_mem.c:245]: destroying the shared memory lock</div></div><div>---------------------------------------------------------------------------------------------------------------------------</div>
<div><div>[MySQL-asterisk]</div><div>Description = MySQL Asterisk database</div><div>Trace = Off</div><div>TraceFile = stderr</div><div>Driver = MySQL</div><div>SERVER = 192.168.1.116 // IP for kamailio and mysql </div>
<div>
USER = asterisk</div><div>PASSWORD = 111111</div><div>PORT = 3306</div><div>DATABASE = asterisk</div></div><div>-----------------use isql test---------------</div><div><div>root@kamailio:/etc# isql -v ODBC</div><div>[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified</div>
<div>[ISQL]ERROR: Could not SQLConnect</div><div>root@kamailio:/etc#</div></div><div>-----------------------------------------------------------</div><div>anyone knows the problem?</div><div>thanks!</div><div><br></div></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>