Hello,
The error suggests there is an issue with getting the home folder for the user. You can try run the [dbo].[GetServiceItems] stored procedure on your SolidCP Database.
The options you can get such as PackageID from the URL for the others use:
@ItemTypeName = N'SolidCP.Providers.OS.HomeFolder, SolidCP.Providers.Base', @GroupName = N'OS',
Regards,
Trevor
@trobinson I think there's something that I missed. From what URL is it that I should be able to get ActorId & PackageID?
I looked at the following two endpoints:
Default.aspx?pid=SpaceMsSql2019&mid=152&ctl=edit_item&ItemID=3&SpaceID=6
Default.aspx?pid=SpaceFileManager&SpaceID=6
Hi Guys
We are also having this problem as well with v1.4.7. Our SQL Server and Web Servers are physically separate servers and the OS for the User is on the Web Server. We can upload files using file manager (which go to the web server) but we cannot backup SQL to the Hosting Space.
Initially, we didn't have an OS defined on the SQL Server so we tried adding that but it still errors out. Our Virtual Server only has the Web Server OS, will it also need the SQL Server OS adding as well?
And if the answer is yes, does this mean that the users will be able to upload files to the SQL Server?
Thanks
Mark Donne
@indexebusiness OS is always required to anything space/ bandwidth related (it normally is equal to the Web / FTP server if you have one, if you do not have a Web / FTP server it can be anything else to your chosing).
If you add it after the space is created already it will normally not automatically work correctly due to saved ServiceID's on space creation, it should then however work for any new space.
Any old space would need to be adjusted in the PackageServices and ServiceItems tables (out the top of my head).
Regards,
Marco
@trobinson I think there's something that I missed. From what URL is it that I should be able to get ActorId & PackageID?
I looked at the following two endpoints:
Default.aspx?pid=SpaceMsSql2019&mid=152&ctl=edit_item&ItemID=3&SpaceID=6
Default.aspx?pid=SpaceFileManager&SpaceID=6
ActorID is your userID from the Users table which is runnung the query (or logged into the panel). For Serveradmin this is always 1.
PackageID can be found from the SpaceID in the URL.
@trobinson sorry for the late reply.
I tried executing the below stored procedure, and I got nothing back
I got a return_value of "0"
I've tried with serveral different ActorIDs, to see if that was the reason I got nothing back
USE [SolidCP]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[GetServiceItems]
@ActorID = 1,
@PackageID = 6,
@ItemTypeName = N'SolidCP.Providers.OS.HomeFolder, SolidCP.Providers.Base',
@GroupName = N'OS',
@Recursive = 0
SELECT 'Return Value' = @return_value
GO
