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:
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