We noted on multiple Virtualmin servers that packages exist in WHMCS and do not pull the correct disk space and traffic overuse information from the Virtualmin server. We then set up a test environment and found the same. The problem is best illustrated below.
The query below show 8 packages that exist in WHMCS.
The second package has the total wrong limits. The limits should be same as package in test 5. In this case Virtualmin and/or WHMCS has assigned unlimited traffic and disk space but actually Virtualmin has severe test limits (30MB and 10MB) on both.
Package ns2.xxxxx.com has the limits and overuse of package arb.xxxxx.com. So in this case, the incorrect package was assigned.
Package arb.xxxxx.com limits are nowhere else to be found in the query.
I’ve tried various combinations of change package, re-assign, etc but I’m not making any progress.
Anyone else seen this issue? The risk factor is some clients will get billed for incorrect overuse, and other’s won’t get billed at all.
select domain, tblproducts.name, diskusage, disklimit, bwlimit, bwusage, lastupdate from tblhosting join tblproducts on tblproducts.id = tblhosting.packageid where domainstatus='Active';
+------------------------+--------------+-----------+-----------+---------+---------+---------------------+
| domain | name | diskusage | disklimit | bwlimit | bwusage | lastupdate |
+------------------------+--------------+-----------+-----------+---------+---------+---------------------+
| aaaoverusetest1.com | Small Plan | 0 | 1024 | 10 | 0 | 2019-04-03 11:35:24 |
| aaaoverusetest2.com | Small Plan | 0 | 0 | 0 | 0 | 2019-04-03 11:35:24 |
| aaaoverusetest3.com | Small Plan | 30 | 1024 | 10 | 30 | 2019-04-03 11:35:24 |
| aaaoverusetest4.com | Small Plan | 0 | 1024 | 10 | 0 | 2019-04-03 11:35:24 |
| aaaoverusetest5.com | Small Plan | 30 | 1024 | 10 | 30 | 2019-04-03 11:35:24 |
| arb.xxxx.net | Default Plan | 30 | 1024 | 10 | 30 | 2019-04-03 11:35:24 |
| ns2.xxxxx.com | Default Plan | 387 | 1536 | 1024 | 195 | 2019-04-03 11:35:24 |
| whmcsdev.xxxx | Default Plan | 0 | 1536 | 1024 | 1 | 2019-04-03 11:35:24 |
+------------------------+--------------+-----------+-----------+---------+---------+---------------------+