Looking for help.
Have successfully run Kanboard on Ubuntu machine with mariadb database.
Looking to do the same using MS Sql Server to keep consistent with our company’s other apps.
Have successfully installed (and have working) Sql Server on Ubuntu.
Have also successfully installed and tested (with php script) the sqlsrv and pdo_sqlsrv drivers.
It is not clear what changes are needed to the Kanboard config.php file to get things running.
Best result so far is “Internal Error: could not find driver” response in browser window when trying to get to dashboard.
I know mssql is experimental at this point, but is there anyone who has successfully implemented this share their setup suggestions?
alfredb
2
First off, I don’t use mssql.
Unfortunately, you didn’t tell, what exactly you tried to configure.
I’d start with the following:
define('DB_DRIVER', 'mssql');
You might take a look at the library README.
fred
3
You can set DB_DRIVER to either dblib or odbc depending on your server configuration.
If you choose odbc, you have to define DB_ODBC_DSN.
Other DB_* options like DB_USERNAME should be similar to the MySQL / Postgresql config options.
Microsoft SQL support has been implemented by a contributor in this pull-request: Add support for Microsoft SQL Server database by jnahmias · Pull Request #5082 · kanboard/kanboard · GitHub
1 Like