5 Nov
2018
5 Nov
'18
2: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>
--
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