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@gmail.comwrote:
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@tevatel.com wrote:
Hi Govoiper
Free Memory on my server 2309 MB
total used free sharedbuffers 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 govoiper@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 shaheryarkh@gmail.com, sr-dev@lists.sip-router.org, Prabhakaran B prabhakaran@tevatel.com, Indu Priya indu@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 prakash.n@tevatel.comwrote:
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@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 prakash.n@tevatel.comwrote:
Hi Shahzad , It is not ,We can able to connect remote mysql ( please findthe 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 shaheryarkh@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-dev@lists.sip-router.org> > Cc: Daniel-Constantin Mierla miconda@gmail.com, > sr-users@lists.sip-router.org, Indu Priya indu@tevatel.com, > Prabhakaran B prabhakaran@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@tevatel.comwrote: > >> 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 miconda@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-dev@lists.sip-router.org, miconda@gmail.com >>> Cc: Prabhakaran B prabhakaran@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-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@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@hotmail.com > Email: shaheryarkh@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@hotmail.com Email: shaheryarkh@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_786pk@hotmail.com Email: shaheryarkh@googlemail.com