[GNUe] appserver setup and appserver_howto

[chafar]

Hello.

I'm trying to setup appserver. I'been able to run it earlier, but just
now I have some troubles. I'm following Sacha's howto and trying 
both last pre-release and svn tree.

I know virtually nothing about postgres, so it's extremely easy some big
mistake to follow.

1) isn't there an error in howto's pg_hba.conf sample line? It seems to
have an extra 'all' token.

2) indications in pg_hba.conf say that local access lines are used
whith connections made via unix sockets; so I suppose howto advise about
danger with that 'local' line if your machine is accesible on the net
is referred to have login access from outside. is this right?

3) appserver INSTALL includes an example of correct connections.conf
entry for appserver with host = localhost, this is the same that you
can find in default connections.conf; this line suggests that appserver
connection is made via net sockets, not unix sockets; my probes seem to
confirm that. is this right?

My probes have been as this: I've created gnue postgres user, with no
pw, and succesfully fed sample.gsd data. With an pg_hba.conf line like
this:

local      all                           trust

I can do this:

$ psql -U gnue gnue
gnue=# INSERT INTO gnue_useraccess (gnue_accesslist, gnue_id,\
gnue_password, gnue_username) values ('all',\
00000000000000000000001000000003, 'pepepw', 'pepe');
INSERT 45561 1

but when I try to run appserver, fails with:

FATAL 1:  IDENT authentication failed for user "gnue"

Instead, if I change to a line like this in pg_hba.conf:

host    all  127.0.0.1   255.0.0.0   trust

then appserver doesn't fail with IDENT error and, instead, psql client
fails with it.

Finally, I wonder if is there a way to do appserver connects to db
backend via unix sockets.

thanks.
-- 
José Esteban
Granada - Spain
http://alcances.net