[SR-Users] Mysql

[Alex Balashov]

In this sense, your initial post is profoundly misleading. You need to provide complete and accurate details from the context in which any issue occurs. 

And as Daniel said, the precise config contact on which this stored procedure is called is key. 

--
Sent from mobile. Apologies for brevity and errors. 

-----Original Message-----
From: Nicolas Breuer <Nicolas.Breuer at belcenter.biz>
To: "miconda at gmail.com" <miconda at gmail.com>, "Kamailio (SER) - Users Mailing
 List" <sr-users at lists.kamailio.org>
Sent: Mon, 05 Nov 2018 6:05 AM
Subject: Re: [SR-Users] Mysql

It's a stored sql procedure launched by the rtimer module.


De : Daniel-Constantin Mierla <miconda at gmail.com>
Envoyé : lundi 5 novembre 2018 11:57
À : Nicolas Breuer <Nicolas.Breuer at belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users at 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 at gmail.com><mailto:miconda at gmail.com>
Envoyé : lundi 5 novembre 2018 09:45
À : Nicolas Breuer <Nicolas.Breuer at belcenter.biz><mailto:Nicolas.Breuer at belcenter.biz>; Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org><mailto:sr-users at 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 at gmail.com><mailto:miconda at gmail.com>
Envoyé : lundi 5 novembre 2018 09:35
À : Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org><mailto:sr-users at lists.kamailio.org>; Nicolas Breuer <Nicolas.Breuer at belcenter.biz><mailto:Nicolas.Breuer at 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 at lists.kamailio.org<mailto:sr-users at 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>