Loading...
> >

Install Studio 4.9 on Mac, get error: "A valid PostgreSQL CMS connection could not be established."

124

Comments

  • inquireinquire Posts: 2,234
    Richard Haseltine said:
    inquire said:

    Again, I'm still having confusion about Run as Administrator and Running from an Administrator Account. If I install DS 4.9, is it OK to do so to an Administrator Account?

    Yes, using an administrator account is fine - as long as you don't use the administrator rights to run the application with elevated privileges (Run as Adminsitrator) it will work. The administrator account gives you superpowers, but they aren't used unless you trigger them.

    OK. Thank you for explaining that.

  • inquireinquire Posts: 2,234

    Mac OS Sierra is just out. Has anyone upgraded to this version of the OS? If so, did this connection error still pop up?

    I'm still using 4.8.0.59, Macintosh, 64-bit, pro. Is anyone using that version with Mac OS Sierra? If so, how well does DAZ Studio run in OS Sierra?

  • Rock3DRock3D Posts: 5

    This was killing me at first, I did EVERYTHING, however what worked for me was making sure in the preferences the Cluster Directory was part of the path.
    Originally it was:
    /Users/Home/Library/Application Support/DAZ 3D/cms

    Once I made it this it finally worked:
    /Users/Home/Library/Application Support/DAZ 3D/cms/ContentCluster

     

  • inquireinquire Posts: 2,234

    Hi, Rock3D: When you did this, were you using the new OS, Sierra, or what? I'm still on El Capitan, OS 10.11.6. Also, when you write out /Home/ , I think you mean your own users folder, sometimes represented by / ~ / . Is that correct?

    Again, when you say "in the preferences," I think you mean the last little Tab in the Preferences, the CMS Settings, the Cluster Directory. If so, how did you add  /ContentCluster to the end of the path? Did you type it in? I can't seem to be able to type anything in there. 

    I also notice that my Port is set to 1024. There has been some discussion about which Port to use. Are you using 1024, or which Port are you using?

    Has anyone else tired adding /ContentCluster to his or her preferences? If so, does this work? Does this work with OS 10.11.6, or is some other OS, such as Sierra, needed?

  • ChoholeChohole Posts: 33,604
    Rock3D said:

    This was killing me at first, I did EVERYTHING, however what worked for me was making sure in the preferences the Cluster Directory was part of the path.
    Originally it was:
    /Users/Home/Library/Application Support/DAZ 3D/cms

    Once I made it this it finally worked:
    /Users/Home/Library/Application Support/DAZ 3D/cms/ContentCluster

     

    I am advised to tell you

    And what you've done will create a second nested ContentCluster folder within the one you selected that then actually holds the folders/files that make up the PostgreSQL database. The reason that adding the ContentCluster folder to the path "worked" is because it creates a new subfolder/files with the proper permissions for the current user of the application. The real problem is either permissions on the cms folder are wrong (so Daz Studio and/or PostgreSQL cannot create/modify the contents of it) or the PostgreSQL configuration file (postgresql.conf) in the original ContentCluster folder has the wrong port listed (in which case Daz Studio is "talking" on one line while PostgreSQL is "listening" on another), or the communication is being blocked by the OS or security software. The other (rare) possibility is localhost being mapped to something other than the loopback IP (127.0.0.1).
     

  • inquireinquire Posts: 2,234

    OK, so how can we check this out? What should I, if I encountered this, or Rock3D, do to check this out and correct the situation? 

    How can we check permissions on the cms folder? And correct them, if necessary?

    How can we check the port if the situation is that the PostgreSQL configuration file (postgresql.conf) in the original ContentCluster folder has the wrong port listed? And correct that, if necessary?

    How can we check to see if the localhost is being mapped to something other than the loopback IP (127.0.0.1)? And correct that, if necessary?

    This all sounds very technical to me, and I would not know what to do about any of these situations.

  • TotteTotte Posts: 14,056
    inquire said:

    OK, so how can we check this out? What should I, if I encountered this, or Rock3D, do to check this out and correct the situation? 

    How can we check permissions on the cms folder? And correct them, if necessary?

    Start Terminal.app (found in /Applications/Utilities)

    type:

    cd ~/Library/Application\ Support/DAZ\ 3D/ 

    Type:  ls -ls

    0 drwxr-xr-x+  3 totte  staff   102 27 Aug  2012 DsonPoser
    0 drwxrwxrwx+  7 totte  staff   238 22 Jun  2015 InstallManager
    0 drwxr-xr-x+ 23 totte  staff   782 23 Dec  2011 Studio3
    0 drwxr-xr-x+ 36 totte  staff  1224 28 Maj 00:07 Studio4
    0 drwxr-xr-x+ 21 totte  staff   714  7 Jun 22:39 Studio4 Public Build
    0 drwxr-xr-x+  5 totte  staff   170 11 Sep  2015 cms
    0 drwxr-xr-x+  4 totte  staff   136 16 Aug  2012 dson
    8 -rw-r--r--+  1 totte  staff  1158 22 Sep 08:37 dzInstall.ini
    0 drwxr-xr-x+  3 totte  staff   102 30 Jun  2011 images

    You will now see the privilegies of the files here rwx rwx rwx  (which are Owner, Group, World, a Read, Write & eXecute)
    You also see owner and group of the owers.

    inquire said:

    How can we check the port if the situation is that the PostgreSQL configuration file (postgresql.conf) in the original ContentCluster folder has the wrong port listed? And correct that, if necessary? 

    While in terminal you can type: more cms/cmscfg.json 

    {
            "Port" : 1024,
            "DatabaseClusterPath" : "/Users/totte/Library/Application Support/DAZ 3D/cms"
    }

    You can now check the postgres config with: more cms/ContentCluster/pg_hba.conf

    And you will at the bottom of the file <space to scroll a page> see

    # TYPE  DATABASE        USER            ADDRESS                 METHOD
    # "local" is for Unix domain socket connections only
    local   all             all                                     reject

    # IPv4 local connections:
    host    all             all             127.0.0.1/32            trust

    # IPv6 local connections:
    host    all             all             ::1/128                 trust

    If you have IPV6 activated but for some reason the IPv& routing tables are screwed up you might not be able to connect.

     

    inquire said:

    How can we check to see if the localhost is being mapped to something other than the loopback IP (127.0.0.1)? And correct that, if necessary?

    in terminal type: more /etc/hosts

    There you would see something like
    127.0.0.1       localhost
    255.255.255.255 broadcasthost
    ::1             localhost 

     

    inquire said:

    This all sounds very technical to me, and I would not know what to do about any of these situations.

    I understand that, ususally all just works, but when it doesn't, it becomes technical.

    But what the "cryptic message" Chohole shared really means is the following:

    You have this path: /Users/Home/Library/Application Support/DAZ 3D/cms

    And when you changed it to /Users/Home/Library/Application Support/DAZ 3D/cms/ContentCluster 

    DS created a new directory inside ContentCluster that now will have the correct privilegies.

    One question that comes to mind, how did you install DS the first time? Using DIM or the manual BitRock Installer? 

     

     

     

  • inquireinquire Posts: 2,234

    Well, I'm still on DS 4.8.0.59. I'm just looking forward (should I say?) to the installation of DS 4.9. I used the DIM to install 4.8, which is working. I just don't want this problem, should I install 4.9.

    I don't even know who to change the permissions to /Users/Home/Library/Application Support/DAZ 3D/cms/ContentCluster; I wouldn't know how to add the ContentCluster.

    So, I probably wouldn't know how to utilize the Terminal appropriately, and might really mess things up.

  • TotteTotte Posts: 14,056

    you can change owners and persmissions in Finder using the "Get Info" (Command-I) dialog, or use terminal chmod command

     

  • inquireinquire Posts: 2,234
    Totte said:

    you can change owners and persmissions in Finder using the "Get Info" (Command-I) dialog, or use terminal chmod command

     

    OK, I know. But I don't know how to change this or check on this using the Finder. And, the terminal does seem too involved for me. 

  • TotteTotte Posts: 14,056

    if you select the cms directory in finder and hit Command-I, you see the right and privs in the bottom section.

     

     

  • inquireinquire Posts: 2,234

    Well, it says "Read and Write," which I guess is what it should be. So, if I encountered the last problem described above, would it be that easy to check permissions on the cms folder, and change them?

    Do you think this is the problem which has been troubling people?

  • TotteTotte Posts: 14,056

    It can really be one of several things (I will when time and power outlets permit try to kick up an old machine and clean install OS and see what happens when I install DS on it.

    There can also be an issue with IPv6 if the network is screwing up IPv6 but tricking OS X it is OK, but that's just a wild guess as I haven't seen that issue, but postgres do support IPv6 local host connections.

    And yes read/write permissions is good. Also check files and folders inside.

     

  • inquireinquire Posts: 2,234

    OK. I wasn't sure if I should check all the files inside the cms folder. But, I will. Thanks for the suggestions.

  • kadaj38kadaj38 Posts: 0

    Hello, I had the same problem and now It's Ok.

    You should run the software as Administrator by right click on it.

  • Richard HaseltineRichard Haseltine Posts: 102,301

    Daz Studio should not be run as administrator.

  • TotteTotte Posts: 14,056
    kadaj38 said:

    Hello, I had the same problem and now It's Ok.

    You should run the software as Administrator by right click on it.

    Nope, you should run the installer from an account that can admin (do sudo), that way things will be installed OK), never run software with admin rights, if you need to, you have a srcrewed up installation, what screwed it up can be a number of different things.

  • nicsttnicstt Posts: 11,715
    Roboman28 said:

    Tried following this thread. The problem seemed to be admin vz user rights on the Postgre CMS directory so it would run if I ran Daz Studio as admin. However I could still not see my content categories. My edit/preferences/CMS pointed to the right files too. Tried reloading DS 4.9 and PostgreSQL a few times without success. After 4 hours set it back to DS 4.8. I need to backup my files across 4 PCs so my CMS needs to be transferable across several PCs and not set to a particular user. In 4.8 it didn't matter. With this DRM thing my heart was set against 4.9 but looks like I can't get it to work anyhow! Was thinking what other software takes hours to resolve installation. Answer none.

    Just don't install SQL, or uninstall if you have; I don't use Connect - not interested in DRM.

    I get a window telling me it can't find it, and annoyingly it spams my SSD (where the file is located) with

    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:43Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:38:44Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:39:03Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:04Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:13Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:21Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:25Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:33Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:53Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:47:06Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:52:03Z Shutdown

    etc.

    Currently 1.18MB in size, and am just clearing it.

    Pity I can't turn that off; Daz please stop spamming my SSD. :)

  • Richard HaseltineRichard Haseltine Posts: 102,301
    edited January 2017
    nicstt said:
    Roboman28 said:

    Tried following this thread. The problem seemed to be admin vz user rights on the Postgre CMS directory so it would run if I ran Daz Studio as admin. However I could still not see my content categories. My edit/preferences/CMS pointed to the right files too. Tried reloading DS 4.9 and PostgreSQL a few times without success. After 4 hours set it back to DS 4.8. I need to backup my files across 4 PCs so my CMS needs to be transferable across several PCs and not set to a particular user. In 4.8 it didn't matter. With this DRM thing my heart was set against 4.9 but looks like I can't get it to work anyhow! Was thinking what other software takes hours to resolve installation. Answer none.

    Just don't install SQL, or uninstall if you have; I don't use Connect - not interested in DRM.

    I get a window telling me it can't find it, and annoyingly it spams my SSD (where the file is located) with

    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:27Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:38:43Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:38:44Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:39:03Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:04Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:13Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:21Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:25Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:33Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:33Z Unexpected exception in CloudFIle::lookupFromDb: Unable to connect to the database
    2017-01-13T22:39:53Z Unexpected exception in productGet: Unable to connect to the database, can not quote
    2017-01-13T22:47:06Z Unexpected exception in contentGetByRelativePath: Unable to connect to the database, can not quote
    2017-01-13T22:52:03Z Shutdown

    etc.

    Currently 1.18MB in size, and am just clearing it.

    Pity I can't turn that off; Daz please stop spamming my SSD. :)

    If it was crashing I would say bug report it on principle (but bear in mind that it might be fixed by adding a check to make sure PostgreSQL is available before DS will boot), but producing errors because you are choosing not to fully install is not really a flaw (and you may well find that the CMS is used for more as time goes by).

    Post edited by Richard Haseltine on
  • TygerTyger Posts: 7
    Richard Haseltine said:

    Theer are a few possible issues:

    If DS was initially Run as Administrator (explicitly from the launch menu, not just launched normally in an administrator account) then the folder used by PostgreSQL may have been created with admin-level access rights and may not allow DS run normally to access it - if that was the case you would probably need to delete the folder and let DS rebuild it on next launch

    Firewall issues - usually this is automatic, but you may need to allow both DS and PostgreSQL to communicate on Localhost, 127.0.0.1 (this doesn't allow internet access, it's purely for the local machine). ZoneAlarm has long-standing issues with PostgreSQL, though one user did report that it has an update that resolves them so it may be worth checking the publisher's site.

    Port conflict - PostgreSQL uses a port to communicate with DS, if some other application is using the same port (Spotify was suggested as a possibility) that can block traffic. Changing the port number in DS, and possibly restarting, should resolve this (Edit>Preferences>CMS Settings, or DAZ Studio menu>Preferences>CMS Settings for a Mac).

    Changing the port as described here worked!   Thanks!

  • paulericmorris_1fffe62637paulericmorris_1fffe62637 Posts: 2
    brainmuffin said:

    I had to install the PostgresSQL CMS separately through the install manager and then it was able to connect.

     

    This fixed the problem for me. I'm just testing out this product for the first time and installing the software is the weirdest setup I've ever seen. Must be a 3d thing!

  • alexandersmithalexandersmith Posts: 23
    edited July 2017
    Richard Haseltine said:

    If DS was initially Run as Administrator (explicitly from the launch menu, not just launched normally in an administrator account) then the folder used by PostgreSQL may have been created with admin-level access rights and may not allow DS run normally to access it - if that was the case you would probably need to delete the folder and let DS rebuild it on next launch

    I solved the problem with this way.

    Thanks!

     

    Post edited by alexandersmith on
  • 3DMD3DMD Posts: 18
    edited August 2017

    Thanks, fixed it!

    Post edited by 3DMD on
  • dhhaackdhhaack Posts: 12

    I've tried everything suggested here, on other Daz forums and blogs and also on the Daz Help Site. Still no viable solution. Daz techs need to fix this bug! I've spent a ton of money on Daz 3D items and feel that this problem should be fixed ASAP or I will be requesting a full refund for all my purchases and uninstall Daz Studio. I don't want to, but I have run out of options and patience!

  • theonlyrodhilltheonlyrodhill Posts: 0
    dhhaack said:

    I've tried everything suggested here, on other Daz forums and blogs and also on the Daz Help Site. Still no viable solution. Daz techs need to fix this bug! I've spent a ton of money on Daz 3D items and feel that this problem should be fixed ASAP or I will be requesting a full refund for all my purchases and uninstall Daz Studio. I don't want to, but I have run out of options and patience!

    I agree 100% (same problem) and will do the same. I have had a tech support person email me with a couple of lines every other day, and they still don’t know what’s going on- eventually just sent me to this thread. Surely they need a better solution.

  • speedgoat_33e3aa5689speedgoat_33e3aa5689 Posts: 3

    I have 2 user accounts (Private & Business) with admin rights on my MacBook running Mojave. Daz and the CMS were running fine on both account. After my motherboard died I had to rebuild my machine from a time machine backup. Since then I can't use the CMS any more. Always got the postgresql error after launching DAZ. It still works on my Business User Account but not on the private one. Uninstalling Studio and/or Postgresql does not help. Any idea what could be the issue here?

  • TotteTotte Posts: 14,056
    speedgoat_33e3aa5689 said:

    I have 2 user accounts (Private & Business) with admin rights on my MacBook running Mojave. Daz and the CMS were running fine on both account. After my motherboard died I had to rebuild my machine from a time machine backup. Since then I can't use the CMS any more. Always got the postgresql error after launching DAZ. It still works on my Business User Account but not on the private one. Uninstalling Studio and/or Postgresql does not help. Any idea what could be the issue here?

    I guess the cms was pointing to somewhere that is no longer the same location, so my best advice is to to a rebuild metadata operation on the CMS (is in the CMS menu in DS)

  • Richard HaseltineRichard Haseltine Posts: 102,301
    Totte said:
    speedgoat_33e3aa5689 said:

    I have 2 user accounts (Private & Business) with admin rights on my MacBook running Mojave. Daz and the CMS were running fine on both account. After my motherboard died I had to rebuild my machine from a time machine backup. Since then I can't use the CMS any more. Always got the postgresql error after launching DAZ. It still works on my Business User Account but not on the private one. Uninstalling Studio and/or Postgresql does not help. Any idea what could be the issue here?

    I guess the cms was pointing to somewhere that is no longer the same location, so my best advice is to to a rebuild metadata operation on the CMS (is in the CMS menu in DS)

    What about permissions (asks Rob)?

  • speedgoat_33e3aa5689speedgoat_33e3aa5689 Posts: 3
    Totte said:

    I guess the cms was pointing to somewhere that is no longer the same location, so my best advice is to to a rebuild metadata operation on the CMS (is in the CMS menu in DS)

    I recieve the same postgresql error message if I try to login, so I have the feeling that it is rather related to permissions?

  • TotteTotte Posts: 14,056
    speedgoat_33e3aa5689 said:
    Totte said:

    I guess the cms was pointing to somewhere that is no longer the same location, so my best advice is to to a rebuild metadata operation on the CMS (is in the CMS menu in DS)

    I recieve the same postgresql error message if I try to login, so I have the feeling that it is rather related to permissions?

    As Richard said, might be permission. Hmm, I answered that question with some pdfs (as you cannot give cmds in the forum). Now where was that?
    This is one thread: https://www.daz3d.com/forums/discussion/comment/3953536/

    here is another (for Mojave): https://www.daz3d.com/forums/discussion/288526/postges-cms-issue-on-studio-4-10-running-on-mojave-resolution/

     

Sign In or Register to comment.