Hi everyone

I have a problem with installing postfixadmin on new mailserver. I have done this 1000 times but now i have difficulties. Thanks for your help.



Postfix Admin Setup Checker

Running software:

PHP version 5.3.3
Apache/2.2.15 (CentOS)

Checking for dependencies:

Magic Quotes: Disabled - OK
Depends on: presence config.inc.php - OK
Checking $CONF['configured'] - OK
Smarty template compile directory is writable - OK
Depends on: MySQL 3.23, 4.0 - OK
Depends on: MySQL 4.1 - OK
Depends on: PostgreSQL - OK
(change the database_type to 'pgsql' in config.inc.php if you want to use PostgreSQL)
Testing database connection - OK - mysqli://postfix:xxxxx@localhost/XXXXXX
Depends on: session - OK
Depends on: pcre - OK
Depends on: multibyte string - OK
Depends on: IMAP functions - OK

Everything seems fine... attempting to create/update database structure

CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'

Database is up to date

can anyone give me advice?

Ok...perhaps if you actually told us WHAT the problem you're having is, we could help. All you've shown us is things working fine. You also don't tell us what version/distro of Linux you're using, postfixadmin, or why you're installing from source rather than from package.

Also, bumping your own thread does ABSOLUTELY NOTHING to get you help faster, and in fact, only makes your thread LESS VISIBLE, since you removed it from the zero-reply list.

diskto is centos 6.5 postfixadmin I have tried almost all versions. problem is it can not update mysql database. errorr it gives me following:

CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'

and after that error I check my domain database tables, they are empty. structure is creating but can't add admin accout.

I think problem is with postfixadmin's upgrade.php script. Now in this case i am using php 5.3.3 version but can't find solution.

Where did you get that command??? Are you entering that EXACT string, including the 40100....CHARACTER stuff??? Did you try omitting that??

The many sets of instructions for instaling postfixadmin don't mention it:
http://www.linuxmail.info/postfix-admin-howto-centos-5/
http://www.server-world.info/en/note..._6&p=mail&f=10

...are just two.

---------- Post added 01-28-15 at 02:04 PM ----------

NEW installations very obviously don't need to be upgraded, since there is nothing to upgrade.

I get that first time when I run setup.php to install postfixadmin. When i copy hash in config.inc.php and try to create admin accout i revieve that. tables are creating in db but they are empty. can not creatr admin account.

manual you send me i did same way enabled booleans even disabled selinux. directives in config.inc.php are correct. I created db same way. when i run setup.php it created tables into db but cannot insert data, cannot create admin account. show grants for db user are correct permissions are granted. what else i must check. One thing is that i run setup.php from remote machin, becouse it is centos minimal. does it matter???

sorry for bumping my own thread but here is the debug of postfixadmin installation. anyway thanks for your help


Invalid query: Duplicate column name 'quota'


updating to version 79 (MySQL)...

Invalid query: Can't DROP 'username'; check that column/key exists

Invalid query: Can't DROP 'address'; check that column/key exists

Invalid query: Can't DROP 'domain'; check that column/key exists

Invalid query: Can't DROP 'username'; check that column/key exists