Urgent: Connecting problem to database !

[hartiberlin]

Hi All,
I am running at
www.overunity.com
SMF 1.1.1 with TP 0.97 and Admod 1.1V2



I now have again the database access problem,
but this time the error is:

Database Error: User 'hartiberlin1' has exceeded the 'max_updates' resource (current value: 30000)
File: /mounted-storage/home4/sub002/sc11940-GNVW/overunity/Sources/Subs.php
Line: 2536

The Techsupport guy writes:

Hello Stefan,

Mind you it is the max_updates where the limit is reached not the max_questions. It is not normal to have that many updates, even for that many pageviews. A busy website will normally only use many questions and only a few updates.

Please check your scripts again to see where the update queries are used.


Kind regards,
Allan, Servage Hosting

===============

What could generate this huge
'max_updates' value ?

When is this parameter being increased ?
Only if somebody posts a message in my forum
or what exactly is it ?

How can I check, which user is generating this huge
'max_updates' value ?

Could it be, that somebody tries to hack my
admin password with a brute force program ?

Please help.

Many thanks.

Regards, Stefan.
 

[G6Cad]

The only thing i can think of is if you have RSS feeds in an article or in a block, or some mod that update often, A javascript that keeps refreshing or some thing.

[hartiberlin]

Hmm,
I have RSS enabled, should I disable it in the admin area ?

Also I have a clock in a TP block at the side
and also Google adsense and Amazon skyscraper ads
in TP blocks at the side boarders of my forum
an a Kontera.com Content-add Javascript , that checks the site
for content words and double marks them and users
can then click these keywords for adds..

Hmm, my Techsupport writes:

Hello Stefan,

Sql updates are INSERT, UPDATE and REPLACE statements.

Sql questions are all statements.

So, what should I change ?
Could it just be a brute force attack from someone,
who tries to get the admin password ?

Many thanks.

Regards, Stefan.

[hartiberlin]

P.S: normally every page of my forum generates
about 19 to 35 queries to the database,
but what exactly makes accesses to this
'max_updates' value ?

How could I check this out, which Block
might increase this value, so I could disable it ?

Many thanks.

[gerrymo]

First, make sure in admin you are not using a persistant connection. It's not needed.

If its not that, try turning off RSS.

[hartiberlin]

Many thanks ,
another guy at the SMF site answered:

--------------------------------------
SMF does quite a few updates to various tables such as sessions and log_online with each page view, you could reduce it a bit by disabling db driven sessions, but your best bet is to find a real host that doesn't impose pointless stupid limits like this.

---------------------------------------------
Where do I find this setting ?
In the Admin area ?

I have the problem, that I can not even access the ADMIN
section anymore.

How could I disable the forum via FTP, so that only me can access
the forum and I could change things in the admin section ?

Many thanks.

[hartiberlin]

In the error log in maintainance section in admin section I also
always get error messages, that
emails did not get send like this:

pxxxse   Today at 03:48:02 PM 
84.173.52.157    65982b50db210aad7d1abb7ee3743b87 
http://www.overunity.com/index.php?action=post2;start=920;board=49 
Unable to send mail to the email address 'lhaxxxxx@flite.net'

What could have caused this error ?

There are now about 30 error pages about emails not sent...
hmm...

[G6Cad]

The email issues you have are simply mails that didnt had the correct adresses or similar, so the mails were never answerd to or didnt had a destination that were correct.
Many users just type in a fake adress when they registerm and those fake adresses are the ones that returns in the error log when you mass send news or news letters.

To prevent this you can set your registration to email validation, it means that the users that wants to registerm have to validate their emal to show that they have a valid email adress, or they simply wont be allowed in to the forum.

[ianus]

Greetings!

First, I donÃ,´t know a reason why 'max_updates' exeeds.

Second.

How could I disable the forum via FTP, so that only me can access
the forum and I could change things in the admin section ?

Download and open your ââ,¬Å"settings.phpââ,¬Â
In line 26, you will find

Code Select Expand

$maintenance = 0; # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)
Change =0 to =1 and only an Admin is able to log in.


Third:
To disable db driven sessions use your board.
Path is Admin -> Server Settings -> Feature configuration
There your will find ââ,¬Å"Use database driven sessionsââ,¬Â.

To disable RSS
Got to News and newsletters -> settings

A short view to your sig.
The Savage offer sounds nice, but a quick search bring up this
http://www.joomlaportal.de/allgemeine-fragen-zu-joomla/70967-sql-max_updates-bei-servage.html

I think, you understand German?
Well, then there is another link. Here you will find a Bot-Trap, a smal php script to prevent access from a huge range of IPÃ,´s and bots
http://www.bot-trap.de
Only to make sure, you are not under an attack.

Also, to your last post.
Flite . net offers webhosting an dial up services.
Imho sombody, or al lot of somebodys are spamming your board.

You should activate Captcha for registration.
Path is Admin -> Registration -> Settings and you will find
ââ,¬Å"Disable the use of the visual verification an registrationââ,¬Â

Under the same path you find the ââ,¬Å"Method of registrationââ,¬Â.
Set it to ââ,¬Å"Member activationââ,¬Â an the SMF send an e-mail to proof if its real, like G6 mentioned
At the moment, I would prefer ââ,¬Å"Member Appovalââ,¬Â. In this case, you have to allow the new user or not. This is not comfortable, but for a short timeââ,¬Â¦


IÃ,´m sorry, but thatââ,¬â,,¢s all I can do for you.

[gerrymo]

I know the previous hosts. I used to be with them, runing a very busy board. I had no problems like this at any time. I feel there may be something wrong on the Installation, rather than the server. But what? I have no idea.