Article ID: 8631, created on Jun 25, 2010, last review on May 9, 2014

  • Applies to:
  • Business Automation 4.4

Symptoms

Provider wants to install PBA-E application server and database server on separate hosts, e.g.:
  • application server - 192.168.32.211
  • database server - 192.168.32.210

They installed MySQL server on host with IP address 192.168.32.210 and ran PBA-E installer on the host with IP address 192.168.32.211.

After installer finished its work Provider ran the script ~bm/tools/configure.pl on PBA-E application server to configure database which is supposed to work on the database server 192.168.32.210.

Script produced the output like shown below:
Running configure.pl
dbi:mysql:database=bm4;host=192.168.32.211, bm4, bm4
Couldn't connect to database via configured parameters.
mysql -h192.168.32.211 -uroot --password= -A
ERROR 1130 (00000): Host '192.168.32.211' is not allowed to connect to this MySQL server
mysql -hlocalhost -uroot --password= -A Connection succeeded!
Create database bm4
ERROR 1130 (00000): Host '192.168.32.211' is not allowed to connect to this MySQL server
Error creating database and granting access:  at db.pm line 115.

Cause

In the provided scenario PBA-E application server with IP 192.168.32.211 is supposed to work with remote MySQL database on the host 192.168.32.210. The script ~bm/tools/configure.pl has to connect remotely to MySQL server on the server 192.168.32.210, create and configure database 'bm4' on the server.

The reason of problem is that Provider did not say to PBA-E that database will be working on remote server, not on the local server, where PBA-E application server is installed. By default PBA-E does suppose that MySQL is installed locally and is trying to connect to local MySQL server using IP address of PBA-E application server.

Provider need to configure PBA-E application server and database servers correctly.

Resolution

Before you start initializing PBA-E database by running the script ~bm/tools/configure.pl in the provided scenario you need to set database host IP address in the parameter DB_HOST in the file /usr/local/bm/etc/ssm.conf.d/.global.conf on PBA-E application server.

In this particular case the parameter has to be set up as follows (it should point to correct IP address of database server):
DB_HOST = 192.168.32.210

Also, It is required to give access rights to MySQL database.
1. Log into database server by SSH as root.
2. Run the following query to configure MySQL:
   # mysql mysql
   mysql> grant all privileges on *.* to root@192.168.32.211 identified by '' with grant option;
   mysql> grant all privileges on *.* to bm4@192.168.32.211 identified by 'bm4' with grant option;
   mysql> flush privileges;
   mysql> exit;


Note - IP address in SQL queries above is IP of PBA-E application server.

Only after the steps above are performed Provider need to run the script ~bm/tools/configure.pl to initialize PBA-E database, at this time all requirements will be satisfied:
  • correct IP address of database server will be set up in the file /usr/local/bm/etc/ssm.conf.d/.global.conf
  • PBA-E application server will be granted with needed privileges on database server

198398b282069eaf2d94a6af87dcb3ff 3d55d50f8852f9c7863e871edae687aa 4ab279b4a01a37a9fdcbcd5333c6c096 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF