MailWatch does not update after update to EFA-3.0.2.3

Report bugs and workarounds
Post Reply
angelo
Posts: 14
Joined: 04 Dec 2014 14:45

MailWatch does not update after update to EFA-3.0.2.3

Post by angelo » 27 Jul 2017 10:20

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

angelo
Posts: 14
Joined: 04 Dec 2014 14:45

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by angelo » 28 Jul 2017 07:13

After checking, also the previous mails stay blank when you try to open them ...

angelo
Posts: 14
Joined: 04 Dec 2014 14:45

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by angelo » 28 Jul 2017 07:21

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 ?

angelo
Posts: 14
Joined: 04 Dec 2014 14:45

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by angelo » 31 Jul 2017 19:18

Anybody who can help me on my way , ... or where to look :?:

Thankx

User avatar
shawniverson
Posts: 2899
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by shawniverson » 31 Jul 2017 20:44

Hello, you have a collation problem in your database...specifically user_filters or users tables.

Looking up command you can run to fix...
Version eFa 4.0.0 now available!

User avatar
shawniverson
Posts: 2899
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by shawniverson » 31 Jul 2017 21:00

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.

Code: Select all

mysql -u root -p
Enter the following code into the mysql console

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;
Exit the console and rerun upgrade.php.
Version eFa 4.0.0 now available!

angelo
Posts: 14
Joined: 04 Dec 2014 14:45

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by angelo » 31 Jul 2017 23:24

I added :

use mailscanner;

for selecting the database

It worked perfectly, mailwatch is working again. I will start testing asap.

Thanks again :D

User avatar
shawniverson
Posts: 2899
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

Re: MailWatch does not update after update to EFA-3.0.2.3

Post by shawniverson » 02 Aug 2017 21:25

Missed that step :oops:

Glad it is working :dance:
Version eFa 4.0.0 now available!

Post Reply