vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Forum Messed up and saying datbase error plz help? (https://vborg.vbsupport.ru/showthread.php?t=288437)

Mark_Zuckerberg 09-28-2012 05:02 PM

Forum Messed up and saying datbase error plz help?
 
Hello

I was working on my forum it was working pretty fine while i refreshed the page it took too long too respond and then came up with an error page saying database error please help i have also tried to disable the hooks by disabling them from config file but the problem is still there please help?:(

Lynne 09-28-2012 05:05 PM

And what is the database error? We need to see it in order to help. You will need to check your email in order to get it for us (the email you entered in your config.php file).

MegaManSec 09-28-2012 05:07 PM

"Taking to long to load"
"Database error"
That sounds like the error "MySQL server has gone away"

Is your server under excessive load ?

Mark_Zuckerberg 09-28-2012 05:10 PM

Quote:

Originally Posted by Lynne (Post 2369265)
And what is the database error? We need to see it in order to help. You will need to check your email in order to get it for us (the email you entered in your config.php file).

yeah i have received 12 mails in my mail account how can i show you that as it contains confidential information? should i pm you

--------------- Added [DATE]1348859533[/DATE] at [TIME]1348859533[/TIME] ---------------

Quote:

Originally Posted by MegaManSec (Post 2369266)
"Taking to long to load"
"Database error"
That sounds like the error "MySQL server has gone away"

Is your server under load ?

I think some one is pinching the site can you please check the url its in the signature

MegaManSec 09-28-2012 05:14 PM

Quote:

Originally Posted by Mark_Zuckerberg (Post 2369269)
yeah i have received 12 mails in my mail account how can i show you that as it contains confidential information? should i pm you

--------------- Added [DATE]1348859533[/DATE] at [TIME]1348859533[/TIME] ---------------



I think some one is pinching the site can you please check the url its in the signature

You mean somebody is mirroring the site? Hm. well that's not to hard to stop.

Also, Your website is down at the moment.

Are you on shared hosting? or a VPS, or a dedicated server?

Mark_Zuckerberg 09-28-2012 05:20 PM

Its a dedicated server mate and i have installed the vb optimise add on by dbtech and in that the option of cache was eaccelrator and memcache the eaccelrator was also not working so i requested to my host to install memcache on my server and now its messed :(

MegaManSec 09-28-2012 05:22 PM

Quote:

Originally Posted by Mark_Zuckerberg (Post 2369273)
Its a dedicated server mate and i have installed the vb optimise add on by dbtech and in that the option of cache was eaccelrator and memcache the eaccelrator was also not working so i requested to my host to install memcache on my server and now its messed :(

So memcache is the problem? Maybe it is misconfigured.
Do you have shell/SSH access?

Mark_Zuckerberg 09-28-2012 05:25 PM

but the server guy is saying they didnt installed it yet :( and i have the access to cpanel and whm

--------------- Added [DATE]1348860459[/DATE] at [TIME]1348860459[/TIME] ---------------

MegaManSec please check at your site is it opening as server guy is saying working fine there :(

MegaManSec 09-28-2012 05:27 PM

I've never used cpanel, or whm before.

Is there a way to see running programs, and how much ram they are using?

Mark_Zuckerberg 09-28-2012 05:32 PM

its working now its opened and now i have opened the profile of other admin and it again stucked :(

MegaManSec 09-28-2012 05:37 PM

PM me what the error is please.
And yes, I can atleast load the website now. but database error.

Mark_Zuckerberg 09-28-2012 05:43 PM

pm sent to you please check

MegaManSec 09-28-2012 06:26 PM

Sorry I forgot about this.

edit your mysql config file and raise max_user_connections to something higher than it currently is.
You should probably check your logs and find out what is causing it..
Then you can block them from your website.

Mark_Zuckerberg 09-28-2012 06:30 PM

i am getting mails again and again the users are from same ip range and the site is giving database error

MegaManSec 09-28-2012 06:32 PM

what is the 'common' ip address? like the ip address that is most likely causing the problem?

Mark_Zuckerberg 09-28-2012 06:40 PM

lastly i have installed this mod will it be the reason or not

Code:

https://vborg.vbsupport.ru/showthread.php?t=267506
The ip is 180.76.5.89 and so on changes the last 2 digits

--------------- Added [DATE]1348864877[/DATE] at [TIME]1348864877[/TIME] ---------------

i have blocked the ips of china as this ip os from china

MegaManSec 09-28-2012 07:13 PM

That's baidu spider.. that shouldn't be a problem.
Are there any other 'common' ip address's?

Mark_Zuckerberg 09-28-2012 07:22 PM

hosting guy said

Quote:

It appears multiple connections are being made to the database and not being killed off, causing the database not to be able to service any new requests. The site is up at this time. I would advise to reach out to you web developer in regards to this issue.
--------------- Added [DATE]1348867922[/DATE] at [TIME]1348867922[/TIME] ---------------

he also send me some recommendations which are this

Quote:

General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 32M)
join_buffer_size (> 1.0M, or always use indexes with joins)
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
what should i do know can you help me out?

CAG CheechDogg 09-28-2012 07:34 PM

Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.

Mark_Zuckerberg 09-28-2012 07:39 PM

Quote:

Originally Posted by CAG CheechDogg (Post 2369326)
Your site is going down because of server overload due to the emails being sent out again and again. Check to see if there is a cron job sending out emails and check to see what email accounts you have set up whether you created those email accounts or not.

If you see any cron job and you didn't set one up in your cPanel remove it. Also change the passwords of any email accounts you have created. If you see email accounts you did not create remove them.

If you are using an email client such as Mozialla Thunderbird make sure they are (POP) and not (IMAP), IMAP keeps processes running until you close your email client. If you have a few or even a couple email accounts opened it will screw you over.

how can i find that any path details?

CAG CheechDogg 09-28-2012 07:40 PM

You have to log into your cPanel and you will see it either on the left or right side. What host are you using?

Mark_Zuckerberg 09-28-2012 07:43 PM

having a dedicated server of wiredtree and i aint find any cron job option in the admin cp although i have searched by expanding all

--------------- Added [DATE]1348868709[/DATE] at [TIME]1348868709[/TIME] ---------------

ok let me c in the cpanel sorry got confused due to tens :(

--------------- Added [DATE]1348868840[/DATE] at [TIME]1348868840[/TIME] ---------------

i have checked and there are no current cron jobs nor any email address is added

CAG CheechDogg 09-28-2012 07:57 PM

Hmmm...very weird...when you turn on your forums what processes are running? That will give you an indication of what is overloading your server.

Mark_Zuckerberg 09-28-2012 07:58 PM

Quote:

Originally Posted by CAG CheechDogg (Post 2369340)
Hmmm...very weird...when you turn on your forums what processes are running? That will give you an indication of what is overloading your server.

The server guy is saying

Quote:

I have run a optimization script here on my end. However any other changes you would have to consult a database administrator.

CAG CheechDogg 09-28-2012 07:59 PM

Mark check your email really quick buddy.

Mark_Zuckerberg 09-28-2012 08:06 PM

Quote:

Originally Posted by CAG CheechDogg (Post 2369343)
Mark check your email really quick buddy.

Pm sent to u plz check?


All times are GMT. The time now is 11:46 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02271 seconds
  • Memory Usage 1,790KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (26)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete