понедельник, 31 мая 2010 г.

Postfix rsyslog

Im using rsyslog with postfix.
Here some confs.

DROP TABLE IF EXISTS `Smtpd`;
CREATE TABLE IF NOT EXISTS `Smtpd` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ReportedTime` datetime NOT NULL,
  `MessageTime` varchar(40) NOT NULL,
  `Host` text NOT NULL,
  `Process` varchar(40) NOT NULL,
  `ProcessID` int(11) NOT NULL,
  `Message` text NOT NULL,
  `ClientHost` varchar(255) NOT NULL,
  `ClientIP` varchar(15) NOT NULL,
  `MailFrom` varchar(255) NOT NULL,
  `MailTo` varchar(255) NOT NULL,
  `MessageID` varchar(40) NOT NULL,
  `Status` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ;

среда, 5 мая 2010 г.

Postfix config

My postfix config.

#---------------------------------------------#
queue_directory = /var/spool/postfix
command_directory = /usr/sbin
daemon_directory = /usr/libexec/postfix
data_directory = /var/lib/postfix