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 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.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 shaheryarkh@gmail.comwrote:
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 ,butKamailio 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