<div dir="ltr">hello:<div>I changed the line:</div><div><div>#!ifdef WITH_MYSQL</div><div># - database URL - used to connect to database server by modules such</div><div># as: auth_db, acc, usrloc, a.s.o.</div><div>#!define DBURL "mysql://openser:openserrw@localhost/openser"</div>
<div>#!ifdef WITH_ASTERISK</div><div>#!define DBASTURL "mysql://asterisk:111111@localhost/asterisk"</div><div>#!endif</div></div><div>---------------------------------------------------------</div><div>i can connect with asterisk database, but the openser still got a problem. this is the error found from kamailio -ddddd:</div>
<div>#!ifdef WITH_MYSQL</div><div># - database URL - used to connect to database server by modules such</div><div># as: auth_db, acc, usrloc, a.s.o.</div><div>#!define DBURL "mysql://openser:openserrw@localhost/openser"</div>
<div>#!ifdef WITH_ASTERISK</div><div>#!define DBASTURL "mysql://asterisk:111111@localhost/asterisk"</div><div>#!endif</div><div>-----------------------------------------------------------------</div><div>I am little confused for kamailio and asterisk real time. I have few questions to ask:</div>
<div>1) what should i register from the domain on xlite? do I register into asterisk or register into kamailio?</div><div>2) why kamctl ul show command has no any users, but my xlite shows READY?</div><div><div>root@kamailio:/usr/local/etc/kamailio# kamctl ul show</div>
<div>Domain:: location table=512 records=0 max_slot=</div></div><div>3) kamctl online show empty. </div><div>4) how can i verify kamailio and asterisk integration is working? the log shows working?</div><div><div> 6(1803) NOTICE: acc [acc.c:275]: ACC: call missed: timestamp=1399253722;method=INVITE;from_tag=as6f7eaf7e;to_tag=2000218801;call_id=<a href="mailto:144595df6bff5b471a5b517a7c11e457@192.168.1.116">144595df6bff5b471a5b517a7c11e457@192.168.1.116</a>;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</div>
<div> 3(1833) DEBUG: mi_fifo [mi_parser.c:84]: end of fifo input tr</div></div><div><br></div><div>thanks for all of you.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-05-04 20:56 GMT+08:00 VOIP Tests <span dir="ltr"><<a href="mailto:kamailio.fs@gmail.com" target="_blank">kamailio.fs@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Have you granted DB access to Kamailio...?<div><br></div><div><span style="color:rgb(0,0,255);font-family:'times new roman','new york',times,serif;font-size:16px">GRANT ALL ON kamailio.* TO DB_USERNAME@'KAMAIALIO_IP' IDENTIFIED BY 'DBPASSWORD....';</span><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Sun, May 4, 2014 at 2:32 AM, toasterisk <span dir="ltr"><<a href="mailto:toasterisk@gmail.com" target="_blank">toasterisk@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">hello, all of users:<div>I am using this link for kamalio+asterisk+mysql:</div>
<div><a href="http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb" target="_blank">http://kb.asipto.com/asterisk:realtime:kamailio-3.3.x-asterisk-10.7.0-astdb</a><br>
</div><div>i do everything based on the link, only different thing is I installed Kamalio+mysql at same server, and asterisk in another server.</div><div>currently, my asterisk can connect with the remove MYSQL server, but kamailio can not connect with that.</div>
<div>when start up the kamailio, i got the error message:</div><div>------------------------------------------</div><div><div>0(3739) DEBUG: <core> [sruid.c:100]: root for sruid is [uloc-5365e604-e9b-] (0 / 18)</div>
<div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): ctl</div><div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): mi_rpc</div><div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc</div>
<div> 0(3739) DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): auth_db</div><div> 0(3739) DEBUG: <core> [db.c:316]: connection 0xb71aab90 not found in pool</div><div> 0(3739) DEBUG: db_mysql [km_my_con.c:94]: opening connection: mysql://xxxx:xxxx@localhost/asterisk</div>
<div> 0(3739) ERROR: db_mysql [km_my_con.c:109]: driver error: Access denied for user 'asterisk'@'localhost' (using password: YES)</div><div> 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</div>
<div> 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)</div><div> 0(3739) ERROR: <core> [main.c:1433]: main_dontfork: init_child failed</div>
<div> 4(3744) INFO: <core> [main.c:851]: INFO: signal 15 received</div><div> 3(3743) INFO: <core> [main.c:851]: INFO: signal 15 received</div><div> 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on</div>
<div> 0(3739) ALERT: <core> [main.c:782]: child process 3743 exited normally, status=0</div><div> 0(3739) ALERT: <core> [main.c:782]: child process 3744 exited normally, status=0</div><div> 0(3739) INFO: <core> [main.c:797]: INFO: dont_fork turned on, living on</div>
<div> 0(3739) DEBUG: <core> [db_pool.c:97]: connection still kept in the pool</div><div> 0(3739) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start</div><div> 0(3739) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash table</div>
<div> 0(3739) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing semaphores</div><div> 0(3739) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying tmcb lists</div><div> 0(3739) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done</div>
<div> 0(3739) DEBUG: <core> [mem/shm_mem.c:242]: shm_mem_destroy</div><div> 0(3739) DEBUG: <core> [mem/shm_mem.c:245]: destroying the shared memory lock</div></div><div>---------------------------------------------------------------------------------------------------------------------------</div>
<div><div>[MySQL-asterisk]</div><div>Description = MySQL Asterisk database</div><div>Trace = Off</div><div>TraceFile = stderr</div><div>Driver = MySQL</div><div>SERVER = 192.168.1.116 // IP for kamailio and mysql </div>
<div>
USER = asterisk</div><div>PASSWORD = 111111</div><div>PORT = 3306</div><div>DATABASE = asterisk</div></div><div>-----------------use isql test---------------</div><div><div>root@kamailio:/etc# isql -v ODBC</div><div>[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified</div>
<div>[ISQL]ERROR: Could not SQLConnect</div><div>root@kamailio:/etc#</div></div><div>-----------------------------------------------------------</div><div>anyone knows the problem?</div><div>thanks!</div><div><br></div></div>
<br></div></div>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>