Connecting the BI module to the BILLmanager database

The article describes how to connect the Business Intelligence (BI) module to an external BILLmanager database. This configuration is used when the BI server and the BILLmanager database run on different servers. For example, when using a database duplicate.
If you use a duplicate of the BILLmanager database located on another server:

Connect to the server with the BILLmanager database duplicate via SSH. For more information about connecting via SSH, see the article Workstation setup.

Add a rule to firewalld:

firewall-cmd --zone=bi --add-source=<bi_server_ip_address>

Restart firewalld:
```
systemctl restart firewalld
```

Add a user in mysql:

Open the mysql console

mysql

CREATE USER 'bi'@'bi_server_address' IDENTIFIED BY 'password';

GRANT SELECT on billmgr.* TO 'bi'.'bi_server_address' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Close the mysql console

exit

Connect to the server with the platform via SSH. For more information about connecting via SSH, see the article Workstation setup.
Specify new values for the bill_db_host, bill_db_port, bill_db_password parameters in the /usr/local/mgr5/ etc/business_intelligence/ansible/vars.json file.
Go to the directory
```
 cd /usr/local/mgr5/ 
```
Run the installation script from the /usr/local/mgr5/ directory:
```
./etc/business_intelligence/ansible/run.sh install
```

To verify that the connection parameters were specified correctly:

Connect to the ETL container on the server with the BI module.
```
docker exec -it etl bash
```

Check the environment variable values:

echo $BILL_DB_HOST
echo $BILL_DB_PORT

Example of execution and output:

~# docker exec -it etl bash
root@5e51783a1c67:/opt/ispsystem# echo $BILL_DB_HOST
<bi_server_ip_address>
root@5e51783a1c67:/opt/ispsystem# echo $BILL_DB_PORT
3306