bpq36ezU

1Postfix Admin Setup Checker
2Running software:
3
4PHP version 7.1.12
5Checking for dependencies:
6
7Magic Quotes: Disabled - OK
8Depends on: presence config.inc.php - OK
9Checking $CONF['configured'] - OK
10Warning: config.local.php - NOT FOUND
11It's Recommended to store your own settings in config.local.php instead of editing config.inc.php
12Create the file, and edit as appropriate (e.g. select database type etc)
13Depends on: MySQL 4.1 - OK
14Testing database connection (using mysqli) - OK
15Depends on: session - OK
16Depends on: pcre - OK
17Depends on: multibyte string - OK
18Depends on: IMAP functions - OK
19Everything seems fine... attempting to create/update database structure
20
21CREATE 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'
22
23Updating database:
24
25- old version: 0; target version: 1840
26
27  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)
28updating to version 1 (MySQL)...   done
29
30updating to version 2 (MySQL)...   done
31
32updating to version 3 (MySQL)...   done
33
34updating to version 4 (MySQL)...
35
36ALTER TABLE `domain` ADD COLUMN quota int(10) NOT NULL default '0' AFTER maxquota
37
38Invalid query: Table 'mail.domain' doesn't exist
39  done
40updating to version 5 (MySQL)...
41
42CREATE TABLE IF NOT EXISTS `admin` ( `username` varchar(255) NOT NULL default '', `password` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`), KEY username (`username`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Admins';
43
44CREATE TABLE IF NOT EXISTS `alias` ( `address` varchar(255) NOT NULL default '', `goto` text NOT NULL, `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`address`), KEY address (`address`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Aliases';
45
46CREATE TABLE IF NOT EXISTS `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', `quota` int(10) NOT NULL default '0', `transport` varchar(255) default NULL, `backupmx` tinyint(1) NOT NULL default '0', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`domain`), KEY domain (`domain`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Domains';
47
48CREATE TABLE IF NOT EXISTS `domain_admins` ( `username` varchar(255) NOT NULL default '', `domain` varchar(255) NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', KEY username (`username`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Domain Admins';
49
50CREATE TABLE IF NOT EXISTS `log` ( `timestamp` datetime NOT NULL default '2000-01-01 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`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Log';
51
52CREATE TABLE IF NOT EXISTS `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 '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`username`), KEY username (`username`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Mailboxes';
53
54CREATE TABLE IF NOT EXISTS `vacation` ( `email` varchar(255) NOT NULL , `subject` varchar(255) NOT NULL, `body` text NOT NULL, `cache` text NOT NULL, `domain` varchar(255) NOT NULL, `created` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`email`), KEY email (`email`) ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Vacation';
55
56  done
57updating to version 79 (MySQL)...
58
59ALTER TABLE `admin` DROP INDEX username
60
61ALTER TABLE `alias` DROP INDEX address
62
63ALTER TABLE `domain` DROP INDEX domain
64
65ALTER TABLE `mailbox` DROP INDEX username
66
67  done
68updating to version 81 (MySQL)...
69
70ALTER TABLE ``vacation`` CHANGE `email` `email` VARCHAR( 255 ) /*!40100 CHARACTER SET latin1 */ NOT NULL
71
72Invalid query: Incorrect table name ''
73ALTER TABLE ``vacation`` CHANGE `subject` `subject` VARCHAR( 255 ) /*!40100 CHARACTER SET utf8 */ NOT NULL
74
75Invalid query: Incorrect table name ''
76ALTER TABLE ``vacation`` CHANGE `body` `body` TEXT /*!40100 CHARACTER SET utf8 */ NOT NULL
77
78Invalid query: Incorrect table name ''
79ALTER TABLE ``vacation`` CHANGE `cache` `cache` TEXT /*!40100 CHARACTER SET latin1 */ NOT NULL
80
81Invalid query: Incorrect table name ''
82ALTER TABLE ``vacation`` CHANGE `domain` `domain` VARCHAR( 255 ) /*!40100 CHARACTER SET latin1 */ NOT NULL
83
84Invalid query: Incorrect table name ''
85ALTER TABLE ``vacation`` CHANGE `active` `active` TINYINT( 1 ) NOT NULL DEFAULT '1'
86
87Invalid query: Incorrect table name ''
88ALTER TABLE ``vacation`` DEFAULT /*!40100 CHARACTER SET latin1 */
89
90Invalid query: Incorrect table name ''
91ALTER TABLE ``vacation`` ENGINE=InnoDB
92
93Invalid query: Incorrect table name ''
94  done
95updating to version 90 (MySQL and PgSQL)...
96
97UPDATE `log` SET action = REPLACE(action,' ','_')
98
99UPDATE `log` SET action = 'edit_alias_state' WHERE action = 'edit_alias_active'
100
101  done
102updating to version 169 (MySQL)...
103
104ALTER TABLE `domain` MODIFY COLUMN `quota` bigint(20) NOT NULL default '0'
105
106ALTER TABLE `domain` MODIFY COLUMN `maxquota` bigint(20) NOT NULL default '0'
107
108ALTER TABLE `mailbox` MODIFY COLUMN `quota` bigint(20) NOT NULL default '0'
109
110  done
111updating to version 318 (MySQL)...
112
113CREATE TABLE IF NOT EXISTS `vacation_notification` ( on_vacation varchar(255) NOT NULL, notified varchar(255) NOT NULL, notified_at timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY on_vacation (`on_vacation`, `notified`), CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation`(`email`) ON DELETE CASCADE ) ENGINE=MyISAM DEFAULT /*!40100 CHARACTER SET latin1 */ COMMENT='Postfix Admin - Virtual Vacation Notifications'
114
115ALTER TABLE `vacation_notification` CHANGE `notified` `notified` VARCHAR( 255 ) /*!40100 CHARACTER SET latin1 */ NOT NULL
116
117ALTER TABLE `vacation_notification` DEFAULT CHARACTER SET utf8
118
119  done
120updating to version 344 (MySQL)...
121
122CREATE TABLE IF NOT EXISTS `fetchmail`( id int(11) unsigned not null auto_increment, mailbox varchar(255) not null default '', src_server varchar(255) not null default '', src_auth enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any'), src_user varchar(255) not null default '', src_password varchar(255) not null default '', src_folder varchar(255) not null default '', poll_time int(11) unsigned not null default 10, fetchall tinyint(1) unsigned not null default 0, keep tinyint(1) unsigned not null default 0, protocol enum('POP3','IMAP','POP2','ETRN','AUTO'), extra_options text, returned_text text, mda varchar(255) not null default '', date timestamp, primary key(id) );
123
124  done
125updating to version 373 (MySQL)...
126
127ALTER TABLE `domain` CHANGE `description` `description` VARCHAR( 255 ) /*!40100 CHARACTER SET utf8 */ NOT NULL
128
129ALTER TABLE `mailbox` CHANGE `name` `name` VARCHAR( 255 ) /*!40100 CHARACTER SET utf8 */ NOT NULL
130
131  done
132updating to version 438 (MySQL)...
133
134CREATE TABLE IF NOT EXISTS `alias_domain` ( `alias_domain` varchar(255) /*!40100 CHARACTER SET latin1 */ NOT NULL default '', `target_domain` varchar(255) /*!40100 CHARACTER SET latin1 */ NOT NULL default '', `created` datetime NOT NULL default '2000-01-01 00:00:00', `modified` datetime NOT NULL default '2000-01-01 00:00:00', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`alias_domain`), KEY `active` (`active`), KEY `target_domain` (`target_domain`) ) ENGINE=MyISAM COMMENT='Postfix Admin - Domain Aliases'
135
136  done
137updating to version 439 (MySQL)...
138
139DEBUG INFORMATION:
140Invalid query: Table '/tmp/#sql_fa_0.MAI' is read only
141
142Check your error_log for the failed query.
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157Postfix Admin Setup Checker
158Running software:
159
160PHP version 7.1.12
161Checking for dependencies:
162
163Magic Quotes: Disabled - OK
164Depends on: presence config.inc.php - OK
165Checking $CONF['configured'] - OK
166Warning: config.local.php - NOT FOUND
167It's Recommended to store your own settings in config.local.php instead of editing config.inc.php
168Create the file, and edit as appropriate (e.g. select database type etc)
169Depends on: MySQL 4.1 - OK
170Testing database connection (using mysqli) - OK
171Depends on: session - OK
172Depends on: pcre - OK
173Depends on: multibyte string - OK
174Depends on: IMAP functions - OK
175Everything seems fine... attempting to create/update database structure
176
177CREATE 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'
178
179Updating database:
180
181- old version: 438; target version: 1840
182
183  (If the update doesn't work, run setup.php?debug=1 to see the detailed error messages and SQL queries.)
184updating to version 439 (MySQL)...
185
186DEBUG INFORMATION:
187Invalid query: Table '/tmp/#sql_fa_0.MAI' is read only
188
189Check your error_log for the failed query.