DBMS Quickstart

This guide provides steps to quickly get the billing system up and running for testing. It generates DBMS table usage data for all 'current' Enterprises.

1. Unzip the 'abiquo-billing-redist.zip' file into suitable 'install location' on your chosen machine.

2. Populate the Account Mapping table. For example, to add mappings for all enterprises you would use the following SQL:

INSERT INTO kinton.billing_account_mapping (idAbiquo, idMappingType, billingAttributeName, billingAttributeValue)
(SELECT idEnterprise, 1, 'ENTERPRISE', e.name FROM kinton.enterprise e);

3. Create a MySQL user account that can be used by the billing system to access the Abiquo DBMS. You must also grant permissions as detailed below for example user 'billing':

CREATE USER 'billing'@'%' IDENTIFIED BY 'password';
GRANT SELECT,EXECUTE ON kinton.* TO 'billing'@'%';
GRANT SELECT ON kinton_accounting.* TO 'billing'@'%';
GRANT SELECT ON mysql.proc TO 'billing'@'%';

4. Modify the billing.properties file, updating the following values:

connector_name=DBMS
dbms_connection_url=jdbc:mysql://<Abiquo DBMS IP Address>:3306/kinton
dbms_user=billing
dbms_password=password

To enable more usage properties, see Configure billing properties.

5. Create a target database and MySQL user account that can be used by the billing system to create and populate the target billing table data in that database. You must also grant permissions as detailed below for example user 'bill':

CREATE DATABASE abiquo_billing CHARACTER SET=utf8;
CREATE USER 'bill'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON abiquo_billing.* TO 'bill'@'%';

6. Modify the dbms.properties files, updating the following red values appropriately:

provider_mapping_name=ENTERPRISE
dbms_connection_url=jdbc:mysql://<Bill Data IP Address>:3306/abiquo_billing
dbms_user=bill
dbms_password=password

7. Optionally enable DBMS output of Cost Code, Storage Tier, Local Storage Tier, Hypervisor, Costing, CPU ON, CPU OFF, Memory ON, Memory OFF, Firewall, Loadbalancer, Backup, and so on, and Custom Usages. See DBMS Billing Integration

8. Run the billing.sh file ('.billing.sh' from the install directory) to generate DBMS usage data.

9. Review the generated 'abiquo_billing_data' table in the target DBMS to review the generated billing data.

9. Optionally schedule the billing integration to run on a regular basis.

For more details, see Abiquo Billing Integration User Guide