[SR-Users] [sr-dev] openser db on an external mysql server
SamyGo
govoiper at gmail.com
Tue Feb 12 13:19:45 CET 2013
Hi Prakash,
Please paste All ERROR appearing and Warnings when you start your kamailio.
What is the free memory situation on your server ?
Regards,
Sammy
On Tue, Feb 12, 2013 at 5:12 PM, Prakash N <prakash.n at tevatel.com> wrote:
> 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
>>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130212/54e1f8ef/attachment.htm>
More information about the sr-users
mailing list