Good day from South Africa

New users please present your self here (no real names needed) so we can prevent spam bots.
Post Reply
Ebenjb
Posts: 3
Joined: 26 Jul 2018 10:02

Good day from South Africa

Post by Ebenjb » 26 Jul 2018 10:22

Good day everybody,

I am a total noob to this particular forum and product. I have been dumped into the deep end seeing that one of my clients are using EFA and Mailscanner and after a power outage we are now being presented with:
_____________________________
Error: Database connection failed

It is possible that the database is overloaded or otherwise not running properly

Contact the system administrator if the problem persists
_____________________________

when trying to login to the web interface.

The following is what I get when running mysqlcheck:
___________________________
[EFA] : 1
[admin@mailscanner ~]$ mysqlcheck --all-databases
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused") when trying to connect
[admin@mailscanner ~]$
___________________________

I will start doing as much research on this as I can and hopefully someone on the forum have a solution for this noob.

kind regards
Ebenjb

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

Re: Good day from South Africa

Post by shawniverson » 29 Jul 2018 17:11

:text-welcomewave:

Try running MariaDB Recovery in the EFA-Configure menu (log into the console)
Version 3.0.2.6 released! Update now to keep your eFa secure!

Ebenjb
Posts: 3
Joined: 26 Jul 2018 10:02

Re: Good day from South Africa

Post by Ebenjb » 30 Jul 2018 07:36

Thank you Shawniverson, I tried the EFA-Configure route but the error that I kept on receiving was that it could not connect to the MYSQL service. I know very little about the product but am quite keen to learn after this ordeal.

I ended up restoring a backup that was made in 2017/02... The mailscanner is running and I only had to make a few updates to the settings.

Cheers and once again thanks for the response.
regards
Eben

henk
Posts: 192
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: Good day from South Africa

Post by henk » 30 Jul 2018 08:32

If there is no .my.cnf file for root, containing credentials, you need to pass them from the EFA-Config

Code: Select all

[client]
user=root
password=your EFA-Config root pwd
or

Code: Select all

mysqlcheck --all-databases -a -uroot -p`grep ROOT /etc/EFA-Config | awk -F: '{print $2}'`
The MySql log is always a nice place to start

Ebenjb
Posts: 3
Joined: 26 Jul 2018 10:02

Re: Good day from South Africa

Post by Ebenjb » 31 Jul 2018 08:55

Thanks Henk, I am currently experimenting with EFA / mailscanner due to no other option...I have restored a very old backup Feb 2017(3.0.1.7) and got the system working again. Mailflow OK but obviously missing a whole bunch of features released in the last year and a half. On top of this all quarentined emails not there anymore. I do however have a backup of the system a day or so before it crashed.

Steps followed:
1. Cloned the EFA / mailscanner (after the crash)
2. Restored a backup of Feb 2017
3. Cloned This restored backup of Feb 2017
4.Snapshot the number "2." before any updates (This system has worked and mailflow is OK but missing features of updates since Feb 2017)
5.Started Update and the system updated to v.3.0.2.6 (System did not allow mailflow.)
6.Reverted to snapshot before update was done and restored mailflow.

I am now on version 3.0.1.7 or nearest. Is it possible to upgrade to a specific version? Say 3.0.2.5, this is the last version that worked just before the crash...unfortunately no backup of that version.

Thanks in advance
Eben

henk
Posts: 192
Joined: 14 Dec 2015 22:16
Location: Netherlands
Contact:

Re: Good day from South Africa

Post by henk » 31 Jul 2018 22:05

Hi Ebenjb,
quarentined emails not there anymore
That should not suprise you. 8-)

Upgrading form 3.0.1.7 to 3.0.2.6 should not be a problem.
You should have saved the upgrade log, as logs are our best friends.
The first thing that comes to mind is available space. So cleanup your system and check your space available.

check space

Code: Select all

df -h
run

Code: Select all

find /var/spool/MailScanner/incoming/SpamAssassin-Temp -mtime +1 -print | xargs rm -f
check space again

To remove old kernels ( install package yum-utils)

Code: Select all

package-cleanup --oldkernels --count=1
Removing some old automatic backups will give you some extra space also.

There are many post in this forum about upgrading.

Like clamav, you need to read viewtopic.php?f=13&p=12600#p12600 and viewtopic.php?f=13&t=2892

Google this forum on upgrade posts:

Code: Select all

site:forum.efa-project.org upgrade

Post Reply