connection problem when migrating database from MariaDB(5.x) to MariaDB10

[mark-sugus]

Baikal version: 0.2.6

• I have searched open and closed issues for duplicates
• I have installed the release zip, not the source code zip
• I have moved the whole, untouched Specific folder to the new installation

Problem:
On my Synology NAS I have migrated my Baikal database from MariaDB5 to MariaDB10. I can connecting with myphpAdmin to the MariaDB10 database and see all the tables belonging to Baikal. However if want to access the Baikal admin page a get the message:

exception 'Exception' with message 'Fatal error: no connection to a database is available.' in /volume1/web/baikal.app/Core/Frameworks/Baikal/Core/Tools.php:66
Stack trace:
#0 /volume1/web/baikal.app/Core/Frameworks/Baikal/Framework.php(79): Baikal\Core\Tools::assertBaikalIsOk()
#1 /volume1/web/baikal.app/Core/Frameworks/BaikalAdmin/Framework.php(34): Baikal\Framework::bootstrap()
#2 /volume1/web/baikal.app/admin/index.php(54): BaikalAdmin\Framework::bootstrap()
#3 {main}

I already changed the default Synology port number (3307) for MariaDB10 to the default MariaDB port number 3305 and my process information is showing this:

root     14184  0.0  0.0  11992  2944 ?        S    18:34   0:00 /bin/sh /usr/local/mariadb10/bin/mysqld_safe --datadir=/var/packages/MariaDB10/target/mysql --pid-file=/run/mysqld/mysqld10.pid
mysql    14486  0.0  0.5 1470748 54820 ?       Sl   18:34   0:00 /usr/local/mariadb10/bin/mysqld --basedir=/usr/local/mariadb10 --datadir=/var/packages/MariaDB10/target/mysql --plugin-dir=/usr/local/mariadb10/lib/mysql/plugin --user=mysql --log-error=/var/packages/MariaDB10/target/mysql/sugus.err --pid-file=/run/mysqld/mysqld10.pid --socket=/run/mysqld/mysqld10.sock --port=3306
root     21133  0.0  0.0  23148  2336 pts/19   S+   18:48   0:00 grep --color=auto mysql

I don't know how to resolve the issue. Any idea is very appreciated.

The main reason to migrate to MariaDB10 is that I would like to upgrade to the newer Baikal 0.6.x version. But before that my actual version should run with MariaDB10.
Thanks to all who are doing a great job in continuosly developing Baikal.

Mark

[ByteHamster]

In that (ancient) version of Baikal, the check for the database connection is commented out for whatever reason. Maybe you can add something like echo $e->getMessage(); there to learn more details about why it fails.

Baikal/Core/Frameworks/Flake/Framework.php

Lines 279 to 291 in d223f2f

	try {
	$GLOBALS["DB"] = new \Flake\Core\Database\Mysql(
	PROJECT_DB_MYSQL_HOST,
	PROJECT_DB_MYSQL_DBNAME,
	PROJECT_DB_MYSQL_USERNAME,
	PROJECT_DB_MYSQL_PASSWORD
	);
	# We now setup the connexion to use UTF8
	$GLOBALS["DB"]->query("SET NAMES UTF8");
	} catch(\Exception $e) {
	#die("<h3>Baïkal was not able to establish a connexion to the configured MySQL database (as configured in Specific/config.system.php).</h3>");
	}

[mark-sugus]

Thank you for the quick reply. With your answer I decided to first upgrade my baikal version before trying to fix the db connection issue. In my previous trials more than a year ago I didn’t succeed to upgrade to 0.4.6 But today I managed to upgrade to 0.5.3 successfully with mariaDB5 as DB server. I transferred the db to mariaDB10. For correct connection to mariaDB10 I had to change the PROJECT_DB_MYSQL_HOST in config.system.php from localhost to 127.0.0.1. From a short check and use with different clients it seems that everything is working like a charm now. Thank again. Cheers Mark

…

Am 02.05.2020 um 23:39 schrieb H. Lehmann ***@***.***>: In that (ancient) version of Baikal, the check for the database connection is commented out for whatever reason. Maybe you can add something like echo $e->getMessage(); there to learn more details about why it fails. https://github.com/sabre-io/Baikal/blob/d223f2fa309e81df54d69c48bfb1962a0deb970a/Core/Frameworks/Flake/Framework.php#L279-L291 <https://github.com/sabre-io/Baikal/blob/d223f2fa309e81df54d69c48bfb1962a0deb970a/Core/Frameworks/Flake/Framework.php#L279-L291> — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#917 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APNIZVTHNBDCSJYJEF6T4HDRPSHHVANCNFSM4MXHCPZA>.