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

speedgoat_33e3aa5689

I'll check that tonight. Hope this tweak will work... Thanks guys :)

murgatroyd314

I had an issue that looked like this suddenly start after a crash a couple of weeks ago. I don't know if this'll help anyone else, but what eventually got it working was, in Studio, selecting "Stop CMS" from the menu (even though no CMS-related process was running, this was the essential step), followed by "Start CMS".

oomu

Murgatroyd said:

I had an issue that looked like this suddenly start after a crash a couple of weeks ago. I don't know if this'll help anyone else, but what eventually got it working was, in Studio, selecting "Stop CMS" from the menu (even though no CMS-related process was running, this was the essential step), followed by "Start CMS".

Thanks a lot !

it was just what I needed to do after a crash of the mac. I guess the DAZ Studio is still finding previously created temporary files by postgresql (like a "run.pid" file, indicating the service is running, or a socket file to connect to it) and have no solutions when the postgresql service is dead but temporary files were not cleaned properly.

ChrisAnderson

MyLa said:

Solved! This one helps me https://helpdaz.zendesk.com/hc/en-us/articles/207812393-PostgreSQL-Connection-Error-and-No-Smart-Content

 

I'm now on the latest version of Daz Studio 4.12 and uninstalling and reinstalling the PostgreSQL to changing the ports in preferences of Daz Studio as suggested with a restart has not helped to resolve this issue. And neither for many other users experiencing the same problem. And interesting to note that this has been an issue with all versions of Daz Studio for both Windows and Mac users and for any number of reasons there is no one simple fix. I'm done with this program and not happy to have spent money on some great content. 

Chris

fermihare

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

 

Thanks a lot !

I have solved my problem by your way ( DAZ stdio 4.12 for MAC ).

fermihare

ChrisAnderson said:

MyLa said:

Solved! This one helps me https://helpdaz.zendesk.com/hc/en-us/articles/207812393-PostgreSQL-Connection-Error-and-No-Smart-Content

 

I'm now on the latest version of Daz Studio 4.12 and uninstalling and reinstalling the PostgreSQL to changing the ports in preferences of Daz Studio as suggested with a restart has not helped to resolve this issue. And neither for many other users experiencing the same problem. And interesting to note that this has been an issue with all versions of Daz Studio for both Windows and Mac users and for any number of reasons there is no one simple fix. I'm done with this program and not happy to have spent money on some great content. 

Chris

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 have solved problem by this way, you can try it.

aecoleman1_8db1c3a285

Totte said:

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.

Thank you so much, Totte!  When I followed this suggestion, it revealed that the permissions for the CMS folder were set to root or system, not to my account. My account had the permissions for all the other folders. I made the change through Finder > Get Info, and Daz immediately started working again. Woo!  You are awesome!

pclarke

Seems the postgresql that comes with Daz isn't supported on OSX Catalina?

 

“pgAdmin3.app” needs to be updated.

The developer of this app needs to update it to work with this version of macOS. Contact the developer for more information.

 

Any ideas?

Totte

pclarke said:

Seems the postgresql that comes with Daz isn't supported on OSX Catalina?

 

“pgAdmin3.app” needs to be updated.

The developer of this app needs to update it to work with this version of macOS. Contact the developer for more information.

 

Any ideas?

pgAdmin is just a user tool that "has to be shipped with postgres, opn source licenses" but it has nothing to do with the actual database backend functionllity.  So, nothing to worry about at all as you re not supposed to fiddle in the CMS db anyway.

gstelmack

Murgatroyd said:

I had an issue that looked like this suddenly start after a crash a couple of weeks ago. I don't know if this'll help anyone else, but what eventually got it working was, in Studio, selecting "Stop CMS" from the menu (even though no CMS-related process was running, this was the essential step), followed by "Start CMS".

so where is that "start CMS" in the menu. what menu. looked everywhere in studio. 

fixmypcmike

gstelmack said:

Murgatroyd said:

I had an issue that looked like this suddenly start after a crash a couple of weeks ago. I don't know if this'll help anyone else, but what eventually got it working was, in Studio, selecting "Stop CMS" from the menu (even though no CMS-related process was running, this was the essential step), followed by "Start CMS".

so where is that "start CMS" in the menu. what menu. looked everywhere in studio. 

Options menu on the Content Library or Smart Content tabs.