Ini mah persoalannya di database mysqlnya coba INSERT INTO diganti dengan REPLACE INTO
On Wed, 2005-09-14 at 23:02 +0700, kiki wrote: > dear om senior > > > tanya error lagi dunk krluarnya seperti ini > > [EMAIL PROTECTED]:/usr/local/src/postfixadmin-2.1.0# mysql -u root -p < > DATABASE_MYSQL.TXT > Enter password: > ERROR 1062 at line 28: Duplicate entry 'localhost-postfix' for key 1 > [EMAIL PROTECTED]:/usr/local/src/postfixadmin-2.1.0# > > sedangkan isi DATABASE.TXT isinya ini > > # > # Postfix Admin > # by Mischa Peters <mischa at high5 dot net> > # Copyright (c) 2002 - 2005 High5! > # License Info: http://www.postfixadmin.com/?file=LICENSE.TXT > # > > # This is the complete MySQL database structure for Postfix Admin. > # If you are installing from scratch you can use this file otherwise you > # need to use the TABLE_CHANGES.TXT or TABLE_BACKUP_MX.TXT that comes > with Postfix Admin. > # > # There are 2 entries for a database user in the file. > # One you can use for Postfix and one for Postfix Admin. > # > # If you run this file twice (2x) you will get an error on the user > creation in MySQL. > # To go around this you can either comment the lines below "USE MySQL" > until "USE postfix". > # Or you can remove the users from the database and run it again. > # > # You can create the database from the shell with: > # > # mysql -u root [-p] < DATABASE_MYSQL.TXT > > # > # Postfix / MySQL > # > USE mysql; > # Postfix user & password > INSERT INTO user (Host, User, Password) VALUES > ('localhost','postfix',password('postfix')); > INSERT INTO db (Host, Db, User, Select_priv) VALUES > ('localhost','postfix','postfix','Y'); > # Postfix Admin user & password > INSERT INTO user (Host, User, Password) VALUES > ('localhost','postfixadmin',password('postfixadmin')); > INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, > Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', > 'Y', 'Y'); > FLUSH PRIVILEGES; > GRANT USAGE ON postfix.* TO [EMAIL PROTECTED]; > GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO [EMAIL PROTECTED]; > GRANT USAGE ON postfix.* TO [EMAIL PROTECTED]; > GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO [EMAIL PROTECTED]; > CREATE DATABASE postfix; > USE postfix; > > # > # Table structure for table admin > # > CREATE TABLE admin ( > username varchar(255) NOT NULL default '', > password varchar(255) NOT NULL default '', > created datetime NOT NULL default '0000-00-00 00:00:00', > modified datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > PRIMARY KEY (username), > KEY username (username) > ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Admins'; > > # > # Table structure for table alias > # > CREATE TABLE alias ( > address varchar(255) NOT NULL default '', > goto text NOT NULL, > domain varchar(255) NOT NULL default '', > created datetime NOT NULL default '0000-00-00 00:00:00', > modified datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > PRIMARY KEY (address), > KEY address (address) > ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Aliases'; > > # > # Table structure for table domain > # > CREATE TABLE domain ( > domain varchar(255) NOT NULL default '', > description varchar(255) NOT NULL default '', > aliases int(10) NOT NULL default '0', > mailboxes int(10) NOT NULL default '0', > maxquota int(10) NOT NULL default '0', > transport varchar(255) default NULL, > backupmx tinyint(1) NOT NULL default '0', > created datetime NOT NULL default '0000-00-00 00:00:00', > modified datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > PRIMARY KEY (domain), > KEY domain (domain) > ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Domains'; > > # > # Table structure for table domain_admins > # > CREATE TABLE domain_admins ( > username varchar(255) NOT NULL default '', > domain varchar(255) NOT NULL default '', > created datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > KEY username (username) > ) TYPE=MyISAM COMMENT='Postfix Admin - Domain Admins'; > > # > # Table structure for table log > # > CREATE TABLE log ( > timestamp datetime NOT NULL default '0000-00-00 00:00:00', > username varchar(255) NOT NULL default '', > domain varchar(255) NOT NULL default '', > action varchar(255) NOT NULL default '', > data varchar(255) NOT NULL default '', > KEY timestamp (timestamp) > ) TYPE=MyISAM COMMENT='Postfix Admin - Log'; > > # > # Table structure for table mailbox > # > CREATE TABLE mailbox ( > username varchar(255) NOT NULL default '', > password varchar(255) NOT NULL default '', > name varchar(255) NOT NULL default '', > maildir varchar(255) NOT NULL default '', > quota int(10) NOT NULL default '0', > domain varchar(255) NOT NULL default '', > created datetime NOT NULL default '0000-00-00 00:00:00', > modified datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > PRIMARY KEY (username), > KEY username (username) > ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes'; > > # > # Table structure for table vacation > # > CREATE TABLE vacation ( > email varchar(255) NOT NULL default '', > subject varchar(255) NOT NULL default '', > body text NOT NULL, > cache text NOT NULL, > domain varchar(255) NOT NULL default '', > created datetime NOT NULL default '0000-00-00 00:00:00', > active tinyint(1) NOT NULL default '1', > PRIMARY KEY (email), > KEY email (email) > ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Vacation'; > > > mohon om tulung lagi > > regards > > kiki > >
