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(a)tevatel.com>wrote;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(a)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(a)lists.sip-router.org>
> Cc: Muhammad Shahzad <shaheryarkh(a)gmail.com>om>,
> sr-dev(a)lists.sip-router.org, Prabhakaran B <prabhakaran(a)tevatel.com>om>,
> Indu Priya <indu(a)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(a)tevatel.com>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> 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(a)tevatel.com>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 <shaheryarkh(a)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(a)lists.sip-router.org>
>>>>> Cc: Daniel-Constantin Mierla <miconda(a)gmail.com>om>,
>>>>> sr-users(a)lists.sip-router.org, Indu Priya <indu(a)tevatel.com>om>,
>>>>> Prabhakaran B <prabhakaran(a)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(a)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(a)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(a)lists.sip-router.org>rg>,
>>>>>>> sr-dev(a)lists.sip-router.org, miconda(a)gmail.com
>>>>>>> Cc: Prabhakaran B <prabhakaran(a)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@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
>>
>>
>
>
--
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