efa-project.org

Error happened again today so I took some time to look into what you requested.
One additional thing, the processlist in mysql seems to be hung up. I'm not a mysql wiz so it'd be hard for me to figure out what's going on there.
Any ideas?
Thanks for you help.

See attachments.

Some new info, it happened again today on a Thursday! Gathered some info. Web interface says: 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 Webmin mysql says: DBI connect fai...

Is there a better script I should use for release? Or an edit to make? I have no problem with that. Or if there is already a KB on it just link it. It seems (based on the the release script) that it is just requesting a valid token, not a specific token. It seems like any token can release any email...

Another Monday with the same issue. When I say the token is 'gone' I mean in the release link, it says 'token=' If I assign a token manually it releases no problem. I also cloned and edited a page which I call release-msg-bak.cgi which doesn't check for the token. It also releases it no problem. The...

Often time when I come in on a monday, my customers will tell me they can't release their mail. Aside from some other possibly unrelated issues, the most common issue is that the 'token=' is blank in the link. I've written a script to easily release these. But I know it is annoying to my customers. ...

BTW, I just wanted to share that this post saved my life: https://routingtheworld.wordpress.com/2011/02/01/postfix-envelope-records-out-of-order/ I tried everything short of manually deleting thousands of emails. I flushed with 50 different commands. Rebooted, restarted services. I worked at it for ...

A few weeks ago, we started getting extremely large queues of spam, typically between 10k and 100k emails in the queue. Always all spam. Because of this, proper emails were taking 4-12 hours to get through the filter. We took some steps with the firewall to avoid this. But I quickly noticed that the...

This is interesting to me.
I'm not sure if the updates have moved some tables around or how your install differs from mine.
I'd be happy to join a web meeting if you'd like to see if I can figure it out.
PM me if interested.

If you want to pm me. I can help u look.

This script is still working for me.
What version are you on?
The domain table is populated by the Transport settings menu under mail settings.

Got this message when trying to add new spam from the link in an email. "Software error: Cannot open /usr/local/bin/sa-learn --spam: No such file or directory at /var/www/cgi-bin/learn-msg.cgi line 99. For help, please send mail to the webmaster (root@localhost), giving this error message and t...

This is '.sh' file you must create and reference it in the cron table.
Copy the contents into a script and add execute permissions.

Here is a much more updated version that gives you more info in the email. The below is a bash script run hourly: #!/bin/bash username=root password=`grep MYSQLROOTPWD /etc/EFA-Config | sed 's/.*://'` database=mailscanner ########mysql query count mysql -u $username -p$password -D $database -e \ &qu...

You'll want to change cur_date() to now(). Other wise it won't calculate for the hour and you'll get notices all day.

I have written a script that will be executed under cron.hourly. It checks the spam from the last hour against a database of domains that are handled by your email server. It then sends you an email if someone from that domain is spamming. There is a lot of room for this to grow. But this is the sim...

Good job with the Mass import script. You can use a simple script to download an online blacklist and import it into the blacklist database. Keep in mind, I'm no pro at scripting. Here is an example of a weekly cron job. and below is the daily job. There are plenty of sites to download blacklists. H...

I'd like to start off by saying I'm new to this forum, but I've been using EFA for a few weeks now and I'm blown away at how successful I've been. It has been a fairly easy setup thus far. Great job all who are involved. I've recently built a mail server and I notice that my queue on EFA has a lot o...