[SR-Users] Mysql
Daniel-Constantin Mierla
miconda at gmail.com
Mon Nov 5 12:39:14 CET 2018
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 at gmail.com>
> *Envoyé :* lundi 5 novembre 2018 12:16
> *À :* Nicolas Breuer <Nicolas.Breuer at belcenter.biz>; Kamailio (SER) -
> Users Mailing List <sr-users at 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 at gmail.com>
> <mailto:miconda at gmail.com>
> *Envoyé :* lundi 5 novembre 2018 11:57
> *À :* 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
>
>
>
> 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>
>
>
>
> --
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20181105/1df90f28/attachment.html>
More information about the sr-users
mailing list