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

Can you set in kamailio.cfg:

debug=3 memdbg=2 memlog=2

and send the syslog messages printed by kamailio from the moment of starting it to me?

They can be a lot, would be good if you can make an archive (tgz) and put it somewhere for download.

Cheers, Daniel

On 20/10/14 11:00, 张顺通 wrote:

when open MEMDBG ?= 1, I get this

<core> [mem/q_malloc.c:159]: qm_debug_frag(): BUG: qm_*: prev. fragm. tail overwritten(0, 0)[0x7f64241cdfc0:0x7f64241cdff0]!

2014-10-20 16:20 GMT+08:00 张顺通 <shuntongzhang@gmail.com mailto:shuntongzhang@gmail.com>:

I have two computer, one is ok ,the other can not startup.

2014-10-20 14:52 GMT+08:00 shuntongzhang <shuntongzhang@gmail.com
<mailto:shuntongzhang@gmail.com>>:

    mysql operation is all ok.

    no private memory left.
    pkg_malloc is failed.


    发自我的小米手机

    在 2014年10月20日 下午1:51，Gonzalo Gasca
    <gascagonzalo@gmail.com <mailto:gascagonzalo@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@gmail.com <mailto:shuntongzhang@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@lists.sip-router.org
            <mailto:sr-users@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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users