Login credentials incorrect after fresh install on Siteground Hosting

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

Hello All !

I am stuck in the loginscreen after installing a fresh install of SuitCRM 8.2.3.

Here is what i have done so far:

  • Checked the compatibility list. All pans out.
  • Checked the supported extensions. All are supported and running.
  • Configure URL rewrites: as it is hosting i cannot do that but i am assuming this already done.
  • Configure php error reporting: as it is hosting i cannot do that but i am assuming this already done.
  • Enable op cache. as it is hosting i cannot do that but i have other caching options to speed up.
  • Downloaded the latest zip, unpack and uploaded it to my domain root.
  • Setting permissions. As far as i can see all folders are 755 and files are 644. I have no control over groupname
  • Created the database and database user within Siteground hosting environment.

According to the manual it says go to the root and the installer will run automatically. It doesn’t.
I had to find the installer which was under [domain]/public/legacy

Ran the installer and filled in the url of suitecrm instance: [domain]
Database info filled in: localhost, name database, name user and password. Port not filled in. (possible problem there?)
Admin info: user and password created.
Finished installer, no errors.

Checked config.php for correct site url: [domain]/public
Checked .htaccess for rewritebase. Here is something weird, according to documentation it should be [domain]/public/public

I try to login with the admin credentials and it fails. In (web)console it mentiones hard 500 error.
Suitecrm.log mentions nothing about the login.

Prod log gives the following error:
[2023-02-10 10:07:26] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ConnectionException: “An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO)” at /home/customer/www/[domain]/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 112 {“exception”:“[object] (Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO) at /home/customer/www/[domain]/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112, Doctrine\DBAL\Driver\PDO\Exception(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO) at /home/customer/www/[domain]/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ‘root’@‘localhost’ (using password: NO) at /home/customer/www/[domain]/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)”} []

I looks like to credentials are passed but i checked config.php and all the right credentials are there?
Could something be going wrong with the connection with the database?

Thanks in advance for your help or insight on where i could check more.

#2

Tried about everything, from new install to contacting Siteground. All extension are ok. No limits on Sitground side. It just doesn’t work for me.

Moving on to Espo. They have done the install process right with all kinds of checks. Maybe you guys need to check how they do it.

PS: forum also doesn’t work well anymore. Get all kinds of errors while fetching pages.

#3

I’m on Siteground and your summary is pretty much my experience as well.

I tried to upgrade from 7 to 8 but it destroyed my 7 instance, luckily I did a backup. So I deleted 7 and decided just to start from scratch with 8 but no luck at all.

I’ve actually been at it for months trying to figure it out but getting nowhere.

Luckily I am only a freelancer and don’t really need SuiteCRM so I have just created my own database with Tap Forms 5.

#4

Hi Steven,

Sorry to hear you have the same experiences. Too bad they haven’t focused much on the install process. I can imagine more people will be put off if the install is so complicated. I’ts a shame because it looked like a very promesing product to me.

I am now running ExpoCRM. Runs like a charm! Very flexible too.

PS: impressive career!

#5

Hi Marco,

I am sad about SuiteCRM but nothing lasts forever I guess.

Thanks for the espoCRM recommendation, I will definitely check it out. Much appreciated!

Take care,
Steve