Connecting to strange IP address (so access denied) after update

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 69111
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by KevC » Tue Sep 15, 2015 10:05 am

steve59 wrote:You seem to have a script which tests phpbb-database names, would you be so kind to test a
name with an underscore _ sign in it?
I just made the database name phpbb3_1 and it works fine.
steve59 wrote:Besides that we got the error when we were running an update (install/database_update.php). Might that give other results?
(because this file is not a part of an operational phpbb-forum)
My test board happened to be 3.1.4 which I updated to 3.1.6 before I started to test and that involved running the database_update.php which ran perfectly.

I think it's a server side redirection of some sort (anything added to an htaccess file you've forgotten about?). The config.php file basically says this is the information I need to connect to the database, so that's where I'm going to look. If that is then being redirected to a different location, that sounds very much like it's something outside of phpBB that's doing it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

steve59
Registered User
Posts: 53
Joined: Mon Jun 01, 2015 9:32 am

Re: Connecting to strange IP address (so access denied) after update

Post by steve59 » Tue Sep 15, 2015 2:37 pm

Hi KevC,

The redirecting behavior is caused by the software of our hosting provider, it occurs at least when a password or username is incorrect (I veryfied this with a stand alone testscript not connected to the phpbb-software)

I tried to upgrade again with version 3.1.6 instead of 3.1.5, but the error remains when running
/install/database_update.php

We could rename the database name to a name without special characters, after this change the error again remained unchanged.

What remains is, that the phpbb-software had problems reading our password when running /install/database_update.php. We cannot choose our password ourselves, it is selected by our hosting provider.

I read somewehere on this forum that there recently where problems with passwords containings special characters like %, but these were solved.
However, where these problems also solved for /install/database_update.php ?

Can you or anyone else please confirm if this is - or is not - the case?

Steve

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21152
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: Connecting to strange IP address (so access denied) after update

Post by Mick » Tue Sep 15, 2015 2:39 pm

Does your password have '%'s in it? I believe that should have been fixed anyway, I can't remember what version but it should be ok after 3.1.5.
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
Lumpy Burgertushie
Registered User
Posts: 66334
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by Lumpy Burgertushie » Tue Sep 15, 2015 2:42 pm

and since this is apparently related to a server setting, have you contacted your host about it? phpbb can only work with what the server provides and some hosts do tend to make things difficult for normal operations...
go(cough)dad(cough)dy......



robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
david63
Registered User
Posts: 16188
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by david63 » Tue Sep 15, 2015 2:43 pm

steve59 wrote:The redirecting behavior is caused by the software of our hosting provider, it occurs at least when a password or username is incorrect
steve59 wrote:We cannot choose our password ourselves, it is selected by our hosting provider.
Never heard of these before - or at least not having the ability to change the password.

There appear to be some very strange procedures set up by your hosts - either they do not know how to set up a server or they just want to make life difficult for everyone (themselves included).

If I was in your situation I would be seriously considering moving to a new host.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

steve59
Registered User
Posts: 53
Joined: Mon Jun 01, 2015 9:32 am

Database_update.php not running with % in password?

Post by steve59 » Wed Sep 16, 2015 3:30 pm

Our hosting provider did the following test for us:

they
(1) did a fresh install of 3.0.14,
(2) tried to update to version 3.1.6, like we did.

With a %-sign in the database-password,
the got the same error after running
/install/database_update.php:
Access denied for user....

Seems that this clearly shows that the % sign in our password is the problem,
UNLESS someone posts here that they were able to update from 3.0.14 to 3.1.5 (or 3.1.6) with
a %-sign in their database password. So if you did, please let us know!

We cannot generate a database password (without a % sign) ourselves, or we should choose another hosting provider (but we are very happy with the one we have).

If the %-sign is indeed the problem, when will an update arrive in which this solved?

This matter is rather urgent I would think, since patches for version 3.0.x will not be available starting from november 2015, I read

Steve

User avatar
Lumpy Burgertushie
Registered User
Posts: 66334
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by Lumpy Burgertushie » Wed Sep 16, 2015 3:39 pm

why can't you generate your own password for your own database? I have never heard of this before.

at the very least the host should be able to give you a different password.

also, that issue was supposed to have been fixed a couple of versions ago.

it could be that there is something strange about your hosting setup that is causing this problem even though phpbb fixed the issue some time ago.

who is your host , maybe we can help you figure out how and where to change your password.


do you only have one database available to you for your hosting account?

luck,
robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69111
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by KevC » Wed Sep 16, 2015 4:17 pm

I can confirm that if there is a % in the password, the site works fine BUT will give this error when running the database_update.php file

SQL ERROR [ mysql4 ]
Access denied for user 'root'@'localhost' (using password: YES) [1045]
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21152
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: Connecting to strange IP address (so access denied) after update

Post by Mick » Wed Sep 16, 2015 5:33 pm

I was under some misconception that the % thing had been fixed but it appears not, see database_upgrade.php fails when database password contains a % character
"The more connected we get the more alone we become" - Kyle Broflovski

steve59
Registered User
Posts: 53
Joined: Mon Jun 01, 2015 9:32 am

Re: Connecting to strange IP address (so access denied) after update

Post by steve59 » Wed Sep 16, 2015 5:54 pm

Hi KevC and Mick,

Thanks for this clear answer, so now what caused our problem is finally known!

However, looking at the release rate, version 3.1.7 probably will not be available before november?
So not before the security patches of 3.0.x end?

Would it not be reasonable that there is at least one (or two) months with bug-free
possiblities to upgrade 3.0.x to 3.1.x, with 3.0.x stiil maintained?

Considering that the late adopters (like we) are probably the ones with integrated phpbb-forums,
so we need time to test and adjust?

Steve

User avatar
KillBill.
Registered User
Posts: 596
Joined: Tue Jun 02, 2009 4:07 pm
Contact:

Re: Connecting to strange IP address (so access denied) after update

Post by KillBill. » Wed Sep 16, 2015 8:22 pm

KillBill. wrote:
Oyabun1 wrote:
KillBill. wrote:I also encountered this error.

This error only occurs during installation or update!
The fault is not to accept any special characters in the password field.
Recommend replace the password and it will work.

For example, the % character will not be tolerated.

if change password - purge cache ;)
That shouldn't be an issue in updating from 3.1.5 to 3.1.6. There was a bug that was resolved in 3.1.2, so once the board files are correctly updated beyond that it should not be an issue any more.

If the board was previously not correctly updated the solution to the invalid characters in the password issue is to upload the phpbb/di/extension/config.php file from the latest version and then purge the board's cache.
Sorry not work

I download 3.1.6 and first install - add sql pass 12345
installed ok
after install I change password HZ765ttgTTz%!+---+H%5tf%tr!%tg
and purge cache

I go index.php page WORK
I again run install/update script add error

Code: Select all

General Error
SQL ERROR [ mysqli ]

Access denied for user 'test'@'localhost' (using password: YES) [1045]

BACKTRACE
KevC wrote:I can confirm that if there is a % in the password, the site works fine BUT will give this error when running the database_update.php file

SQL ERROR [ mysql4 ]
Access denied for user 'root'@'localhost' (using password: YES) [1045]
Thank you confirmed. ;)

steve59
Registered User
Posts: 53
Joined: Mon Jun 01, 2015 9:32 am

Patch for database_update.php?

Post by steve59 » Thu Sep 17, 2015 7:16 am

Since the error with % in de database-password only happens when running
database_update.php, maybe it is possible to develop some kind of
(maybe temporarely) patch to circumvent this problem?

Steve

Locked

Return to “[3.1.x] Support Forum”