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




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



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

 

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

 

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