For most Users (non-resellers directly under ServerAdmin), the disk space report page shows Files only. How can I make it show SQL Server and Mail as well? (I can see the data exists in PackagesDiskspace table, but it isn't displayed.)
For Resellers and Resellers' Users, the disk space report includes Files, SQL Server, and Mail. That's mostly what I would expect, but is there any way to include MySQL also?
Also for GroupID=2, the PackagesDiskspace table shows only negative values (or zero) for DiskSpace. Can anyone clarify why?
Thanks!
I found a solution for the MySQL portion of my question. In the server setup (MySQL service settings in SolidCP), I needed to configure "MySQL Installation Folder" as the folder that contains the MySQL data folder.
I'm still trying to figure out how to get everyone's disk report to show all of the diskspace data that exists for the package.
Furthermore "Files" are double-counted for resellers (at least on my system where I configured end-user spaces to be inside the reseller space folder).
For GroupID=1, the PackagesDiskspace table has a correct entry for the reseller space, plus additional entries for the end-user spaces (packages). Apparently the Disk Space report adds it all up, resulting in double-counting for the reseller's space.
(I don't see any double-counting for the remaining groups.)
Sorry for our lack of response, we where very pre-occupied with our datacenter move which has finally been completed 🙂
I do think the whole space and bw calculation can use a revamp (as it uses alot of old techniques), however that won't really help at this point in time ofcourse.
Thanks Marco!
There is similar behavior in the bandwidth calculation. For many users (spaces), SolidCP shows only "Web" bandwidth (GroupID=2) even though the database also includes Mail bandwidth (GroupID=4).