vendredi 27 septembre 2019

Attempting to Install FireflyIII - PDO Exceptions

I am following a guide for installing FireflyIII as a personal finance project.

pi@raspberrypi:/var/www/html/finance $ php7.2 artisan migrate:refresh --seed

In Connection.php line 664:

  could not find driver (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type  
   = 'BASE TABLE')                                                                                                                            


In PDOConnection.php line 31:

  could not find driver  


In PDOConnection.php line 27:

  could not find driver                        

Of course I look in the php.ini file and see:

...
extension=mysqli
...
extension=pdo_mysql
...

I check these packages:

pi@raspberrypi:/var/www/html/finance $ sudo apt install php7.2-mysql
php7.2-mysql is already the newest version (7.2.9-1+b2).

pi@raspberrypi:/var/www/html/finance $ sudo apt install php7.2-pdo
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Note, selecting 'php7.2-common' instead of 'php7.2-pdo'
php7.2-common is already the newest version (7.2.9-1+b2).

I check the phpinfo() page.

I created the user in MYSQL for firefly and the database:

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'firefly'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.007 sec)
MariaDB [(none)]> CREATE DATABASE firefly;
ERROR 1007 (HY000): Can't create database 'firefly'; database exists

Which is echoed in the .env file:

DB_CONNECTION=pgsql                                                                                                                            
DB_HOST=firefly_iii_db                                                                                                                         
DB_PORT=5432                                                                                                                                   
DB_DATABASE=firefly                                                                                                                            
DB_USERNAME=firefly                                                                                                                            
DB_PASSWORD=password

And I rebooted this thing after reseting the apache2 server about three times.

What else could it be?





Aucun commentaire:

Enregistrer un commentaire