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

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 &lt;prakash.n(a)tevatel.com&gt;wrote;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 &lt;shaheryarkh(a)gmail.com&gt; >> 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&gt; >> Cc: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;om>, >> sr-users(a)lists.sip-router.org, Indu Priya &lt;indu(a)tevatel.com&gt;om>, >> Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >> >> >> 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 &lt;prakash.n(a)tevatel.com&gt;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 >>> >>>> >>>> ---------- Forwarded message ---------- >>>> From: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; >>>> 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" &lt;sr-users(a)lists.sip-router.org&gt;rg>, >>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com >>>> Cc: Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt; >>>> >>>> >>>> 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 >>> >>> >> >> >> -- >> 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 >> >> > -- 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