efa-project.org

So the increased space has worked.....we are back up and working......

I would still like to make sure that I do not need to "adjust" something else.

pdwalker - If you are ever in my neck of the woods let me know. I owe you!

Now to leave for that camping trip with the family...the one that I ...

Looking into increasing size.....

PS: In the event I forget. Thank you!

Quarantine changed

Still errors:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /var/www/html/mailscanner/functions.php on line 751
Could not connect to database: Can't connect to local MySQL server through socket '/var/lib/mysql ...

edit: after changing those values, run the quarantine_maint.php script
sudo /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_maint.php --clean
df -h

[root@acs-mailscan mailscanner]# sudo /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_maint.php --clean

Warning: mysql_connect(): Can't ...

/var/www/html/mailscanner/conf.php
132 define('QUARANTINE_DAYS_TO_KEEP', 30);
You may also wish to consider reducing these slightly
113 // Define how many days of emails to keep
114 define('RECORD_DAYS_TO_KEEP', 60);
115
116 // Define how many days to audit logs to keep
117 define('AUDIT_DAYS_TO ...

also do
sudo du -sch /var/lib/mysql/* | grep -v [0-9]K
sudo du -sch /var/dcc/* | grep -v [0-9]K


[administrator@acs-mailscan quarantine]$ sudo du -sch /var/lib/mysql/* | grep -v [0-9]K
[sudo] password for administrator:
75M /var/lib/mysql/ibdata1
5.0M /var/lib/mysql/ib_logfile0
5.0M /var/lib ...

Ok, you have most of your space taken up by your quarantine directory. Now the question is, how come it hasn't been cleaned out?

Did you suddenly got a flood of mail into your system?

And here is a question for others: How does the quarantine directory get cleared out? Do we have to do that by ...

[administrator@acs-mailscan quarantine]$ sudo du -sch /var/spool/MailScanner/quarantine/* | grep -v [0-9]K
534M /var/spool/MailScanner/quarantine/20150323
517M /var/spool/MailScanner/quarantine/20150324
646M /var/spool/MailScanner/quarantine/20150325
572M /var/spool/MailScanner/quarantine/20150326 ...

79M /var/spool/MailScanner/incoming
16G /var/spool/MailScanner/quarantine
16G total

16 gb /var/spool/MailScanner

formatted for legibility

Well now....that did help.


[administrator@acs-mailscan /]$ sudo du -sch /var/* | grep -v [0-9]K
[sudo] password for administrator:
51M /var/cache
283M /var/clamav
1.6G /var/dcc
778M /var/EFA
740M /var/lib
221M /var/log
0 /var/mail
16G /var/spool
13M /var/www
20G total ...

[administrator@acs-mailscan ~]$ df -H
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_00-lv_root
8.5G 1.9G 6.2G 24% /
tmpfs 985M 0 985M 0% /dev/shm
/dev/sda1 508M 62M 420M 13% /boot
/dev/mapper/vg_00-lv_tmp
1.1G 48M 956M 5% /tmp
/dev/mapper/vg_00-lv_var
22G 21G 0 100% /var
none 985M 21M ...

To me the indication of out of space....is contradicted by info below:


Real memory 801.95 MB used, 1.83 GB total
Local disk space 22.48 GB used, 29.51 GB total
Package updates 30 package updates are available

Well I "THINK" i know what the issue is.........but not sure how to solve this:

150423 14:33:00 mysqld_safe Number of processes running now: 0
150423 14:33:00 mysqld_safe mysqld restarted
150423 14:33:00 InnoDB: Initializing buffer pool, size = 8.0M
150423 14:33:00 InnoDB: Completed initialization ...

--------------------------------------------------------------
--- Welcome to the EFA Configuration program ---
--- http://www.efa-project.org ---
--------------------------------------------------------------


MySQL Daemon and Database Recovery

Description:
This tool will assist with mysql ...

Other Information I have seen or found:
>>>>>>>>From several emails<<<<<<<
Sent: Wednesday, April 22, 2015 2:58 PM
To: >>NAME REMOVED<<
Subject: Re: club help May 7

MailScanner was attacked by a Denial Of Service attack, and has therefore deleted this part of the message. Please contact your e-mail ...

When you say "crash", what do you mean exactly?
>>The only thing it would do is allow part of the Webmin site. (Not all of it worked.) SSL was no responsive. Email was not allowed in or out. EFA was non responsive to anything that I tried.

Did the server reboot?
>>Only after I did the reboot in ...

Have you rebooted?

Is this the last thing you saw at the end of recovery?

MailScanner and SQLgrey
Starting MailScanner daemons:
incoming postfix: [ OK ]
outgoing postfix: [ OK ]
MailScanner: [ OK ]
Starting SQLgrey: [ OK ]



You are correct. That is the last thing I saw after the recovery ...

Well it happened.....We had our first crash. NO real response....NO ssl, but I did fin on the Webmin page a way to restart the whole thing. So thinking life is ok.....until it tells me that the MySQL database needs repair. So SSL connection, option 10, and ...... it stops on the restart ...

I am getting the following message when I try to manually run this job. (sudo /usr/local/bin/mailwatch/tools/Cron_jobs/mailwatch_ldap_sync.sh)

ERROR at line 74: Unknown command '\@'.

I am not sure what is even wrong.....much less how to fix it.

That was just too cool.....you just made my day!!!!

Cool. I will put that into use in the AM.

Thanks!!!

I was hoping it would provide some type of overview of yesterdays events. We are a small organization, and what I receive now allows me to get a quick view and make decisions about what needs a closer look.

Not to overwhelm, but for information I will attach a text version of an html report that I ...

Nope. I Thought I had done something wrong. It is set to send to my email address, but I have never received it.

I have it bound to our AD servers, so if somme one logs in with ad creds it makes the account. I have thought about using the AD import tools to pull them all in at once. As of now I have not done either as I was trying to find this solution before making all accounts.