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

[Gonzalo Gasca]

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> 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
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20141019/07623153/attachment.html>