Page Comparison

...

Configure programmatic billing in cloud providers

Amazon

See the AWS documentation about how to configure programmatic billing for AWS EC2 - https://aws.amazon.com/blogs/aws/new-programmatic-access-to-aws-billing-data/

1. Create an S3 bucket and note down the name. AWS will write the programmatic billing data to this bucket

2. Assign the following policy to the S3 bucket. In this example, the bucket is called "programmaticbilling". Replace "programmaticbilling" with the name of your bucket

   Code Block

   { "Version": "2008-10-17", "Id": "Policy1335892530063", "Statement": [ { "Sid": "Stmt1335892150622", "Effect": "Allow", "Principal": { "AWS": "arn:aws:iam::386209384616:root" }, "Action": [ "s3:GetBucketAcl", "s3:GetBucketPolicy" ], "Resource": "arn:aws:s3:::programmaticbilling" }, { "Sid": "Stmt1335892526596", "Effect": "Allow", "Principal": { "AWS": "arn:aws:iam::386209384616:root" }, "Action": "s3:PutObject", "Resource": "arn:aws:s3:::programmaticbilling/*" } ] }

   
   

3. Open Billing preferences and select the option to "Receive billing reports". Enter the name of your bucket
4. Create a new user for programmatic billing (you can give it any name - we used "programmaticbilling"!). Assign the AmazonS3ReadOnlyAccess policy to your user

Monthly CSV file 

Azure

1. Grant access to billing records to the app role created in Azure
2. Obtain the OfferDurableID from the offer agreement for your enterprise by going to your subscription → Administer. 
3. Also, obtain the Currency, Locale and RegionInfo.

Reference for Azure billing: https://docs.microsoft.com/es-es/azure/billing/billing-usage-rate-card-partner-solution-cloudyn 

Install and configure billing packages

...

1. Install the billing packages. The package name for Azure is "abiquo-billing-arm" and the package name for Amazon is "abiquo-billing-ec2".

2. Create the local billing databases and import schemas

   AWS:

   Code Block
   mysql -e "create database ec2_billing" mysql -h -p -u ec2_billing < /opt/abiquo-billing-ec2/lib/app/schema.sql

   Azure:

   Code Block
   mysql -e "create database arm_billing" mysql -h -p -u arm_billing < /opt/abiquo-billing-arm/lib/app/schema.sql

   
   

3. Grant privileges to a user for the local billing databases

4. Configure the billing packages, edit the config.yml file. By default for AWS, this is file is located at /opt/abiquo-billing-ec2/config/config.yml and the following example file shows the values that must replace.

   Code Block
   abiquo_database: host: 10.10.10.36 user: user password: password port: 3306 billing_database: host: 10.10.10.38 user: user password: password port: 3306 abiquo: api_url: http://10.10.10.32/api user: admin password: xabiquo seed:

   
   Notes: 

   1. The billing database is the one you created in the above steps, so it can be hosted on localhost

   2. "seed" is the name of a custom seed that encrypts the Abiquo database. Copy the custom seed into the same directory as the config.yml file for each provider

5. On the Abiquo database, grant select privileges from this host to the abiquo_database user that will run the bililng scripts 
6. In Abiquo, check that the Abiquo API user has the Manage bills privilege
7. In Abiquo, configure Enterprise properties with the name of billing properties 
   AWS
   • Configure the "billing_bucket" property, with a value of the name of the billing bucket you created
   Azure 
   • OfferDurableID
   • Currency, the default is "USD"
   • Locale, the default is "en-US"
   • RegionInfo, the default is "US"
8. Assign Abiquo users the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)
   

...