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
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.com wrote:
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
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-
Muhammad Shahzad -
Prakash N