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

From: SamyGo &lt;govoiper(a)gmail.com&gt; Date: Tue, Feb 12, 2013 at 5:49 PM Subject: Re: [SR-Users] [sr-dev] 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; Cc: Muhammad Shahzad &lt;shaheryarkh(a)gmail.com&gt;om>, sr-dev(a)lists.sip-router.org, Prabhakaran B &lt;prabhakaran(a)tevatel.com&gt;om>, Indu Priya &lt;indu(a)tevatel.com&gt; 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 &lt;prakash.n(a)tevatel.com&gt;wrote;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(a)gmail.com&gt; 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 >> > > > _______________________________________________ > SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list > sr-users(a)lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > >