Article ID: 119245, created on Dec 20, 2013, last review on May 18, 2015

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

OBAS database is stored on an external server:

[root@pbas ~]# grep MAIN_DB /etc/hspc/hspc.conf
MAIN_DB_HOST    = <mysql_host>
MAIN_DB_NAME    = aspc
MAIN_DB_USER    = <mysql_user>
MAIN_DB_PASS    = <mysql_password>
[root@pbas ~]#

The following error occurs when I try upgrading OBAS to version 4.5:

[root@pbas ~]# sh install.sh -C
...
Dec 12 2013 13:40:10 [:16178] DEBUG: Failed to connect to MySQL server using 'root' account:
ERROR 1045 (28000): Access denied for user 'root'@'<mysql_host>' (using password: NO)
Please make shure that MySQL server is running and connection parameters are
specified in the local .my.cnf file as it is described in upgrade notes.
...
Upgrade integrity system check failed:
Previous system upgrades finished with errors!
Upgrades 4.3.4-22 -> 4.5-37 -> 4.5-55 failed.
Please contact support.

Cause

File /root/.my.cnf with mysql's root password for remote server is missing on OBAS node.

Resolution

Before upgrading OBAS with a remote database server, please make sure to create /root/.my.cnf with mysql's root password on OBAS node according to Release Notes:

[client]
password=<root_password>
host=<mysql_host>

Where <root_password> is MySQL root password, <mysql_host> is MySQL server location.

Additional information

How to upgrade OBAS system to the latest available version?

Cannot upgrade OBAS to 4.5: "SELECT command denied to user 'aspcomplete'"

Search Words

Failed to connect to MySQL server using 'root' account

Upgrades 4.3.4-22 -> 4.5-37 -> 4.5-55 failed

Please make shure that MySQL server is running and connection parameters are specified in the local .my.cnf file as it is described in upgrade notes

upgrade failed due to mysql connection

Access denied for user 'root'

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF