Re: Almost done with manual for Gentoo - but need some help

[Joseph <..hidden..>]

OK, I still stuck.

I did:
edgersmb_db=# UPDATE users_conf SET password = md5('syscon') WHERE id = 1;
UPDATE 1
ledgersmb_db=# \q

# /etc/init.d/postgresql restart

But When I'm trying to login:
$ psql -U ledgersmb
Password:
psql: FATAL:  password authentication failed for user "ledgersmb"

I have in: pg_hba.conf
local   all         all                               md5
host    all         all         127.0.0.1/32        md5


I am always getting stuck on this part.

#Joseph



On Mon, 2007-09-17 at 18:15 -0700, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Joshua D. Drake wrote:
> > Joseph wrote:
> 
> >> ledgersmb_db=#
> > 
> >> At this point to change or setup password for this user "ledgersmb" and
> >> database "ledgersmb_db" do I type:
> >> UPDATE users_conf SET password = md5('MYPASSWORD') WHERE id = 1;
> > 
> > Wrong... use:
> > 
> > ALTER USER name WITH ENCRYPTED PASSWORD 'password';
> 
> Well I feel dumb... Sorry ;) I saw UPDATE users...
> 
> > 
> > Joshua D. Drake
> > 
> >> Do I need to type password within bracket and quotation: ('phrase') 
> > 
> 
> Yes you do... md5() is the function and the string must be passed quoted.
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> 
> > 
> > 
> 
> - -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 
> 
> 
> - --
> 
>       === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
> PostgreSQL solutions since 1997  http://www.commandprompt.com/
> 			UNIQUE NOT NULL
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFG7yauATb/zqfZUUQRAjieAJwPdQsnv+3KtRQ9W1X66BIFgTYZXACgrjhU
> n05XaF3iIX9TN/rgJa62nDU=
> =prLP
> -----END PGP SIGNATURE-----
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
-- 
#Joseph