Re: [SR-Users] Mysql

Hello, Any updates on this issue ? Still the same error on the last version of Kamailio De : sr-users &lt;sr-users-bounces(a)lists.kamailio.org&gt; De la part de Tyler Preder Envoyé : mardi 13 novembre 2018 14:07 À : Kamailio (SER) - Users Mailing List &lt;sr-users(a)lists.kamailio.org&gt; Objet : Re: [SR-Users] Mysql Just as a check, if you run the commands from the within Mysql do they complete successfully? 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>