[SR-Users] Mysql

Henning Westerholt hw at kamailio.org
Sun Jan 20 17:34:05 CET 2019 

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 at lists.kamailio.org> De la part de Tyler
> Preder Envoyé : mardi 13 novembre 2018 14:07
> À : Kamailio (SER) - Users Mailing List <sr-users at 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 at lists.kamailio.org<mailto:sr-users-bounces at lists.kamailio
> .org>> On Behalf Of Nicolas Breuer Sent: Thursday, November 8, 2018 9:42 AM
> To: miconda at gmail.com<mailto:miconda at gmail.com>; Kamailio (SER) - Users
> Mailing List
> <sr-users at lists.kamailio.org<mailto:sr-users at 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 at gmail.com<mailto:miconda at gmail.com>>
> Envoyé : lundi 5 novembre 2018 12:39
> À : 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
> 
> 
> 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><mailto:miconda at gmail.com>
> Envoyé : lundi 5 novembre 2018 12:16
> À : 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
> 
> 
> 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
 


-- 
Henning Westerholt - https://skalatan.de/blog/
Kamailio services - https://skalatan.de/services
Kamailio security assessment - https://skalatan.de/de/assessment

More information about the sr-users mailing list