Loading...
> >

PostgreSQL CMS Connection on a Mac

124

Comments

  • The ManagementThe Management Posts: 227

    Thanks for replying.

    One other thing to note: I have macbook with the same imaged drive on it. I don't use DS on it but when I started it has the same problem and nothing has changed on that drive.

    I have a PC and it works fine with DS CMS. All my machines web acsess is through the same Arris router service provider is Comcast. Not sure if that helps.

    What do you have in log.txt from DAZ Studio at the same time?

     

    Here's what the log says

    2021-03-27 14:05:41.447 Iray [INFO] - IRAY:RENDER ::   1.0   IRAY   rend progr: Received update to 00024 iterations after 15.403s.
    2021-03-27 14:05:42.701 Iray [INFO] - IRAY:RENDER ::   1.0   IRAY   rend progr: Received update to 00026 iterations after 16.657s.
    2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): curl_easy_perform(https://hpclscruffy.daz3d.com/Customer/authenticate) failed: SSL connect error
    2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): Communication to server failed.
    2021-03-27 14:05:43.957 Iray [INFO] - IRAY:RENDER ::   1.0   IRAY   rend progr: Received update to 00028 iterations after 17.913s.
    2021-03-27 14:05:45.230 Iray [INFO] - IRAY:RENDER ::   1.0   IRAY   rend progr: Received update to 00030 iterations after 19.186s.
    2021-03-27 14:05:47.093 Iray [INFO] - IRAY:RENDER ::   1.0   IRAY   rend progr: Received update to 00033 iterations after 21.049s.

     

  • TotteTotte Posts: 14,045

    Hi,

    <span style="background-color:rgb(242, 244, 246); color:rgb(34, 42, 48)">2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): curl_easy_perform(</span><a href="https://hpclscruffy.daz3d.com/Customer/authenticate"; target="_blank">https://hpclscruffy.daz3d.com/Customer/authenticate</a><span style="background-color:rgb(242, 244, 246); color:rgb(34, 42, 48)">) failed: SSL connect error</span><br /> <span style="background-color:rgb(242, 244, 246); color:rgb(34, 42, 48)">2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): Communication to server failed.</span>
    do you have a firewall blocking https://hpclscruffy.daz3d.com/Customer/authenticate? 

     

     

  • The ManagementThe Management Posts: 227

    Richard Haseltine said:

    Is the issue with the CMS services in DS, or a failed PostgreSQL cionnection at launch, or is it just installation? If it's installation why not just use DIM until the account issue can be resolved?

     I have been using DIM for months now and just am sick of CMS not working and it's about time to track this down. I have too much content to keep track of through DIM.

    Maybe these screen shots may help?

    Screen Shot 2021-03-27 at 4.20.03 PM.jpg
    4471 x 1254 - 420K
    Screen Shot 2021-03-27 at 3.18.40 AM.jpg
    1918 x 849 - 215K
  • The ManagementThe Management Posts: 227

    Totte said:

    Hi,

    2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): curl_easy_perform(https://hpclscruffy.daz3d.com/Customer/authenticate) failed: SSL connect error
    2021-03-27 14:05:42.861 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): Communication to server failed.
    do you have a firewall blocking https://hpclscruffy.daz3d.com/Customer/authenticate? 

     

     

    I don't think so?

    How do I check that? 

  • The ManagementThe Management Posts: 227
    edited March 2021

    I have also had 3 versions of DS on my system 4.10, 4.12, 4.15.

    After the lastest reinstall of DS and PostgreSQL, now I have only V 4.15.

    Not sure if that matters.

    Post edited by The Management on
  • Richard HaseltineRichard Haseltine Posts: 102,252

    Logging in to your Daz account is not related to ciommunicating with PostgreSQL/smart content.

  • TotteTotte Posts: 14,045

    There is one thing, if for some reason DS cannot find your Connect folder, it will report the CMS not working, maybe the same thing happens on a failed login, not sure though, but could be related.

  • The ManagementThe Management Posts: 227
    edited March 2021

    Maybe my problem is not CMS and It's that I can't login to Daz on Mac?

    On PC I can login and I see the most resent content that I bought just the other day under Products Tab and I was able to Install it.

    Attached is the dblog.txt from my PC. In comparing the Mac and PC versions the first thing that stood out to me is:

    PC- has my first and last name correctly.

    Mac- has only my first name, no last name at all. (My Mac user name is just first name, PC uses first and last)

    Perhaps, my Mac is looking for a nolonger existing daz server?

    I do all my work on Mac and the PC is just a test case, PC is just for games.

    I turned Firewall off on Mac and still can't login.

    I need my Mac to work and I can't figure it out.

     

    Post edited by The Management on
  • The ManagementThe Management Posts: 227

    One more thing about login.

    Richard asked about this:

    I clicked the EULA link and it said 'Failed to obtain the end-user license agreement (Unable to obtain end-user license agreement from the server). Screenshot attached.

    Although, I'm sure I must have agreed to the EULA a long time ago. 

  • The ManagementThe Management Posts: 227

    Richard Haseltine said:

    Logging in to your Daz account is not related to ciommunicating with PostgreSQL/smart content.

    I thought the PostgreSQL was for logging in? My bad.

    Is there something that can be done about my inability to login?

    Why can I login on PC but not Mac?

    On Mac, in DS, at the top, Connect /my account/ my cart/ my wishlist/ my gallery all work fine.

    Just no login.

    Below and attached is log text comparing my Mac DS statup to PC

     

    MAC

    2021-03-27 23:41:36.133 Executing startup script...

    2021-03-27 23:41:44.419 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): curl_easy_perform(https://hpclscruffy.daz3d.com/Customer/authenticate) failed: SSL connect error

    2021-03-27 23:41:44.419 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): Communication to server failed.

    2021-03-27 23:41:44.450 Started in: /Applications/DAZ 3D/DAZStudio4 64-bit

    2021-03-27 23:41:44.451 DAZ Studio Started

    2021-03-27 23:41:44.451 Creating Pixel Buffer

    2021-03-27 23:41:44.451 Pixel buffer - Width: 1024 Height: 1024

    2021-03-27 23:41:44.451 Compiling OpenGL Shader...

    2021-03-27 23:41:44.454 Fragment Shader:

    Fragment Shader compiled successfully.

    Linking Shader:

    Shader Program successfully linked.

     

    2021-03-27 23:42:30.110 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): curl_easy_perform(https://hpclscruffy.daz3d.com/Eula/get_eula.json) failed: SSL connect error

    2021-03-27 23:42:30.111 WARNING: /src/sdksource/cloud/dzcloudtasknotifier.cpp(178): TaskGetEula failed, url: https://hpclscruffy.daz3d.com/Eula/get_eula.json

    2021-03-27 23:59:06.972 WARNING: Object::connect: No such signal DzRSLTextEdit::clicked(int,int)

    2021-03-28 00:04:11.022 WARNING: /src/sdksource/interface/dzviewportmgr.cpp(1620): Unmatched call to DzViewportMgr::endManipulation()!

    ——————————————————————————————————————————————————————————————————————————————

    PC

    2021-03-27 23:53:55.667 Executing startup script...

    2021-03-27 23:53:55.744 Started in: C:/Daz 3D/Applications/64-bit/DAZ 3D/DAZStudio4

    2021-03-27 23:53:55.744 DAZ Studio Started

    2021-03-27 23:53:55.745 Creating Pixel Buffer

    2021-03-27 23:53:55.828 Pixel buffer - Width: 1024 Height: 1024

    2021-03-27 23:53:55.832 Compiling OpenGL Shader...

    2021-03-27 23:53:55.841 Fragment Shader:

    Fragment Shader compiled successfully.

    Linking Shader:

    Shader Program successfully linked.

     

    2021-03-27 23:54:12.468 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(660): sync completed successfully, 3 items succeeded, 0 items failed.

    2021-03-27 23:54:12.469 Metadata update succeeded.

    2021-03-27 23:56:53.735 Updated metadata for 0 of 1 items.

    2021-03-27 23:56:54.373 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(660): sync completed successfully, 1 items succeeded, 0 items failed.

    2021-03-27 23:56:54.373 Metadata update succeeded.

  • TotteTotte Posts: 14,045

    It looks like you fail to access https://hpclscruffy.daz3d.com/ from your mac, let's focus on solving that and the rest will follow.

    We start with 

    ping hpclscruffy.daz3d.com

    open the terminal and type that and hit return, you should see something like:

    64 bytes from 104.18.222.105: icmp_seq=0 ttl=58 time=12.067 ms64 bytes from 104.18.222.105: icmp_seq=1 ttl=58 time=10.302 ms64 bytes from 104.18.222.105: icmp_seq=2 ttl=58 time=13.447 ms

    and not :
     

    Request timeout for icmp_seq 0Request timeout for icmp_seq 1

     

  • The ManagementThe Management Posts: 227

    Yes, I got this:

    Last login: Sat Mar 27 06:24:11 on ttys000

    You have mail.

    iMac2016:~ Bob$ ping hpclscruffy.daz3d.com

    PING hpclscruffy.daz3d.com (104.18.221.105): 56 data bytes

    64 bytes from 104.18.221.105: icmp_seq=0 ttl=59 time=15.923 ms

    64 bytes from 104.18.221.105: icmp_seq=1 ttl=59 time=16.333 ms

     

  • TotteTotte Posts: 14,045


    Then it do look like it  really fails to log in to your DAZConnect Account for some reason.
    Have you checked and doublechecked you passwords?

  • Richard HaseltineRichard Haseltine Posts: 102,252

    To want extent is it remembering you between session and to what extent are you entering the details (email and password) afresh? If it's using store details, even if you then overtype them, try clearing the remember me/automatically check in boxes (you may need to Work offline and then connect to get access to the dialogue), close DS, and restart then try connecting again. Of course you may well have done this already.

  • The ManagementThe Management Posts: 227

    It seems no matter what I try to do in the welcome screen (uncheck Remember Me and or Automatically Login, delete my email and password) they always repopulate.

    If I quit, check Work Offline, anytime I come back to the Welcome screen all boxes are checked and filled.

    It sems DS won't release my info.? 

    Is there a file where that info is kept?

  • Richard HaseltineRichard Haseltine Posts: 102,252

    Daz Studio>Preferences has the author information, but that isn't used by the connection dialogue as far as I know. I'm not sure where the values are stored, and I'm not immediately seeing a way to access (let alone clear) them via scripting.

  • TotteTotte Posts: 14,045

    First, in ~/Application Support/DAZ 3D/Studio 4/ is a file called cloudLog.txt, that might give hints

     

  • The ManagementThe Management Posts: 227
    edited March 2021

    There seems to be a bunch of connection lines in the cloudlog.txt

    I'm not sure what part is important. I shortened duplicate lines as best I could, so I'll post some of it.

    I changed the / to # , - to $ , : to % hoping daz will let me post this without rejection.

    Not sure I can post this, it's giving me problems thinking I'm trying to hack the site....

    Is there some line that I can look for?

     

    Ok, Looks like I was able to post some of this.

    Can you make anything out of it?

     

     

     

     

    Post edited by The Management on
  • The ManagementThe Management Posts: 227

    2021$03$28T00%35%50Z Unexpected exception in categoryGetRoot% could not connect to server% Connection refused

        Is the server running on host "localhost" (%%1) and accepting

        TCP#IP connections on port 5432?

    could not connect to server% Connection refused

        Is the server running on host "localhost" (fe80%%1) and accepting

        TCP#IP connections on port 5432?

    could not connect to server% Connection refused

        Is the server running on host "localhost" (127.0.0.1) and accepting

        TCP#IP connections on port 5432?

  • The ManagementThe Management Posts: 227

    2021$03$28T03%36%16Z Startup

    2021$03$28T03%36%28Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$28T03%36%28Z Communication to server failed.

    2021$03$28T03%36%45Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$28T03%36%45Z Communication to server failed.

    2021$03$28T03%41%12Z Shutdown

    2021$03$29T06%42%53Z Startup

    2021$03$29T06%43%05Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$29T06%43%05Z Communication to server failed.

    2021$03$30T00%28%44Z Shutdown

  • The ManagementThe Management Posts: 227

    2021$03$27T10%11%03Z Startup

    2021$03$27T10%11%15Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$27T10%11%15Z Communication to server failed.

    2021$03$27T10%11%32Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$27T10%11%32Z Communication to server failed.

    2021$03$27T10%11%41Z Shutdown

  • The ManagementThe Management Posts: 227

    2021$03$27T10%09%32Z Startup

    2021$03$27T10%09%34Z Unexpected exception in getAllAccounts% Unable to connect to the database, can not quote

    2021$03$27T10%09%34Z Unexpected exception in categoryGetRoot% Unable to connect to the database

    2021$03$27T10%09%35Z Unexpected exception in categoryGetRoot% Unable to connect to the database

    2021$03$27T10%09%35Z Unexpected exception in contentFilterPathsToCloudInstalledContent% Unable to connect to the database

    2021$03$27T10%09%35Z Unexpected exception in categoryGetRoot% Unable to connect to the database

    2021$03$27T10%09%36Z Unexpected exception in categoryGetRoot% Unable to connect to the database

    2021$03$27T10%09%36Z Unexpected exception in CloudFIle%%lookupFromDb% Unable to connect to the database

    2021$03$27T10%09%36Z Unexpected exception in contentGetBySubdir% Unable to connect to the database, can not quote

    2021$03$27T10%09%38Z Unexpected exception in CloudFIle%%lookupFromDb% Unable to connect to the database

    2021$03$27T10%09%38Z Unexpected exception in CloudFIle%%lookupFromDb% Unable to connect to the database

    2021$03$27T10%09%38Z Unexpected exception in needMigrate% Unable to connect to the database, can not quote

    2021$03$27T10%09%38Z Unexpected exception in runNextTask$runTask% Unable to connect to the database

    2021$03$27T10%09%38Z Unexpected exception in contentFilterPathsToCloudInstalledContent% Unable to connect to the database

    2021$03$27T10%09%38Z Unexpected exception in contentFilterPathsToCloudInstalledContent% Unable to connect to the database

    2021$03$27T10%09%45Z curl_easy_perform(https%##hpclscruffy.daz3d.com#Customer#authenticate) failed% SSL connect error

    2021$03$27T10%09%45Z Communication to server failed.

  • The ManagementThe Management Posts: 227

    2021$03$27T09%59%30Z Unexpected exception in categoryGetRoot% could not connect to server% Connection refused

        Is the server running on host "localhost" (%%1) and accepting

        TCP#IP connections on port 17237?

    could not connect to server% Connection refused

        Is the server running on host "localhost" (fe80%%1) and accepting

        TCP#IP connections on port 17237?

    could not connect to server% Connection refused

        Is the server running on host "localhost" (127.0.0.1) and accepting

        TCP#IP connections on port 17237?

  • TotteTotte Posts: 14,045

    The Management said:

    There seems to be a bunch of connection lines in the cloudlog.txt

    I'm not sure what part is important. I shortened duplicate lines as best I could, so I'll post some of it.

    I changed the / to # , - to $ , : to % hoping daz will let me post this without rejection.

    Not sure I can post this, it's giving me problems thinking I'm trying to hack the site....

    Is there some line that I can look for?

     

    Ok, Looks like I was able to post some of this.

    Can you make anything out of it?

     

     

     

     

    ah, the hacker shield, best way it to make a pdf and upload that. 

  • The ManagementThe Management Posts: 227

    Ok. Here's a PDF, I took out 55 pages of duplicate lines.

    This is only 4 pages.

    pdf
    pdf
    cloudLog.pdf
    18K
  • TotteTotte Posts: 14,045

    ok, still the most important key is:

    2021-03-27T09:57:13Z Startup
    2021-03-27T09:57:26Z curl_easy_perform(https://hpclscruffy.daz3d.com/Customer/authenticate) failed: SSL connect error 2021-03-27T09:57:26Z Communication to server failed.
    2021-03-27T09:57:43Z curl_easy_perform(https://hpclscruffy.daz3d.com/Customer/authenticate) failed: SSL connect error 2021-03-27T09:57:43Z Communication to server failed.

    Now, if someone could figure out where that information is hidden. I know I helped someone with that, to figure out which settings file the username/password was saved in... 

     

     

  • The ManagementThe Management Posts: 227
    edited March 2021

    One other thing.

    My Mac systems (iMac, Macbook) all are imaged from the same backup HD, it had DS working when I limaged the drives. I used to run my system off this backup as it was my internal iMac drive. When I got a new SSD I imaged the HD to the SSD, and Macbook and started using the SSD as the internal main drive. Everything was working fine for a couple of years. When Daz did their server change, my problem connecting started.

    Now I have tried testing my original HD, that has been sitting in a drawer and it also cannot connect, also neither can my Macbook and I never used DS on the Macbook.

    So I have two drives that had no daily operational use and now they both can't connect.

    All 3 drives have the same problem.

    Tonight I decided to try my old MacPro Tower running os 10.7. This machine at one time had DS installed but I must have uninstalled it as in those days I used Poser.

    I installed a fresh copy of DS 4.10 and to my surprise IT CONNECTED!!! Weeeeeeeee! Used all my exact same info.

    I have attached the log, dblog, and cloud log of both the non working iMac and the working MacPro for compareson. Maybe that will help? I hope.

    One thing I noticed, the working MacPro has no lines connecting to hpclscruffy.daz3d.com.

    pdf
    pdf
    Compare cloudlog1.pdf
    65K
    pdf
    pdf
    Compare dblog1.pdf
    42K
    pdf
    pdf
    iMac log mac DOES NOT WORK.pdf
    601K
    pdf
    pdf
    MacPro log WORKS.pdf
    260K
    Post edited by The Management on
  • TotteTotte Posts: 14,045
    edited March 2021

    OK, here I think you can solve the issue.

    in ~/Library/Preferences/ locate the file com.daz.Studio4.plist

    Open with BBEdit or TextWrangler and locate these entries (search for Authentication.Id or Authentication.AutomaticallyLogin)
     

       &lt;key&gt;Authentication.AutomaticallyLogin&lt;/key&gt;    &lt;false/&gt;    &lt;key&gt;Authentication.Id&lt;/key&gt;    &lt;string&gt;## SOME ENCRYPTED STRING ##&lt;/string&gt;    &lt;key&gt;Authentication.Id2&lt;/key&gt;    &lt;string&gt;## SOME ENCRYPTED STRING ##&lt;/string&gt;    &lt;key&gt;Authentication.RememberMe&lt;/key&gt;    &lt;true/&gt;



    Replace that with 

        &lt;key&gt;Authentication.AutomaticallyLogin&lt;/key&gt;    &lt;false/&gt;    &lt;key&gt;Authentication.RememberMe&lt;/key&gt;    &lt;false/&gt;


    save the file, start DS, now it wont try to login to connect anymore and failing.

     

     

     

    Post edited by Totte on
  • The ManagementThe Management Posts: 227

    My file doesn't look anything like what you're showing.

    The Authentication lines are there but nothing following them seems correct.

    Could you please point it out to me? I have attached the file.

    pdf
    pdf
    com.daz.Studio4.pdf
    97K
  • TotteTotte Posts: 14,045

    What program did you open with?
    You need to use TextWranger or BBEdit or another application that can open zipped plist files.

Sign In or Register to comment.