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@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@kamailio:/etc#

-----------------------------------------------------------

anyone knows the problem?

thanks!

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users