Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: SuiteCRM Database Configuration problem

SuiteCRM Database Configuration problem 2 months 1 week ago #76354

  • Scorza
  • Scorza's Avatar
  • Offline
  • New Member
  • Posts: 9
  • Karma: 0
Hello, I downloaded SuiteCRM but I'm having problems during the installation process, specifically in "Database configuration" section.



Obviously the "crm" database was created as well as the "crmadmin" user. I can not understand what the problem is, the error that returns is as follows:

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

Database: mysql Ver 8.0.13 for Linux on x86_64 (MySQL Community Server - GPL)
OS: CentOS 7
Kernel: 3.10.0-957.1.3.el7.x86_64
php version: 7.0.33

my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

bind-address = 0.0.0.0
port = 3306


I also tried to make a remote connection (i've changed localhost to the workstation's ip) to the database using the specified user and it works properly. Thanks in advance, Juri
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76366

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9342
  • Thank you received: 1409
  • Karma: 340
Which version of SuiteCRM is this?

Are you installing yourself, or did you use any package install (Softaculous, etc)?

Normally you shouldn't pre-create the database, the installer takes care of that. You just need to give it valid credentials.

Try connecting to MySQL from the command-line with those credentials to check they're working as you expect.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76368

  • Scorza
  • Scorza's Avatar
  • Offline
  • New Member
  • Posts: 9
  • Karma: 0
Hi, I'm installing SuiteCRM version 7.10.11 by myself, without additional software.

I already tried the installation process without creating the database and the user before.

The connection from the terminal (mysql -u crmadmin -p crm) works correctly.

I think I found the problem: SuiteCRM does not support mysql80 but only up to mysql 5.7.
Last Edit: 2 months 1 week ago by Scorza.
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76372

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 9342
  • Thank you received: 1409
  • Karma: 340
Maybe it is only this simple problem, if so, you should see that error in your web server log:

github.com/salesagility/SuiteCRM/issues/6046

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76394

  • jrivas
  • jrivas's Avatar
  • Offline
  • Premium Member
  • Posts: 101
  • Thank you received: 2
  • Karma: 0
Hello,

I have the same problem I can not install the latest version of suitecrm 7.11 but can not connect to the database. I have done this procedure several times but now it does not work. I use PHP version 5.6.3 on a linux server on which I have installed several instances of suitecrm.

Suitecrm.log: [FATAL] Could not connect to DB server localhost as xxxxxxx. port : Access denied for user xxxxxxxt' to database 'xxxxxxx'

Any other idea of the problem or solution.

Thank you.
Javer Rivas
www.esatic.com
Skype: javer.rivas
5713132774176
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76395

  • Scorza
  • Scorza's Avatar
  • Offline
  • New Member
  • Posts: 9
  • Karma: 0
Hello, what database are you using and what version?

Best regards, Juri
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76397

  • jrivas
  • jrivas's Avatar
  • Offline
  • Premium Member
  • Posts: 101
  • Thank you received: 2
  • Karma: 0
Hello Juri,

MySQL 5.6.39

Thank you.
Javer Rivas
www.esatic.com
Skype: javer.rivas
5713132774176
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76398

  • Scorza
  • Scorza's Avatar
  • Offline
  • New Member
  • Posts: 9
  • Karma: 0
I also need to know the operating system you are using. I was able to solve the problem using version 5.7 of MySQL, however it seems that your problem is a little bit different.
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76399

  • jrivas
  • jrivas's Avatar
  • Offline
  • Premium Member
  • Posts: 101
  • Thank you received: 2
  • Karma: 0
Hi,

it is CENTOS 6.10.

Thank you.
Javer Rivas
www.esatic.com
Skype: javer.rivas
5713132774176
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76400

  • jrivas
  • jrivas's Avatar
  • Offline
  • Premium Member
  • Posts: 101
  • Thank you received: 2
  • Karma: 0
Solved

I deleted the instance and returned to restore the instance again and now it works normally.

Thank you.
Javer Rivas
www.esatic.com
Skype: javer.rivas
5713132774176
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76402

  • jrivas
  • jrivas's Avatar
  • Offline
  • Premium Member
  • Posts: 101
  • Thank you received: 2
  • Karma: 0
Sorry the problem has not been solved. there was a confusion with another version.

Using data from the database with another version it works but trying to install version 7.11 does not work. I get a communication error with the database.

Thank you.
Javer Rivas
www.esatic.com
Skype: javer.rivas
5713132774176
The administrator has disabled public write access.

SuiteCRM Database Configuration problem 2 months 1 week ago #76437

  • mikebeck
  • mikebeck's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 1076
  • Thank you received: 207
  • Karma: 40
check the compatibility matrix here docs.suitecrm.com/admin/compatibility-matrix/

best regards
Check your logs and permissions
The administrator has disabled public write access.
Time to create page: 0.120 seconds
Powered by Kunena Forum