upgrading mysql 5.7 to 8

Community Support for Booked Scheduler
Post Reply
rhowe72
Posts: 2
Joined: Thu Sep 24, 2020 7:04 pm

upgrading mysql 5.7 to 8

Post 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

l.l.gibbons
Posts: 2
Joined: Thu Sep 24, 2020 10:20 am

Re: upgrading mysql 5.7 to 8

Post 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.

l.l.gibbons
Posts: 2
Joined: Thu Sep 24, 2020 10:20 am

Re: upgrading mysql 5.7 to 8

Post 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.

gbottaro
Posts: 7
Joined: Thu Oct 01, 2020 12:53 am

Re: upgrading mysql 5.7 to 8

Post by gbottaro »

Hi, try appending --default-authentication-plugin=mysql_native_password in the start command.

User avatar
TechCoder
Posts: 97
Joined: Mon Aug 10, 2020 12:54 pm
Contact:

Re: upgrading mysql 5.7 to 8

Post 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)
Apps-n-Add-Ons.com is independently owned and operated and provides clients worldwide with Plugins for Booked Scheduler to solve common needs.
Custom software solutions, paid help, Booked Hosting and more..... Apps-n-Add-Ons.com

Post Reply