#17051: postgres account on leopard 10.5.5 cannot remote login (ssh) ----------------------------------+----------------------------------------- Reporter: gezeala@gmail.com | Owner: mww@macports.org Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Resolution: | Keywords: postgresql Port: postgresql83-server | ----------------------------------+----------------------------------------- Comment(by gezeala@gmail.com): Replying to [comment:4 nox@…]:
The postgres accound need to have a valid shell: {{{ sudo dscl -create /Local/Default/Users/postgres UserShell /bin/bash }}}
Replying to [comment:4 nox@…]:
The postgres accound need to have a valid shell: {{{ sudo dscl -create /Local/Default/Users/postgres UserShell /bin/bash }}}
btw, default shell of postgres was '''/bin/sh'''. i can '''su - postgres''' from any of my mac accounts. i've set postgres' password, PATH etc with /bin/sh. i don't see how changing the shell of postgres will "list" it in the '''Users & Groups'''. {{{ mac02:~ gezeala$ sudo dscl . -read /Users/postgres AppleMetaNodeLocation: /Local/Default AuthenticationAuthority: ;ShadowHash; ;Kerberosv5;;postgres@LKDC:SHA1.D35E6A88B0061658842A202C43B6E60E8F19F307;LKDC:SHA1.D35E6A88B0061658842A202C43B6E60E8F19F307; GeneratedUID: 90D310B9-D592-480E-B945-528479EEABE3 NFSHomeDirectory: /opt/local/var/db/postgresql83 Password: ******** PrimaryGroupID: 500 RealName: postgres RecordName: postgres RecordType: dsRecTypeStandard:Users UniqueID: 500 UserShell: /bin/sh }}} then {{{ mac02:~ gezeala$ sudo dscl -create /Users/postgres UserShell /bin/bash }}} then {{{ mac02:~ gezeala$ sudo dscl . -read /Users/postgres AppleMetaNodeLocation: /Local/Default AuthenticationAuthority: ;ShadowHash; ;Kerberosv5;;postgres@LKDC:SHA1.D35E6A88B0061658841A202C43B6E60E8F19F307;LKDC:SHA1.D35E6A88B0061658841A202C43B6E60E8F19F307; GeneratedUID: 90D310B9-D592-480E-B945-528479EEABE3 NFSHomeDirectory: /opt/local/var/db/postgresql83 Password: ******** PrimaryGroupID: 500 RealName: postgres RecordName: postgres RecordType: dsRecTypeStandard:Users UniqueID: 500 UserShell: /bin/bash }}} still.. postgres account is not in '''Users & Groups'''. please do take note that '''i can ssh postgres@hostname successfully''' if i select the "'''All users'''" though. -- Ticket URL: <http://trac.macports.org/ticket/17051#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS