Interesting. Do you know what user PostgreSQL is running as?
Best Wishes,
Chris Travers
On 4/11/07, Peter Houppermans <[EMAIL PROTECTED]> wrote:
>
> It appears that the default postgres user is not set in the Fedora Core 6
> installation, or I may have made a mistake somewhere. However, maybe adding
> this to the INSTALL file will by default make sure it doesn't get left to
> chance, I've put everything in there what I either dug out or what Chris
> told me.
>
> All in my efforts to make the LSMB install 'me' proof - it's then less
> likely to confound other SME/SMB users as well :-)
>
> /// P ///
>
>
> Checking PostgreSQL setup.
> ==========================
>
> A: (re)setting password for 'postgres' database user
> ----------------------------------------------------
>
> If it's a new installation it is possible that the password for the
> "postgres" database user is unknown (this is different to the SYSTEM user
> 'postgres' which can be simply set with 'passwd postgres' from the root
> prompt). How to (re)set that password (replace "my_password" with a
> suitably strong password):
>
> (1) locate the file pg_hba.conf. In Fedore Core 6 this is in
> /var/lib/pqsql/data
> (2) add the line "local all all trust" to the top of the file and save
> (3) reload or restart PostgreSQL ("/etc/init.d/postgresql reload")
> (4) set the password for the "postgres" user:
>
> [EMAIL PROTECTED] ~]# su postgres
> bash-3.1$ psql -d template1
> template1=# ALTER USER postgres WITH PASSWORD 'my_password';
> template1=# \q <= exit
> bash-3.1$ exit
>
> (5) open pg_hba.conf again
> (6) remove the "locall all all trust" line and save.
>
> B. Checking authentication method
> ---------------------------------
> Both OpenSuSE and Fedore (and maybe other distros) use the 'ident'
> authentication which needs changing:
>
> (1) locate the file pg_hba.conf. In Fedore Core 6 this is in
> /var/lib/pqsql/data
> (2) find the line starting with "local all all" - it is likely to contain
> the word 'ident'
> (3) change it so it reads "local all all md5 sameuser" and save the file
> (4) reload or restart PostgreSQL ("/etc/init.d/postgresql reload")
>
> -----------X8----- cut here ------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ledger-smb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
