*** SachaS has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
<johannesV> good morning
*** dimas_ has quit IRC
*** dimas_ has joined #gnuenterprise
<reinhard> :q
<reinhard> oops
<reinhard> bbl
*** reinhard has quit IRC
*** johannesV_ has joined #gnuenterprise
*** johannesV has quit IRC
*** jamest has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** llp has joined #gnuenterprise
*** ncjp has quit IRC
*** chillywi1ly has joined #gnuenterprise
*** ncjp has joined #gnuenterprise
*** chillywilly has quit IRC
*** klasstek has joined #gnuenterprise
*** SachaS has quit IRC
*** chillywi1ly is now known as chillywilly
*** jcater has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** llp has quit IRC
*** derek has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** llp has joined #gnuenterprise
*** curt has joined #gnuenterprise
<curt> I am using 0.4.3-1 (debian package install) .. gnue-schema --connection=gnue --createdb gnue.gsd asks for password twice (in a shell with user postgres) .. It creates the user gnue just fine .. then it asks for password again and fails with 'Readgsd: FATAL:  Password authentication failed for user "gnue"' .. it creates the database gnue but it is empty.
<curt> sh-3.1$ gnue-setupdb
<curt> You are about to create the new database 'gnue'. Continue [y,N]: y
<curt> Password:
<curt> Password:
<curt> CREATE USER
<curt> Password:
<curt> CREATE DATABASE
<curt> readgsd: FATAL:  Password authentication failed for user "gnue"
<curt> For help, type: readgsd --help
<curt> sh-3.1$ pwd
<curt> /usr/share/gnue/appserver
<curt> sh-3.1$ whoami
<curt> postgres
<reinhard> curt: hi
<reinhard> curt: give me a second please
<curt> reinhard, no problem, I'm just idling around here anyway .. checking back periodically.
<reinhard> hmmm
<reinhard> the second password is for the "gnue" user
<reinhard> depending on your postgres security policy, you might want to add a "password = ...." line to connections.conf under [gnue]
<reinhard> :
<reinhard> first login to db is to create new user gnue
<reinhard> second login to db is already with that new user, so the tables are created with an owner of "gnue"
<reinhard> if you want the db user to be a different one, add a "user = ..." line to connections.conf
<curt> in /etc/gnue/connections.conf I added password = gnue and I get 'Password authentication failed for user "postgres"' when I use 'gnue' for the third pass. I added user = postgres thinking I could use the existing pass for all three but oddly enough I get 'Password authentication failed for user "gnue"' .. must not be reading user = postgres .. I would guess that it's not reading password = gnue either then.
<reinhard> hmm damn
<reinhard> there was a bug with reading username and password from connections.conf at some point
<reinhard> maybe debian still has that old version
<reinhard> your machine is open for access from others?
<reinhard> for testing I always allow passwordless connecting to postgres, as it saves all that trouble with the passwords
*** derek__ has joined #gnuenterprise
<reinhard> For the quick and dirty "full access" configuration, edit the file
<reinhard> /etc/postgresql/pg_hba.conf and set host, db or user to 'trust'.
<reinhard> To grant 'trusted' (full) access from the local host add a line like:
<reinhard>   host  all  all  127.0.0.1     255.255.255.255  trust
<reinhard> (this is the "get this damn thing work, no matter how" way)
*** derek__ has quit IRC
<reinhard> other possibility would be to create the db and the user manually in postgres
<reinhard> and then run the gnue-readgcd command manually with --user and --password options (which IIRC worked in the buggy version)
<reinhard> must run, hopefully somebody else can help you if you have further problems
<reinhard> otherwise I'll be back here tomorrow
<reinhard> cu
*** reinhard has quit IRC
*** deke has joined #gnuenterprise
*** deke has quit IRC
*** deke has joined #gnuenterprise
*** deke has quit IRC
*** deke has joined #gnuenterprise
*** deke has quit IRC
*** deke has joined #gnuenterprise
*** deke has quit IRC
*** deke has joined #gnuenterprise
*** deke has quit IRC
*** btami has quit IRC
*** johannesV_ has quit IRC
*** deke has joined #gnuenterprise
*** jamest has quit IRC
*** derek has quit IRC
*** sjc has joined #gnuenterprise
*** SachaS is now known as SachaZzzz
*** jcater has quit IRC
*** deke is now known as derek
*** klasstek has quit IRC
*** derek has quit IRC
*** sjc has quit IRC
*** holycow has joined #gnuenterprise
*** holycow has left #gnuenterprise
*** derek has joined #gnuenterprise
*** bigbrother` has quit IRC
*** bigbrother` has joined #gnuenterprise
*** llp has quit IRC