přihlasovaci heslo postfixadmin

[Jaroslav Votruba]

dobry den
nainstalil jsem si postfixadmina, ten mi funguje, ale nemuzu se napoprve 
do nej prihlasit,abych si zmenil adminsky heslo a nastavil jej.Nikde 
jsem nenasel ze by bylo nejaky defaltni startovaci heslo,ani na webu 
postfixadmina,ani v konfiguraku.Pri vytvareni BD pro postfixe jsem 
pouzil nasledujici soubor-viz nize,ale i mima mizernyma znalostma sql 
bych predpokladal,ze jmeno a heslo se vklada timto-

INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('PasswordPostfixadmin'));

, ale samozrejme se muzu mylit.Mohl by me nekdo popostrcit spravnym smerem?



# Postfix / MySQL

#

USE mysql;

# Postfix user & password

#

INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('PasswordPostix'));

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('PasswordPostfixadmin'));

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 postfix at localhost;

GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfix at localhost;

GRANT USAGE ON postfix.* TO postfixadmin at localhost;

GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfixadmin at localhost;

CREATE DATABASE postfix;

USE postfix;

 

#

#

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';

#

#

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';

 

#

#

CREATE TABLE domain (

  domain varchar(255) NOT NULL default '',

  description varchar(255) NOT NULL default '',

  aliases int(10) NOT NULL default '-1',

  mailboxes int(10) NOT NULL default '-1',

  maxquota int(10) NOT NULL default '-1',

  transport varchar(255) default 'virtual',

  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';

#

#

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';

#

#

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';

#

#

CREATE TABLE mailbox (

  username varchar(255) NOT NULL default '',

  password varchar(255) NOT NULL default '',

  name varchar(255) NOT NULL default '',

  home char(255) default '/home',

  maildir varchar(255) NOT NULL default '',

  quota int(10) NOT NULL default '-1',

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

  uid int(10) unsigned default '125',

  gid int(10) unsigned default '6',

  PRIMARY KEY  (username),

  KEY username (username)

) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes';#

#

#

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';


-- 
s pozdravem
Votruba Jaroslav
tel: 389002504
mailto:jaroslav.votruba at keytec.cz