Billing dashboard widgets

1. Configure billing in cloud providers as required
   
   1. AWS EC2 - https://aws.amazon.com/blogs/aws/new-programmatic-access-to-aws-billing-data/

      1. Create an S3 bucket and assign the following policy to make it writable by AWS programmatic billing

          Click here to expand...

         {
           "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/*"
             }
           ]
         }

      2. Go to Billing preferences and assign the bucket name you have configured
      3. Create a new programmaticbilling user (any user name) and add AmazonS3ReadOnlyAccess policy
   2. Azure ARM
      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. Also, you should check the Currency, Locale and RegionInfo.
2. In Abiquo, configure Enterprise properties with the name of billing properties 
   1. AWS EC2 
      1.  "billing_bucket" property, with a value of the name of the billing bucket you created in the previous step
   2. Azure ARM requires
      1. OfferDurableID
      2. Currency, the default is "USD"
      3. Locale, the default is "en-US"
      4. RegionInfo, the default is "US"
3. On a server with MariaDB installed and with access to Abiquo Server, Abiquo database and public cloud providers, install the new billing packages
   1. abiquo-billing-arm
   2. abiquo-billing-ec2
4. Configure billing packages
   
   1. AWS: Edit /opt/abiquo-billing-ec2/config/config.yml
      1. Abiquo database connection: user must be granted select from this host
      2. ec2-billing database: can be hosted on localhost
      3. Abiquo API: user must have Manage bills privilege

5. Edit the configuration files in config/config.yml

6. Create the local billing databases and import schemas

   AWS:

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

   Azure:

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

7. Grant permissions on the local billing databases to the user configured in each config.yml
8. If the Abiquo database is encrypted with a custom seed, copy that seed with each config.yml
9. Assign Abiquo user privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)
   
   

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