[SR-Users] Kamailio and mysql connection error: db_mysql [km_my_con.c:109]: driver error:

[toasterisk]

hello, all of users:
I am using this link for kamalio+asterisk+mysql:
http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb
i do everything based on the link, only different thing is I installed
Kamalio+mysql at same server, and asterisk in another server.
currently, my asterisk can connect with the remove MYSQL server, but
kamailio can not connect with that.
when start up the kamailio, i got the error message:
------------------------------------------
0(3739) DEBUG: <core> [sruid.c:100]: root for sruid is [uloc-5365e604-e9b-]
(0 / 18)
 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): ctl
 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): mi_rpc
 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc
 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): auth_db
 0(3739) DEBUG: <core> [db.c:316]: connection 0xb71aab90 not found in pool
 0(3739) DEBUG: db_mysql [km_my_con.c:94]: opening connection:
mysql://xxxx:xxxx@localhost/asterisk
 0(3739) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for
user 'asterisk'@'localhost' (using password: YES)
 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
 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)
 0(3739) ERROR: <core> [main.c:1433]: main_dontfork: init_child failed
 4(3744) INFO: <core> [main.c:851]: INFO: signal 15 received
 3(3743) INFO: <core> [main.c:851]: INFO: signal 15 received
 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on
 0(3739) ALERT: <core> [main.c:782]: child process 3743 exited normally,
status=0
 0(3739) ALERT: <core> [main.c:782]: child process 3744 exited normally,
status=0
 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on
 0(3739) DEBUG: <core> [db_pool.c:97]: connection still kept in the pool
 0(3739) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start
 0(3739) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash table
 0(3739) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing semaphores
 0(3739) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying tmcb
lists
 0(3739) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done
 0(3739) DEBUG: <core> [mem/shm_mem.c:242]: shm_mem_destroy
 0(3739) DEBUG: <core> [mem/shm_mem.c:245]: destroying the shared memory
lock
---------------------------------------------------------------------------------------------------------------------------
[MySQL-asterisk]
Description = MySQL Asterisk database
Trace = Off
TraceFile = stderr
Driver = MySQL
SERVER = 192.168.1.116  // IP for kamailio and mysql
USER = asterisk
PASSWORD = 111111
PORT = 3306
DATABASE = asterisk
-----------------use isql test---------------
root at kamailio:/etc# isql -v ODBC
[IM002][unixODBC][Driver Manager]Data source name not found, and no default
driver specified
[ISQL]ERROR: Could not SQLConnect
root at kamailio:/etc#
-----------------------------------------------------------
anyone knows the problem?
thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140504/d5b572a8/attachment.html>