SuiteCRM 8.0.1 installation problems

Hi @simondawson,

Could you check the chrome devtools network tab, please? what does it show?

Another thing, do you have some kind of reverse proxy on top of apache?

Hi @Prafull_Satasiya,

Thank you.

There is a step to check if the system is able access the db. It is not being able to.

[2022-01-06 11:46:45] install.INFO: step: check-db-connection | messages: [] []
[2022-01-06 11:46:45] install.INFO: Could not connect to db [] []

Are you setting the db port?

Hi @clemente.raposo

No reverse proxy installed or used.

The network tab shows a list of the redirects it is attempting:

mydomain 301 document/Redirect Other
index.php?action=Login&module=Users 302 document/Redirect (index)
mydomain 301 document/Redirect 301 document/Redirect index.php?action=Login&module=Users

Lines 2 and 3 then repeat 10 times before it gives up.

Yes, I am setting it as 3306. I have checked it in mysql.

On a side note, I am using root user. Could it be the issue?

Hi @Prafull_Satasiya,

Thank you. Using the root user should not be an issue.
Try not setting the port, please.

Hi @simondawson,

The redirects happen when try to access the a graphql call or mayb just the /?

Anyway, that gives some hints on were the problem may be. Suite 7 is giving some kind of error and re-directing

Could you check permissions, please? Namely on public/legacy/cache and cache?
Is your user and group www-data?

No difference. Same error.

Hi @Prafull_Satasiya,

Ok, thank you. Are you using localhost? or the ip?
Maybe try connecting using ip

I have tried both. localhost and 127.0.0.1

Hi @clemente.raposo

./SuiteCRM/cache has:

drwxr-sr-x permissions.

./SuiteCRM/legacy/public/cache has:

drwxr-sr-x as well.

Iā€™m using FCGI so the user and group is the user of the account used. So it isnā€™t www-data but another user. I have made sure that the new user is used when following the instructions for setting the user permissions in the installation instructions.

Hi @simondawson,

Thank you. So, its not the permissionsā€¦

Could you try removing the following line from your vhost config?
DirectoryIndex index.html index.htm index.php

the /public folder has a index.html and an index.php. Its just a guess, though apache may be picking up index.html instead of index.php

Hi @Prafull_Satasiya,

Could you try connecting to it using another mysql client from the same server?

There is some problem with the db connection. Need to try and understand what it could be.

No, no difference.
:frowning:

Hi @simondawson,

Hmā€¦ starting to run out of ideas.

Could you send me a screenshot of the network tab after the call to the the main route, please? To understand the requests being made.
Please hide any server address or any sensitive info.

Hi @simondawson,

EDIT: please look into the following post before going into this one.

Thank you. Not sure what is going on.

Iā€™m starting to think it may be related with php-fpm / fastcgi. Could you have a look at the following please?

Maybe best to check other things also. Could you check the following please?

  1. Were the public/legacy/config.php and public/legacy/config_override.php files generated?
  2. On /public/legacy/.htaccess how does the RewriteBase, it should be something like RewriteBase /legacy

Hi @simondawson,

I think this time I may have found what is missing.

Could you look into the following guide from symfony.

There are sone extra things we need to add to the vhost config for PHP FPM fastcgi

Fingers crossed : )

Hi @clemente.raposo

The config.php and config_override.php were both created and the RewriteBase is set to /legacy/

I will have a look at the various FCGI configuration guides now and get back to you.

Thank you for the time you have committed to help me solve thisā€¦it is much appreciated. Hopefully we are nearly there.
:slight_smile:

I have tried that and also followed your conversation on this thread. Install database connection issue with SuiteCRM 8 - #21 by Jurij0123

I have also tried the silent install. It stuck at Running: check-db-connection

Hi @clemente.raposo

No luck Iā€™m afraid. This has outwitted me Iā€™m afraid. I have given up on this server and I am trying the install on a new VPS to see how far I can get this time.

THank you for your helpā€¦much appreciated.
Simon