postgresqui Cms Connection error all of sudden? Solved

IceDragonArtIceDragonArt Posts: 12,745
edited June 2019 in The Commons

I'm getting a valid postgreSQl Cms Connection error all of sudden for both my 4.10 version and my 4.11 beta.  Was working find yesterday, opened it up today and nada.  I've uninstalled and re installed via dim, same error.  Any suggestions?  (I'm leaving for a couple of hours but will check back as soon as I'm back).  If someone could tell me where those files are supposed to be going, I can make sure that they are in fact, there?  Edit, I had to redo all of the paths in DIM and once the paths were edited I had to redo eveyrthing in Studio to match those paths.  Not sure why installing a new version would change all of my paths?

Post edited by IceDragonArt on

Comments

  • FishtalesFishtales Posts: 6,210

    You may have had an update to virus softare or firewall and the internal port that postgres needs is being blocked. You will have to go in and add the port in Studio, Menu/edit/preferences/cms, to the white list of the virus/firewall software.

  • Saxa -- SDSaxa -- SD Posts: 880

    Seems to me I read not long ago you wrote about your Category Library breaking down more often as well?

    At the time, one thought I had was either your harddrive has physical issues (some die a slow death with increasing bad sectors).  CHKDSK or some hard-drive checker may not be a bad idea for peace of mind? to rule that out.  Also remember reading you had like 6TB of data?  That's like wow-huge.  Would ask DAZ support if there are any changes in config for PostgreSQL are necessary for such humungo database, or if there any known limits.

    I did have that not valid CMS connection once.  But that's when I changed location of my Daz data to a larger harddrive and I forgot to update all the file paths in DS and the DIM.  Sounds like DS either can't find anymore or recognize that file-path. 

  • IceDragonArtIceDragonArt Posts: 12,745
    Fishtales said:

    You may have had an update to virus softare or firewall and the internal port that postgres needs is being blocked. You will have to go in and add the port in Studio, Menu/edit/preferences/cms, to the white list of the virus/firewall software.

    Okay I tried this, it did not fix the problem

     

    Seems to me I read not long ago you wrote about your Category Library breaking down more often as well?

    At the time, one thought I had was either your harddrive has physical issues (some die a slow death with increasing bad sectors).  CHKDSK or some hard-drive checker may not be a bad idea for peace of mind? to rule that out.  Also remember reading you had like 6TB of data?  That's like wow-huge.  Would ask DAZ support if there are any changes in config for PostgreSQL are necessary for such humungo database, or if there any known limits.

    I did have that not valid CMS connection once.  But that's when I changed location of my Daz data to a larger harddrive and I forgot to update all the file paths in DS and the DIM.  Sounds like DS either can't find anymore or recognize that file-path. 

    My missing files is happening on two separate machines so I doubt its a corrupt drive (and I'm not the only one its happening to)

    I don't know how to make DS find or recognize the path.  I've looked at the files the cms files are where they are supposed to be.  (on my C Drive, although all of my  content is on a different drive, but its never been an issue before.) 

  • IceDragonArtIceDragonArt Posts: 12,745

    I'm kind of freaking out a little.  Just checked and it looks like Windows decided to do an upate.  Not sure if that has anything to do with anything but if it does. I don't even know how to fix it.  And I am have deadlines I need to meet.

     

  • Saxa -- SDSaxa -- SD Posts: 880
    edited June 2019

    Edit, I had to redo all of the paths in DIM and once the paths were edited I had to redo eveyrthing in Studio to match those paths.  Not sure why installing a new version would change all of my paths?

    See you edited your OP.  So you got it? Not a windows update thing? Well Great. :)  Would guess if you install new version to a slightly different directory it goes back to vanilla paths?  Otherwise don't know what to say.

    Post edited by Saxa -- SD on
Sign In or Register to comment.