Search Engine: Elastic

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

  • Applies to:
  • Business Automation 4.4


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

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

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

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


In the provided scenario PBA-E application server with IP is supposed to work with remote MySQL database on the host The script ~bm/tools/ has to connect remotely to MySQL server on the server, 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.


Before you start initializing PBA-E database by running the script ~bm/tools/ 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):

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@ identified by '' with grant option;
   mysql> grant all privileges on *.* to bm4@ 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/ 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