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: 2821
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 RC3 now available in testing repo. Come join us in advancing eFa!

User avatar
shawniverson
Posts: 2821
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 RC3 now available in testing repo. Come join us in advancing eFa!

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: 2821
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 RC3 now available in testing repo. Come join us in advancing eFa!

Post Reply