Can't get class list to to load

[mgavazzi]

After a fresh install of Fusio, when I try to create a connection through the Dashboard->Connection-> "+" (Add), the Class drop down list is Empty. I was expecting it to be populated with all the adapters that are available for connectivity "out of the box". I am particularly interested in connecting to MySQL. Under vendor\psx I see a list of adapters, including SQL. Nonetheless, I run:

composer require fusio/adapter-sql php bin/fusio system:register "Fusio\Adapter\Sql\Adapter"

And while both commands seem to finish successfully, the CLASS list is still empty while trying to create a new Connection thru the dashboard. Any thoughts/guidance is welcome.

MG.

**************Environment ******** Fusio 1.4.0 Ubuntu 10.04 Php 7.2.13 Apache2 2.4.29

composer require fusio/adapter-sql Generating autoload files ocramius/package-versions: Generating version class... ocramius/package-versions: ...done generating version class

php bin/fusio system:register "Fusio\Adapter\Sql\Adapter" /var/www/appsvr/api$ sudo php bin/fusio system:register "Fusio\Adapter\Sql\Adapter" Loaded definition /var/www/appsvr/api/vendor/fusio/adapter-sql/src/../definition.json

The adapter will install the following entries into the system. +------------------+------------------------------------------+ | Type | Description | +------------------+------------------------------------------+ | Action Class | Fusio\Adapter\Sql\Action\SqlTable | | Connection Class | Fusio\Adapter\Sql\Connection\Sql | | Connection Class | Fusio\Adapter\Sql\Connection\SqlAdvanced | +------------------+------------------------------------------+ Do you want to continue (y/n)? y Registration successful!

[chriskapp]

Hi, the SQL adapter is already registered by default so you dont need to install the adapter manually. The class list is taken from the provider.php file, could you take a look which classes are available there i.e.: https://github.com/apioo/fusio/blob/master/provider.php

[mgavazzi]

Thanks for replying - My provider.php that sits at the root level of my installation directory contains (what seems to the the expected and normal) - but when I try to create a connection, still, I see no options available on the drop down list.

return [ 'action' => [ \Fusio\Adapter\File\Action\FileProcessor::class, \Fusio\Adapter\Http\Action\HttpProcessor::class, \Fusio\Adapter\Php\Action\PhpProcessor::class, \Fusio\Adapter\Php\Action\PhpSandbox::class, \Fusio\Adapter\Sql\Action\SqlTable::class, \Fusio\Adapter\Util\Action\UtilStaticResponse::class, \Fusio\Adapter\V8\Action\V8Processor::class, ], 'connection' => [ \Fusio\Adapter\Http\Connection\Http::class, \Fusio\Adapter\Sql\Connection\Sql::class, \Fusio\Adapter\Sql\Connection\SqlAdvanced::class ], 'payment' => [ ], 'user' => [ \Fusio\Impl\Provider\User\Facebook::class, \Fusio\Impl\Provider\User\Github::class, \Fusio\Impl\Provider\User\Google::class, ], ];

[chriskapp]

mhh ok, this looks good. To further debug this problem we need some more information about the problem. Could you take a look at the AJAX response of the request, which requests the list of connections (through the browser network inspection). Maybe there is a useful error response. Also you could increase the error output by setting the psx_debug setting in the configuration.php file to true. And you may also take a look at the error logs of your web server.