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

Prakash N prakash.n at tevatel.com
Tue Feb 12 14:00:43 CET 2013


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130212/ca503ccd/attachment-0001.htm>


More information about the sr-dev mailing list