#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: High | Milestone: Port Bugs Component: ports | Version: 1.6.0 Resolution: | Keywords: postgresql Port: postgresql83-server | ----------------------------------+----------------------------------------- Changes (by nox@macports.org): * cc: nox@macports.org (added) Comment: This is not a problem in the port, I don't think the postgres account should remote login right out of the box. -- Ticket URL: <http://trac.macports.org/ticket/17051#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS

#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: High | Milestone: Port Bugs Component: ports | Version: 1.6.0 Resolution: | Keywords: postgresql Port: postgresql83-server | ----------------------------------+----------------------------------------- Comment(by nox@macports.org): The postgres accound need to have a valid shell: {{{ sudo dscl -create /Local/Default/Users/postgres UserShell /bin/bash }}} -- Ticket URL: <http://trac.macports.org/ticket/17051#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS

#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

#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:7 nox@…]:

I've never played with the postgres accound. Mine did not have a valid shell to begin, thus preventing login entirely. When I added the UserShell key, the postgres account showed up in the '''Users & Groups''' panel. Weird. [[BR]]

hmmm. that's odd. i can '''su - postgres''' right after install. anyway may i ask if you've set a password for postgres account? i "googled" this problem a lot and some suggested to set password to default *. i've set postgres' password since i ssh from another pc.. -- Ticket URL: <http://trac.macports.org/ticket/17051#comment:8> MacPorts <http://www.macports.org/> Ports system for Mac OS