Could not connect to the database. Please refer to suitecrm.log for details (2).

šŸ“¦ Install & Upgrade Help
1

Hello I am having issue with installation I have ran into issue with the user being created.I am using Ubuntu 19.10 and Suite 7.11.8. Below are the commands that I am using for the installation and configurations. Also I have attached an image of the error and the message in the suitecrm.log.Any help would be appreciated greatly.

sudo su
apt-get update
apt-get upgrade
apt-get install apache2
apt-get install mysql-server
apt-get install php libapache2-mod-php
apt-get install curl libcurl4 libcurl3-dev php7.3-curl php-gd php-zip php-intl php-simplexml php-dom php-mysql php-imap
apt-get install composer
cd /var/www/html
rm index.html
wget https://github.com/salesagility/SuiteCRM/archive/v7.11.8.zip
unzip v7.11.8.zip
rm v7.11.8.zip
mv SuiteCRM-7.11.8/* /var/www/html
rm -r SuiteCRM-7.11.8
composer update --dev
composer install --no-dev
mkdir cache
chown -R www-data:www-data .
chmod -R 755 .
chmod -R 775 cache custom modules themes data upload
chmod 775 config_override.php 2>/dev/null
nano /etc/php/7.3/apache2/php.ini
/sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
nano /etc/mysql/mysql.conf.d/mysqld.cnf

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address = 0.0.0.0

mysql -u root

USE mysql;
SELECT User, Host, plugin FROM mysql.user;
UPDATE user SET plugin=ā€˜mysql_native_passwordā€™ WHERE User=ā€˜rootā€™;
FLUSH PRIVILEGES;
SELECT User, Host, plugin FROM mysql.user;
exit;

systemctl restart apache2
systemctl restart mysql

Wed Oct 30 04:42:40 2019 [16494][-none-][FATAL] Query Failed: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, INDEX
ON SUITECRM.*
TO ā€œsuiteadminā€@ā€œvm-suitecrm-mysql-01ā€
IDENTIFIED BY ā€˜MyPasswordā€™;: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ne>
Wed Oct 30 04:42:40 2019 [16494][-none-][FATAL] Could not connect to DB server localhost as suiteadmin. port : Access denied for user ā€˜suiteadminā€™@ā€˜localhostā€™ (using password: YES)

2

I donā€™t advise ā€œcomposer updateā€. You should only do ā€œcomposer install --no-devā€. This is because the update in composer is actually an ā€œupgrade to latestā€ command. It will take you past the versions that SuiteCRM is tested to work with.

Can you get the full MYSQL error from the log? Itā€™s truncated just before the part that would let us understand what happenedā€¦

Also, please check that you are within the versions listed in the Compatibility Matrix

https://docs.suitecrm.com/admin/compatibility-matrix/

3

Thanks for sending your response. I went back over the compatible matrix and the versions of each components. I found the issue was MySQL was version 8. I reinstalled using MariaDB 10.2 and I was able to install successfully. Thanks again for your help. I had been searching and reading for the last week with no success until your post.

4

Iā€™m glad you got it working! B-)

Can I ask you to please add a comment to this Github Issue, documenting the version you used before, and that error you got? Weā€™ll need to work on this MySQl 8.0 pretty soon.

https://github.com/salesagility/SuiteCRM/issues/7092

Thanks