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!
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@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@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
hello: I changed the line: #!ifdef WITH_MYSQL # - database URL - used to connect to database server by modules such # as: auth_db, acc, usrloc, a.s.o. #!define DBURL "mysql://openser:openserrw@localhost/openser" #!ifdef WITH_ASTERISK #!define DBASTURL "mysql://asterisk:111111@localhost/asterisk" #!endif --------------------------------------------------------- i can connect with asterisk database, but the openser still got a problem. this is the error found from kamailio -ddddd: #!ifdef WITH_MYSQL # - database URL - used to connect to database server by modules such # as: auth_db, acc, usrloc, a.s.o. #!define DBURL "mysql://openser:openserrw@localhost/openser" #!ifdef WITH_ASTERISK #!define DBASTURL "mysql://asterisk:111111@localhost/asterisk" #!endif ----------------------------------------------------------------- I am little confused for kamailio and asterisk real time. I have few questions to ask: 1) what should i register from the domain on xlite? do I register into asterisk or register into kamailio? 2) why kamctl ul show command has no any users, but my xlite shows READY? root@kamailio:/usr/local/etc/kamailio# kamctl ul show Domain:: location table=512 records=0 max_slot= 3) kamctl online show empty. 4) how can i verify kamailio and asterisk integration is working? the log shows working? 6(1803) NOTICE: acc [acc.c:275]: ACC: call missed: timestamp=1399253722;method=INVITE;from_tag=as6f7eaf7e;to_tag=2000218801;call_id= 144595df6bff5b471a5b517a7c11e457@192.168.1.116;code=487;reason=Request Terminated;src_user=102;src_domain=192.168.1.116;src_ip=192.168.1.153;dst_ouser=102;dst_user=102;dst_domain=192.168.1.105 3(1833) DEBUG: mi_fifo [mi_parser.c:84]: end of fifo input tr
thanks for all of you.
2014-05-04 20:56 GMT+08:00 VOIP Tests kamailio.fs@gmail.com:
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@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@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
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
-
5060 -
toasterisk
-
VOIP Tests