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