I have both sl and lsmb running. Here is my pg_hba.conf
#TYPE DATABASE USER CIDR-ADDRESS METHOD
> local all postgres ident sameuser
> local all sql-ledger trust
> local all dt ident sameuser
> local all all md5
>
> host all sql-ledger 127.0.0.0/16 trust
> host all dt 127.0.0.0/16 ident sameuser
> host all all 127.0.0.0/16 md5
>
> host all all 10.0.0.0/8 md5
>
> host all all 192.168.0.0/16 md5
>
> host all all 0.0.0.0/0 md5
> host all all ::1/128 md5
>
On 9/12/07, Joseph <[EMAIL PROTECTED]> wrote:
>
> [snip]
> >
> > This worked as well, next in order to login I had to change
> > file:
> > pg_hba.conf to:
> > local all all md5
> > # IPv4 local connections:
> > host all all 127.0.0.1/32 md5
> >
> > at this point I can login but I can not create "dataset"
> > I think the password for "postgres" is getting encrypted where
> > as
> > originally it was set unencrypted.
> >
> >
> > change the auth types back to trust for a moment.
> > Then log in as postgres
> > run the following command:
> > ALTER USER postgres WITH PASSWORD '[secret]';
> >
> > Then change the auth types back to md5 (note that any change to the
> > pg_hba.conf requires restarting PostgreSQL.
> >
> > Best Wishes,
> > Chris Travers
> >
> How do I login as postgres, I've tried the following:
>
> # su postgres
> [EMAIL PROTECTED] /etc/apache2 $ ALTER USER postgres WITH PASSWORD
> '[secret]';
> bash: ALTER: command not found
>
> $ psql -U postgres
> psql: FATAL: database "postgres" does not exist
>
> --
> #Joseph
>
> -------------------------------------------------------------------------
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
--
The Last Great Frontier is in Your Mind
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
