Install.php does not accept credentials for SQL Azure database.

[jpgollnitz]

Steps taken so far: I am attempting to install Fusio on an Azure Web Application. I configured a GIT connection to get the files directly from GitHub to sync directly into the web application.

I set the root folder to /public, and when I get to https://mydomain.com/install.php, I get the install page fields.

However, when I click the button at the bottom to finish the installation, I get an error stating that the script cannot connect to the database.

I made a connection to the database from SQL Server Management Studio to ensure that the database was live and accessible. Confirmed (also made sure firewall was not the issue). There is also no blank on the install.php page for the database port number for the connection.

Also tried setting the driver to 'sqlsrv' in the configuration.php file.

Any help is appreciated.

[chriskapp]

Hi, ok do you have installed the fitting PHP extension? If you use the sqlsrv driver you also need to install also the sqlsrv extension for PHP to be able to connect to a MSSQL server: https://github.com/Microsoft/msphpsql#microsoft-drivers-for-php-for-microsoft-sql-server

Also for further debugging it would be useful to check the error logs of the webserver.

If you can use docker you could also checkout our docker image where everything is already configured: https://github.com/apioo/fusio-docker

[jpgollnitz]

Christoph,

I had it working late last night with docker but then my connection or something timed out and I can no longer log back in. I've tried restarting docker-compose and rebooting the server, but nothing happens.

[image: image.png]

I changed the username and password to matching values in the docker-composer.yml file and again did sudo docker-compose up -d

Please let me know what you think is going on.

Thanks

Jared

On Thu, Jan 10, 2019 at 2:31 PM Christoph Kappestein < [email protected]> wrote:

Hi, ok do you have installed the fitting PHP extension? If you use the sqlsrv driver you also need to install also the sqlsrv extension for PHP to be able to connect to a MSSQL server:

https://github.com/Microsoft/msphpsql#microsoft-drivers-for-php-for-microsoft-sql-server

Also for further debugging it would be useful to check the error logs of the webserver.

If you can use docker you could also checkout our docker image where everything is already configured: https://github.com/apioo/fusio-docker

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/apioo/fusio/issues/209#issuecomment-453223679, or mute the thread https://github.com/notifications/unsubscribe-auth/AP_nCQzLFlt2HDL5s5Ze-kSo52DNOVuIks5vB5T6gaJpZM4Z4Z_U .

[chriskapp]

Mhh the image was not included in your post so I cant exactly see what the problem is.