Unable to check database version. (Database Configuration)

📦 Install & Upgrade Help
1

First time setup, everything goes smooth for me until I get to Step 5 Database Configuration.

Background
Amazon EC 2 Instance
Ubuntu Server 14.04 LTS (PV), SSD Volume Type - ami-23ebb513
SuiteCRM 7.2 MAX
Typical Install
MySQL

I have created a user called dev and have granted him ALL PRIVILEDGES

Please fix the following errors before proceeding:

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
Unable to check database version.

I’m never getting pass “Verifying DB Credentials…”

2

Can you connect to the MySQL instance outwith SuiteCRM using those details? If you can what does running

SELECT version()

give?

Thanks,
Jim

1 Like
3

Hi Jim,

This is what I got:


mysql> SELECT version()
    ->


mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+-------------------------+
| Variable_name           | Value                   |
+-------------------------+-------------------------+
| innodb_version          | 5.5.41                  |
| protocol_version        | 10                      |
| slave_type_conversions  |                         |
| version                 | 5.5.41-0ubuntu0.14.04.1 |
| version_comment         | (Ubuntu)                |
| version_compile_machine | x86_64                  |
| version_compile_os      | debian-linux-gnu        |
+-------------------------+-------------------------+
7 rows in set (0.00 sec)
4

This may also be helpful:

mysql> STATUS;
--------------
mysql  Ver 14.14 Distrib 5.5.41, for debian-linux-gnu (x86_64) using readline 6.3

Connection id:          65
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.5.41-0ubuntu0.14.04.1 (Ubuntu)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 9 hours 29 min 41 sec

Threads: 1  Questions: 663  Slow queries: 0  Opens: 433  Flush tables: 1  Open tables: 41  Queries per second avg: 0.019
--------------
5

Hello,

I think you have to set “localhost” or have you allowed remote to your Database?

1 Like
6

Had the same issue this morning hope this helps:

Win8
XAMPP
I set Apache to run on port 8080 since the beginning, launched Install.php, got stuck at Verifiyng DB credential…
I provided localhost:8080 as hostname while installing Suitecrm, no way either
I reverted back to port 80 in the Apache config, everything run smoothly then

Hope this helps

F