I am installing SuiteCRM on my Synology NAS and I keep getting this error message:
“Database Support was not found. Please make sure you have the necessary drivers for one of the following supported Database Types: MySQL or MS SQLServer. You might need to uncomment the extension in the php.ini file, or recompile with the right binary file, depending on your version of PHP. Please refer to your PHP Manual for more information on how to enable Database Support”
I succesfully run Joomla, using PHP7 on this machine so I do not get why this is apparently a problem for my SuiteCRM installation.
That was meant to help you with the database problem, not just to check PHP version.
From the output of phpinfo, you can check two things:
The path to your php.ini, where you can change settings
The modules that are loaded, where you can confirm your settings become effective.
There are some modules for database access, I believe it should be mysqli but there might be different names on different systems.
Then to get the connection right you will probably want to use just “localhost” as the host, and then your username and password. Don’t add a port number, and don’t use 127.0.0.1 (I am assuming the database is on the same server, and in the standard port - tell me if not).
The MySQLi database is indeed on the same system and I see the path to the php.ini file. Running the php info shows that MySQLi is active (see below). I do not know exactly what to look for in the php.ini file.
MysqlI Support enabled
Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b84 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile On On
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket /run/mysqld/mysqld.sock /run/mysqld/mysqld.sock
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off
When I type in the command it says “command not found”. I think it has to do with not sufficient rights (though I a logged in via SSH as admin), or there is a PATH issue and cannot find the mysql command…
I searched for the mysql command (using “find”) and found it at the following location: “/usr/local/mariadb10/bin/mysql”.
I ran the command you gave me earlier with the full path and was able to log in as root!
Therefore I assume I need to add /usr/local/mariadb10/bin/ to my $PATH? Is that correct, or is it better to do something else?
Other than that, I am a bit confused by your feedback, I’ve asked several questions that have gone unanswered - I would prefer to know clearly the exact text of your error, and the exact values you’re trying.
I added a screenshot of where I get stuck. The credentials can be found in that screenshot 9of course not the passwords). The software resides in the directory /web/kantoor on my Synology DiskStation
Below is also the part from the log file:
2018-09-20 05:56:00…Begin DB Check Process *************
2018-09-20 05:56:00…testing with mysql:mysqli
2018-09-20 05:56:00…Basic form info is valid, continuing Process.
2018-09-20 05:56:00…Testing user account…
2018-09-20 05:56:00…ERROR:: The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password
2018-09-20 05:56:00…FATAL:: errors have been detected! User will not be allowed to continue. Errors are as follow:
2018-09-20 05:56:00… The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username and password
2018-09-20 05:56:00…End DB Check Process *************
I am about to give up on this one… seems something funky in the Synology set-up, but cannot figure it out… installing packages via the Synology interface goes fine, but when I do not have a package and do a manual install it gets stuck. There is SugarCRM package and I could then take it from there ad migrate it to SuiteCRM (used to work some years ago). I also logged a ticket with Synology, though no response yet.
But to answer your questions:
Using 127.0.0.1 as host also does not resolve the issue
No response wehn telnetting to port 3306 (mysqli listening port). Also netstat -nld|grep 3306 shows there is no listening port 3306 active. But I am not sure if this is needed as SueCRM is installed on the same machine as the MariaDB and mysql.
Any last suggestions? Else we call it a day and maybe I will recommence my quest to get this fixed; I do know now it is a Synology issue, not SuiteCRM issue.