subject:"\[SR\-Users\] creating DB in MySQL for Homer Capture server gives errors"

[SR-Users] creating DB in MySQL for Homer Capture server gives errors

2012-02-14 Thread Nelson Pereira

Hi all, Trying to create the Homer SIP capture (Kamailio) DB and getting an error: Error SQL query: CREATE TABLE `sip_capture` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT '-00-00 00:00:00', `micro_ts` bigint(18) NOT NULL DEFAULT '0',

Re: [SR-Users] creating DB in MySQL for Homer Capture server gives errors

2012-02-14 Thread Alexandr Dubovikov

Hi Nelson, your mysql server is old. The best way upgrade your mysql server minimum up to 5.1.43, if not, don't use UNIX_TIMESTAMP partitioning for this mysql. Wbr, Alexandr 14.02.2012 15:25, Nelson Pereira wrote: