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 <mico...@gmail.com> > *Envoyé :* lundi 5 novembre 2018 12:16 > *À :* Nicolas Breuer <nicolas.bre...@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 <mico...@gmail.com> > <mailto:mico...@gmail.com> > *Envoyé :* lundi 5 novembre 2018 11:57 > *À :* Nicolas Breuer <nicolas.bre...@belcenter.biz> > <mailto:nicolas.bre...@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 <mico...@gmail.com> > <mailto:mico...@gmail.com> > *Envoyé :* lundi 5 novembre 2018 09:45 > *À :* Nicolas Breuer <nicolas.bre...@belcenter.biz> > <mailto:nicolas.bre...@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 <mico...@gmail.com> > <mailto:mico...@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.bre...@belcenter.biz> > <mailto:nicolas.bre...@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 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
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users