Can someone point me in the right direction on what mssql driver to install? I’ve tried sybase and freetds can’t seem to get it to work. Any help would be appreciated.
Im running ubuntu 16.04.1 LTS
PHP 7
Brand new install of SuiteCRM7.7.4
Thank you
mssql (MicroSoft SQL) works only on Windows machine.
On linux enviroments you can use MySQL or MariaDB.
SuiteCRM only works with MS SQL, MariaDB and MySQL only.
EDIT: Please describe to us your systems.
Thanks
So suitecrm 7.4 php 7 will only work with ms sql if its on windows? Will suitecrm and mssql work with php 5.6.25 on ubuntu 16?
The compatibility matrix shows any version of linux and sql should work.
You are confused.
First of all SuiteCrm package contains only the SuiteCrm files. No Apache,no php compiler, no SQL server.
Second, in order to be able to use SuiteCrm you must have a web server(Apache,IIS), php compiler installed with webserver and a database server(mysql,mssql,mariadb).
Third, to run the above you need an operating system(OS) (Linux, Windows).
Now Apache run on Linux and Windows, IIS only on Windows.
Php compiler runs on both os.
Mysql and mariadb run on both OS, MS sql only on Windows.
Scenario:
If you have only one computer and you want to run everything in that computer you have to choose an OS first and next install the application that are able run in it. In you case the OS is ubuntu, so you selected Apache for web server. You can not select mssql for your database server because mssql can NOT install/run/execute under Linux.You must select between mysql and mariadb.
If you desperately want to use mssql, you must use a second computer with windows to install mssql. If you don’t have a second computer and you still desperataly want to use mssql then switch your computer OS to windows!
If you can live without mssql, install mysql or mariadb in you ubuntu.
Edit: I didn’t write anything for MAC OS cause I do 't have any experience.
UPDATE: Microsoft SQL server is available for Ubuntu linux
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu
Should work with SuiteCRM.
Just to clarify that the version of MS SQL that runs in Linux systems is the SQL Server 2017 CTP 2.1 (Community Technology Preview)
SuiteCRM might not be compatible with this version.
Did you or anyone else test it?
I’m able to use sql on microsoft server on ubuntu with php 7. Use this driver here
git hub php 7 sql
It takes a little tweaking depending on your setup but its not to hard to setup
my setup
- microsoft server 2012 R2 standard
- sql server 2014
- ubuntu 12.04.5 LTS
- php 7
@mdinat3 can you explain your set up a little better? I don’t understand it.
Are these two different computers, one is Windows and runs SQL Server, the other is Ubuntu and runs PHP and SuiteCRM? Is that it?
Because I thought this thread was about running everything from the same computer (Ubuntu, with SQL Server in it, with PHP and SuiteCRM):
https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-ubuntu
Anyway, I think this is really cool, Microsoft is changing a lot…
Yes this is 2 different computers, I started this thread with that in mind. I currently do this with sugarcrm 6.5 and mssql on a windows computer php 5.3. But since we want to upgrade everything to 7 i needed a way to use Suitecrm latest with php 7 and mssql on another computer and the setup i gave are 2 different computers, the code Suitecrm runs on linux ubuntu and the DB runs on MS sql 2014 server. hope that clarify
1 Like