Abiquo cron jobs

Borrador - confluence page is broken

All versions

In all versions, Abiquo metrics usage system: abiquo-metrics-usage-system

Abiquo 6.2

Abiquo 6.1 with new billing

Periodic process	How is it run?	Default
Abiquo on-premise billing	abiquo.billing.task.cron property

abiquo.billing.task.cron

Cron expression to run the consolidation of usage and cost from private cloud and public cloud providers.
If the cron expression is not compatible with Quartz, the platform will use the default.

To generate valid expressions, you can use this tool: https://www.freeformatter.com/cron-expression-generator-quartz.html . Some other commonly used tools may generate invalid expressions.

0 30 0 ? * * *

abiquo.pricefactor.type.product.check.cron

Cron expression to run the periodic checks of price factor bill type and products.

0 0 0 1 * *

abiquo.tagging.synccheckcron

Cron expression to run the periodic tag synchronization by enterprise. If the cron expression is not compatible with Quartz, the platform will use the default.

0 0 */4 ? * *

Abiquo accounting

On the Abiquo server, or the separate database server, there should be a default accounting cron job at /etc/cron.d/abiquo-accounting similar to the one below.

# Runs every hour
0  * * * * root mysql -uADMUSER -pADMPASS -hlocalhost -e "CALL kinton.UpdateAccounting();"

# Runs every Sunday at 12:00 and deletes records older than a week.
0 12 * * 0 root mysql -uADMUSER -pADMPASS -hlocalhost -e "CALL kinton.DeleteOldRegisteredEvents(168);"

Old push Abiquo private billing data for dashboard

For old billing (before the entry of new billing in 6.1 or before the activation of new billing).

The cron entry that executes the process nightly is at /etc/cron.d/abiquo-billing-private

Old Abiquo billing integration

From Abiquo deployer, billing scripts, the cron job to run abiquo-billing hourly is at /etc/cron.d/abiquo-billing. File content is:

   0 1 * * * root cd /opt/abiquo-billing; /bin/bash /opt/abiquo-billing/billing.sh 2>&1 | tee --append /var/log/billing.log

Note that there is also a cron command to update the enterprise mapping, which maybe in teh file: abiquo-billing-mapping. File content is:

10 0 * * * root mysql --host specifythedbhost --user root --password yourpass --execute "INSERT IGNORE INTO kinton.billing_account_mapping (idAbiquo, idMappingType, billingAttributeName, billingAttributeValue) (SELECT idEnterprise, 1, 'ENTERPRISE', e.name FROM kinton.enterprise e);"

Notes from the billing comparison page

Before you enable on-premise billing, stop the abiquo-private-billing cron job
To configure the cron job that runs on-premise billing use the Abiquo property.
When you transition to on-premise billing, you can stop the old abiquo-billing cron job

Abiquo reporting

To periodically remove temporary tables from the DB, add the following cron job on the reporting or database server.

0 1 * * * root mysql -ureporter -preporter -e "CALL kinton_reporting.TruncateRLSTables ();"

Abiquo 6.0

Properties

In Abiquo 6.0, this

abiquo.billing.task.cron

Cron expression to run the consolidation of usage and cost from public cloud providers.
If the cron expression is not compatible with Quartz, the platform will use the default.

To generate valid expressions, you can use this tool: https://www.freeformatter.com/cron-expression-generator-quartz.html . Some other commonly used tools may generate invalid expressions.

0 30 0 ? * * *