Good output for MailWatch 1.2.0 upgrade.php

gistfile1.txt

# php upgrade.php mailscanner/functions.php

MailWatch for MailScanner Database Upgrade to 1.2.0

Have you done a full backup of your database? Type 'yes' to continue: yes

Testing connectivity to the database ................................. OK

Updating database schema:

 - Convert database to utf8........................................... OK

 - Drop `geoip_country` table......................................... OK
 - Drop `spamscores` table............................................ OK
 - Add autorelease table to `mailscanner` database.................... OK
 - Add resetid, resetexpire and lastreset fields in `users` table..... OK

 - Fix schema for username field in `audit_log` table................. OK
 - Fix schema for id field in `blacklist` table....................... OK
 - Fix schema for username field in `users` table..................... OK
 - Fix schema for spamscore field in `users` table.................... OK
 - Fix schema for highspamscore field in `users` table................ OK
 - Fix schema for username field in `user_filters` table.............. OK
 - Fix schema for username field in `whitelist` table................. OK
 - Fix schema for username field in `audit_log` table................. OK
 - Fix schema for password field in `users` table..................... OK
 - Fix schema for fullname field in `users` table..................... OK
 - Fix schema for rule_desc field in `mcp_rules` table................ OK

 - Add id field and primary key to `audit_log` table.................. OK
 - Add inq_id field and primary key to `inq` table.................... OK
 - Add maillog_id field and primary key to `maillog` table............ OK
 - Add mtalog_id field and primary key to `mtalog` table.............. OK
 - Add mtalog_id field and primary key to `outq` table................ OK
 - Add id field and primary key to `saved_filters` table.............. OK
 - Add mtalog_id field and primary key to `user_filters` table........ OK

 - Convert database to utf8mb4........................................ OK

 - Convert table `audit_log` to utf8mb4............................... OK
 - Convert table `autorelease` to utf8mb4............................. OK
 - Convert table `blacklist` to utf8mb4............................... OK
 - Convert table `inq` to utf8mb4..................................... OK
 - Convert table `maillog` to utf8mb4................................. OK
 - Convert table `mcp_rules` to utf8mb4............................... OK
 - Convert table `mtalog` to utf8mb4.................................. OK
 - Convert table `mtalog_ids` to utf8mb4.............................. OK
 - Convert table `outq` to utf8mb4.................................... OK
 - Convert table `saved_filters` to utf8mb4........................... OK
 - Convert table `sa_rules` to utf8mb4................................ OK
 - Convert table `users` to utf8mb4................................... OK
 - Convert table `user_filters` to utf8mb4............................ OK
 - Convert table `whitelist` to utf8mb4............................... OK

 - Convert table `audit_log` to InnoDB................................ OK
 - Convert table `autorelease` to InnoDB.............................. ALREADY CONVERTED
 - Convert table `blacklist` to InnoDB................................ OK
 - Convert table `inq` to InnoDB...................................... OK
 - Convert table `maillog` to InnoDB.................................. OK
 - Convert table `mcp_rules` to InnoDB................................ OK
 - Convert table `mtalog` to InnoDB................................... OK
 - Convert table `mtalog_ids` to InnoDB............................... OK
 - Convert table `outq` to InnoDB..................................... OK
 - Convert table `saved_filters` to InnoDB............................ OK
 - Convert table `sa_rules` to InnoDB................................. OK
 - Convert table `users` to InnoDB.................................... OK
 - Convert table `user_filters` to InnoDB............................. OK
 - Convert table `whitelist` to InnoDB................................ OK

 - Dropping too big index `maillog_from_idx` on table `maillog`....... ALREADY DONE
 - Dropping too big index `maillog_to_idx` on table `maillog`......... ALREADY DONE

 - Search for missing indexes on table `maillog`...................... DONE
 - Adding missing index `timestamp_idx` on table `maillog`............ OK
 - Adding missing index `subject_idx` on table `maillog`.............. OK

Checking MailScanner.conf settings:

 - QuarantineWholeMessage ............................................ OK
 - QuarantineWholeMessagesAsQueueFiles ............................... OK
 - DetailedSpamReport ................................................ OK
 - IncludeScoresInSpamAssassinReport ................................. OK
 - SpamActions ....................................................... OK
 - HighScoringSpamActions ............................................ OK
 - AlwaysLookedUpLast ................................................ OK

Checking conf.php configuration entry:

 - All mandatory entries are present.................................. OK
 - All obsolete entries are already removed........................... OK
 - optional RPC_PORT ................................................. WARNING
 - optional RPC_SSL .................................................. WARNING
 - optional RPC_REMOTE_SERVER ........................................ WARNING
 - optional LDAP_BIND_PREFIX ......................................... WARNING
 - optional LDAP_BIND_SUFFIX ......................................... WARNING
 - optional EXIM_QUEUE_IN ............................................ WARNING
 - optional EXIM_QUEUE_OUT ........................................... WARNING
 - optional PWD_RESET_FROM_NAME ...................................... WARNING
 - optional PWD_RESET_FROM_ADDRESS ................................... WARNING

*** ERROR/WARNING SUMMARY ***
conf.php: optional configuration entry "RPC_PORT" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_SSL" is missing, needed if RPC_ONLY mode is enabled
conf.php: optional configuration entry "RPC_REMOTE_SERVER" is missing, needed to show number of mails in postfix queues on remote server (RPC)
conf.php: optional configuration entry "LDAP_BIND_PREFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "LDAP_BIND_SUFFIX" is missing, needed when using LDAP authentication
conf.php: optional configuration entry "EXIM_QUEUE_IN" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "EXIM_QUEUE_OUT" is missing, needed only if using Exim as MTA
conf.php: optional configuration entry "PWD_RESET_FROM_NAME" is missing, needed if Password Reset feature is enabled
conf.php: optional configuration entry "PWD_RESET_FROM_ADDRESS" is missing, needed if Password Reset feature is enabled