Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Suppress-o-Matic - Stop database error spam Details »
Suppress-o-Matic - Stop database error spam
Mod Version: 1.00, by GeekyDesigns (Coder) GeekyDesigns is offline
Developer Last Online: May 2012 I like it Show Printable Version Email this Page

vB Version: 3.8.x Rating: (20 votes - 4.90 average) Installs: 94
Released: 15 Jul 2009 Last Update: 17 Nov 2009 Downloads: 525
Not Supported Code Changes Additional Files  

What is Suppress-o-matic?
Suppress-o-matic is a change to the way vBulletin handles database error emails. It limits sending the same error email repeatedly to your inbox every time a database error is generated. On a busy site if a table is crashed or mysql itself goes down you could recieve several thousand emails. This causes the email server to bog down, and possibly the server itself if there is enough traffic generating emails.

Why do I want Suppress-o-matic?
It should be pretty clear, you still get the vital information that your vBulletin forum is offline for whichever reason, without the hassle of having to delete and manage your inbox afterwords.

Why do I have to edit the files?
If the database is down, there is no way to get to the plugins. Plugins are stored in the vBulletin database.

Isn't there a vBulletin Option for this?
There is an option to disable some emails, assuming that the settings table can be read. If it cannot then it doesn't work. It even states this on the option itself.

Can't I just remove my tech email from the config file?
This doesn't keep you up to date. What if a serious error like error 28 (no space left) crops up? This means that your server could potentially have serious issues. Not resolving these problems could cause major issues.

Are you considering adding more functionality to Suppress-o-matic?
We have plans to add a repair feature at some point in time, with an on/off switch.

What is SQlite?
SQLite is a tiny database engine that is found in PHP. It is very lite, and requires only that php have the extension. There is no other dedicated server for it. You can find more information here: http://en.wikipedia.org/wiki/SQLite


Whats required?
PHP5
SQLITE2 or newer (found in most php installations)
1 file edit
1 file to upload

Future versions:
Repair table feature



Project Credits:
Zachery - Project Planning, design goals, pestering.
Link14716 - Hard work.

This works for vBulletin 4.0 as well as 3.7+. vB4 thread located here.

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Advanced Query Matic Atakan KOC vBulletin 3.8 Add-ons 16 17 May 2009 15:37
Administrative and Maintenance Tools Advanced Query Matic Atakan KOC vBulletin 3.7 Add-ons 22 04 Jul 2008 14:35

  #46  
Old 22 Oct 2010, 20:10
6impy 6impy is offline
 
Join Date: Nov 2001
I'm having a similar issue as psychonikeo.

sqlitedberrors.sqlite has the right permissions.

I echo'ed out: DIR .'/sqlitedberrors.sqlite' and it has the correct path.

I took a look in the sqlitedberrors.sqlite file and nothing is changing.

SQLite is properly installed because error_log is not spitting out any PHP errors for unrecognized commands.

Is there any way to see what the result/error of a query is?

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Edit:
Could it be the version of SQLite I'm running?

PDO Driver for SQLite 3.x enabled
PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c 272374 2008-12-31 11:17:49Z sebastian $
SQLite Library 3.3.7
---
SQLite support enabled
PECL Module version 2.0-dev $Id: sqlite.c 282740 2009-06-25 00:07:20Z scottmac $
SQLite Library 2.8.17
SQLite Encoding iso8859
Reply With Quote
  #47  
Old 23 Oct 2010, 20:30
6impy 6impy is offline
 
Join Date: Nov 2001
I fixed the problem I was having and thought I would share it with others who run into it.

For whatever reason, I needed to put the sqlitedberrors.sqlite file in a subfolder of the forum directory that was chmod'ed to 666 (sqlitedberrors.sqlite also being chmod'ed to 666)

e.g.
/path/to/web/forum/sqlite/sqlitedberrors.sqlite

instead of:
/path/to/web/forum/sqlitedberrors.sqlite

Then I modified the very first line of modified code (below the comments) that goes into /includes/class_core.php from:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

to (look after the DIR part for the added subfolder)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

It's working perfectly and now I don't get hundreds of text messages when my database goes down.

Cheers,
Drew
Reply With Quote
  #48  
Old 24 Oct 2010, 00:21
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
sounds like a permission error on the host OS/PHP more than SQLite.
__________________
Looking for ImpEx?
Reply With Quote
  #49  
Old 24 Oct 2010, 03:04
6impy 6impy is offline
 
Join Date: Nov 2001
That could be the case, but I tried changing ownership of the file and giving 777 to it. Nothing seemed to allow an update the content of the sqlite file. It would always spit out a query error on the insert. I even tried writing completely separate sqlite code to test it out. It only worked when I stuck it in a folder that was also writable.

Anyway, it may be of help to someone else...
Reply With Quote
  #50  
Old 27 Oct 2010, 02:40
adwade adwade is offline
 
Join Date: Aug 2006
Real name: A.D.
Thumbs up

Originally Posted by BirdOPrey5 View Post
I've been lucky enough to not ever need this, but now installed just in case- thanks.
DITTO!
Reply With Quote
  #51  
Old 02 Dec 2010, 12:12
ehd ehd is offline
 
Join Date: Jun 2009
hm...different one here.

I got emails with the db-errors, but also the sqlite-file was modifed und data has been inserted.

Why do I still get emails? Is there a way to check this?

Thx

Last edited by ehd; 02 Dec 2010 at 14:08.
Reply With Quote
  #52  
Old 02 Dec 2010, 22:14
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
What were the emails that you got?
__________________
Looking for ImpEx?
Reply With Quote
  #53  
Old 03 Dec 2010, 04:51
ehd ehd is offline
 
Join Date: Jun 2009
just the normal error-message you get when an error occurs.

I'll go into more details here.

I got the error-mails (board has another language though, but that wouldn't matter?)
and then I checked the sqlite-file.
It was last modified at the date of the db-error.
then I downloaded it and checked if there was an entry. And I could find the ip of the last db-error.

[edit] Just one IP, in the mails were more...[/edit]

That's quite strange, the db file has been accessed, but the mails were still sent... hm..

Here's the message, but that's the standard-one, which I got 10 times. With the same timestamp. Just a little error, normally I get more. It only differs in ips and paths.

Datenbankfehler in vBulletin :


mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (11)
/var/www/xxx/forum/includes/class_core.php on line 311


MySQL-Fehler :
Fehler-Nr. :
Fehler-Zeit : Wednesday, 24.11.2010 @ 10:32:01
Datum : Wednesday, 24.11.2010 @ 10:32:01
Skript : http://www.xxx/forum/ajax.php
Referrer : http://www.xxx/forum/xxx
IP-Adresse : 62.154.195.71
Benutzername :
Klassenname : vB_Database
MySQL-Version :
Reply With Quote
  #54  
Old 12 Dec 2010, 16:52
ehd ehd is offline
 
Join Date: Jun 2009
OK, strange enough: the last times I had db-errors there was only one mail.
And there always one entry in the sqlite-DB.
Reply With Quote
  #55  
Old 25 Jan 2011, 13:14
Floezen Floezen is offline
 
Join Date: Apr 2006
SQLiteDatabase Error

I installed this Plug-In about 2 weeks ago without problems.

Now, that there seemed to occur some database error, the error mail says: To many Connections.

But the page shows following:

Warning: SQLiteDatabase::queryExec() [sqlitedatabase.queryexec]: unable to open database file in /path_to_dir/httpdocs/includes/class_core.php on line 1032

Warning: SQLiteDatabase::queryExec() [sqlitedatabase.queryexec]: unable to open database file in /path_to_dir/httpdocs/includes/class_core.php on line 1038
Is that what it is supposed to show???

Regards
Florian
Reply With Quote
  #56  
Old 26 Jan 2011, 19:31
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Did you set the permissions correctrly?
__________________
Looking for ImpEx?
Reply With Quote
  #57  
Old 14 Feb 2011, 22:26
Floezen Floezen is offline
 
Join Date: Apr 2006
I would say, yes:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #58  
Old 15 Feb 2011, 23:51
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Real name: Zachery Woods
Did you try 777?
__________________
Looking for ImpEx?
Reply With Quote
  #59  
Old 17 May 2011, 03:55
Romamo Romamo is offline
 
Join Date: Nov 2008
Real name: Roman
I have a more simple decision: http://tracker.vbulletin.com/browse/VBIV-12105
Patch limits email sending to 1 per minute.
Reply With Quote
  #60  
Old 17 May 2011, 05:59
6impy 6impy is offline
 
Join Date: Nov 2001
Thanks for sharing!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 22:58.

Layout Options | Width: Wide Color: