Hallo,
yesterday I updated to version EFA-3.0.2.3, after that the mails keep flowing, but MailWatch does not update.
I only see the mails before the update.
can someone help me out ?
thank you,
Angelo
MailWatch does not update after update to EFA-3.0.2.3
Re: MailWatch does not update after update to EFA-3.0.2.3
After checking, also the previous mails stay blank when you try to open them ...
Re: MailWatch does not update after update to EFA-3.0.2.3
I looked at thread : viewtopic.php?f=13&t=2290&p=9587&hilit= ... wing#p9587
So I tried :
[root@~]# wget https://raw.githubusercontent.com/mailw ... pgrade.php
[root@~]# sudo /usr/bin/php ./upgrade.php
MailWatch for MailScanner Database Upgrade to 1.2.3-dev
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......................................... ALREADY DROPPED
- Drop `spamscores` table............................................ ALREADY DROPPED
- Add autorelease table to `mailscanner` database.................... ALREADY EXIST
- Add mtalog_ids table to `mailscanner` database..................... ALREADY EXIST
- Add resetid, resetexpire and lastreset fields in `users` table..... ALREADY EXIST
- Add login_expiry and login_timeout fields in `users` table......... ALREADY EXIST
- 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 timestamp field in `maillog` 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
- Cleanup orphaned user_filters...................................... ERROR
Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' - SQL = 'DELETE FROM `user_filters` WHERE `username` NOT IN (SELECT `username` FROM `users`)'
I get the above error ?
So I tried :
[root@~]# wget https://raw.githubusercontent.com/mailw ... pgrade.php
[root@~]# sudo /usr/bin/php ./upgrade.php
MailWatch for MailScanner Database Upgrade to 1.2.3-dev
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......................................... ALREADY DROPPED
- Drop `spamscores` table............................................ ALREADY DROPPED
- Add autorelease table to `mailscanner` database.................... ALREADY EXIST
- Add mtalog_ids table to `mailscanner` database..................... ALREADY EXIST
- Add resetid, resetexpire and lastreset fields in `users` table..... ALREADY EXIST
- Add login_expiry and login_timeout fields in `users` table......... ALREADY EXIST
- 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 timestamp field in `maillog` 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
- Cleanup orphaned user_filters...................................... ERROR
Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' - SQL = 'DELETE FROM `user_filters` WHERE `username` NOT IN (SELECT `username` FROM `users`)'
I get the above error ?
Re: MailWatch does not update after update to EFA-3.0.2.3
Anybody who can help me on my way , ... or where to look
Thankx
Thankx
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MailWatch does not update after update to EFA-3.0.2.3
Hello, you have a collation problem in your database...specifically user_filters or users tables.
Looking up command you can run to fix...
Looking up command you can run to fix...
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MailWatch does not update after update to EFA-3.0.2.3
Okay, try this....
Look for the password for mysql in /etc/EFA-Config, then execute the following to drop into mysql. Paste/enter the password when prompted.
Enter the following code into the mysql console
Exit the console and rerun upgrade.php.
Look for the password for mysql in /etc/EFA-Config, then execute the following to drop into mysql. Paste/enter the password when prompted.
Code: Select all
mysql -u root -p
Code: Select all
SET foreign_key_checks = 0;
ALTER TABLE `user_filters` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE `users` CONVERT to CHARACTER SET utf8 COLLATE utf8_unicode_ci;
SET foreign_key_checks = 1;
Re: MailWatch does not update after update to EFA-3.0.2.3
I added :
use mailscanner;
for selecting the database
It worked perfectly, mailwatch is working again. I will start testing asap.
Thanks again
use mailscanner;
for selecting the database
It worked perfectly, mailwatch is working again. I will start testing asap.
Thanks again
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
Re: MailWatch does not update after update to EFA-3.0.2.3
Missed that step
Glad it is working
Glad it is working