Mysql Errr on DB postfixlog [FIXED]

all about postfix Problems, questions???

Mysql Errr on DB postfixlog [FIXED]

New postby w.hackl » Thu Nov 13, 2014 3:17 pm

Artica v.1.8.111201 :

I think the class.mysql.postfix.builder.inc

public function BuildDayConnectTable($tablename){

$sql="CREATE TABLE IF NOT EXISTS `$tablename` (
`zmd5` varchar(90) NOT NULL,
`zDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`hour` tinyint(2) NOT NULL,
`messageid` varchar(60) NOT NULL,
`hostname` varchar(255) NOT NULL,
`domain` varchar(128) NOT NULL,
`ipaddr` VARCHAR(90) NOT NULL,
PRIMARY KEY (`zmd5`),
KEY `zDate` (`zDate`),
KEY `messageid` (`messageid`),
KEY `hostname` (`mailfrom`),
KEY `domain` (`domainfrom`),

KEY `ipaddr` (`ipaddr`)
) ENGINE=MYISAM;";

if(!$this->QUERY_SQL($sql)){return false;}
return true;

}

should read as

public function BuildDayConnectTable($tablename){

$sql="CREATE TABLE IF NOT EXISTS `$tablename` (
`zmd5` varchar(90) NOT NULL,
`zDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`hour` tinyint(2) NOT NULL,
`messageid` varchar(60) NOT NULL,
`hostname` varchar(255) NOT NULL,
`domain` varchar(128) NOT NULL,
`ipaddr` VARCHAR(90) NOT NULL,
PRIMARY KEY (`zmd5`),
KEY `zDate` (`zDate`),
KEY `messageid` (`messageid`),
KEY `hostname` (`hostname`),
KEY `domain` (`domain`),

KEY `ipaddr` (`ipaddr`)
) ENGINE=MYISAM;";

if(!$this->QUERY_SQL($sql)){return false;}
return true;

}
w.hackl
 
Posts: 3
Joined: Wed Feb 26, 2014 11:22 am
Location: Austria
Artica servers number: 1
Linux System: Debian
Technical skills: A Linux System Administrator

Re: Mysql Errr on DB postfixlog

New postby admin » Fri Nov 21, 2014 1:36 am

Fixed in 1.8.112102
User avatar
admin
Site Admin
 
Posts: 11941
Joined: Wed Oct 17, 2007 7:59 am
Location: France


Return to Postfix Discusss

Who is online

Users browsing this forum: No registered users and 2 guests

cron