Helm3 : File Manager Not Showing any Files

andy18    Helm     File Manager, Helm 3

If you are running Helm version 3 and your Helm control panel is not listing any files from the server owned by your domain ( after you have confirmed there’s files uploaded ), try uninstall and re-install the File and Print services at your server’s NIC. Make sure you select the correct options to uninstall if this is a production server or else it will be a pretty nasty crash on your server.

Helm4 Error on Remove Domain

andy18    Helm     Helm 4 remove domain error

The following error can be generated if the “Helm 4 Network Service” on the remote server is not started on the Services MMC.

Offline
Failed to establish socket connection: No connection could be made because the target machine actively refused it 123.123.123.123:7086

Just login to the remote server and make sure the services are started.

Sorting Helm 3.x Database

andy18    Helm    

If you need to sort out the username, domain name and the package type hosted under a reseller, the following SQL query may help:

use HelmDBName
select PackageType.ResellerAccountNumber, Package.AccountNumber, HostDomain.DomainName,PackageType.PackageTypeName
from PackageType, HostDomain,Package
where PackageType.PackageTypeId = Package.PackageTypeId AND
Package.PackageId = HostDomain.PackageId AND
ResellerAccountNumber = ‘Reseller_Username‘ AND
HostDomain.SubDomainId = 0 AND
HostDomain.DomainAliasId = 0