Re: [postfix-users] tanya error lagi

2005-09-15 Thread kiki 

om Amiruddin


makasi om , udah bisa


regards
kiki


Amiruddin Utina wrote:


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 '-00-00 00:00:00',
 modified datetime NOT NULL default '-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 '-00-00 00:00:00',
 modified datetime NOT NULL default '-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 '-00-00 00:00:00',
 modified datetime NOT NULL default '-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 '-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 '-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 '-00-00 00:00:00',
 modified datetime NOT NULL default '-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

Re: [postfix-users] tanya error lagi

2005-09-14 Thread Amiruddin Utina 
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 '-00-00 00:00:00',
   modified datetime NOT NULL default '-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 '-00-00 00:00:00',
   modified datetime NOT NULL default '-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 '-00-00 00:00:00',
   modified datetime NOT NULL default '-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 '-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 '-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 '-00-00 00:00:00',
   modified datetime NOT NULL default '-00-00 00:00:00',
   active tinyint(1) NOT NULL default '1',
   PRIMARY KEY  (username),
   KEY username