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

[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:
>
> 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: *Description: Documentation 
> <http://172.20.25.149/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=1d6b9d77bce4c6f164883e3c6dd6bc09>
>
> #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
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120214/b377412d/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 602 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120214/b377412d/attachment-0001.png>