----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 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.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla -- www.asipto.comhttp://www.asipto.com
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio World Conference -- www.kamailioworld.comhttp://www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.comhttp://www.asipto.com