<div>There is no such thing as local mysql db and remote mysql db connection as far as kamailio is concerned, it uses native libmysqlclient library for mysql operations over TCP socket, EVEN if mysql service is running locally.</div>
<div><br></div><div>Please pay ATTENTION on this error,</div><div><br></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">7654]: </span><span style="font-family:arial,sans-serif;background-color:rgb(255,255,255)"><font color="#ff0000" size="4">ERROR: db_mysql [km_my_con.c:109]: driver error: Unknown database 'openser'</font></span></div>
<div><br></div><div>Problem is NOT connecting to mysql service, problem is accessing database named "openser". It either does not exists at all or the user has no permission to access it.</div><div><br></div><div>
Also I asked you to try below command,</div><div><br></div><div><span style="font-family:arial,sans-serif;background-color:rgb(255,255,255)"><font color="#009900" size="4">mysql -u openser -h 192.168.1.170 -p </font><font size="4" color="#ff0000">openser</font></span></div>
<div><br></div><div>You are connecting with mysql with only GREEN words in command, ignoring RED one, which is the important here, since it ensures that you are not only connecting to mysql server but also going to run SQL queries on "openser" database, therefore, it will check for its existence and permission of this user for accessing mentioned database.</div>
<br>You can also run following SQL on mysql console to identify the same problem yourself or send me its output and i will explain it to you,<div><br></div><div>SHOW GRANTS FOR 'openser'@'192.168.1.170';<br>
<br>Thank you,<br><br><br><div class="gmail_quote">On Wed, Feb 13, 2013 at 5:45 AM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Shahzad ,<div><br></div><div> It is working through command ( I have already mentioned in my mail)</div><div><br></div><div> I think there is some format error (modparam("acc", "db_url", DBURL)</div>
<div> I hope i need define some other variable for remote mysql ,if i give local db it is working </div><div><br></div><div> Please advice what variable or parameter or some other thing i am missing for remote MYSQL db</div>
<div><br></div><div>With Regards</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>N.Prakash</div></font></span><div class="HOEnZb"><div class="h5"><div><br></div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 10:42 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Try this,</div><div><br></div><div>mysql -u openser -h 192.168.1.170 -p openser</div><div><br></div>If it gives same error, then user openser does not have permission to access openser db as kamailio says.<div>
<br></div>
<div>Thank you.</div><div><div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 5:43 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br></div><div>Hi Shahzad,</div><div><br></div><div> Please find the error ,but the 'openser' already there in remote mysql server and we can able to reach through command </div>
<div>with that database </div>
<div><br></div><div><br></div><div><br></div><div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: db_mysql [km_my_con.c:109]: driver error: Unknown database 'openser'</div><div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: <core> [db.c:320]: could not add connection to the pool</div>
<div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div><div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div>
<div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 4, pid 7654, "udp receiver child=3 sock=<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>"</div>
<div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: : <core> [main.c:1625]: main_loop: Cannot fork</div><div>Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7650]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div><div>
<br><div class="gmail_quote">On Tue, Feb 12, 2013 at 9:01 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
syslogs are dumped to /var/log/message in CentOS.<div><br></div><div>Thank you.</div><div><div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 3:47 PM, Prabhakaran B <span dir="ltr"><<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear Shahzad <div>Im usig centos 6.3, im not able to find the sylog</div><div><br></div><div>i have defined debug on kamailio.cfg if i give kamailio -dd -D 2 to et the debug message </div>
<div><br></div><div>please advice anyother way to get debug message for our issue</div>
<div><br></div><div>With Regards</div><span><font color="#888888"><div>B.Prabhakaran</div></font></span><div><div><div><br></div><div>On Tue, Feb 12, 2013 at 7:37 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:</div>
<div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">There is no mysql error in logs.<div><br></div><div>Set debug=4 on line 143 instead of defining WITH_DEBUG, since that flag force kamailio to listen on localhost address only while db is on 192.168.1.x. Then send me debug log file again (logs will appear in syslog).</div>
<div><br></div><div>Thank you.</div><div><div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 2:54 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Dear Shahzad,</div><div><br></div><div> Please find the debug detail</div><div><br></div><div><br></div><div>kamailio -dd -D 2</div>
<div><br></div><div> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring asterisk.bindip</div>
<div> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring asterisk.bindport</div><div> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring kamailio.bindip</div>
<div> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: new_cfg_script_var(): declaring kamailio.bindport</div><div> 0(4971) DEBUG: <core> [cfg.y:1785]: loading modules under /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/</div>
<div>loading modules under /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/</div><div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module db_mysql.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/db_mysql.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/db_mysql/db_mysql.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/db_mysql.so></div>
<div> 0(4971) DEBUG: <core> [db_query.c:375]: About to allocate sql_buf size = 65535</div><div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_fifo.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/mi_fifo.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module kex.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/kex.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: kex</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tm.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/tm.so></div><div>
0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/tm/tm.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/tm.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tmx.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/tmx.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: tmx</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sl.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sl.so></div><div>
0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sl/sl.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/sl.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module rr.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/rr.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: rr</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module pv.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/pv.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: pv</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module maxfwd.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/maxfwd.so></div><div>
0(4971) DEBUG: <core> [cfg.y:1772]: loading module usrloc.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/usrloc.so></div><div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module registrar.so</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/registrar.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: registrar</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module textops.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/textops.so></div>
<div>
0(4971) DEBUG: <core> [cfg.y:1772]: loading module siputils.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/siputils.so></div><div>
0(4971) DEBUG: <core> [cfg.y:1772]: loading module xlog.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/xlog.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: xlog</div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sanity.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sanity.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/sanity/sanity.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/sanity.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module ctl.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/ctl.so></div><div>
0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/ctl/ctl.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/ctl.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module cfg_rpc.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/cfg_rpc.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/cfg_rpc/cfg_rpc.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/cfg_rpc.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_rpc.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/mi_rpc.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/mi_rpc/mi_rpc.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/mi_rpc.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module acc.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/acc.so></div><div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth.so</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/auth.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/auth/auth.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/auth.so></div><div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth_db.so</div><div>
0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/auth_db.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module debugger.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/debugger.so></div>
<div> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file not found </usr/local/lib64/kamailio/modules_k/debugger/debugger.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules/debugger.so></div>
<div> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module uac.so</div><div> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/local/lib64/kamailio/modules_k/uac.so></div><div> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: uac</div>
<div> 0(4971) DEBUG: <core> [mem/f_malloc.c:293]: fm_malloc_init: F_OPTIMIZE=16384, /ROUNDTO=2048</div><div> 0(4971) DEBUG: <core> [mem/f_malloc.c:295]: fm_malloc_init: F_HASH_SIZE=2099, fm_block size=33896</div>
<div> 0(4971) DEBUG: <core> [mem/f_malloc.c:296]: fm_malloc_init(0x7ffbe2e78000, 33554432), start=0x7ffbe2e78000</div><div> 0(4971) DEBUG: <core> [mem/shm_mem.c:203]: shm_mem_init: success</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'mi_fifo' matches module 'mi_fifo'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fifo_name> in module mi_fifo [/usr/local/lib64/kamailio/modules_k/mi_fifo.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fifo_name> in module mi_fifo [/usr/local/lib64/kamailio/modules_k/mi_fifo.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <failure_reply_mode> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <failure_reply_mode> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' matches module 'tm'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <fr_inv_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <fr_inv_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' matches module 'rr'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <enable_full_lr> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <enable_full_lr> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' matches module 'rr'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <append_fromtag> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <append_fromtag> in module rr [/usr/local/lib64/kamailio/modules_k/rr.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <method_filtering> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <method_filtering> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <max_expires> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <max_expires> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'registrar' matches module 'registrar'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <gruu_enabled> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <gruu_enabled> in module registrar [/usr/local/lib64/kamailio/modules_k/registrar.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <early_media> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <early_media> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <report_ack> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <report_ack> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <report_cancels> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <report_cancels> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <detect_direction> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <detect_direction> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACC] value [1]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div><div>
0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACCMISSED] value [2]</div><div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div>
<div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_missed_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_missed_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <log_extra> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <log_extra> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><div> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID [FLT_ACCFAILED] value [3]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' matches module 'acc'</div><div> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found <failed_transaction_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div>
<div> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: found <failed_transaction_flag> in module acc [/usr/local/lib64/kamailio/modules_k/acc.so]</div><br><div class="gmail_quote"><div><div>
On Tue, Feb 12, 2013 at 6:38 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">These are not debug logs. I need to see what happens before below line,<div><div><br></div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div><br></div></div><div>You can enabled debug log either by setting line 143 to 5 OR define WITH_DEBUG.</div><div><br></div><div>Thank you.</div><div><div><div><br><br><div class="gmail_quote">
On Tue, Feb 12, 2013 at 2:00 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Dear Shahzad ,</div><div><br></div><div> Please find the error</div><div><br></div><div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 2, pid 4424, "udp receiver child=1 sock=<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>"</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: : <core> [main.c:1625]: main_loop: Cannot fork</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 5, pid 4427, "udp receiver child=0 sock=<a href="http://192.168.1.101:5060" target="_blank">192.168.1.101:5060</a>"</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: <core> [db.c:320]: could not add connection to the pool</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: : <core> [main.c:1625]: main_loop: Cannot fork</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: <core> [db.c:320]: could not add connection to the pool</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4430]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4431]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4439]: : <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 16</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: <core> [db.c:320]: could not add connection to the pool</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: usrloc [ul_mod.c:407]: child(1): failed to connect to database</div><div>Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: <core> [db.c:320]: could not add connection to the pool</div>
</div><div><div><div><br></div></div></div></blockquote></div></div></div></div></blockquote><div><br></div></div></div><div><div><div>With Regards</div><div><br></div><div>N.Prakash </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div></div><div><br></div><br><div class="gmail_quote">
On Tue, Feb 12, 2013 at 6:23 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">kamailio.cfg looks OK, can you increase the debug level to 4+, start kamailio and send me logs? May be we can find something in logs.<div>
<br></div><div>Thank you.</div><div><div><div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 1:40 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br></div><div>Hi Govoiper</div><div><br></div><div>Free Memory on my server 2309 MB</div><div><br></div><div><div>
total used free shared buffers cached</div><div> Mem: 2795 486 <font color="#ff0000">2309 </font> 0 70 180</div>
<div> -/+ buffers/cache: 234 2561</div><div> Swap: 2927 0 2927</div></div><div><br></div><div><br></div><div><b><u>Kamailio error:</u></b></div><div><b><u><br></u></b></div><div>
<div>ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start failed</div><div style="font-weight:bold;text-decoration:underline"><br></div></div><div><br></div><div><u><b>tail -f /var/log/messages:</b></u></div>
<div><br></div><div><div><br></div><div>Feb 12 23:41:28 localhost /usr/local/sbin/kamailio[4280]: INFO: <core> [udp_server.c:230]: INFO: udp_init: SO_RCVBUF is finally 262142</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: usrloc [ul_mod.c:407]: child(1): failed to connect to database</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module usrloc (/usr/local/lib64/kamailio/modules_k/usrloc.so)</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [db.c:320]: could not add connection to the pool</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [sr_module.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div><div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> [pt.c:350]: ERROR: fork_process(): init_child failed for process 3, pid 4283, "udp receiver child=2 sock=<a href="http://127.0.0.1:5060" target="_blank">127.0.0.1:5060</a>"</div>
<div>Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> [main.c:1625]: main_loop: Cannot fork</div></div><div><br></div><div>With Regards</div><span><font color="#888888"><div><br></div>
<div>N.Prakash</div><br></font></span><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_quote"><div><div>---------- Forwarded message ----------<br>From: <b class="gmail_sendername">SamyGo</b> <span dir="ltr"><<a href="mailto:govoiper@gmail.com" target="_blank">govoiper@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 5:49 PM<br>
Subject: Re: [SR-Users] [sr-dev] openser db on an external mysql server<br>To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List" <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>><br>
</div></div><div><div>
Cc: Muhammad Shahzad <<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>>, <a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>, Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>>, Indu Priya <<a href="mailto:indu@tevatel.com" target="_blank">indu@tevatel.com</a>><br>
<br><br><div dir="ltr">Hi Prakash,<div><br></div><div>Please paste All ERROR appearing and Warnings when you start your kamailio. What is the free memory situation on your server ?</div><div><br></div><div>Regards,</div>
<div>
Sammy</div>
<div><br><div><br></div></div></div><div><div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 5:12 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Muhammad,<div><br><div> Yes, I have define Mysql on top in Kamailio.cfg</div><div><br></div><div> DBURL "mysql://<a href="http://openser:openserrw@192.168.1.170/openser" target="_blank">openser:openserrw@192.168.1.170/openser</a>"</div>
<div><br></div><div><br></div><div> I have attached Kamailio.cfg ,please advice</div><div><br></div><div>With Regards</div><span><font color="#888888"><div><br></div></font></span><div><span><font color="#888888">N.Prakash</font></span><div>
<div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">What is your connection string in kamailio i.e. DBURL? Also make sure you have defined WITH_MYSQL on the top of kamailio.cfg to load necessary drivers.<div>
<br></div><div>#!define WITH_MYSQL</div><div><br></div><div>Thank you.</div><div><div>
<div><br><br><div class="gmail_quote">On Tue, Feb 12, 2013 at 12:56 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi <span class="gmail_sendername">Shahzad ,</span><div> </div><div> It is not ,We can able to connect remote mysql ( please find the detail below),moreover we can able create openser db from Kamailio server to remote mysql server</div>
<div><br></div><div><b>Mysql server : 192.168.1.170</b></div><div><b>Kamailio server : 192.168.1.101</b></div><div><br></div><div> </div><div><b>Mysql output :</b></div><div><b><br></b></div><div> <b>mysql -u openser -h 192.168.1.170 -p</b></div>
<div><div>Enter password:</div><div>Welcome to the MySQL monitor. Commands end with ; or \g.</div><div>Your MySQL connection id is 68</div><div>Server version: 5.1.67 Source distribution</div><div><br></div><div>Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.</div>
<div><br></div><div>Oracle is a registered trademark of Oracle Corporation and/or its</div><div>affiliates. Other names may be trademarks of their respective</div><div>owners.</div><div><br></div><div>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</div>
<div><br></div><div>mysql></div><div><br></div><div class="gmail_quote"><div>With Regards</div><span><font color="#888888"><div><br></div><div>N.Prakash</div></font></span><div><div><div> </div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Muhammad Shahzad</b> <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 5:16 PM<br>Subject: Re: [sr-dev] [SR-Users] openser db on an external mysql server<br>To: Development mailing list of the sip-router project <<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>><br>
Cc: Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>>, <a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>, Indu Priya <<a href="mailto:indu@tevatel.com" target="_blank">indu@tevatel.com</a>>, Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>><br>
<br><br>Its not a Kamailio error, it is problem with connecting to mysql server. Error 4 means No MySQL Server Running On Specified Host.<div><br></div><div>May be MySQL server is down or there is some firewall running or MySQL not listening on IP you specified.</div>
<div><br></div><div>Thank you.</div><div><br><br><div class="gmail_quote"><div><div><div><div>On Tue, Feb 12, 2013 at 12:11 PM, Prakash N <span dir="ltr"><<a href="mailto:prakash.n@tevatel.com" target="_blank">prakash.n@tevatel.com</a>></span> wrote:<br>
</div></div></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div><div> Dear Daniel,<div><br></div><div> Thanks for your quick response</div>
<div>
<br></div><div> We can able to create operseb db on remote mysql server ,but Kamailio not getting start</div>
<div><br></div><div>
<font color="#ff0000"> Error detail:</font></div><div><br></div><div> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to MySQL server on '192.168.1.170' (4)<div> ERROR: <core> [db.c:32 0]: could not add connection to the pool</div>
<div> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the database</div><div> ERROR: <core> [sr_modu le.c:896]: init_mod_child(): Error while initializing module auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so)</div>
<div><br></div><div><br></div><div>I have attached my kamailo.cfg ( we followed Kamailio and Asterisk real time installation) ,please advice </div><div><br></div><div>With Regards</div><span><font color="#888888"><div>
<br></div><div>N.Prakash</div></font></span><div><div>
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Daniel-Constantin Mierla</b> <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span><br>
Date: Tue, Feb 12, 2013 at 2:41 PM<br>Subject: Re: [SR-Users] openser db on an external mysql server<br>To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List" <<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>>, <a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a>, <a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a><br>
Cc: Prabhakaran B <<a href="mailto:prabhakaran@tevatel.com" target="_blank">prabhakaran@tevatel.com</a>><br><br><br>
<div bgcolor="#FFFFFF" text="#000000">
<div>Hello,<br>
<br>
kamailio database is created with:<br>
<br>
kamdbctl create<br>
<br>
the host of mysql server has to be specified in kamctlrc file via
DBHOST variable - kamctlrc is located in same directory as
kamailio.cfg.<br>
<br>
In kamailio.cfg, update the db_url value (or DBURL define) to
reflect the mysql server host.<br>
<br>
Cheers,<br>
Daniel<div><div><div><div><br>
<br>
On 2/12/13 4:16 AM, Prakash N wrote:<br>
</div></div></div></div></div>
<blockquote type="cite"><div><div><div><div>Hi All,
<div><br>
</div>
<div> I am new this Kamailo ,ther is any step by step document to
set up openser db on an external mysql server ?</div>
<div><br>
</div>
<div>With Regards</div>
<div><br>
</div>
<div>N.Prakash</div>
<div><br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div></div></div><pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<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><span><font color="#888888"><span><font color="#888888">
</font></span></font></span></pre><span><font color="#888888"><span><font color="#888888">
</font></span></font></span></blockquote><span><font color="#888888"><span><font color="#888888">
<br>
<br>
<pre cols="72">--
Daniel-Constantin Mierla - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, April 16-17, 2013, Berlin
- <a href="http://conference.kamailio.com" target="_blank">http://conference.kamailio.com</a> -</pre>
</font></span></font></span></div>
</div><br>
</blockquote></div><br></div></div></div>
<br></div></div></div></div>_______________________________________________<br>
sr-dev mailing list<br>
<a href="mailto:sr-dev@lists.sip-router.org" target="_blank">sr-dev@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev</a><br>
<br></blockquote></div><span><font color="#888888"><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</font></span></font></span></div>
</div><br>
</blockquote></div></div></div><br></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div><br></div></div></div></div>
<br>_______________________________________________<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>
</div></div></div></div></div></div></div><br>
</blockquote></div><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div></div></div><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">------------------------------</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shaheryarkh@googlemail.com</a>
</div>