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 <shaherya...@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 <prakas...@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 <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 >>> >>> >> > > > -- > 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 >
kamailio.cfg
Description: Binary data
_______________________________________________ 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
