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 <shaherya...@gmail.com>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 <prakas...@tevatel.com> 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 <govoi...@gmail.com> >>> 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" <sr-users@lists.sip-router.org> >>> Cc: Muhammad Shahzad <shaherya...@gmail.com>, >>> sr-...@lists.sip-router.org, Prabhakaran B <prabhaka...@tevatel.com>, >>> Indu Priya <i...@tevatel.com> >>> >>> >>> 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 <prakas...@tevatel.com>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 < >>>> shaherya...@gmail.com> 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 <prakas...@tevatel.com>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 <shaherya...@gmail.com> >>>>>>> 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-...@lists.sip-router.org> >>>>>>> Cc: Daniel-Constantin Mierla <mico...@gmail.com>, >>>>>>> sr-users@lists.sip-router.org, Indu Priya <i...@tevatel.com>, >>>>>>> Prabhakaran B <prabhaka...@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 >>>>>>> <prakas...@tevatel.com>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 <mico...@gmail.com> >>>>>>>>> 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@lists.sip-router.org>, >>>>>>>>> sr-...@lists.sip-router.org, mico...@gmail.com >>>>>>>>> Cc: Prabhakaran B <prabhaka...@tevatel.com> >>>>>>>>> >>>>>>>>> >>>>>>>>> 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-us...@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-...@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_78...@hotmail.com >>>>>>> Email: shaherya...@googlemail.com >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Muhammad Shahzad >>>>> ----------------------------------- >>>>> CISCO Rich Media Communication Specialist (CRMCS) >>>>> CISCO Certified Network Associate (CCNA) >>>>> Cell: +49 176 99 83 10 85 >>>>> MSN: shari_78...@hotmail.com >>>>> Email: shaherya...@googlemail.com >>>>> >>>> >>>> >>>> _______________________________________________ >>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list >>>> sr-users@lists.sip-router.org >>>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> >> > > > -- > Muhammad Shahzad > ----------------------------------- > CISCO Rich Media Communication Specialist (CRMCS) > CISCO Certified Network Associate (CCNA) > Cell: +49 176 99 83 10 85 > MSN: shari_78...@hotmail.com > Email: shaherya...@googlemail.com >
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
