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

VOIP Tests kamailio.fs at gmail.com
Sun May 4 14:56:17 CEST 2014


Have you granted DB access to Kamailio...?

GRANT ALL ON kamailio.* TO DB_USERNAME@'KAMAIALIO_IP' IDENTIFIED BY
'DBPASSWORD....';


On Sun, May 4, 2014 at 2:32 AM, toasterisk <toasterisk at gmail.com> wrote:

> 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!
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20140504/cc75706c/attachment.html>


More information about the sr-users mailing list