[SR-Users] kamailio 4.2 ,have some problems when use mysql db

Daniel-Constantin Mierla miconda at gmail.com
Mon Oct 20 11:09:34 CEST 2014


Are both computers using same database or each of them has a database
server locally?

Do you use same configuration file and command line parameters on both
systems? Can you start with higher pkg memory on the computer where you
have troubles? Like:

kamailio -M 12 ...

Cheers,
Daniel

On 20/10/14 10:20, 张顺通 wrote:
> I have two computer, one is ok ,the other can not startup.
>
> 2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang at gmail.com
> <mailto:shuntongzhang at gmail.com>>:
>
>     mysql operation is all ok.
>
>     no private memory left.
>     pkg_malloc is failed.
>
>
>     发自我的小米手机
>
>     在 2014年10月20日 下午1:51,Gonzalo Gasca <gascagonzalo at gmail.com
>     <mailto:gascagonzalo at gmail.com>> 写道:
>
>         Hi,
>
>         Based on:
>
>         Oct 20 08:14:45 ka[15500]: ERROR: <core> [db.c:401]:
>         db_table_version(): error in db_query
>         Oct 20 08:14:45 ka[15500]: ERROR: dispatcher [dispatch.c:669]:
>         init_ds_db(): failed to query table version
>
>         What's the result when you run a direct mysql query for
>         "version" table for the following "select * from version":
>
>         Example:
>
>         mysql -h localhost -P 3306 -u root -p
>
>         mysql> use kamailiodb; <Use your kamailio Db name here>
>
>         mysql>desc version;
>
>         mysql> select count(*) from version; 
>
>         mysql> select * from version; 
>
>         /G
>
>
>
>         On Sun, Oct 19, 2014 at 6:38 PM, 张顺通
>         <shuntongzhang at gmail.com <mailto:shuntongzhang at gmail.com>> wrote:
>
>             Oct 20 08:14:45 ka[15500]: INFO: rr
>             [../outbound/api.h:54]: ob_load_api(): Failed to import
>             bind_ob
>             Oct 20 08:14:45 ka[15500]: INFO: rr [rr_mod.c:160]:
>             mod_init(): outbound module not available
>             Oct 20 08:14:45 ka[15500]: INFO: usrloc [hslot.c:53]:
>             ul_init_locks(): locks array size 1024
>             Oct 20 08:14:45 ka[15500]: INFO: auth [auth_mod.c:350]:
>             mod_init(): auth: qop set, but nonce-count (nc_enabled)
>             support disabled
>             Oct 20 08:14:45 ka[15500]: ERROR: <core> [db_res.c:114]:
>             db_new_result(): no private memory left
>             Oct 20 08:14:45 ka[15500]: ERROR: db_mysql
>             [km_dbase.c:229]: db_mysql_store_result(): no memory left
>             Oct 20 08:14:45 ka[15500]: ERROR: <core> [db_query.c:139]:
>             db_do_query_internal(): error while storing result
>             Oct 20 08:14:45 ka[15500]: ERROR: <core> [db.c:401]:
>             db_table_version(): error in db_query
>             Oct 20 08:14:45 ka[15500]: ERROR: dispatcher
>             [dispatch.c:669]: init_ds_db(): failed to query table version
>             Oct 20 08:14:45 ka[15500]: ERROR: dispatcher
>             [dispatcher.c:319]: mod_init(): could not initiate a
>             connect to the database
>             Oct 20 08:14:45 ka[15500]: ERROR: <core>
>             [sr_module.c:968]: init_mod(): Error while initializing
>             module dispatcher (/lib64/kamailio/dispatcher.so)
>
>             I need help.thks
>
>             _______________________________________________
>             SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
>             mailing list
>             sr-users at lists.sip-router.org
>             <mailto:sr-users at lists.sip-router.org>
>             http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>
>
> _______________________________________________
> 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

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141020/d038576f/attachment.html>


More information about the sr-users mailing list