Mysql

List overview All Threads
Download

newer

older

Kamailio Docker 5.2.1

segfault error - process stopped

Nicolas Breuer

4 Nov 2018 4 Nov '18

9:09 a.m.

Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

Attachments:

attachment.html (text/html — 2.5 KB)

Show replies by date

Daniel-Constantin Mierla

5 Nov 5 Nov

8:35 a.m.

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote:

...

Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio World Conference -- www.kamailioworld.com Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com

Nicolas Breuer

8:37 a.m.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sip_trace | CREATE TABLE `sip_trace` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01', `time_us` int(10) unsigned NOT NULL DEFAULT '0', `callid` varchar(255) NOT NULL DEFAULT '', `traced_user` varchar(128) NOT NULL DEFAULT '', `msg` mediumtext NOT NULL, `method` varchar(50) NOT NULL DEFAULT '', `status` varchar(128) NOT NULL DEFAULT '', `fromip` varchar(50) NOT NULL DEFAULT '', `toip` varchar(50) NOT NULL DEFAULT '', `fromtag` varchar(64) NOT NULL DEFAULT '', `totag` varchar(64) NOT NULL DEFAULT '', `direction` varchar(4) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `traced_user_idx` (`traced_user`), KEY `date_idx` (`time_stamp`), KEY `fromip_idx` (`fromip`), KEY `callid_idx` (`callid`), KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:35 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Nicolas Breuer Nicolas.Breuer@belcenter.biz Objet : Re: [SR-Users] Mysql

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla

8:44 a.m.

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

On 05.11.18 09:37, Nicolas Breuer wrote:

...

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| sip_trace | CREATE TABLE `sip_trace` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',

`time_us` int(10) unsigned NOT NULL DEFAULT '0',

`callid` varchar(255) NOT NULL DEFAULT '',

`traced_user` varchar(128) NOT NULL DEFAULT '',

`msg` mediumtext NOT NULL,

`method` varchar(50) NOT NULL DEFAULT '',

`status` varchar(128) NOT NULL DEFAULT '',

`fromip` varchar(50) NOT NULL DEFAULT '',

`toip` varchar(50) NOT NULL DEFAULT '',

`fromtag` varchar(64) NOT NULL DEFAULT '',

`totag` varchar(64) NOT NULL DEFAULT '',

`direction` varchar(4) NOT NULL DEFAULT '',

PRIMARY KEY (`id`),

KEY `traced_user_idx` (`traced_user`),

KEY `date_idx` (`time_stamp`),

KEY `fromip_idx` (`fromip`),

KEY `callid_idx` (`callid`),

KEY `id` (`id`),

KEY `id_2` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC |

+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

*De :*Daniel-Constantin Mierla miconda@gmail.com *Envoyé :* lundi 5 novembre 2018 09:35 *À :* Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Nicolas Breuer Nicolas.Breuer@belcenter.biz *Objet :* Re: [SR-Users] Mysql

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote:
Hello,

 

Working on sip_trace table produce this error

 

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns():
unhandled data type column (Msg_text) type id (250), use
DB1_STRING as default

 

 




_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.org <mailto:sr-users@lists.kamailio.org>

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla -- www.asipto.com http://www.asipto.com www.twitter.com/miconda http://www.twitter.com/miconda -- www.linkedin.com/in/miconda http://www.linkedin.com/in/miconda Kamailio World Conference -- www.kamailioworld.com http://www.kamailioworld.com Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com http://www.asipto.com

Nicolas Breuer

9:40 a.m.

Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:45 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

On 05.11.18 09:37, Nicolas Breuer wrote: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | sip_trace | CREATE TABLE `sip_trace` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01', `time_us` int(10) unsigned NOT NULL DEFAULT '0', `callid` varchar(255) NOT NULL DEFAULT '', `traced_user` varchar(128) NOT NULL DEFAULT '', `msg` mediumtext NOT NULL, `method` varchar(50) NOT NULL DEFAULT '', `status` varchar(128) NOT NULL DEFAULT '', `fromip` varchar(50) NOT NULL DEFAULT '', `toip` varchar(50) NOT NULL DEFAULT '', `fromtag` varchar(64) NOT NULL DEFAULT '', `totag` varchar(64) NOT NULL DEFAULT '', `direction` varchar(4) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `traced_user_idx` (`traced_user`), KEY `date_idx` (`time_stamp`), KEY `fromip_idx` (`fromip`), KEY `callid_idx` (`callid`), KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC | +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:35 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org; Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz Objet : Re: [SR-Users] Mysql

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla

10:56 a.m.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote:

...

Hello,

We see the error when this procedure is executed :

BEGIN

delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH;

OPTIMIZE TABLE sip_trace;

END $$

*De :*Daniel-Constantin Mierla miconda@gmail.com *Envoyé :* lundi 5 novembre 2018 09:45 *À :* Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org *Objet :* Re: [SR-Users] Mysql

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

On 05.11.18 09:37, Nicolas Breuer wrote:

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| sip_trace | CREATE TABLE `sip_trace` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',

  `time_us` int(10) unsigned NOT NULL DEFAULT '0',

  `callid` varchar(255) NOT NULL DEFAULT '',

  `traced_user` varchar(128) NOT NULL DEFAULT '',

  `msg` mediumtext NOT NULL,

  `method` varchar(50) NOT NULL DEFAULT '',

  `status` varchar(128) NOT NULL DEFAULT '',

  `fromip` varchar(50) NOT NULL DEFAULT '',

  `toip` varchar(50) NOT NULL DEFAULT '',

  `fromtag` varchar(64) NOT NULL DEFAULT '',

  `totag` varchar(64) NOT NULL DEFAULT '',

  `direction` varchar(4) NOT NULL DEFAULT '',

  PRIMARY KEY (`id`),

  KEY `traced_user_idx` (`traced_user`),

  KEY `date_idx` (`time_stamp`),

  KEY `fromip_idx` (`fromip`),

  KEY `callid_idx` (`callid`),

  KEY `id` (`id`),

  KEY `id_2` (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1
ROW_FORMAT=DYNAMIC |

+-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

*De :*Daniel-Constantin Mierla <miconda@gmail.com>
<mailto:miconda@gmail.com>
*Envoyé :* lundi 5 novembre 2018 09:35
*À :* Kamailio (SER) - Users Mailing List
<sr-users@lists.kamailio.org>
<mailto:sr-users@lists.kamailio.org>; Nicolas Breuer
<Nicolas.Breuer@belcenter.biz> <mailto:Nicolas.Breuer@belcenter.biz>
*Objet :* Re: [SR-Users] Mysql

 

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers,
Daniel

 

On 04.11.18 10:09, Nicolas Breuer wrote:

    Hello,

     

    Working on sip_trace table produce this error

     

    WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns():
    unhandled data type column (Msg_text) type id (250), use
    DB1_STRING as default

     

     





    _______________________________________________

    Kamailio (SER) - Users Mailing List

    sr-users@lists.kamailio.org <mailto:sr-users@lists.kamailio.org>

    https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users




-- 

Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>

Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>

-- Daniel-Constantin Mierla -- www.asipto.com http://www.asipto.com www.twitter.com/miconda http://www.twitter.com/miconda -- www.linkedin.com/in/miconda http://www.linkedin.com/in/miconda Kamailio World Conference -- www.kamailioworld.com http://www.kamailioworld.com Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com http://www.asipto.com

Nicolas Breuer

11:04 a.m.

It's a stored sql procedure launched by the rtimer module.

De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:45 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla

11:16 a.m.

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote:

...

It’s a stored sql procedure launched by the rtimer module.

*De :*Daniel-Constantin Mierla miconda@gmail.com *Envoyé :* lundi 5 novembre 2018 11:57 *À :* Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org *Objet :* Re: [SR-Users] Mysql

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote:

Hello,

 

We see the error when this procedure is executed :

 

BEGIN

  delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH;

  OPTIMIZE TABLE sip_trace;

END $$

 

*De :*Daniel-Constantin Mierla <miconda@gmail.com>
<mailto:miconda@gmail.com>
*Envoyé :* lundi 5 novembre 2018 09:45
*À :* Nicolas Breuer <Nicolas.Breuer@belcenter.biz>
<mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users
Mailing List <sr-users@lists.kamailio.org>
<mailto:sr-users@lists.kamailio.org>
*Objet :* Re: [SR-Users] Mysql

 

There is no column "Msg_text" there, are you sure it is about this
table?

Cheers,
Daniel

 

On 05.11.18 09:37, Nicolas Breuer wrote:

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

    | sip_trace | CREATE TABLE `sip_trace` (

      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

      `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01',

      `time_us` int(10) unsigned NOT NULL DEFAULT '0',

      `callid` varchar(255) NOT NULL DEFAULT '',

      `traced_user` varchar(128) NOT NULL DEFAULT '',

      `msg` mediumtext NOT NULL,

      `method` varchar(50) NOT NULL DEFAULT '',

      `status` varchar(128) NOT NULL DEFAULT '',

      `fromip` varchar(50) NOT NULL DEFAULT '',

      `toip` varchar(50) NOT NULL DEFAULT '',

      `fromtag` varchar(64) NOT NULL DEFAULT '',

      `totag` varchar(64) NOT NULL DEFAULT '',

      `direction` varchar(4) NOT NULL DEFAULT '',

      PRIMARY KEY (`id`),

      KEY `traced_user_idx` (`traced_user`),

      KEY `date_idx` (`time_stamp`),

      KEY `fromip_idx` (`fromip`),

      KEY `callid_idx` (`callid`),

      KEY `id` (`id`),

      KEY `id_2` (`id`)

    ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1
    ROW_FORMAT=DYNAMIC |

    +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

     

    *De :*Daniel-Constantin Mierla <miconda@gmail.com>
    <mailto:miconda@gmail.com>
    *Envoyé :* lundi 5 novembre 2018 09:35
    *À :* Kamailio (SER) - Users Mailing List
    <sr-users@lists.kamailio.org>
    <mailto:sr-users@lists.kamailio.org>; Nicolas Breuer
    <Nicolas.Breuer@belcenter.biz>
    <mailto:Nicolas.Breuer@belcenter.biz>
    *Objet :* Re: [SR-Users] Mysql

     

    Hello,

    can you give the output of the next command run in mysql
    client tool?

    show create table sip_trace;

    Cheers,
    Daniel

     

    On 04.11.18 10:09, Nicolas Breuer wrote:

        Hello,

         

        Working on sip_trace table produce this error

         

        WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns():
        unhandled data type column (Msg_text) type id (250), use
        DB1_STRING as default

         

         






        _______________________________________________

        Kamailio (SER) - Users Mailing List

        sr-users@lists.kamailio.org
        <mailto:sr-users@lists.kamailio.org>

        https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users





    -- 

    Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

    www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>

    Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

    Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>




-- 

Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>

Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>

Nicolas Breuer

11:22 a.m.

modparam("rtimer", "timer", "name=cleantrace;interval=86400;mode=1;") modparam("rtimer", "exec", "timer=cleantrace;route=Clean_Traces")

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : lundi 5 novembre 2018 12:16 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It's a stored sql procedure launched by the rtimer module.

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla

11:39 a.m.

You do not need the response from the sql procedure, try with:

sql_query("cb","call Traces_Clean()");

Cheers, Daniel

On 05.11.18 12:22, Nicolas Breuer wrote:

...

modparam("rtimer", "timer", "name=cleantrace;interval=86400;mode=1;")

modparam("rtimer", "exec", "timer=cleantrace;route=Clean_Traces")

route[Clean_Traces] {

xlog("L_NOTICE", "Cleaning Traces" );

sql_query("cb","call Traces_Clean()","rb");

}

*De :*Daniel-Constantin Mierla miconda@gmail.com *Envoyé :* lundi 5 novembre 2018 12:16 *À :* Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org *Objet :* Re: [SR-Users] Mysql

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote:

It’s a stored sql procedure launched by the rtimer module.

 

 

*De :*Daniel-Constantin Mierla <miconda@gmail.com>
<mailto:miconda@gmail.com>
*Envoyé :* lundi 5 novembre 2018 11:57
*À :* Nicolas Breuer <Nicolas.Breuer@belcenter.biz>
<mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users
Mailing List <sr-users@lists.kamailio.org>
<mailto:sr-users@lists.kamailio.org>
*Objet :* Re: [SR-Users] Mysql

 

Hello,

how do you execute that sql statement?

Cheers,
Daniel

 

On 05.11.18 10:40, Nicolas Breuer wrote:

    Hello,

     

    We see the error when this procedure is executed :

     

    BEGIN

      delete FROM sip_trace where time_stamp < now() - INTERVAL 2
    MONTH;

      OPTIMIZE TABLE sip_trace;

    END $$

     

    *De :*Daniel-Constantin Mierla <miconda@gmail.com>
    <mailto:miconda@gmail.com>
    *Envoyé :* lundi 5 novembre 2018 09:45
    *À :* Nicolas Breuer <Nicolas.Breuer@belcenter.biz>
    <mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users
    Mailing List <sr-users@lists.kamailio.org>
    <mailto:sr-users@lists.kamailio.org>
    *Objet :* Re: [SR-Users] Mysql

     

    There is no column "Msg_text" there, are you sure it is about
    this table?

    Cheers,
    Daniel

     

    On 05.11.18 09:37, Nicolas Breuer wrote:

        ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

        | sip_trace | CREATE TABLE `sip_trace` (

          `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

          `time_stamp` datetime NOT NULL DEFAULT '1900-01-01
        00:00:01',

          `time_us` int(10) unsigned NOT NULL DEFAULT '0',

          `callid` varchar(255) NOT NULL DEFAULT '',

          `traced_user` varchar(128) NOT NULL DEFAULT '',

          `msg` mediumtext NOT NULL,

          `method` varchar(50) NOT NULL DEFAULT '',

          `status` varchar(128) NOT NULL DEFAULT '',

          `fromip` varchar(50) NOT NULL DEFAULT '',

          `toip` varchar(50) NOT NULL DEFAULT '',

          `fromtag` varchar(64) NOT NULL DEFAULT '',

          `totag` varchar(64) NOT NULL DEFAULT '',

          `direction` varchar(4) NOT NULL DEFAULT '',

          PRIMARY KEY (`id`),

          KEY `traced_user_idx` (`traced_user`),

          KEY `date_idx` (`time_stamp`),

          KEY `fromip_idx` (`fromip`),

          KEY `callid_idx` (`callid`),

          KEY `id` (`id`),

          KEY `id_2` (`id`)

        ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT
        CHARSET=latin1 ROW_FORMAT=DYNAMIC |

        +-----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

         

        *De :*Daniel-Constantin Mierla <miconda@gmail.com>
        <mailto:miconda@gmail.com>
        *Envoyé :* lundi 5 novembre 2018 09:35
        *À :* Kamailio (SER) - Users Mailing List
        <sr-users@lists.kamailio.org>
        <mailto:sr-users@lists.kamailio.org>; Nicolas Breuer
        <Nicolas.Breuer@belcenter.biz>
        <mailto:Nicolas.Breuer@belcenter.biz>
        *Objet :* Re: [SR-Users] Mysql

         

        Hello,

        can you give the output of the next command run in mysql
        client tool?

        show create table sip_trace;

        Cheers,
        Daniel

         

        On 04.11.18 10:09, Nicolas Breuer wrote:

            Hello,

             

            Working on sip_trace table produce this error

             

            WARNING: db_mysql [km_res.c:142]:
            db_mysql_get_columns(): unhandled data type column
            (Msg_text) type id (250), use DB1_STRING as default

             

             







            _______________________________________________

            Kamailio (SER) - Users Mailing List

            sr-users@lists.kamailio.org
            <mailto:sr-users@lists.kamailio.org>

            https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users






        -- 

        Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

        www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda
        <http://www.linkedin.com/in/miconda>

        Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

        Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>





    -- 

    Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

    www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>

    Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

    Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>




-- 

Daniel-Constantin Mierla -- www.asipto.com <http://www.asipto.com>

www.twitter.com/miconda <http://www.twitter.com/miconda> -- www.linkedin.com/in/miconda <http://www.linkedin.com/in/miconda>

Kamailio World Conference -- www.kamailioworld.com <http://www.kamailioworld.com>

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com <http://www.asipto.com>

Nicolas Breuer

8 Nov 8 Nov

5:42 p.m.

Hello Daniel,

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

De : Daniel-Constantin Mierla miconda@gmail.com Envoyé : lundi 5 novembre 2018 12:39 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

You do not need the response from the sql procedure, try with:

sql_query("cb","call Traces_Clean()"); Cheers, Daniel On 05.11.18 12:22, Nicolas Breuer wrote: modparam("rtimer", "timer", "name=cleantrace;interval=86400;mode=1;") modparam("rtimer", "exec", "timer=cleantrace;route=Clean_Traces")

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 12:16 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It’s a stored sql procedure launched by the rtimer module.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Henning Westerholt

9 Nov 9 Nov

10:28 p.m.

Am Donnerstag, 8. November 2018, 18:42:27 CET schrieb Nicolas Breuer:

...

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default [..]

Hello Nicolas,

so it seems that the method call is still returning a value which Kamailio did not properly understand. Two ideas:

- enable debugging in Kamailio to get more information about the warning - look with e.g. wireshark on the line what is actually returned from mysql

Best regards,

Henning

-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment

Tyler Preder

13 Nov 13 Nov

1:06 p.m.

Just as a check, if you run the commands from the within Mysql do they complete successfully?

...

delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace;

Tyler

From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM To: miconda@gmail.com; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Mysql

Hello Daniel,

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

De : Daniel-Constantin Mierla <miconda@gmail.commailto:miconda@gmail.com> Envoyé : lundi 5 novembre 2018 12:39 À : Nicolas Breuer <Nicolas.Breuer@belcenter.bizmailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Objet : Re: [SR-Users] Mysql

You do not need the response from the sql procedure, try with:

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It’s a stored sql procedure launched by the rtimer module.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Nicolas Breuer

6:19 p.m.

Yes.

mysql> delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; Query OK, 3706 rows affected (0.12 sec)

De : sr-users sr-users-bounces@lists.kamailio.org De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

Just as a check, if you run the commands from the within Mysql do they complete successfully?

...

delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace;

Tyler

From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio.org> On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM To: miconda@gmail.commailto:miconda@gmail.com; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Subject: Re: [SR-Users] Mysql

Hello Daniel,

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

You do not need the response from the sql procedure, try with:

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It’s a stored sql procedure launched by the rtimer module.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Nicolas Breuer

19 Jan 19 Jan

9:05 a.m.

Hello,

Any updates on this issue ? Still the same error on the last version of Kamailio

Just as a check, if you run the commands from the within Mysql do they complete successfully?

...

delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace;

Tyler

Hello Daniel,

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

You do not need the response from the sql procedure, try with:

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

How is launched by the rtimer module? Paste the route block here if you want further assistance.

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It’s a stored sql procedure launched by the rtimer module.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Henning Westerholt

20 Jan 20 Jan

4:34 p.m.

Am Samstag, 19. Januar 2019, 10:05:49 CET schrieb Nicolas Breuer:

...

Hello,

Any updates on this issue ? Still the same error on the last version of Kamailio

Hello Nicolas,

have you tried to execute the command from mysql client as suggested from Tyler? Do you see the same error there, do you get a result back from the function?

If you can't get rid of this somehow, you could ignore it. It is only a warning after all, that shows that the DB interface don't know about the result code from the stored procedure and default to DB1_STRING type.

Best regards,

Henning

...

De : sr-users sr-users-bounces@lists.kamailio.org De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

Just as a check, if you run the commands from the within Mysql do they complete successfully?

...

...
delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH;

OPTIMIZE TABLE sip_trace;

Tyler

From: sr-users <sr-users-bounces@lists.kamailio.orgmailto:sr-users-bounces@lists.kamailio .org> On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM To: miconda@gmail.commailto:miconda@gmail.com; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Subject: Re: [SR-Users] Mysql

Hello Daniel,

Still the same error ☹

Nov 8 12:41:30 proxy1 /usr/sbin/kamailio[16889]: WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

De : Daniel-Constantin Mierla <miconda@gmail.commailto:miconda@gmail.com> Envoyé : lundi 5 novembre 2018 12:39 À : Nicolas Breuer <Nicolas.Breuer@belcenter.bizmailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org> Objet : Re: [SR-Users] Mysql

You do not need the response from the sql procedure, try with:

sql_query("cb","call Traces_Clean()"); Cheers, Daniel On 05.11.18 12:22, Nicolas Breuer wrote: modparam("rtimer", "timer", "name=cleantrace;interval=86400;mode=1;") modparam("rtimer", "exec", "timer=cleantrace;route=Clean_Traces")

route[Clean_Traces] { xlog("L_NOTICE", "Cleaning Traces" ); sql_query("cb","call Traces_Clean()","rb"); }

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 12:16 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

How is launched by the rtimer module? Paste the route block here if you want further assistance.

...

The c code for using sip_trace table in the siptrace module is not the one printing the log message, so we need to see the config part that creates it.

...

Cheers, Daniel

On 05.11.18 12:04, Nicolas Breuer wrote: It’s a stored sql procedure launched by the rtimer module.

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:45 À : Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org Objet : Re: [SR-Users] Mysql

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

On 05.11.18 09:37, Nicolas Breuer wrote:

------------------------+ | sip_trace | CREATE TABLE `sip_trace` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `time_stamp` datetime NOT NULL DEFAULT '1900-01-01 00:00:01', `time_us` int(10) unsigned NOT NULL DEFAULT '0', `callid` varchar(255) NOT NULL DEFAULT '', `traced_user` varchar(128) NOT NULL DEFAULT '', `msg` mediumtext NOT NULL, `method` varchar(50) NOT NULL DEFAULT '', `status` varchar(128) NOT NULL DEFAULT '', `fromip` varchar(50) NOT NULL DEFAULT '', `toip` varchar(50) NOT NULL DEFAULT '', `fromtag` varchar(64) NOT NULL DEFAULT '', `totag` varchar(64) NOT NULL DEFAULT '', `direction` varchar(4) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `traced_user_idx` (`traced_user`), KEY `date_idx` (`time_stamp`), KEY `fromip_idx` (`fromip`), KEY `callid_idx` (`callid`), KEY `id` (`id`), KEY `id_2` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6810087 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC |

+-----------+--------------------------------------------------------------

De : Daniel-Constantin Mierla miconda@gmail.com mailto:miconda@gmail.com Envoyé : lundi 5 novembre 2018 09:35 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org mailto:sr-users@lists.kamailio.org; Nicolas Breuer Nicolas.Breuer@belcenter.biz mailto:Nicolas.Breuer@belcenter.biz Objet : Re: [SR-Users] Mysql

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

-- Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment

Alex Balashov

5 Nov 5 Nov

11:24 a.m.

In this sense, your initial post is profoundly misleading. You need to provide complete and accurate details from the context in which any issue occurs.

And as Daniel said, the precise config contact on which this stored procedure is called is key.

-- Sent from mobile. Apologies for brevity and errors.

-----Original Message----- From: Nicolas Breuer Nicolas.Breuer@belcenter.biz To: "miconda@gmail.com" miconda@gmail.com, "Kamailio (SER) - Users Mailing List" sr-users@lists.kamailio.org Sent: Mon, 05 Nov 2018 6:05 AM Subject: Re: [SR-Users] Mysql

It's a stored sql procedure launched by the rtimer module.

Hello,

how do you execute that sql statement?

Cheers, Daniel

On 05.11.18 10:40, Nicolas Breuer wrote: Hello,

We see the error when this procedure is executed :

BEGIN delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; OPTIMIZE TABLE sip_trace; END $$

There is no column "Msg_text" there, are you sure it is about this table?

Cheers, Daniel

Hello,

can you give the output of the next command run in mysql client tool?

show create table sip_trace;

Cheers, Daniel

On 04.11.18 10:09, Nicolas Breuer wrote: Hello,

Working on sip_trace table produce this error

WARNING: db_mysql [km_res.c:142]: db_mysql_get_columns(): unhandled data type column (Msg_text) type id (250), use DB1_STRING as default

_______________________________________________

Kamailio (SER) - Users Mailing List

sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org

https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com

www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda

Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com

Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com

2234

Age (days ago)

2311

Last active (days ago)

sr-users@lists.kamailio.org

16 comments

5 participants

tags (0)

participants (5)

Alex Balashov
Daniel-Constantin Mierla
Henning Westerholt
Nicolas Breuer
Tyler Preder