Page 1 of 1

upgrading mysql 5.7 to 8

Posted: Thu Sep 24, 2020 7:34 pm
by rhowe72
I have upgraded the MySQL server from version 5.7 to version 8 and now when I go to the login page I get Unknown Error

Re: upgrading mysql 5.7 to 8

Posted: Mon Sep 28, 2020 2:52 pm
by l.l.gibbons
I'm having the same issue, I have just done a fresh install on Centos7, PHP 7.4, Mysql 8, and just getting unknown error on the home page.

Initially I did the database schema install via command line and all appeared to work ok. Then I tried it via webpage at /Web/install/index.php but that returned error messages for some of the schema updates, things like unable to create field as already exists...

I tried to install mariadb on centos 7 but it wouldn't let me, can only use mysql 8 by the look of it.

Re: upgrading mysql 5.7 to 8

Posted: Wed Sep 30, 2020 10:33 am
by l.l.gibbons
I set the server up into DEBUG mode and this is what I get in the error log:


2020-09-30T10:13:38+00:00 [13793] DEBUG default - [User= ()] Using CaptchaService [File=/var/www/enbooked/html/lib/Application/Authenticatio$
2020-09-30T10:13:38+00:00 [13793] ERROR default - [User= ()] Error connecting to database
Check your database settings in the config file
[File=/var/www/enbooked/html/lib/Database/MySQL/MySqlConnection.php,Line=66]
2020-09-30T10:13:38+00:00 [13793] ERROR default - [User= ()] Uncaught exception: Exception: Error connecting to database
Error: in /var/www/enbooked/html/lib/Database/MySQL/MySqlConnection.php:67
Stack trace:
#0 /var/www/enbooked/html/lib/Database/Database.php(41): MySqlConnection->Connect()
#1 /var/www/enbooked/html/Domain/Access/AnnouncementRepository.php(29): Database->Query()
#2 /var/www/enbooked/html/Presenters/LoginPresenter.php(154): AnnouncementRepository->GetFuture()
#3 /var/www/enbooked/html/Pages/LoginPage.php(138): LoginPresenter->PageLoad()
#4 /var/www/enbooked/html/Web/index.php(43): LoginPage->PageLoad()
#5 {main} [File=/var/www/enbooked/html/lib/Common/Logging/ExceptionHandler.php,Line=33]


Seems to be a connection error, so I created a simple php connection test:


<?php
$servername = "localhost";
$database = "bookeddb";
$username = "booked-user";
$password = "Password";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
mysqli_close($conn);
?>


When I use localhost the connection is successfull, when I use 127.0.0.1 the connection is denied. I have created booked-user@localhost and booked-user@127.0.0.1 in mysql with same password and same grants. For some reason 127.0.0.1 is not connecting. I have 127.0.0.1 set as hostspec in the config.php file. However if I change it to localhost it makes no difference so I'm not sure this is actually the problem.

Re: upgrading mysql 5.7 to 8

Posted: Thu Oct 01, 2020 4:27 am
by gbottaro
Hi, try appending --default-authentication-plugin=mysql_native_password in the start command.

Re: upgrading mysql 5.7 to 8

Posted: Mon Nov 22, 2021 6:55 pm
by TechCoder
You should read the 'readme.html' file in your Booked instance (in the root folder) - it points to

Installing Booked Scheduler
at
https://www.bookedscheduler.com/help/installation/

Which, at the very top of the page, states....

Prerequisites
PHP 7.x (8.x is not yet supported)