PostgreSQL opacity and error

djfilms_d40a8287d1

I'm trying to set up Daz Studio. It installs, and when I open it, it says it can't connect to CMS PostgreSQL. I followed a link whiich listed many users seeing this error. Most were on Windows, but Iam on Mac OSX 13. I used DIM to install a version of PostgreSQL (see screenshot). But after starting DS I still get the error message. So..

Can any clever soul tell me how  to get PostgreSQL working on a Mac in DS in DazStudio 4.22? Any assistance gratefully received.

ADDENDUM: I built training centres for multiple companies, and I NEVER encountered a competent easy-to-use CMS. NEVER. One simple reason: they are too compicated. It just needs a cheesy relational database. Filemaker  and other rograms can to that in their sleep. SQL is overkill for the needs of Daz Studio.

Totte

The problem is usaully that Postgres wants no one else to be able to access its files (security reasons) and Apple recently (macOS 11 )changed the security settings so that files user/Library/Application Support should be readable by group and world.

i can give give you some info later, when at my Mac., but basically it's about creating the directory needed with the right protection flags 

Totte

First, the cms db, even though it's a postgres server, is not fast enough when you have 15k + installed producrts, so using something as slow as filemaker could never be an option. 15k+ products with in average 100 files/product gives you about 1.5 million records.  Every database have a drop off point from where the indices needs to be split into a second or third level, and it'd there it starts to take time.  I wrote my first software using databases as an internship back in 1982 using RegISAM800 (  it was developed by Allan and Monty that many years later develped RegLisp-ISAM, that then later evolved into MySQL)

OK, back to the actual problem.
The cms folder is located in ~/Library/Application Support/DAZ 3D and is called cms

If you check in studio under preferences, under CMS Settings, you see the path (but expanded from your user), ending with the folder cms

If there is no cms folder:
if you create that folder and set the privs to "user read/write/execute but not grp or wrld, then click on the start cms button.

If there is a cms folder:
if you click the start.cms button does it start?

One thing that causes the CMS not found error is if the DAZConnect diretory cannot be found, as DAZConnect relies on the cms,. and if that directory cannot be found (DAZConnect fails, and when it fails, it is interpreted as the cms was not responding)

Check this and reply back.

djfilms_d40a8287d1

Totte,

Many thanks for takiing the time to reply, and clarifying the set-up. This is much appreciated. You should be hired by DAZ to prvide clear documentation. I am away from my main machine at the moment, but I will try as you suggest, since the steps are clear.  Best regards, David

PS: Noted about Filemaker limitation for large number of records! :-)

djfilms_d40a8287d1

Totte, Alas, I need to drink at the fountain of your knowledge a bit more. I used your suggesitons and here is the status:

 

1. There was a cms folder in the correct place  (app support>Daz3D>cms folder)

2. All folders set to editable by me using the get info in the finder.

3. In DAZStudio, I selected Preferences and clicked on the CMS settings tab. A pop-up allowed me to choose the correct path ((app support>DAZ3D>cms). The port defaiults to 1024. Iclick APPLY and then ACCEPT and the dialog box closes. If I immediately choose DAZ preferences again to bring up the dialog box, the path is empty, impying it did not be properly assigned?  I'm stuck there.

Any enlightenment gratefully received.

best regards, David