Problem installing Fusio on my synology

[Nicolas Bouillon]

Hi guys,

I installed Fusio on my macbook running MAMP PRO succesfully, big thanks to Christoph for his precious help.

I therefore decided to install it on my PROD environement, running Synology DSM 7 and MariaDB

I followed the exact same steps:

- composer install

- fusio configuration and installation

- fusion user creation,

- fusion app installation

with minor issues,

Now, I face an unknown issue, I see the FUSIO app in the list and try to connect to the Backend and it doesn't work, no error message, nothing.

I checked the log and I have the following (hereunder), can someone please tell me what's wrong?

Thx a bunch guys, I'm almost there....

Cheers

Nico

An exception occurred in driver: could not find driver in /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 128

Stack trace:
[21-Jun-2022 14:30:16 UTC] #0 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))
[21-Jun-2022 14:30:16 UTC] #1 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An exception oc...')
[21-Jun-2022 14:30:16 UTC] #2 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php(31): Doctrine\DBAL\DBALException::driverException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception))
[21-Jun-2022 14:30:16 UTC] #3 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(412): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'root', 'Explore11*', Array)
[21-Jun-2022 14:30:16 UTC] #4 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1952): Doctrine\DBAL\Connection->connect()
[21-Jun-2022 14:30:16 UTC] #5 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1290): Doctrine\DBAL\Connection->getWrappedConnection()
[21-Jun-2022 14:30:16 UTC] #6 /volume1/web/fusio/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(665): Doctrine\DBAL\Connection->executeQuery('SELECT id FROM ...', Array, Array)
[21-Jun-2022 14:30:16 UTC] #7 /volume1/web/fusio/vendor/fusio/impl/src/Table/Category.php(61): Doctrine\DBAL\Connection->fetchColumn('SELECT id FROM ...', Array)
[21-Jun-2022 14:30:16 UTC] #8 /volume1/web/fusio/vendor/fusio/impl/src/Framework/Loader/LocationFinder/DatabaseFinder.php(79): Fusio\Impl\Table\Category->getCategoryIdForPath('/')
[21-Jun-2022 14:30:16 UTC] #9 /volume1/web/fusio/vendor/psx/framework/src/Loader/Loader.php(95): Fusio\Impl\Framework\Loader\LocationFinder\DatabaseFinder->resolve(Object(PSX\Http\Request), Object(Fusio\Impl\Framework\Loader\Context))
[21-Jun-2022 14:30:16 UTC] #10 /volume1/web/fusio/vendor/psx/framework/src/Dispatch/Dispatch.php(126): PSX\Framework\Loader\Loader->load(Object(PSX\Http\Request), Object(PSX\Http\Response), Object(Fusio\Impl\Framework\Loader\Context))
[21-Jun-2022 14:30:16 UTC] #11 /volume1/web/fusio/vendor/psx/engine/src/WebServer/Engine.php(58): PSX\Framework\Dispatch\Dispatch->route(Object(PSX\Http\Request), Object(PSX\Http\Response))
[21-Jun-2022 14:30:16 UTC] #12 /volume1/web/fusio/vendor/psx/framework/src/Environment/Environment.php(70): PSX\Engine\WebServer\Engine->serve(Object(PSX\Framework\Dispatch\Dispatch))
[21-Jun-2022 14:30:16 UTC] #13 /volume1/web/fusio/public/index.php(28): PSX\Framework\Environment\Environment->serve()
[21-Jun-2022 14:30:16 UTC] #14 {main}

[Christoph Kappestein]

Hi Nico,

Iam not familiar with Synology but it looks like the PHP installation has no mysql extension installed and therefor Fusio is not able to create a connection to the mysql database.

Could you check whether the mysql extensions is available?

best regards

Christoph

[Nicolas Bouillon]

Hi Christophe,

All extensions are installed, it's my PROD system on which my whole application works. That's what's weird;

Besides, Fusio was able to create its database on that same server running mysql without issue

Is there a file or place in the db that holds connection parameters so that I can check them?

Regards

Nico

[Christoph Kappestein]

Hi Nico,

ok this sound indeed weird, could you check with "php -m" whether pdo_mysql is installed. You can also take a look at the configuration.php file

there is a "psx_connection" configuration key s.

https://github.com/apioo/fusio/blob/master/configuration.php#L89

You can also check whether those connection credentials are correct. We pass these credentials directly to the doctrine DBAL library s.

https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#configuration

best regards

Christoph

[Nicolas Bouillon]

Hi Christophe

Alright, I activated pdo_mysql, now I have another error but I figured out what's wrong...but I can't fix it.

When I log in, I get a CORS error on the token request.

The request goes to http://localhost/fusio/public/index.php/authorization/token (Request-URL as shown in Chrome console)
The issue is that on my Macbook, the web server runs on localhost, so does fusio and was set up in the env file.

On the server, I use 2 types of URLs, when I'm on my LAN, I use the 192.168.0.* address and when external I use the external DYNDNS name.

In the env file, before the install, I mentionned localhost as the url of the server and database, that's the issue I think.

I checked my env file and modified the following:

FUSIO_URL="http://xxxxx.dyndns.xxxxxx/fusio/public"

FUSIO_DB_USER="######" - I anonimized it here
FUSIO_DB_PW="######" - anonimized it here
FUSIO_DB_HOST="xxxxx.dyndns.xxxxxx"

And I try to log in via the following URL: http://xxxxx.dyndns.xxxxxx/fusio/public/apps/fusio/#!/login

Still, I get the CORS error above.

Honestly, I don't get it.

Thanks again for your help

Nico

[Christoph Kappestein]

Hi Nico,

ok, so if you receive a CORS error it is mostly a problem that the CORS preflight request fails and Fusio returns a 500 error, then the browser will fail and not make a request. Most likely the 500 error is another problem with the Fusio installation. Could you check whether in your PHP error logs are maybe some errors available

best regards
Christoph