Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello,
I have installed ProjeQtOr in the www folder of a php/appache docker container connected to a MariaDB (MySQL) database (also in a container).
Server version: 10.1.47-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
PHP 8.0.2 (cli) (built: Feb 9 2021 12:01:24) ( NTS )
Immediately after the initial setup screen, I'm hitting a large red box with the message ERROR : PDO object is uninitialized.
i'm a little at a loss since PDO is loaded.
I forgot to include the database status. Php seems to be able to communicate with MariaDb because it creates the database but there is no table in the database:
Welcome to the MariaDB monitor. Commands end with ; or g.
Your MariaDB connection id is 87
Server version: 10.1.47-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| projeqtor |
+--------------------+
4 rows in set (0.00 sec)
MariaDB [(none)]> use projeqtor
Database changed
MariaDB [projeqtor]> show tables;
Empty set (0.00 sec)
Projeqtor did not create any log file in the log path.
Php is not returning any error in the PHP_errors.log
First, note that ProjeQtOr V9.0 is not compatible with PHP 8.0 (V9.1 will be)
Then, you parameters.php contains unexpected escape charactes. I hope it is a side effect of transfer.
Are you sure about IP of MySql server ? It is a remote one (not on same server as PHP) ?
Possibly it is connection through PHP (using PHP user) that fails.
Hello,
the database is on the same computer but not in the same container (docker). Php is able to communicate with the database since it created the database in the DB server but nit the tables.
I'll try to install another version of PHP and maybe install the database in the same container.
I have included the config file without the garbage in it.
Thanks for your help
As DB is not local, you must grant root@IP_of_PHP_Server to projeqtor database.
By default only root@localhost is granted to all DBs.
Have local DB will fix the issue.
Hello, I verified this:
+------+---------------+
| User | Host |
+------+---------------+
| root | % |
| root | 172.21.0.% |
| root | 192.168.100.% |
+------+---------------+
3 rows in set (0.01 sec)
Still have the same issue
These are users able to connect to mysql as root, but are you sure this user is granted to the specific projeqtor database ?
I downgraded to PHP 7.4 and everything worked fine. I guess PHP 8 was the problem.