Database error

SeawebEdition
Junior Member
Beiträge: 6
Registriert: Do 7. Okt 2021, 10:05

Database error

Beitragvon SeawebEdition » Do 7. Okt 2021, 10:16

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?

NilSole
Senior Member
Beiträge: 303
Registriert: Mi 27. Mär 2019, 15:28

Re: Database error

Beitragvon NilSole » Fr 8. Okt 2021, 18:59

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?

SeawebEdition
Junior Member
Beiträge: 6
Registriert: Do 7. Okt 2021, 10:05

Re: Database error

Beitragvon SeawebEdition » Di 12. Okt 2021, 07:36

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

NilSole
Senior Member
Beiträge: 303
Registriert: Mi 27. Mär 2019, 15:28

Re: Database error

Beitragvon NilSole » Di 12. Okt 2021, 11:07

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

SeawebEdition
Junior Member
Beiträge: 6
Registriert: Do 7. Okt 2021, 10:05

Re: Database error

Beitragvon SeawebEdition » Do 14. Okt 2021, 14:42

I have added the port and I still getting the errors.
webEdition.png
webEdition.png (33.92 KiB) 4046 mal betrachtet

NilSole
Senior Member
Beiträge: 303
Registriert: Mi 27. Mär 2019, 15:28

Re: Database error

Beitragvon NilSole » Do 14. Okt 2021, 15:32

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/

SeawebEdition
Junior Member
Beiträge: 6
Registriert: Do 7. Okt 2021, 10:05

Re: Database error

Beitragvon SeawebEdition » Mo 18. Okt 2021, 09:05

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?
Dateianhänge
webEdition.png
webEdition.png (26.8 KiB) 3977 mal betrachtet

NilSole
Senior Member
Beiträge: 303
Registriert: Mi 27. Mär 2019, 15:28

Re: Database error

Beitragvon NilSole » Mo 18. Okt 2021, 10:49

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.

SeawebEdition
Junior Member
Beiträge: 6
Registriert: Do 7. Okt 2021, 10:05

Re: Database error

Beitragvon SeawebEdition » Do 21. Okt 2021, 15:12

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.
Dateianhänge
webEditionOnlineInstaller.png
webEditionOnlineInstaller.png (61.22 KiB) 3923 mal betrachtet

NilSole
Senior Member
Beiträge: 303
Registriert: Mi 27. Mär 2019, 15:28

Re: Database error

Beitragvon NilSole » Mi 27. Okt 2021, 19:40

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.


Zurück zu „webEdition Basic Version“

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 8 Gäste