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

[Muhammad Shahzad]

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 at tevatel.com> wrote:

>      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 -
>>
>>
>>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at 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 at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130212/4ac717c0/attachment-0001.htm>