12 Feb
2013
12 Feb
'13
1:07 p.m.
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(a)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
--
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk(a)hotmail.com
Email: shaheryarkh(a)googlemail.com
---------- Forwarded message ----------
From: Muhammad Shahzad <shaheryarkh(a)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(a)lists.sip-router.org>
Cc: Daniel-Constantin Mierla <miconda(a)gmail.com>om>,
sr-users(a)lists.sip-router.org, Indu Priya <indu(a)tevatel.com>om>,
Prabhakaran B <prabhakaran(a)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(a)tevatel.com>wrote;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
--
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk(a)hotmail.com
Email: shaheryarkh(a)googlemail.com
---------- Forwarded message ----------
From: Daniel-Constantin Mierla <miconda(a)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(a)lists.sip-router.org>rg>,
sr-dev(a)lists.sip-router.org, miconda(a)gmail.com
Cc: Prabhakaran B <prabhakaran(a)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@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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev