A valid PostgreSQL CMS connection and Access is Denied

Hello there,

I'm at my wits end. I have been trying to fix this for months and nothing works for me, I have looked at every single forum post about "A valid PostgreSQL CMS connection could not be established." to find a solution but none of that works, I really don't know what to do anymore. I have reset my computer completely and started all over again, several times... I've uninstalled and installed again, I've given permissions, I've gone through my firewall... I don't know how to fix this...

As well whenever I am trying to update metadata, I keep getting errors and everything fails..I looked at the log files and this is what I get "2019-10-11 10:42:43.378 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): boost::filesystem::create_directories: Access is denied: "C:/Users/Myname/Documents/DAZ 3D/Studio/My Daz Connect Library\data\cloud"

I really don't know what to do anymore T.T

Comments

  • That does read like a permissions issue. Had you, at any time in the past, run DS or Install Manager "As administrator"? That is, right-click>Run as Administrator, not just run normally from an administrator account.

  • No I haven't... Considering that even if I do try it, I get a pop up saying that the programs cannot be run with elevated permissions.

  • No I haven't... Considering that even if I do try it, I get a pop up saying that the programs cannot be run with elevated permissions.

    Yes, that's true now but it wasn't in the past.

  • Like i said, I have formatted my computer because of this and started all over again just a few months ago so I def haven't done the Run as Administrator when I was installing it for the first time.

    Though I have noticed something weird with my folders, they are all read only so I am wondering if it's that? Since I keep getting "Access is Denied", I saw it as well for the PostgreSQL CMS when it was trying to connect.

  • Like i said, I have formatted my computer because of this and started all over again just a few months ago so I def haven't done the Run as Administrator when I was installing it for the first time.

    Though I have noticed something weird with my folders, they are all read only so I am wondering if it's that? Since I keep getting "Access is Denied", I saw it as well for the PostgreSQL CMS when it was trying to connect.

    Yes, if they are restoed back ups then - depending on how you restored - you may not have owneship of the files. I had that on one occasion, the fix was a "Take Ownership" shell script that was linked for me https://www.daz3d.com/forums/discussion/comment/2104406/#Comment_2104406

  • Ok... so I've done that as well now, the "Take Ownership" but it still keeps giving me the same errors... "Access is Denied".

    I'm wondering if I should just once again try to uninstall and install everything. I don't know what's going on and why it keeps doing this -siiiiiiiigh- T.T

  • You did the Take Owndership on the stuff in the AppData folder too (which is hidden by default)?

  • Yeah I did, I did it on every folder I could think of belonging to Daz3D

  • Try changing, in DS (if it will let you) the location of the ContentCluster and the port used to communicate (chaneg one, restart, see if it helps, chnage the other if not). The settings are in Edit>Preferences, in the CMS Settings tab. Even if you've already tried this it may be worth trying aain now the access issues are - hopefully - resolved.

  • Hi Richard and fjolasolveig

    You may recall that I am having the same problem, I have observed that there is nothing in the cms content cluster on my machine - could this be a clue to the problem???

  • Hi Richard and fjolasolveig

    You may recall that I am having the same problem, I have observed that there is nothing in the cms content cluster on my machine - could this be a clue to the problem???

    Yes, that sounds very like permission issues. Have you, in the pst, ruin DIM or DS "as administrator"? (I f not, don't - that's a question rather than a suggestion of something to try.)

  • I have never run DLM or Studio with elevated permissions (administrator or not).

    Judging by the number of similar issues posted on this forum I think there has to be an inherent problem with the latest version of studio.

    My active folders seem tohave the same properties as any other file.

    I really dont understand why I can manually instal DS, but if I try to do so through the DLM I get an error, and PostgreSQL doesnt work.

  • UPDATE:

    Having had a good rumage around my PC for any reasons that might give me these problems, I discovered that I could not get the windows command prompt shell to work. So I checked this out with powershell and discovered that some of the system files were indeed corrupted.

    I tried to fix this through the powershell utility, but this didnt solve the problem, so I bit the bullet and reset my windows 10 installation.

    I now have the install manager,and Daz 4.12 working WITH CMS !!! - PostgreSQL is now working again, after loading it through the DLM.

    Problem now is I only have default content installed, and not any purchases.

    I looked at resetting the database, but this only lists default instalation stuff, despite the fact that the DLM has all the other things listed as installed, and the DLM is pointed at the correct directory

    I really dont want to go through the process of reinstalling stuff again form my backups - so any ideas???

  • When you say you looked at resetting the database, did you try to reimport metadata?

  • The import metadata option from within studio 4.12 only shows the default content, and nothing else is listed.

  • Have you told DS about your previous content directories?

  • I dont really understand what you mean to be honest.

    Ill have a good look at what directories it is pointing at and get back to you

  • I'm still having this problem even after doing a format on my computer and reinstalling everything... I really don't understand anything..

    I looked at the Log File and this is what pops up

    2019-10-26 10:51:36.493 Upgrading CMS
    2019-10-26 10:51:36.613 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Upgrading database from version 1 to 48
    2019-10-26 10:51:43.301 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in contentFilterPathsToCloudInstalledContent: Unable to connect to the database
    2019-10-26 10:51:43.302 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in contentFilterPathsToCloudInstalledContent: Unable to connect to the database
    2019-10-26 10:51:43.314 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in productGetAllFirstLetter: Unable to connect to the database, can not quote
    2019-10-26 10:51:43.314 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in categoryGetRoot: Unable to connect to the database

    Can anyone understand that? >.<

  • I'm still having this problem even after doing a format on my computer and reinstalling everything... I really don't understand anything..

    I looked at the Log File and this is what pops up

    2019-10-26 10:51:36.493 Upgrading CMS
    2019-10-26 10:51:36.613 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Upgrading database from version 1 to 48
    2019-10-26 10:51:43.301 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in contentFilterPathsToCloudInstalledContent: Unable to connect to the database
    2019-10-26 10:51:43.302 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in contentFilterPathsToCloudInstalledContent: Unable to connect to the database
    2019-10-26 10:51:43.314 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in productGetAllFirstLetter: Unable to connect to the database, can not quote
    2019-10-26 10:51:43.314 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Unexpected exception in categoryGetRoot: Unable to connect to the database

    Can anyone understand that? >.<

    Is this a clean system - no attempt to restore the application settings or your own files? Is there any security software isntalled? Which version of PostgreSQL is installed?

  • Is this a clean system - no attempt to restore the application settings or your own files? Is there any security software isntalled? Which version of PostgreSQL is installed?

    Yeah, it is. I didn't install anything at all after formatting and so I was just using the usual Windows Defender and I have the usual PostgreSQL installed, not the valentina one.

    Though I think I've gotten this to work now, by the looks of it. Don't ask me how but after I formatted and changed the user name to a more simple one (Not my own with special characters which my country likes to use), it started to work. Though I'm still on the edge and keeping my fingers crossed that it keeps working.

  • Ah, yes - I should have asked about special (non-US) characters.

Sign In or Register to comment.