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 '0000-00-00 00:00:00',
`micro_ts` bigint(18) NOT NULL DEFAULT '0', `method` varchar(50) NOT NULL
DEFAULT '', `reply_reason` varchar(100) NOT NULL, `ruri` varchar(200) NOT
NULL DEFAULT '', `ruri_user` varchar(100) NOT NULL DEFAULT '',
`from_user`
varchar(100) NOT NULL DEFAULT '', `from_tag` varchar(64) NOT NULL DEFAULT
'', `to_user` varchar(100) NOT NULL DEFAULT '', `to_tag` varchar(64) NOT
NULL, `pid_user` varchar(100) NOT NULL DEFAULT '', `contact_user`
varchar(120) NOT NULL, `auth_user` varchar(120) NOT NULL, `callid`
varchar(100) NOT NULL DEFAULT '', `callid_aleg` varchar(100) NOT NULL
DEFAULT '', `via_1` varchar(256) NOT NULL, `via_1_branch` varchar(80) NOT
NULL, `cseq` varchar(25) NOT NULL, `diversion` varchar(256) NOT NULL,
`reason` varchar(200) NOT NULL, `content_type` varchar(256) NOT NULL,
`authorization` varchar(256) N[...]
MySQL said:
<http://172.20.25.149/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdo
c%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=1d6b9d77bce4c6f1648
83e3c6dd6bc09> Description: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'PARTITION BY RANGE ( UNIX_TIMESTAMP(`date`) ) (
PARTITION pmax VALUES LESS THAN ' at line 50
System Information:
. Apache/2.2.10 (Linux/SUSE)
. MySQL client version: 5.0.67
. PHP extension: mysqli
Server is SLES 11 SP1