Re: [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 '-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: 
#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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



  

___
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

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

[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', `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

#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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users