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

Muhammad Shahzad shaheryarkh at gmail.com
Tue Feb 12 14:08:43 CET 2013


These are not debug logs. I need to see what happens before below line,

Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: db_mysql
[km_my_con.c:109]: driver error: Can't connect to MySQL server on
'192.168.1.170' (4)

You can enabled debug log either by setting line 143 to 5 OR define
WITH_DEBUG.

Thank you.


On Tue, Feb 12, 2013 at 2:00 PM, Prakash N <prakash.n at tevatel.com> wrote:

> Dear Shahzad ,
>
>  Please find the error
>
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: auth_db
> [authdb_mod.c:174]: unable to connect to the database
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: 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 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: ERROR: <core>
> [pt.c:350]: ERROR: fork_process(): init_child failed for  process 2, pid
> 4424, "udp receiver child=1 sock=127.0.0.1:5060"
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4424]: : <core>
> [main.c:1625]: main_loop: Cannot fork
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: auth_db
> [authdb_mod.c:174]: unable to connect to the database
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: 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 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: ERROR: <core>
> [pt.c:350]: ERROR: fork_process(): init_child failed for  process 5, pid
> 4427, "udp receiver child=0 sock=192.168.1.101:5060"
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4427]: : <core>
> [main.c:1625]: main_loop: Cannot fork
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: ERROR: auth_db
> [authdb_mod.c:174]: unable to connect to the database
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4430]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4431]: ERROR: db_mysql
> [km_my_con.c:109]: driver error: Can't connect to MySQL server on
> '192.168.1.170' (4)
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4439]: : <core>
> [pass_fd.c:293]: ERROR: receive_fd: EOF on 16
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4432]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4428]: 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 13 00:06:05 localhost /usr/local/sbin/kamailio[4429]: ERROR: auth_db
> [authdb_mod.c:174]: unable to connect to the database
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4423]: ERROR: usrloc
> [ul_mod.c:407]: child(1): failed to connect to database
> Feb 13 00:06:05 localhost /usr/local/sbin/kamailio[4433]: ERROR: <core>
> [db.c:320]: could not add connection to the pool
>
>
>
> On Tue, Feb 12, 2013 at 6:23 PM, Muhammad Shahzad <shaheryarkh at gmail.com>wrote:
>
>> 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 <prakash.n at 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 <govoiper at 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 at lists.sip-router.org>
>>>>  Cc: Muhammad Shahzad <shaheryarkh at gmail.com>,
>>>> sr-dev at lists.sip-router.org, Prabhakaran B <prabhakaran at tevatel.com>,
>>>> Indu Priya <indu at 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 <prakash.n at 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 <
>>>>> shaheryarkh at 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 <prakash.n at 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 <shaheryarkh at 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 at lists.sip-router.org>
>>>>>>>> Cc: Daniel-Constantin Mierla <miconda at gmail.com>,
>>>>>>>> sr-users at lists.sip-router.org, Indu Priya <indu at tevatel.com>,
>>>>>>>> Prabhakaran B <prabhakaran at 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 at 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 <miconda at 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 at lists.sip-router.org>,
>>>>>>>>>> sr-dev at lists.sip-router.org, miconda at gmail.com
>>>>>>>>>> Cc: Prabhakaran B <prabhakaran at 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 at 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 at 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 at hotmail.com
>>>>>>>> Email: shaheryarkh at 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 at hotmail.com
>>>>>> Email: shaheryarkh at googlemail.com
>>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>>>>> sr-users at 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_786pk at hotmail.com
>> Email: shaheryarkh at 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 at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/88636ede/attachment-0001.htm>


More information about the sr-dev mailing list