Search Engine: Elastic

Article ID: 119245, created on Dec 20, 2013, last review on May 30, 2017

  • 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@obas ~]#

The following error occurs during OBAS upgrade:

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 sure that MySQL server is running and connection parameters are
specified in the local .my.cnf file as it is described in upgrade notes.

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'"

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF