Shut Out

[Don_NUTSO]

It was  1.1 RC1
Now I have the same problem

Грешка с базата данни: MySQL server has gone away
Файл: /wwwprefix/forum.stih4e.com/www/Sources/Security.php
Линия: 272

[Geri Lx]

I have the same problem:
.../Sources/Security.php
Line: 272 error
and
...Sources/Load.php
line: 2005


I one of the (2) administrators. And I am a dum newbie in this domain.
My fellow administrator has some problems and can't help me these days, so that's why I'm asking for help here.
I tried to access the forum with IE and Opera, and it does not work. (But I can acess the cPanel.)
I also tried to acess the forum using a diferent OS, from a Live CD (fedora) and it works fine.
It works ok also when I acess the forum from my work.
The IP I get using the fedora OS is different from the usual IP that I have within windows, (the one from work it's of course also different) so maybe the MySQL blocks my IP. But why I do not now.
I scanned my computer with 3 different virus scanners (2 online scanners) and it looks clean.
I also deactivated, during trials, the firewall... so that's not  causing this eiher.
Help please.

[Sarge]

To all that posted about it: try deleting your cookies and cache (temporary Internet files) from your browser. You have problems logging in from one computer, so the problem is on that computer, not the site.

[Geri Lx]

I tried that last night, and I tried it now again.
I deleted all temporary files on the computer, by searching for the teporary folders, including opera and IE,
...and by serching using the run/%temp%/ok command.
I deleted all files using the IE preferences menu and Opera also.
I dleted all cookies from IE and Opera. Veryfied it...all clean.
I iven deleted the bookmark shortcuts to my forum.

I searched for the forum using google so it could not use a shortcut and coockie from the browser (I left none).  And i tried to acess it...the result is the same. No access. Same errors.

I looked in the cPanel in the error logs...no errors with my IP.
I did a ping tot the site and the server responded ok. Ping successful.
I did a tracert and it get to the server.
...Don't now what else to try.

[Sarge]

Try contacting your ISP, maybe they can help with it.

Can you post your forum URL here?

[Geri Lx]

Try contacting your ISP, maybe they can help with it.

Can you post your forum URL here?

Ill try...and if it's possible I will ask them to change my IP to see if it works then.
Thank you sarge for trying to help.
http://www.arthalia.ro [nofollow] ...it's the url.

[KROSH]

To all that posted about it: try deleting your cookies and cache (temporary Internet files) from your browser. You have problems logging in from one computer, so the problem is on that computer, not the site.

The problem is for the IP, the forum blocks some IPs but nobody can say why... the only solution to accede to the forum is that the blocked user tries to change his IP...

[Sarge]

The problem is for the IP, the forum blocks some IPs but nobody can say why... the only solution to accede to the forum is that the blocked user tries to change his IP...

Look at Admin > Ban List. Another possibility is that the IP is blocked by a firewall at the server or host network level, not at the forum level.

[Don_NUTSO]

I'm writing you this again - it's not from the ISP, it's not from the cookies or temp files, and in the ban list there are not described this IPs.
A friend of mine helped me: he has edited security.php, and when I or some of my users have this "ban problem" i'm putting the edited security.php (I'm not shure but I think then the ban which you have are not active) and when the problem has gone I put the original security.php. It is primitive decision but it works, and I'm pleased and also my users.

[Sarge]

Can you attach the edited Security.php? It can help us pinpoint the problem more accurately, perhaps even offer a better fix. Thank you!

[Don_NUTSO]

here is the edited file, but i can't tell you where or what was changed, because i do not understand.

[Tony Reid]

All that I can see is that he has removed(by comment) Lines 213 - 431

The bit that deals with this....
// Only check the ban every so often. (to reduce load.)


Which could be detrimental on server load.

[Sarge]

Actually, the whole code of the function is_not_banned() is commented out, except for this:

Code Select Expand


return;

which makes the function return true (the user is not banned), no matter what. So that change will allow all banned members to visit, log on, post etc. on your forum. I'm starting to think that the problem lies with the SMF and/or PHP configuration.

Verify that these settings in SMF Admin > Server Settings > Feature Configuration tab are set as below:

Enable local storage of cookies - unchecked (not ticked)
Use subdomain independent cookies - checked (ticked)
Use database driven sessions - checked (ticked)

Also post the link to your phpinfo.php
What is a phpinfo() file?

[Don_NUTSO]

here is the info http://forum.stih4e.com/phpinfo__.php [nofollow]

about this:
Enable local storage of cookies - unchecked (not ticked)
Use subdomain independent cookies - checked (ticked)
Use database driven sessions - checked (ticked)

it was the same ...


I want to ask about search engine, sometimes when i click to search something, the whole forum loading very slow, and sometimes shows blank page. My DB is very big, more than 250 MB is the SQL file, is the problem from this?

Sorry for my bad english.

[Sarge]

Another possible cause I can think of is that those users have firewalls installed on their computers that won't allow your forum to set its cookies.

[Don_NUTSO]

I was banned before a few weeks from my forum (i made a mistake to log out) I have not installed firewalls. This is a big mistery

[GregMCrowe]

I am having this exact problem with hxxp:forum.x-tremeoffroaders.com [nonactive]

Host is godaddy, forum is lightly traveled. SMF is 1.1.4, no mods.

85% of users never have a problem, 15% of users can never get online, ever. Problem is 100% consistent across small subset of users. For these reasons, I do not expect it is godaddy mysql load.

smf_ban_groups and smf_ban_items on my DB are both empty.

I have 2 IP providers at my home. Connected to 1 MySQL times out with the security.php error. Connected to another the forum works fine. Now, while I still somewhat suspect the ISP to be involved, I have had several (3) techs from various call centers swear up and down that they are not traffic shaping in any way. Other usage (p2p, specifically) appears to back up these claims. Also, I personally know other users on this ISP in this geographic area (in other words, on the same ISP CO gear and thereby theoretically subjected to the same presumed traffic shaping) who can get to SMF no problems.

I have ... some considerable experience debugging software and I am at a bit of a loss here. I am tempted to do as Don has done and comment out the ban list entirely, though this is obviously a non-optimal solution.

Thoughts?
- Greg

edit: grammar.

[Geri Lx]

For me it worked with the IP change.

But for more users it can be anoying.  Hopefuly there are no users of my forum (other than me ) affected.

I will keep my eye to this topic...in case if it happends again.

[Rumbaar]

Wow this support thread is a mess, what is there 3-4 different people asking questions having issues.  This is why it's best to create a single thread per person per issue so it can be followed cleanly.

Now could the IP issue be with newly released IP ranges and/or IPv4/Ipv6 addresses?   

[KROSH]

Now could the IP issue be with newly released IP ranges and/or IPv4/Ipv6 addresses?   

I have this problem in my forum when someone tries to connect from an IP that it begins for 193.