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

10: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 thread

Daniel-Constantin Mierla

5 Nov 5 Nov

9: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(a)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

9: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(a)gmail.com> Envoyé : lundi 5 novembre 2018 09:35 À : Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>rg>; Nicolas Breuer <Nicolas.Breuer(a)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

9: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(a)gmail.com> *Envoyé :* lundi 5 novembre 2018 09:35 *À :* Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>rg>; Nicolas Breuer <Nicolas.Breuer(a)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(a)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

10: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(a)gmail.com> Envoyé : lundi 5 novembre 2018 09:45 À : Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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

11: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(a)gmail.com> *Envoyé :* lundi 5 novembre 2018 09:45 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 09:35 *À :* Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> <mailto:sr-users@lists.kamailio.org>; Nicolas Breuer <Nicolas.Breuer(a)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(a)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

12:04 p.m.

It's a stored sql procedure launched by the rtimer module. De : Daniel-Constantin Mierla <miconda(a)gmail.com> Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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>

Daniel-Constantin Mierla

12:16 p.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(a)gmail.com> *Envoyé :* lundi 5 novembre 2018 11:57 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 09:45 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz> <mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 09:35 *À :* Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> <mailto:sr-users@lists.kamailio.org>; Nicolas Breuer <Nicolas.Breuer(a)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(a)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

12:22 p.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(a)gmail.com> Envoyé : lundi 5 novembre 2018 12:16 À : Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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> -- 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>

Alex Balashov

12:24 p.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(a)belcenter.biz> To: "miconda(a)gmail.com" <miconda(a)gmail.com>om>, "Kamailio (SER) - Users Mailing List" <sr-users(a)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. De : Daniel-Constantin Mierla <miconda(a)gmail.com> Envoyé : lundi 5 novembre 2018 11:57 À : Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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>

Daniel-Constantin Mierla

12:39 p.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(a)gmail.com> *Envoyé :* lundi 5 novembre 2018 12:16 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 11:57 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz> <mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 09:45 *À :* Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz> <mailto:Nicolas.Breuer@belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users(a)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(a)gmail.com> <mailto:miconda@gmail.com> *Envoyé :* lundi 5 novembre 2018 09:35 *À :* Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org> <mailto:sr-users@lists.kamailio.org>; Nicolas Breuer <Nicolas.Breuer(a)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(a)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> -- 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

6: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(a)gmail.com> Envoyé : lundi 5 novembre 2018 12:39 À : Nicolas Breuer <Nicolas.Breuer(a)belcenter.biz>iz>; Kamailio (SER) - Users Mailing List <sr-users(a)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 _______________________________________________ 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> -- 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>

Henning Westerholt

9 Nov 9 Nov

11: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

2: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(a)lists.kamailio.org> On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM To: miconda(a)gmail.com; Kamailio (SER) - Users Mailing List <sr-users(a)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.com<mailto:miconda@gmail.com>> Envoyé : lundi 5 novembre 2018 12:39 À : 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 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 _______________________________________________ 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> -- 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

7:19 p.m.

Yes. mysql> delete FROM sip_trace where time_stamp < now() - INTERVAL 2 MONTH; Query OK, 3706 rows affected (0.12 sec) mysql> OPTIMIZE TABLE sip_trace; +-------------------+----------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+----------+----------+----------+ | sip_trace | optimize | status | OK | +-------------------+----------+----------+----------+ 1 row in set (3.02 sec) De : sr-users <sr-users-bounces(a)lists.kamailio.org> De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List <sr-users(a)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.org<mailto:sr-users-bounces@lists.kamailio.org>> On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM To: miconda@gmail.com<mailto:miconda@gmail.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org<mailto: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.com<mailto:miconda@gmail.com>> Envoyé : lundi 5 novembre 2018 12:39 À : 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 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 _______________________________________________ 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> -- 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

19 Jan 19 Jan

10:05 a.m.

Hello, Any updates on this issue ? Still the same error on the last version of Kamailio De : sr-users <sr-users-bounces(a)lists.kamailio.org> De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List <sr-users(a)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;

Henning Westerholt

20 Jan 20 Jan

5: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(a)lists.kamailio.org> De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List <sr-users(a)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;

...

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

1917

days inactive

1994

days old

sr-users@lists.kamailio.org

Manage subscription

16 comments

5 participants

tags (0)

participants (5)

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