SuiteCRM-8.6.2 installation | MY SQL DATABASE ISSUE

📦 Install & Upgrade Help
1

hello dears,
i download SuiteCRM-8.6.2, i reach the last part to enter my sql data base that i already created but i could not find where i will enter them in the uploaded open source file.

thank for advance

2

Hi there . can you please elaborate what do you mean by last part? and where you want to enter sql database ?

3

i reach the part where i enter my sql data base that i create and i enter them correctly

image
image1209×405 7.72 KB

4

i do not know where and witch file to put them so i process to the next part on install

5

Hello Ichiko,

usually, you woulnd’t need to manually enter the sql server details in the file.
Check out this video as a reference:

But should you wish to setup another DB / do a server migration or similar, check out the file:

public/legacy/config.php

  array (
    'db_host_name' => 'localhost',
    'db_host_instance' => '',
    'db_user_name' => 'user',
    'db_password' => 'pass',
    'db_name' => 'db',
    'db_type' => 'mysql',
    'db_port' => '3306',
    'db_manager' => 'MysqliManager',
    'collation' => NULL,
    'charset' => NULL,
  ),

as well as the file:

.env.local

where you can configure your DATABASE_URL

6

thank you sir for your time and effort,

concerning the legacy file not exist, and for .env i have this code below

image
image989×564 42.1 KB

CODE .env:

In all environments, the following files are loaded if they exist,

the latter taking precedence over the former:

* .env contains default values for the environment variables needed by the app

* .env.local uncommitted file with local overrides

* .env.$APP_ENV committed environment-specific defaults

* .env.$APP_ENV.local uncommitted environment-specific overrides

Real environment variables win over .env files.

DO NOT DEFINE PRODUCTION SECRETS IN THIS FILE NOR IN ANY OTHER COMMITTED FILES.

Run “composer dump-env prod” to compile .env files for production use (requires symfony/flex >=1.2).

###> symfony/framework-bundle ###
APP_ENV=prod
#TRUSTED_PROXIES=127.0.0.0/8,10.0.0.0/8,172.16.0.0/12,192.168.0.0/16
#TRUSTED_HOSTS=‘^localhost|example.com$’
###< symfony/framework-bundle ###

###> nelmio/cors-bundle ###
CORS_ALLOW_ORIGIN=^https?://(localhost|127.0.0.1)(:[0-9]+)?$
###< nelmio/cors-bundle ###

###> AUTH_TYPE ###
AUTH_TYPE=native
###< AUTH_TYPE ###

###> LDAP CONFIG ###
LDAP_HOST=‘’
LDAP_PORT=389
LDAP_ENCRYPTION=tls
LDAP_PROTOCOL_VERSION=3
LDAP_REFERRALS=false
LDAP_DN_STRING=‘’
LDAP_QUERY_STRING=‘’
LDAP_SEARCH_DN=‘’
LDAP_SEARCH_PASSWORD=‘’
###< LDAP CONFIG ###

###> LDAP AUTO CREATE CONFIG ###
LDAP_AUTO_CREATE=disabled
LDAP_PROVIDER_BASE_DN=‘’
LDAP_PROVIDER_SEARCH_DN=‘’
LDAP_PROVIDER_SEARCH_PASSWORD=‘’
LDAP_PROVIDER_DEFAULT_ROLES=ROLE_USER
LDAP_PROVIDER_UID_KEY=‘’
LDAP_PROVIDER_FILTER=‘’
###< LDAP AUTO CREATE CONFIG ##

###> SAML CONFIG ###
SAML_AUTO_CREATE=disabled
SAML_USERNAME_ATTRIBUTE=uid
SAML_USE_ATTRIBUTE_FRIENDLY_NAME=true
###< SAML CONFIG ###

###> symfony/lock ###
LOCK_DSN=flock
###< symfony/lock ###

###> login throttling ###
LOGIN_THROTTLING_MAX_ATTEMPTS=5
###< login throttling ###

###> login throttling ###
LOGIN_THROTTLING_IP_LOGIN_MAX_ATTEMPTS=50
LOGIN_THROTTLING_INTERVAL=“30 minutes”
###< login throttling ###

7

Please recheck the files, folders and names carefully:

and:

8

in legacy file there NO config.php, but i find this

image
image1160×646 49.2 KB

9

i think the change would be here but to be hosnest i did not witch file i update

image
image767×762 34.4 KB

10

In that case, you have not completed the installation.
Your config.php is being created from / during the installation with your variables (like the MySQL credentials) set during the installation.

Are you trying a standard installation?
Or a CLI installation?

I’m wondering why you want to write the MySQL connection details manually into the file(s) - since this is only needed in special situations (like a server migration or similar).

11

in my case :
1 i download the files from the official site
2 i have access to my file manager in my hosting plan, i extract them, i run into technical issue but my hosting provider solve it
but when i reach into my sql data base that i created they refuse to make or help me do the connection, because they said where is the exact file

12

Check if the MYSQL modules are turned on in your CPanel, or ask your hosting about it.

The SuiteCRM installer should be able to create its own database without your manual intervention. But that can only work if your PHP is able to connect with MySQL.

13

for my SQL database already work because i have other site where i use it and it ok, i think the issue is what you mention PHP is not able to connect with mysql

14

hello dears,
in case anyone install SuiteCRM-8.6.2 and face the issue of MYSQL DATABASE you can solved it by adding this code into .env file directly
image
and with the same info add them in suite crm.
after that you will face dashboard issue you can solve it by permmesion