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

[Muhammad Shahzad]

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

>     Hi Shahzad ,
>
>         It is not ,We can able to connect remote mysql ( please find the
> 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 at 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 at lists.sip-router.org>
>> Cc: Daniel-Constantin Mierla <miconda at gmail.com>,
>> sr-users at lists.sip-router.org, Indu Priya <indu at tevatel.com>,
>> Prabhakaran B <prabhakaran at 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 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
>>
>>
>


-- 
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-dev/attachments/20130212/c8abd1e5/attachment.htm>