4 May
2014
4 May
'14
9:32 a.m.
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!
4 May
4 May
2:56 p.m.
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
5 May
5 May
3:54 a.m.
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(a)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(a)gmail.com>om>:
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(a)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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
3667
days inactive
3668
days old
2 comments
3 participants
participants (3)
-
5060 -
toasterisk
-
VOIP Tests