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?
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.)
ok the issue with the mysql data folder fix. does not work, because the moment you change the folder to the datafiles location the backup no longer works.
We have installed mysql on the server on the c: drive, and the data files exist on the e: drive. If we don’t point this folder to the c drive location you cant backup files.
A fix to this is to copy the bin folder to the root folder where the data files are located, ie if data is in d:\mysqldb\data then copy the bin folder into the d:\mysqldb folder. It seems the provider uses the bin folder for the mysql dump and files..