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 list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
 - http://conference.kamailio.com -