Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Suppress-o-Matic - Stop database error spam Details »»
Suppress-o-Matic - Stop database error spam
Version: 1.00, by GeekyDesigns GeekyDesigns is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.8.x Rating:
Released: 07-14-2009 Last Update: 11-16-2009 Installs: 96
Code Changes Additional Files  
No support by the author.

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

File Type: zip DB Error Suppress-o-matic.zip (1.7 KB, 426 views)

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #52  
Old 12-02-2010, 10:12 AM
ehd ehd is offline
 
Join Date: Jun 2009
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #53  
Old 12-02-2010, 08:14 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What were the emails that you got?
Reply With Quote
  #54  
Old 12-03-2010, 02:51 AM
ehd ehd is offline
 
Join Date: Jun 2009
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.

Quote:
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
  #55  
Old 12-12-2010, 02:52 PM
ehd ehd is offline
 
Join Date: Jun 2009
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
  #56  
Old 01-25-2011, 11:14 AM
Floezen Floezen is offline
 
Join Date: Apr 2006
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:

Quote:
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
  #57  
Old 01-26-2011, 05:31 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you set the permissions correctrly?
Reply With Quote
  #58  
Old 02-14-2011, 08:26 PM
Floezen Floezen is offline
 
Join Date: Apr 2006
Posts: 2
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would say, yes:

Code:
-rw-rw-rw-  1 user psacln    5120 Jan  3 23:35 sqlitedberrors.sqlite
Reply With Quote
  #59  
Old 02-15-2011, 09:51 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you try 777?
Reply With Quote
  #60  
Old 05-17-2011, 01:55 AM
Romamo Romamo is offline
 
Join Date: Nov 2008
Location: Cyprus
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have a more simple decision: http://tracker.vbulletin.com/browse/VBIV-12105
Patch limits email sending to 1 per minute.
Reply With Quote
  #61  
Old 05-17-2011, 03:59 AM
6impy 6impy is offline
 
Join Date: Oct 2001
Location: Seattle
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for sharing!
Reply With Quote
Reply


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


All times are GMT. The time now is 07:36 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05528 seconds
  • Memory Usage 2,329KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete