CE Phoenix Upgrader Utility

PHP Warning: mysqli_connect(): (HY000/1045): Access denied - CE Phoenix Upgrader Utility

PHP Warning: mysqli_connect(): (HY000/1045): Access denied

by edfaught » Sun Apr 11, 2021 11:40 pm

PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user 'fwcvhp5_museum'@'localhost' (using password: YES)
in xxx\upgrader\inc\steps\06.php on line 82

Does upgrader look for a local configure file? I'd guess not.
User avatar
edfaught
Member
Posts: 49
Joined: Mon Oct 26, 2020 3:22 pm
Phoenix Version:
Contact:

Re: PHP Warning: mysqli_connect(): (HY000/1045): Access den

by zipurman » Sun Apr 11, 2021 11:50 pm

The upgrader loads the configure.php based on the answer to the catalog root provided in "Link to file structure for your CE Phoenix store".

It then uses those credentials and database to perform the upgrades. If line 82 of step 06 says it cannot connect, then I would review the access assigned to the user that is specified in the catalog/includes/configure.php as that part of the script is trying to create a database table as a test to make sure access is allowed. The upgrader will need full access to the database as upgrades need to add/drop/alter tables,columns, etc.
zipurman
-----------
User avatar
zipurman
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Contact:

Re: PHP Warning: mysqli_connect(): (HY000/1045): Access den

by edfaught » Mon Apr 12, 2021 4:33 pm

I was using an old /local/configure.php file which I figured Upgrader was not looking for, so I got rid of it and fixed the normal config file.
User avatar
edfaught
Member
Posts: 49
Joined: Mon Oct 26, 2020 3:22 pm
Phoenix Version:
Contact:

Re: PHP Warning: mysqli_connect(): (HY000/1045): Access den

by cristiangliga » Thu Feb 10, 2022 3:51 pm

I ran into the same issue.

As a suggestion for future versions: Upgrader could check whether or not there is a configure.php file in /includes/local/ and use the credentials from it.

Excellent Addon! Thank you, zipurman!
User avatar
cristiangliga
Member
Posts: 9
Joined: Tue Feb 09, 2021 7:19 am
Phoenix Version:
Contact:

Re: PHP Warning: mysqli_connect(): (HY000/1045): Access den

by zipurman » Thu Feb 10, 2022 4:02 pm

Thanks ;)

Will keep that in mind for future release as an option ;)
zipurman
-----------
User avatar
zipurman
Builder
Posts: 540
Joined: Tue Oct 13, 2020 5:20 pm
Phoenix Version: v
Contact: