kamailio.cfg looks OK, can you increase the debug level to 4+, start kamailio and send me logs? May be we can find something in logs.
Thank you. On Tue, Feb 12, 2013 at 1:40 PM, Prakash N <prakas...@tevatel.com> wrote: > > Hi Govoiper > > Free Memory on my server 2309 MB > > total used free shared buffers > cached > Mem: 2795 486 2309 0 70 > 180 > -/+ buffers/cache: 234 2561 > Swap: 2927 0 2927 > > > *Kamailio error:* > * > * > ERROR: PID file /var/run/kamailio.pid does not exist -- Kamailio start > failed > > > *tail -f /var/log/messages:* > > > Feb 12 23:41:28 localhost /usr/local/sbin/kamailio[4280]: INFO: <core> > [udp_server.c:230]: INFO: udp_init: SO_RCVBUF is finally 262142 > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: db_mysql > [km_my_con.c:109]: driver error: Can't connect to MySQL server on > '192.168.1.170' (4) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> > [db.c:320]: could not add connection to the pool > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: usrloc > [ul_mod.c:407]: child(1): failed to connect to database > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4281]: ERROR: <core> > [sr_module.c:896]: init_mod_child(): Error while initializing module usrloc > (/usr/local/lib64/kamailio/modules_k/usrloc.so) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: db_mysql > [km_my_con.c:109]: driver error: Can't connect to MySQL server on > '192.168.1.170' (4) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> > [db.c:320]: could not add connection to the pool > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: auth_db > [authdb_mod.c:174]: unable to connect to the database > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> > [sr_module.c:896]: init_mod_child(): Error while initializing module > auth_db (/usr/local/lib64/kamailio/modules_k/auth_db.so) > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: ERROR: <core> > [pt.c:350]: ERROR: fork_process(): init_child failed for process 3, pid > 4283, "udp receiver child=2 sock=127.0.0.1:5060" > Feb 12 23:41:30 localhost /usr/local/sbin/kamailio[4283]: : <core> > [main.c:1625]: main_loop: Cannot fork > > With Regards > > N.Prakash > > ---------- Forwarded message ---------- >> From: SamyGo <govoi...@gmail.com> >> 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" <sr-users@lists.sip-router.org> >> Cc: Muhammad Shahzad <shaherya...@gmail.com>, >> sr-...@lists.sip-router.org, Prabhakaran B <prabhaka...@tevatel.com>, >> Indu Priya <i...@tevatel.com> >> >> >> 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 <prakas...@tevatel.com> 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 <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 >>>> >>> >>> >>> _______________________________________________ >>> 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 >>> >>> >> >> > -- 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
