CCDC1
19 February 2020 16:21
1
Hi everyone, I’m installing suitecrm onto my nas drive and im running into an error during my installation. In the database configuration page after filling up my data, I get the error of:
“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”
attached is a photo of the error.
note: I had my email in the space but i took it out for the photo
My setup is currently:
Nas: synology DCM 6.2
Suitecrm 7.11.12
mariadb 10
phpmyadmin
php 5.6 , 7.0
Thanks in advance for the help.
pgr
19 February 2020 16:36
2
Maybe it’s the port? See this, and the Github issues linked there:
I want to install an instance of SuiteCRM using a non-standard MySQL socket and port (we have a host serving a number of different databases for different applications/users, so obviously we need to have each database or group of databases running under a separate server process). I overcame a related problem when moving a previously-installed SuiteCRM instance to a new server, by setting db_port in config…php, and at the top of the same file adding the line “ini_set(‘mysqli.default_socket’, …)…
CCDC1
19 February 2020 16:53
3
Hi there,
I changed the port number to my mariadb10 port number but I still get the error.
Here of some screenshots of what I changed.
pgr
19 February 2020 16:55
5
If you can, use the default port, and hen ommit the port in the Setup Wizard, write just the IP address
CCDC1
19 February 2020 16:57
6
I omitted the the port number but still getting the same error.
pgr
19 February 2020 17:00
7
It’s time to check your logs …
Check your php.ini
to know where your PHP errors log is.
CCDC1
19 February 2020 17:01
8
any advice on where to find it? I’m a noob.
CCDC1
19 February 2020 18:04
9
Hi there once again. I was able to install using the 127.0.0.1:3307 for the host name.
I’m a little confused as to why this worked. Being a local address can other users on the network connect to this address??
pgr
19 February 2020 18:17
10
that’s the hostname of your database , as long as SuiteCRM can reference that correctly, it will work.
A different thing is your SuiteCRM host name, or how it is accessible in the network to others.
CCDC1
19 February 2020 18:57
11
Just tested with other users within the network and it works just fine. Thanks for your help