Seite 1 von 1

Database error

Verfasst: Do 7. Okt 2021, 10:16
von SeawebEdition
I have been tasked with updating an aging PHP 7.1 website.
I have downloaded everything and I am running it locally in XAMPP.
My problem is with the webEdition 8.0.4.0. setup Database settings

• ERROR: Please enter the host name of your MySQL database server.
• ERROR: Please enter the database name to be used by webEdition. This database does not need to exist yet, if the specified database user has the permission to create databases.
• ERROR: Please enter the username for accessing your MySQL database server.
• ERROR: Please enter the password for accessing your MySQL database server.

My Database information is correct and I can connect with console, and I can see the connection is successful in the General log from MySQL.
However, when I add the same database information to the "webEdition database settings" I am getting no connect request in the general log in MySQL.

Why am I receiving the above error, when my database settings are correct?

Re: Database error

Verfasst: Fr 8. Okt 2021, 18:59
von NilSole
Well you should at least provide some info on what you actually did enter. Did you maybe forget to set the correct port for the DB connection?

Re: Database error

Verfasst: Di 12. Okt 2021, 07:36
von SeawebEdition
Here is the login information that worked on the console

mysql -u ***** -p ********* -h 127.0.0.1

I used the same information in the "webEdition database settings" but I get the errors listed in my first post

Re: Database error

Verfasst: Di 12. Okt 2021, 11:07
von NilSole
For the Server entry you should add the Port! The default MySQL port is 3306.

So for Database connection you should write 127.0.0.1:3306

This might help

Re: Database error

Verfasst: Do 14. Okt 2021, 14:42
von SeawebEdition
I have added the port and I still getting the errors.
webEdition.png
webEdition.png (33.92 KiB) 4371 mal betrachtet

Re: Database error

Verfasst: Do 14. Okt 2021, 15:32
von NilSole
This looks like the very old 'manual' Installer (that one is not functional currently). Please make sure to use the 'online installer' from the official website. Link saying 'Online Installation'. With that one it should work.

https://www.webedition.org/de/webedition/

Re: Database error

Verfasst: Mo 18. Okt 2021, 09:05
von SeawebEdition
Even though the OnlineInstaller.php says it functions with PHP 7.1 when I run it, it says “PHP Version 7.2 or newer required.”

Which is the latest version that functions with PHP 7.1 that also has a functioning database settings?

Re: Database error

Verfasst: Mo 18. Okt 2021, 10:49
von NilSole
I see, we don't have extended support for old versions.
You got 2 Options:
1. (recommended) use a more recent PHP-Version, eg 7.4, but not PHP 8 (incompatible to WE8). Since you use Xampp anyways this should be easy.

2. After running the OnlineInstaller for the first time you should be able to access the following file: /yourServerRoot/OnlineInstaller/setup.php
Edit line 44, change 7.2 to 7.1 (not tested but that could help if we don't use PHP 7.2 functions in the OnlineInstaller).

Don't forget that PHP 7.1 has been discontinued 2 years ago already, so if possible you should also update the servers PHP-Version.

Re: Database error

Verfasst: Do 21. Okt 2021, 15:12
von SeawebEdition
I tried option two, and after editing the setup.php I could start the installer.
However there is an other php version check during the process that the installer couldn’t pass.

Re: Database error

Verfasst: Mi 27. Okt 2021, 19:40
von NilSole
Then I suggest to go with option 1. Otherwise there may be the Update server checking for your PHP version as well, and fixing that would be too big of an effort just for using a deprecated PHP version locally.