[MacPorts] #17051: postgres account on leopard 10.5.5 cannot remote login (ssh)

[MacPorts]

#17051: postgres account on leopard 10.5.5 cannot remote login (ssh)
----------------------------------+-----------------------------------------
  Reporter:  gezeala at gmail.com    |       Owner:  mww at 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 at 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 at 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 at 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 at 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