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...@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 <toaster...@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 > >
_______________________________________________ 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
