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 <shaherya...@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-...@lists.sip-router.org>
> Cc: Daniel-Constantin Mierla <mico...@gmail.com>,
> sr-users@lists.sip-router.org, Indu Priya <i...@tevatel.com>, Prabhakaran
> B <prabhaka...@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 <prakas...@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 <mico...@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@lists.sip-router.org>,
>>> sr-...@lists.sip-router.org, mico...@gmail.com
>>> Cc: Prabhakaran B <prabhaka...@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-us...@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-...@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_78...@hotmail.com
> Email: shaherya...@googlemail.com
>
>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
