[sr-dev] [SR-Users] openser db on an external mysql server

[Prakash N]

     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 at 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 at lists.sip-router.org>, sr-dev at lists.sip-router.org,
> miconda at gmail.com
> Cc: Prabhakaran B <prabhakaran at 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 at 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 -
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/d17e9055/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kamailio.cfg
Type: application/octet-stream
Size: 22886 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/d17e9055/attachment-0001.obj>