Forum Messed up and saying datbase error plz help?

[Mark_Zuckerberg]

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]

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]

"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]

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 1348859533 at 1348859533 ---------------

"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]

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 1348859533 at 1348859533 ---------------



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]

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]

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]

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

--------------- Added 1348860459 at 1348860459 ---------------

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

[MegaManSec]

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]

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

[MegaManSec]

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

[Mark_Zuckerberg]

pm sent to you please check

[MegaManSec]

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]

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

[MegaManSec]

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

[Mark_Zuckerberg]

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

https://vborg.vbsupport.ru/showthread.php?t=267506

The ip is 180.76.5.89 and so on changes the last 2 digits

--------------- Added 1348864877 at 1348864877 ---------------

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

[MegaManSec]

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

[Mark_Zuckerberg]

hosting guy said


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 1348867922 at 1348867922 ---------------

he also send me some recommendations which are this

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]

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]

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]

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]

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 1348868709 at 1348868709 ---------------

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

--------------- Added 1348868840 at 1348868840 ---------------

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

[CAG CheechDogg]

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]

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

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

[CAG CheechDogg]

Mark check your email really quick buddy.

[Mark_Zuckerberg]

Mark check your email really quick buddy.

Pm sent to u plz check?