postgres account on leopard 10.5.5 cannot remote login (ssh)

[gezeala@…]

i've successfully installed postgresql83, postgresql83-server and postgresql83-doc.

problem is i cannot add the postgres account created during install to Systems Preferences->Sharing->Remote Login->Allow access for: Only these users:. upon clicking the "+" sign to add accounts, the postgres account is not included in the Users & Groups list.

i can ssh postgres@hostname successfully if i select the "All users" though.

i need to be able to select specific users that are allowed for Remote Login (ssh).

[nox@…]

This is not a problem in the port, I don't think the postgres account should remote login right out of the box.

[gezeala@…]

Replying to nox@…:

This is not a problem in the port, I don't think the postgres account should remote login right out of the box.

i don't want remote login to be default for postgres also. but what i want is to be able to select specific users that are allowed for Remote Login (ssh).

if i issue the command "finger postgres" i can view the details for the postgres account. but if i go to Systems Preferences->Sharing->Remote Login->Allow access for: Only these users:. upon clicking the "+" sign to add accounts, the postgres account is not included in the Users & Groups list. why is this so? please explain further.

another thing is i can login to my macbook using the postgres account created during installation but how come "postgres" is not in the Users & Groups list.

[nox@…]

The postgres accound need to have a valid shell:

sudo dscl -create /Local/Default/Users/postgres UserShell /bin/bash

[gezeala@…]

Users & Groups - postgres account not listed

[gezeala@…]

Replying to nox@…:

The postgres accound need to have a valid shell:

sudo dscl -create /Local/Default/Users/postgres UserShell /bin/bash

Replying to 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.

[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.

[gezeala@…]

Replying to 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.

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..

[nox@…]

No, I haven't given it a password

[(none)]

Milestone Port Bugs deleted

[jmroot (Joshua Root)]

I’m pretty sure the account is not meant to be able to login. Maintainers, shall we just close this?

[jmroot (Joshua Root)]

Maintainer agreed via email.