Problem installing Fusio on my synology

26 views
Skip to first unread message

Nicolas Bouillon

unread,
Jun 21, 2022, 10:32:56 AMJun 21
to Fusio
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

unread,
Jun 21, 2022, 6:00:11 PMJun 21
to Fusio
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

unread,
Jun 22, 2022, 2:05:02 AMJun 22
to Fusio
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

unread,
Jun 22, 2022, 2:13:22 PMJun 22
to Fusio
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.

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

best regards
Christoph

Nicolas Bouillon

unread,
Jun 22, 2022, 4:06:59 PMJun 22
to Fusio
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_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

unread,
Jun 26, 2022, 5:17:41 AMJun 26
to Fusio
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
Reply all
Reply to author
Forward
0 new messages