From: SamyGo &lt;govoiper(a)gmail.com&gt; Date: Tue, Feb 12, 2013 at 5:49 PM Subject: Re: [SR-Users] [sr-dev] openser db on an external mysql server To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt; Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, sr-dev(a)lists.sip-router.org, Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt;om>, Indu Priya &lt;indu(a)tevatel.com&gt; Hi Prakash, Please paste All ERROR appearing and Warnings when you start your kamailio. What is the free memory situation on your server ? Regards, Sammy On Tue, Feb 12, 2013 at 5:12 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > Hi Muhammad, > > Yes, I have define Mysql on top in Kamailio.cfg > > DBURL "mysql://openser:openserrw@192.168.1.170/openser" > > > I have attached Kamailio.cfg ,please advice > > With Regards > > N.Prakash > > > On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad < > shaheryarkh(a)gmail.com&gt; wrote: > >> 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. >> >> #!define WITH_MYSQL >> >> Thank you. >> >> >> On Tue, Feb 12, 2013 at 12:56 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >> >>> Hi Shahzad , >>> >>> 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 >>> >>> *Mysql server : 192.168.1.170* >>> *Kamailio server : 192.168.1.101* >>> >>> >>> *Mysql output :* >>> * >>> * >>> *mysql -u openser -h 192.168.1.170 -p* >>> Enter password: >>> Welcome to the MySQL monitor. Commands end with ; or \g. >>> Your MySQL connection id is 68 >>> Server version: 5.1.67 Source distribution >>> >>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights >>> reserved. >>> >>> Oracle is a registered trademark of Oracle Corporation and/or its >>> affiliates. Other names may be trademarks of their respective >>> owners. >>> >>> Type 'help;' or '\h' for help. Type '\c' to clear the current input >>> statement. >>> >>> mysql> >>> >>> With Regards >>> >>> N.Prakash >>> >>> >>>> >>>> ---------- Forwarded message ---------- >>>> From: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt; >>>> Date: Tue, Feb 12, 2013 at 5:16 PM >>>> Subject: Re: [sr-dev] [SR-Users] openser db on an external mysql >>>> server >>>> To: Development mailing list of the sip-router project < >>>> sr-dev(a)lists.sip-router.org&gt; >>>> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >>>> sr-users(a)lists.sip-router.org, Indu Priya &lt;indu(a)tevatel.com&gt;om>, >>>> Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>> >>>> >>>> Its not a Kamailio error, it is problem with connecting to mysql >>>> server. Error 4 means No MySQL Server Running On Specified Host. >>>> >>>> May be MySQL server is down or there is some firewall running or >>>> MySQL not listening on IP you specified. >>>> >>>> Thank you. >>>> >>>> >>>> On Tue, Feb 12, 2013 at 12:11 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>>> >>>>> Dear Daniel, >>>>> >>>>> Thanks for your quick response >>>>> >>>>> We can able to create operseb db on remote mysql server >>>>> ,but Kamailio not getting start >>>>> >>>>> Error detail: >>>>> >>>>> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect to >>>>> MySQL server on '192.168.1.170' (4) >>>>> ERROR: <core> [db.c:32 0]: could not add connection to the pool >>>>> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the >>>>> database >>>>> 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) >>>>> >>>>> >>>>> I have attached my kamailo.cfg ( we followed Kamailio and >>>>> Asterisk real time installation) ,please advice >>>>> >>>>> With Regards >>>>> >>>>> N.Prakash >>>>> >>>>>> >>>>>> ---------- Forwarded message ---------- >>>>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>>>> Date: Tue, Feb 12, 2013 at 2:41 PM >>>>>> Subject: Re: [SR-Users] openser db on an external mysql server >>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) >>>>>> - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt;rg>, >>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>> >>>>>> >>>>>> Hello, >>>>>> >>>>>> kamailio database is created with: >>>>>> >>>>>> kamdbctl create >>>>>> >>>>>> the host of mysql server has to be specified in kamctlrc file via >>>>>> DBHOST variable - kamctlrc is located in same directory as kamailio.cfg. >>>>>> >>>>>> In kamailio.cfg, update the db_url value (or DBURL define) to >>>>>> reflect the mysql server host. >>>>>> >>>>>> Cheers, >>>>>> Daniel >>>>>> >>>>>> >>>>>> On 2/12/13 4:16 AM, Prakash N wrote: >>>>>> >>>>>> Hi All, >>>>>> >>>>>> I am new this Kamailo ,ther is any step by step document to >>>>>> set up openser db on an external mysql server ? >>>>>> >>>>>> With Regards >>>>>> >>>>>> N.Prakash >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >>>>>> Kamailio World Conference, April 16-17, 2013, Berlin >>>>>> - http://conference.kamailio.com - >>>>>> >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> sr-dev mailing list >>>>> sr-dev(a)lists.sip-router.org >>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Muhammad Shahzad >>>> ----------------------------------- >>>> CISCO Rich Media Communication Specialist (CRMCS) >>>> CISCO Certified Network Associate (CCNA) >>>> Cell: +49 176 99 83 10 85 >>>> MSN: shari_786pk(a)hotmail.com >>>> Email: shaheryarkh(a)googlemail.com >>>> >>>> >>> >> >> >> -- >> Muhammad Shahzad >> ----------------------------------- >> CISCO Rich Media Communication Specialist (CRMCS) >> CISCO Certified Network Associate (CCNA) >> Cell: +49 176 99 83 10 85 >> MSN: shari_786pk(a)hotmail.com >> Email: shaheryarkh(a)googlemail.com >> > > > _______________________________________________ > 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 > >

wrote:

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. Thank you. On Tue, Feb 12, 2013 at 1:40 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > > Hi Govoiper > > Free Memory on my server 2309 MB > > total used free shared > buffers cached > Mem: 2795 486 2309 0 70 > 180 > -/+ buffers/cache: 234 2561 > Swap: 2927 0 2927 > > > *Kamailio error:* > * > * > ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start > failed > > > *tail -f /var/log/messages:* > > > 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 > 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) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: > usrloc [ul_mod.c:407]: child(1): failed to connect to database > 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) > 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) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > 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) > 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=127.0.0.1:5060" > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> > [main.c:1625]: main_loop: Cannot fork > > With Regards > > N.Prakash > > ---------- Forwarded message ---------- >> From: SamyGo &lt;govoiper(a)gmail.com&gt; >> Date: Tue, Feb 12, 2013 at 5:49 PM >> Subject: Re: [SR-Users] [sr-dev] openser db on an external mysql >> server >> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - >> Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt; >> Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, >> sr-dev(a)lists.sip-router.org, Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt;om>, >> Indu Priya &lt;indu(a)tevatel.com&gt; >> >> >> Hi Prakash, >> >> Please paste All ERROR appearing and Warnings when you start your >> kamailio. What is the free memory situation on your server ? >> >> Regards, >> Sammy >> >> >> >> >> On Tue, Feb 12, 2013 at 5:12 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >> >>> Hi Muhammad, >>> >>> Yes, I have define Mysql on top in Kamailio.cfg >>> >>> DBURL "mysql://openser:openserrw@192.168.1.170/openser" >>> >>> >>> I have attached Kamailio.cfg ,please advice >>> >>> With Regards >>> >>> N.Prakash >>> >>> >>> On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad < >>> shaheryarkh(a)gmail.com&gt; wrote: >>> >>>> 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. >>>> >>>> #!define WITH_MYSQL >>>> >>>> Thank you. >>>> >>>> >>>> On Tue, Feb 12, 2013 at 12:56 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>>> >>>>> Hi Shahzad , >>>>> >>>>> 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 >>>>> >>>>> *Mysql server : 192.168.1.170* >>>>> *Kamailio server : 192.168.1.101* >>>>> >>>>> >>>>> *Mysql output :* >>>>> * >>>>> * >>>>> *mysql -u openser -h 192.168.1.170 -p* >>>>> Enter password: >>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>> Your MySQL connection id is 68 >>>>> Server version: 5.1.67 Source distribution >>>>> >>>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights >>>>> reserved. >>>>> >>>>> Oracle is a registered trademark of Oracle Corporation and/or its >>>>> affiliates. Other names may be trademarks of their respective >>>>> owners. >>>>> >>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current >>>>> input statement. >>>>> >>>>> mysql> >>>>> >>>>> With Regards >>>>> >>>>> N.Prakash >>>>> >>>>> >>>>>> >>>>>> ---------- Forwarded message ---------- >>>>>> From: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt; >>>>>> Date: Tue, Feb 12, 2013 at 5:16 PM >>>>>> Subject: Re: [sr-dev] [SR-Users] openser db on an external mysql >>>>>> server >>>>>> To: Development mailing list of the sip-router project < >>>>>> sr-dev(a)lists.sip-router.org&gt; >>>>>> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >>>>>> sr-users(a)lists.sip-router.org, Indu Priya &lt;indu(a)tevatel.com&gt;om>, >>>>>> Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>> >>>>>> >>>>>> Its not a Kamailio error, it is problem with connecting to mysql >>>>>> server. Error 4 means No MySQL Server Running On Specified Host. >>>>>> >>>>>> May be MySQL server is down or there is some firewall running or >>>>>> MySQL not listening on IP you specified. >>>>>> >>>>>> Thank you. >>>>>> >>>>>> >>>>>> On Tue, Feb 12, 2013 at 12:11 PM, Prakash N < >>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>> >>>>>>> Dear Daniel, >>>>>>> >>>>>>> Thanks for your quick response >>>>>>> >>>>>>> We can able to create operseb db on remote mysql server >>>>>>> ,but Kamailio not getting start >>>>>>> >>>>>>> Error detail: >>>>>>> >>>>>>> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't connect >>>>>>> to MySQL server on '192.168.1.170' (4) >>>>>>> ERROR: <core> [db.c:32 0]: could not add connection to the pool >>>>>>> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the >>>>>>> database >>>>>>> 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) >>>>>>> >>>>>>> >>>>>>> I have attached my kamailo.cfg ( we followed Kamailio and >>>>>>> Asterisk real time installation) ,please advice >>>>>>> >>>>>>> With Regards >>>>>>> >>>>>>> N.Prakash >>>>>>> >>>>>>>> >>>>>>>> ---------- Forwarded message ---------- >>>>>>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>>>>>> Date: Tue, Feb 12, 2013 at 2:41 PM >>>>>>>> Subject: Re: [SR-Users] openser db on an external mysql server >>>>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router >>>>>>>> (SER) - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt;rg>, >>>>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>>>>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>> >>>>>>>> >>>>>>>> Hello, >>>>>>>> >>>>>>>> kamailio database is created with: >>>>>>>> >>>>>>>> kamdbctl create >>>>>>>> >>>>>>>> the host of mysql server has to be specified in kamctlrc file >>>>>>>> via DBHOST variable - kamctlrc is located in same directory as kamailio.cfg. >>>>>>>> >>>>>>>> In kamailio.cfg, update the db_url value (or DBURL define) to >>>>>>>> reflect the mysql server host. >>>>>>>> >>>>>>>> Cheers, >>>>>>>> Daniel >>>>>>>> >>>>>>>> >>>>>>>> On 2/12/13 4:16 AM, Prakash N wrote: >>>>>>>> >>>>>>>> Hi All, >>>>>>>> >>>>>>>> I am new this Kamailo ,ther is any step by step document to >>>>>>>> set up openser db on an external mysql server ? >>>>>>>> >>>>>>>> With Regards >>>>>>>> >>>>>>>> N.Prakash >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >>>>>>>> Kamailio World Conference, April 16-17, 2013, Berlin >>>>>>>> - http://conference.kamailio.com - >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> sr-dev mailing list >>>>>>> sr-dev(a)lists.sip-router.org >>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Muhammad Shahzad >>>>>> ----------------------------------- >>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>> CISCO Certified Network Associate (CCNA) >>>>>> Cell: +49 176 99 83 10 85 >>>>>> MSN: shari_786pk(a)hotmail.com >>>>>> Email: shaheryarkh(a)googlemail.com >>>>>> >>>>>> >>>>> >>>> >>>> >>>> -- >>>> Muhammad Shahzad >>>> ----------------------------------- >>>> CISCO Rich Media Communication Specialist (CRMCS) >>>> CISCO Certified Network Associate (CCNA) >>>> Cell: +49 176 99 83 10 85 >>>> MSN: shari_786pk(a)hotmail.com >>>> Email: shaheryarkh(a)googlemail.com >>>> >>> >>> >>> _______________________________________________ >>> 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 >>> >>> >> >> > -- Muhammad Shahzad ----------------------------------- CISCO Rich Media Communication Specialist (CRMCS) CISCO Certified Network Associate (CCNA) Cell: +49 176 99 83 10 85 MSN: shari_786pk(a)hotmail.com Email: shaheryarkh(a)googlemail.com

wrote:

These are not debug logs. I need to see what happens before below line, 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) You can enabled debug log either by setting line 143 to 5 OR define WITH_DEBUG. Thank you. On Tue, Feb 12, 2013 at 2:00 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > Dear Shahzad , > > Please find the error > > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > 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) > 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=127.0.0.1:5060" > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: : <core> > [main.c:1625]: main_loop: Cannot fork > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > 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) > 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=192.168.1.101:5060" > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: > <core> [db.c:320]: could not add connection to the pool > 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) > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: : <core> > [main.c:1625]: main_loop: Cannot fork > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: > <core> [db.c:320]: could not add connection to the pool > 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) > 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) > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4439]: : <core> > [pass_fd.c:293]: ERROR: receive_fd: EOF on 16 > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: > <core> [db.c:320]: could not add connection to the pool > 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) > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: > usrloc [ul_mod.c:407]: child(1): failed to connect to database > Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: > <core> [db.c:320]: could not add connection to the pool > >

> > On Tue, Feb 12, 2013 at 6:23 PM, Muhammad Shahzad < > shaheryarkh(a)gmail.com&gt; wrote: > >> 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. >> >> Thank you. >> >> >> On Tue, Feb 12, 2013 at 1:40 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >> >>> >>> Hi Govoiper >>> >>> Free Memory on my server 2309 MB >>> >>> total used free shared >>> buffers cached >>> Mem: 2795 486 2309 0 70 >>> 180 >>> -/+ buffers/cache: 234 2561 >>> Swap: 2927 0 2927 >>> >>> >>> *Kamailio error:* >>> * >>> * >>> ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio >>> start failed >>> >>> >>> *tail -f /var/log/messages:* >>> >>> >>> 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 >>> 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) >>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>> <core> [db.c:320]: could not add connection to the pool >>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: >>> usrloc [ul_mod.c:407]: child(1): failed to connect to database >>> 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) >>> 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) >>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>> <core> [db.c:320]: could not add connection to the pool >>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: >>> auth_db [authdb_mod.c:174]: unable to connect to the database >>> 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) >>> 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=127.0.0.1:5060" >>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> >>> [main.c:1625]: main_loop: Cannot fork >>> >>> With Regards >>> >>> N.Prakash >>> >>> ---------- Forwarded message ---------- >>>> From: SamyGo &lt;govoiper(a)gmail.com&gt; >>>> Date: Tue, Feb 12, 2013 at 5:49 PM >>>> Subject: Re: [SR-Users] [sr-dev] openser db on an external mysql >>>> server >>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - >>>> Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt; >>>> Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, >>>> sr-dev(a)lists.sip-router.org, Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt;om>, >>>> Indu Priya &lt;indu(a)tevatel.com&gt; >>>> >>>> >>>> Hi Prakash, >>>> >>>> Please paste All ERROR appearing and Warnings when you start your >>>> kamailio. What is the free memory situation on your server ? >>>> >>>> Regards, >>>> Sammy >>>> >>>> >>>> >>>> >>>> On Tue, Feb 12, 2013 at 5:12 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>>> >>>>> Hi Muhammad, >>>>> >>>>> Yes, I have define Mysql on top in Kamailio.cfg >>>>> >>>>> DBURL "mysql://openser:openserrw@192.168.1.170/openser" >>>>> >>>>> >>>>> I have attached Kamailio.cfg ,please advice >>>>> >>>>> With Regards >>>>> >>>>> N.Prakash >>>>> >>>>> >>>>> On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad < >>>>> shaheryarkh(a)gmail.com&gt; wrote: >>>>> >>>>>> 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. >>>>>> >>>>>> #!define WITH_MYSQL >>>>>> >>>>>> Thank you. >>>>>> >>>>>> >>>>>> On Tue, Feb 12, 2013 at 12:56 PM, Prakash N < >>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>> >>>>>>> Hi Shahzad , >>>>>>> >>>>>>> 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 >>>>>>> >>>>>>> *Mysql server : 192.168.1.170* >>>>>>> *Kamailio server : 192.168.1.101* >>>>>>> >>>>>>> >>>>>>> *Mysql output :* >>>>>>> * >>>>>>> * >>>>>>> *mysql -u openser -h 192.168.1.170 -p* >>>>>>> Enter password: >>>>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>>>> Your MySQL connection id is 68 >>>>>>> Server version: 5.1.67 Source distribution >>>>>>> >>>>>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All >>>>>>> rights reserved. >>>>>>> >>>>>>> Oracle is a registered trademark of Oracle Corporation and/or its >>>>>>> affiliates. Other names may be trademarks of their respective >>>>>>> owners. >>>>>>> >>>>>>> Type 'help;' or '\h' for help. Type '\c' to clear the current >>>>>>> input statement. >>>>>>> >>>>>>> mysql> >>>>>>> >>>>>>> With Regards >>>>>>> >>>>>>> N.Prakash >>>>>>> >>>>>>> >>>>>>>> >>>>>>>> ---------- Forwarded message ---------- >>>>>>>> From: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt; >>>>>>>> Date: Tue, Feb 12, 2013 at 5:16 PM >>>>>>>> Subject: Re: [sr-dev] [SR-Users] openser db on an external >>>>>>>> mysql server >>>>>>>> To: Development mailing list of the sip-router project < >>>>>>>> sr-dev(a)lists.sip-router.org&gt; >>>>>>>> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >>>>>>>> sr-users(a)lists.sip-router.org, Indu Priya &lt;indu(a)tevatel.com&gt;om>, >>>>>>>> Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>> >>>>>>>> >>>>>>>> Its not a Kamailio error, it is problem with connecting to >>>>>>>> mysql server. Error 4 means No MySQL Server Running On Specified Host. >>>>>>>> >>>>>>>> May be MySQL server is down or there is some firewall running >>>>>>>> or MySQL not listening on IP you specified. >>>>>>>> >>>>>>>> Thank you. >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Feb 12, 2013 at 12:11 PM, Prakash N < >>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>> >>>>>>>>> Dear Daniel, >>>>>>>>> >>>>>>>>> Thanks for your quick response >>>>>>>>> >>>>>>>>> We can able to create operseb db on remote mysql >>>>>>>>> server ,but Kamailio not getting start >>>>>>>>> >>>>>>>>> Error detail: >>>>>>>>> >>>>>>>>> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't >>>>>>>>> connect to MySQL server on '192.168.1.170' (4) >>>>>>>>> ERROR: <core> [db.c:32 0]: could not add connection to the >>>>>>>>> pool >>>>>>>>> ERROR: auth_db [authdb _mod.c:174]: unable to connect to the >>>>>>>>> database >>>>>>>>> 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) >>>>>>>>> >>>>>>>>> >>>>>>>>> I have attached my kamailo.cfg ( we followed Kamailio and >>>>>>>>> Asterisk real time installation) ,please advice >>>>>>>>> >>>>>>>>> With Regards >>>>>>>>> >>>>>>>>> N.Prakash >>>>>>>>> >>>>>>>>>> >>>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>>>>>>>> Date: Tue, Feb 12, 2013 at 2:41 PM >>>>>>>>>> Subject: Re: [SR-Users] openser db on an external mysql server >>>>>>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router >>>>>>>>>> (SER) - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt;rg>, >>>>>>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>>>>>>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Hello, >>>>>>>>>> >>>>>>>>>> kamailio database is created with: >>>>>>>>>> >>>>>>>>>> kamdbctl create >>>>>>>>>> >>>>>>>>>> the host of mysql server has to be specified in kamctlrc file >>>>>>>>>> via DBHOST variable - kamctlrc is located in same directory as kamailio.cfg. >>>>>>>>>> >>>>>>>>>> In kamailio.cfg, update the db_url value (or DBURL define) to >>>>>>>>>> reflect the mysql server host. >>>>>>>>>> >>>>>>>>>> Cheers, >>>>>>>>>> Daniel >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 2/12/13 4:16 AM, Prakash N wrote: >>>>>>>>>> >>>>>>>>>> Hi All, >>>>>>>>>> >>>>>>>>>> I am new this Kamailo ,ther is any step by step document >>>>>>>>>> to set up openser db on an external mysql server ? >>>>>>>>>> >>>>>>>>>> With Regards >>>>>>>>>> >>>>>>>>>> N.Prakash >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >>>>>>>>>> Kamailio World Conference, April 16-17, 2013, Berlin >>>>>>>>>> - http://conference.kamailio.com - >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> sr-dev mailing list >>>>>>>>> sr-dev(a)lists.sip-router.org >>>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Muhammad Shahzad >>>>>>>> ----------------------------------- >>>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>>> Cell: +49 176 99 83 10 85 >>>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Muhammad Shahzad >>>>>> ----------------------------------- >>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>> CISCO Certified Network Associate (CCNA) >>>>>> Cell: +49 176 99 83 10 85 >>>>>> MSN: shari_786pk(a)hotmail.com >>>>>> Email: shaheryarkh(a)googlemail.com >>>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> 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 >>>>> >>>>> >>>> >>>> >>> >> >> >> -- >> Muhammad Shahzad >> ----------------------------------- >> CISCO Rich Media Communication Specialist (CRMCS) >> CISCO Certified Network Associate (CCNA) >> Cell: +49 176 99 83 10 85 >> MSN: shari_786pk(a)hotmail.com >> Email: shaheryarkh(a)googlemail.com >> > > -- Muhammad Shahzad ----------------------------------- CISCO Rich Media Communication Specialist (CRMCS) CISCO Certified Network Associate (CCNA) Cell: +49 176 99 83 10 85 MSN: shari_786pk(a)hotmail.com Email: shaheryarkh(a)googlemail.com

wrote:

wrote:

wrote:

wrote:

wrote:

Try this, mysql -u openser -h 192.168.1.170 -p openser If it gives same error, then user openser does not have permission to access openser db as kamailio says. Thank you. On Tue, Feb 12, 2013 at 5:43 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: > > Hi Shahzad, > > Please find the error ,but the 'openser' already there in remote > mysql server and we can able to reach through command > with that database > > > > Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: > db_mysql [km_my_con.c:109]: driver error: Unknown database 'openser' > Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: > <core> [db.c:320]: could not add connection to the pool > Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: ERROR: > auth_db [authdb_mod.c:174]: unable to connect to the database > 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) > 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=127.0.0.1:5060" > Feb 13 03:45:50 ASTERFONE /usr/local/sbin/kamailio[7654]: : <core> > [main.c:1625]: main_loop: Cannot fork > 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) > > On Tue, Feb 12, 2013 at 9:01 PM, Muhammad Shahzad < > shaheryarkh(a)gmail.com&gt; wrote: > >> syslogs are dumped to /var/log/message in CentOS. >> >> Thank you. >> >> >> On Tue, Feb 12, 2013 at 3:47 PM, Prabhakaran B < >> prabhakaran(a)tevatel.com&gt; wrote: >> >>> Dear Shahzad >>> Im usig centos 6.3, im not able to find the sylog >>> >>> i have defined debug on kamailio.cfg if i give kamailio -dd -D 2 to >>> et the debug message >>> >>> please advice anyother way to get debug message for our issue >>> >>> With Regards >>> B.Prabhakaran >>> >>> On Tue, Feb 12, 2013 at 7:37 PM, Muhammad Shahzad < >>> shaheryarkh(a)gmail.com&gt; wrote: >>> >>>> There is no mysql error in logs. >>>> >>>> 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). >>>> >>>> Thank you. >>>> >>>> >>>> On Tue, Feb 12, 2013 at 2:54 PM, Prakash N &lt;prakash.n(a)tevatel.com&gt;wrote;wrote: >>>> >>>>> Dear Shahzad, >>>>> >>>>> Please find the debug detail >>>>> >>>>> >>>>> kamailio -dd -D 2 >>>>> >>>>> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: >>>>> new_cfg_script_var(): declaring asterisk.bindip >>>>> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: >>>>> new_cfg_script_var(): declaring asterisk.bindport >>>>> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: >>>>> new_cfg_script_var(): declaring kamailio.bindip >>>>> 0(4971) DEBUG: <core> [cfg/cfg_script.c:47]: DEBUG: >>>>> new_cfg_script_var(): declaring kamailio.bindport >>>>> 0(4971) DEBUG: <core> [cfg.y:1785]: loading modules under >>>>> /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/ >>>>> loading modules under >>>>> /usr/local/lib64/kamailio/modules_k/:/usr/local/lib64/kamailio/modules/ >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module db_mysql.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/db_mysql.so> >>>>> 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> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/db_mysql.so> >>>>> 0(4971) DEBUG: <core> [db_query.c:375]: About to allocate sql_buf >>>>> size = 65535 >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_fifo.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/mi_fifo.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module kex.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/kex.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: kex >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tm.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/tm.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/tm/tm.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/tm.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module tmx.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/tmx.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: tmx >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sl.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/sl.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/sl/sl.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/sl.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module rr.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/rr.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: rr >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module pv.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/pv.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: pv >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module maxfwd.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/maxfwd.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module usrloc.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/usrloc.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module registrar.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/registrar.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: >>>>> registrar >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module textops.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/textops.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module siputils.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/siputils.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module xlog.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/xlog.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: xlog >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module sanity.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/sanity.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/sanity/sanity.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/sanity.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module ctl.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/ctl.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/ctl/ctl.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/ctl.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module cfg_rpc.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/cfg_rpc.so> >>>>> 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> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/cfg_rpc.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module mi_rpc.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/mi_rpc.so> >>>>> 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> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/mi_rpc.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module acc.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/acc.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/auth.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/auth/auth.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/auth.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module auth_db.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/auth_db.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module debugger.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:499]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/debugger.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:522]: load_module: module file >>>>> not found </usr/local/lib64/kamailio/modules_k/debugger/debugger.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules/debugger.so> >>>>> 0(4971) DEBUG: <core> [cfg.y:1772]: loading module uac.so >>>>> 0(4971) DEBUG: <core> [sr_module.c:564]: load_module: trying to >>>>> load </usr/local/lib64/kamailio/modules_k/uac.so> >>>>> 0(4971) DEBUG: <core> [sr_module.c:343]: register PV from: uac >>>>> 0(4971) DEBUG: <core> [mem/f_malloc.c:293]: fm_malloc_init: >>>>> F_OPTIMIZE=16384, /ROUNDTO=2048 >>>>> 0(4971) DEBUG: <core> [mem/f_malloc.c:295]: fm_malloc_init: >>>>> F_HASH_SIZE=2099, fm_block size=33896 >>>>> 0(4971) DEBUG: <core> [mem/f_malloc.c:296]: >>>>> fm_malloc_init(0x7ffbe2e78000, 33554432), start=0x7ffbe2e78000 >>>>> 0(4971) DEBUG: <core> [mem/shm_mem.c:203]: shm_mem_init: success >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: >>>>> 'mi_fifo' matches module 'mi_fifo' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' >>>>> matches module 'tm' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' >>>>> matches module 'tm' >>>>> 0(4971) DEBUG: <core> [sr_module.c:770]: find_param_export: found >>>>> <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] >>>>> 0(4971) DEBUG: <core> [modparam.c:113]: set_mod_param_regex: >>>>> found <fr_timer> in module tm [/usr/local/lib64/kamailio/modules/tm.so] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'tm' >>>>> matches module 'tm' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' >>>>> matches module 'rr' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'rr' >>>>> matches module 'rr' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: >>>>> 'registrar' matches module 'registrar' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: >>>>> 'registrar' matches module 'registrar' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: >>>>> 'registrar' matches module 'registrar' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID >>>>> [FLT_ACC] value [1] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID >>>>> [FLT_ACCMISSED] value [2] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> 0(4971) DEBUG: <core> [cfg.lex:1878]: ### returning define ID >>>>> [FLT_ACCFAILED] value [3] >>>>> 0(4971) DEBUG: <core> [modparam.c:96]: set_mod_param_regex: 'acc' >>>>> matches module 'acc' >>>>> 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] >>>>> 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] >>>>> >>>>> On Tue, Feb 12, 2013 at 6:38 PM, Muhammad Shahzad < >>>>> shaheryarkh(a)gmail.com&gt; wrote: >>>>> >>>>>> These are not debug logs. I need to see what happens before below >>>>>> line, >>>>>> >>>>>> 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) >>>>>> >>>>>> You can enabled debug log either by setting line 143 to 5 OR >>>>>> define WITH_DEBUG. >>>>>> >>>>>> Thank you. >>>>>> >>>>>> >>>>>> On Tue, Feb 12, 2013 at 2:00 PM, Prakash N &lt;prakash.n(a)tevatel.com >>>>>> > wrote: >>>>>> >>>>>>> Dear Shahzad , >>>>>>> >>>>>>> Please find the error >>>>>>> >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: >>>>>>> auth_db [authdb_mod.c:174]: unable to connect to the database >>>>>>> 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) >>>>>>> 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=127.0.0.1:5060" >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: : >>>>>>> <core> [main.c:1625]: main_loop: Cannot fork >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: >>>>>>> auth_db [authdb_mod.c:174]: unable to connect to the database >>>>>>> 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) >>>>>>> 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=192.168.1.101:5060" >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> 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) >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: : >>>>>>> <core> [main.c:1625]: main_loop: Cannot fork >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: >>>>>>> auth_db [authdb_mod.c:174]: unable to connect to the database >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> 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) >>>>>>> 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) >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4439]: : >>>>>>> <core> [pass_fd.c:293]: ERROR: receive_fd: EOF on 16 >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> 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) >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: >>>>>>> auth_db [authdb_mod.c:174]: unable to connect to the database >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: >>>>>>> usrloc [ul_mod.c:407]: child(1): failed to connect to database >>>>>>> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: >>>>>>> <core> [db.c:320]: could not add connection to the pool >>>>>>> >>>>>>> >>>>> With Regards >>>>> >>>>> N.Prakash >>>>> >>>>>> >>>>>>> >>>>>>> On Tue, Feb 12, 2013 at 6:23 PM, Muhammad Shahzad < >>>>>>> shaheryarkh(a)gmail.com&gt; wrote: >>>>>>> >>>>>>>> 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. >>>>>>>> >>>>>>>> Thank you. >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Feb 12, 2013 at 1:40 PM, Prakash N < >>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>> >>>>>>>>> >>>>>>>>> Hi Govoiper >>>>>>>>> >>>>>>>>> Free Memory on my server 2309 MB >>>>>>>>> >>>>>>>>> total used free >>>>>>>>> shared buffers cached >>>>>>>>> Mem: 2795 486 2309 0 >>>>>>>>> 70 180 >>>>>>>>> -/+ buffers/cache: 234 2561 >>>>>>>>> Swap: 2927 0 2927 >>>>>>>>> >>>>>>>>> >>>>>>>>> *Kamailio error:* >>>>>>>>> * >>>>>>>>> * >>>>>>>>> ERROR: PID file /var/run/kamailio.pid does not exist -- >>>>>>>>> Kamailio start failed >>>>>>>>> >>>>>>>>> >>>>>>>>> *tail -f /var/log/messages:* >>>>>>>>> >>>>>>>>> >>>>>>>>> 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 >>>>>>>>> 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) >>>>>>>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: >>>>>>>>> ERROR: <core> [db.c:320]: could not add connection to the pool >>>>>>>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: >>>>>>>>> ERROR: usrloc [ul_mod.c:407]: child(1): failed to connect to database >>>>>>>>> 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) >>>>>>>>> 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) >>>>>>>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: >>>>>>>>> ERROR: <core> [db.c:320]: could not add connection to the pool >>>>>>>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: >>>>>>>>> ERROR: auth_db [authdb_mod.c:174]: unable to connect to the database >>>>>>>>> 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) >>>>>>>>> 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= >>>>>>>>> 127.0.0.1:5060" >>>>>>>>> Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : >>>>>>>>> <core> [main.c:1625]: main_loop: Cannot fork >>>>>>>>> >>>>>>>>> With Regards >>>>>>>>> >>>>>>>>> N.Prakash >>>>>>>>> >>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>>> From: SamyGo &lt;govoiper(a)gmail.com&gt; >>>>>>>>>> Date: Tue, Feb 12, 2013 at 5:49 PM >>>>>>>>>> Subject: Re: [SR-Users] [sr-dev] openser db on an external >>>>>>>>>> mysql server >>>>>>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router >>>>>>>>>> (SER) - Users Mailing List" &lt;sr-users(a)lists.sip-router.org&gt; >>>>>>>>>> Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, >>>>>>>>>> sr-dev(a)lists.sip-router.org, Prabhakaran B < >>>>>>>>>> prabhakaran(a)tevatel.com&gt;gt;, Indu Priya &lt;indu(a)tevatel.com&gt; >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Hi Prakash, >>>>>>>>>> >>>>>>>>>> Please paste All ERROR appearing and Warnings when you start >>>>>>>>>> your kamailio. What is the free memory situation on your server ? >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> Sammy >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Feb 12, 2013 at 5:12 PM, Prakash N < >>>>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>>>> >>>>>>>>>>> Hi Muhammad, >>>>>>>>>>> >>>>>>>>>>> Yes, I have define Mysql on top in Kamailio.cfg >>>>>>>>>>> >>>>>>>>>>> DBURL "mysql://openser:openserrw@192.168.1.170/openser" >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> I have attached Kamailio.cfg ,please advice >>>>>>>>>>> >>>>>>>>>>> With Regards >>>>>>>>>>> >>>>>>>>>>> N.Prakash >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad < >>>>>>>>>>> shaheryarkh(a)gmail.com&gt; wrote: >>>>>>>>>>> >>>>>>>>>>>> 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. >>>>>>>>>>>> >>>>>>>>>>>> #!define WITH_MYSQL >>>>>>>>>>>> >>>>>>>>>>>> Thank you. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Feb 12, 2013 at 12:56 PM, Prakash N < >>>>>>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Shahzad , >>>>>>>>>>>>> >>>>>>>>>>>>> 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 >>>>>>>>>>>>> >>>>>>>>>>>>> *Mysql server : 192.168.1.170* >>>>>>>>>>>>> *Kamailio server : 192.168.1.101* >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> *Mysql output :* >>>>>>>>>>>>> * >>>>>>>>>>>>> * >>>>>>>>>>>>> *mysql -u openser -h 192.168.1.170 -p* >>>>>>>>>>>>> Enter password: >>>>>>>>>>>>> Welcome to the MySQL monitor. Commands end with ; or \g. >>>>>>>>>>>>> Your MySQL connection id is 68 >>>>>>>>>>>>> Server version: 5.1.67 Source distribution >>>>>>>>>>>>> >>>>>>>>>>>>> Copyright (c) 2000, 2012, Oracle and/or its affiliates. >>>>>>>>>>>>> All rights reserved. >>>>>>>>>>>>> >>>>>>>>>>>>> Oracle is a registered trademark of Oracle Corporation >>>>>>>>>>>>> and/or its >>>>>>>>>>>>> affiliates. Other names may be trademarks of their >>>>>>>>>>>>> respective >>>>>>>>>>>>> owners. >>>>>>>>>>>>> >>>>>>>>>>>>> Type 'help;' or '\h' for help. Type '\c' to clear the >>>>>>>>>>>>> current input statement. >>>>>>>>>>>>> >>>>>>>>>>>>> mysql> >>>>>>>>>>>>> >>>>>>>>>>>>> With Regards >>>>>>>>>>>>> >>>>>>>>>>>>> N.Prakash >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>>>>>>> From: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt; >>>>>>>>>>>>>> Date: Tue, Feb 12, 2013 at 5:16 PM >>>>>>>>>>>>>> Subject: Re: [sr-dev] [SR-Users] openser db on an >>>>>>>>>>>>>> external mysql server >>>>>>>>>>>>>> To: Development mailing list of the sip-router project < >>>>>>>>>>>>>> sr-dev(a)lists.sip-router.org&gt; >>>>>>>>>>>>>> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >>>>>>>>>>>>>> sr-users(a)lists.sip-router.org, Indu Priya < >>>>>>>>>>>>>> indu(a)tevatel.com&gt;gt;, Prabhakaran B &lt;prabhakaran(a)tevatel.com >>>>>>>>>>>>>> > >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> Its not a Kamailio error, it is problem with connecting >>>>>>>>>>>>>> to mysql server. Error 4 means No MySQL Server Running On Specified Host. >>>>>>>>>>>>>> >>>>>>>>>>>>>> May be MySQL server is down or there is some firewall >>>>>>>>>>>>>> running or MySQL not listening on IP you specified. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thank you. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Tue, Feb 12, 2013 at 12:11 PM, Prakash N < >>>>>>>>>>>>>> prakash.n(a)tevatel.com&gt; wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Dear Daniel, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Thanks for your quick response >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> We can able to create operseb db on remote mysql >>>>>>>>>>>>>>> server ,but Kamailio not getting start >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Error detail: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> ERROR: db_mysql [km_my_con.c:109]: driver error: Can't >>>>>>>>>>>>>>> connect to MySQL server on '192.168.1.170' (4) >>>>>>>>>>>>>>> ERROR: <core> [db.c:32 0]: could not add connection to >>>>>>>>>>>>>>> the pool >>>>>>>>>>>>>>> ERROR: auth_db [authdb _mod.c:174]: unable to connect >>>>>>>>>>>>>>> to the database >>>>>>>>>>>>>>> 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) >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I have attached my kamailo.cfg ( we followed Kamailio >>>>>>>>>>>>>>> and Asterisk real time installation) ,please advice >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> With Regards >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> N.Prakash >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> ---------- Forwarded message ---------- >>>>>>>>>>>>>>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>>>>>>>>>>>>>> Date: Tue, Feb 12, 2013 at 2:41 PM >>>>>>>>>>>>>>>> Subject: Re: [SR-Users] openser db on an external mysql >>>>>>>>>>>>>>>> server >>>>>>>>>>>>>>>> To: "SIP Router - Kamailio (OpenSER) and SIP Express >>>>>>>>>>>>>>>> Router (SER) - Users Mailing List" < >>>>>>>>>>>>>>>> sr-users(a)lists.sip-router.org&gt;gt;, >>>>>>>>>>>>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>>>>>>>>>>>>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hello, >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> kamailio database is created with: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> kamdbctl create >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> the host of mysql server has to be specified in >>>>>>>>>>>>>>>> kamctlrc file via DBHOST variable - kamctlrc is located in same directory >>>>>>>>>>>>>>>> as kamailio.cfg. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> In kamailio.cfg, update the db_url value (or DBURL >>>>>>>>>>>>>>>> define) to reflect the mysql server host. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Cheers, >>>>>>>>>>>>>>>> Daniel >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On 2/12/13 4:16 AM, Prakash N wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Hi All, >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I am new this Kamailo ,ther is any step by step >>>>>>>>>>>>>>>> document to set up openser db on an external mysql server ? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> With Regards >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> N.Prakash >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>> Daniel-Constantin Mierla - http://www.asipto.comhttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda >>>>>>>>>>>>>>>> Kamailio World Conference, April 16-17, 2013, Berlin >>>>>>>>>>>>>>>> - http://conference.kamailio.com - >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>> sr-dev mailing list >>>>>>>>>>>>>>> sr-dev(a)lists.sip-router.org >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> Muhammad Shahzad >>>>>>>>>>>>>> ----------------------------------- >>>>>>>>>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>>>>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>>>>>>>>> Cell: +49 176 99 83 10 85 >>>>>>>>>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>>>>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> Muhammad Shahzad >>>>>>>>>>>> ----------------------------------- >>>>>>>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>>>>>>> Cell: +49 176 99 83 10 85 >>>>>>>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> 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 >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Muhammad Shahzad >>>>>>>> ----------------------------------- >>>>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>>>> CISCO Certified Network Associate (CCNA) >>>>>>>> Cell: +49 176 99 83 10 85 >>>>>>>> MSN: shari_786pk(a)hotmail.com >>>>>>>> Email: shaheryarkh(a)googlemail.com >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Muhammad Shahzad >>>>>> ----------------------------------- >>>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>>> CISCO Certified Network Associate (CCNA) >>>>>> Cell: +49 176 99 83 10 85 >>>>>> MSN: shari_786pk(a)hotmail.com >>>>>> Email: shaheryarkh(a)googlemail.com >>>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Muhammad Shahzad >>>> ----------------------------------- >>>> CISCO Rich Media Communication Specialist (CRMCS) >>>> CISCO Certified Network Associate (CCNA) >>>> Cell: +49 176 99 83 10 85 >>>> MSN: shari_786pk(a)hotmail.com >>>> Email: shaheryarkh(a)googlemail.com >>>> >>> >>> >> >> >> -- >> Muhammad Shahzad >> ----------------------------------- >> CISCO Rich Media Communication Specialist (CRMCS) >> CISCO Certified Network Associate (CCNA) >> Cell: +49 176 99 83 10 85 >> MSN: shari_786pk(a)hotmail.com >> Email: shaheryarkh(a)googlemail.com >> > > -- Muhammad Shahzad ----------------------------------- CISCO Rich Media Communication Specialist (CRMCS) CISCO Certified Network Associate (CCNA) Cell: +49 176 99 83 10 85 MSN: shari_786pk(a)hotmail.com Email: shaheryarkh(a)googlemail.com