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

Tue Feb 12 13:12:52 CET 2013

Hi Muhammad,

   Yes, I have define Mysql on top in Kamailio.cfg

   DBURL "mysql://openser:openserrw@192.168.1.170/openser"

  I have attached Kamailio.cfg ,please advice

With Regards

N.Prakash

On Tue, Feb 12, 2013 at 5:37 PM, Muhammad Shahzad <shaheryarkh at gmail.com>wrote:

> 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/1bd329cb/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/1bd329cb/attachment-0001.obj>