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.
Search found 42 matches
- 11 Oct 2018 13:12
- Forum: 3.x Bugs
- Topic: Database issue not assigning token.
- Replies: 33
- Views: 57176
- 27 Sep 2018 15:08
- Forum: 3.x Bugs
- Topic: Database issue not assigning token.
- Replies: 33
- Views: 57176
Re: Database issue not assigning token.
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...
- 24 Sep 2018 18:11
- Forum: 3.x Bugs
- Topic: Database issue not assigning token.
- Replies: 33
- Views: 57176
Re: Database issue not assigning token.
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...
- 17 Sep 2018 13:31
- Forum: 3.x Bugs
- Topic: Database issue not assigning token.
- Replies: 33
- Views: 57176
Re: Database issue not assigning token.
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...
- 27 Aug 2018 12:39
- Forum: 3.x Bugs
- Topic: Database issue not assigning token.
- Replies: 33
- Views: 57176
Database issue not assigning token.
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. ...
- 24 Jul 2017 20:20
- Forum: How-to
- Topic: Postfix queue would not flush NO MATTER WHAT.
- Replies: 1
- Views: 1959
Postfix queue would not flush NO MATTER WHAT.
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 ...
- 25 Mar 2017 00:10
- Forum: How-to
- Topic: Kill Large Scale Spammers quickly
- Replies: 0
- Views: 1888
Kill Large Scale Spammers quickly
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...
- 14 Feb 2017 18:07
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
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.
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.
- 23 Dec 2016 14:06
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
If you want to pm me. I can help u look.
- 22 Dec 2016 19:57
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
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.
What version are you on?
The domain table is populated by the Transport settings menu under mail settings.
- 22 Apr 2016 13:00
- Forum: 3.x Bugs
- Topic: After upgrading to 3.0.9, sa-learn moved
- Replies: 0
- Views: 2112
After upgrading to 3.0.9, sa-learn moved
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...
- 21 Apr 2016 12:48
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
This is '.sh' file you must create and reference it in the cron table.
Copy the contents into a script and add execute permissions.
Copy the contents into a script and add execute permissions.
- 24 Jul 2015 03:25
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
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...
- 24 Jul 2015 01:42
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Re: Spammer Alert
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.
- 14 Jul 2015 02:16
- Forum: How-to
- Topic: Spammer Alert
- Replies: 20
- Views: 17045
Spammer Alert
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...
- 30 May 2015 04:50
- Forum: How-to
- Topic: Mass Import WhiteList/BlackList
- Replies: 13
- Views: 18118
Re: Mass Import WhiteList/BlackList
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...
- 30 May 2015 04:13
- Forum: How-to
- Topic: Integration with Email Users.
- Replies: 1
- Views: 2017
Integration with Email Users.
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...