Create a user for billing and grant permissions to the user. For example
CREATE USER 'billing'@'%' IDENTIFIED BY 'mypassword';
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);
For full details, see Populate the account mapping table for billing.
Note: set up a separate process to maintain the account mapping table.
If you are using the DBMS connector, create a target database and MySQL user account for the billing integration. Do not use the Abiquo database. You must also grant permissions, for example.
CREATE DATABASE abiquo_billing CHARACTER SET=utf8;
On the billing server, configure the billing.properties file in the same folder as the billing.sh script.
Set the connector_name property to "CSV" or "DBMS" for your connector. And enter the details of the billing user and IP address to access the Abiquo database.
For full details, see Configure billing properties
On the billing server, Configure the connector properties file in the same folder as the billing.sh script.
For the CSV connector, edit csv.properties.
Set the provider_mapping_name property.
For full details of CSV connector configuration, see CSV Billing Integration
For the DBMS connector, edit dbms.properties.
Set the provider_mapping_name and also add the credentials for the output database
Run the billing.sh file ('./billing.sh' from the install directory) to generate the usage data.
Check the generated usage data. CSV files are in the 'CSV_files' folder of the installation directory and DBMS data is in the abiquo_billing_data table in your database.