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

["Joshua D. Drake" <..hidden..>]

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