How to fix a connection by web control panel Froxlor to MySQL?-CodePudding

I installed Apache2 and MySQL client/server and PHP8.1.2 manually. Ubuntu 22.04 successfully connected to the database from the terminal, changed the root password, exit.

Next, I tried to install the web control panel.

I first downloaded Froxlor from git https://github.com/Froxlor/Froxlor to the /var/www/froxlor master branch folder. Then I installed all the dependencies from the list, but this was not enough. The PHP application code gave out unsatisfied dependencies.

Here https://deb.froxlor.org/debian/pool/main/f/froxlor / found the DEB package and installed it in the same folder through the terminal, satisfying all the dependencies with this - the code worked.

Then I started the installation. through the browser. By going to /index.php I am offered no options to go to ./install/, where I fill in all the relevant fields (maybe not correctly?) in the second window of the page and after clicking "submit" I get an error:

Checking MySQL-root access... SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' There seems to be a problem with the database-connection. Cannot continue. Please go back and check your credentials.

such an error crashes in the terminal if you connect to the database without "sudo", here I was confused. I have researched /install/lib/class.FroxlorInstall.php on the subject of at least some zatseki what should I do and still tried to add "sudo" in the file /tests/bootstrap.php in line 50 exec("sudo mysql -u root -p" . $rpwd . " froxlor010 " . dirname(DIR) . "/install/froxlor.sql");

but it didn't lead to anything. Maybe there is some similar experience, please tell me. Thx

P.S. I also tried to install via froxlor.phar, but my installation hung up at the moment of connecting to the database, perhaps the script was waiting for the password to be entered, but this was not reflected.

CodePudding user response：

Oh, I solve it by my self.

It need to create file ../froxlor/lib/userdata.inc.php by this example:

<?php //automatically generated userdata.inc.php for Froxlor
$sql['host']='127.0.0.1'; $sql['user']='froxlor';
$sql['password']='PASS'; $sql['db']='froxlor';
$sql_root[0]['caption']='Default'; $sql_root[0]['host']='127.0.0.1';
$sql_root[0]['user']='root'; $sql_root[0]['password']='PASS'; ?>

CodePudding user response：

also you need to create "froxlor010" user and "froxlor010" database in MySQL then run in terminal:

sudo php /var/www/froxlor/tests/bootstrap.php

sudo php /var/www/froxlor/install/scripts/config-services.php --froxlor-dir=/var/www/froxlor/ --create