On 9/10/07, Joseph <[EMAIL PROTECTED]> wrote:
>
> I have postgresql-8.0.13, so that should be OK.
>
> I'm just not that good working with postgresql: setting up users /
> databases etc.
Try dropping the --no-superuser option. If this works for you, I will
change the docs.
Unfortunately, there have been some 8.0 compatibility issues in the past and
this may be one of them :-)
Best Wishes,
Chris Travers
--
> #Joseph
>
> On Tue, 2007-09-11 at 03:51 +0200, Vladimir Botka wrote:
> > Hello!
> >
> > You need postgresql 8.x. lSMB 1.2.7 works for me with postgresql 8.2.
> >
> > Cheers,
> > -vlado
> >
> >
> > Dne Mon, 10 Sep 2007 19:15:41 -0600
> > Joseph <[EMAIL PROTECTED]> napsal(a):
> >
> > > I'm trying to give it a try and create new installation (currently
> > > still running sql-ledger).
> > >
> > > MANUAL INSTALL
> > > ==============
> > >
> > > 1) Untar went OK :-)
> > > Maybe I'm picky but it would be convenient to post complete set of
> > > instruction on what use suppose to type; it makes easier for newbies.
> > > eg.
> > > # chown apache:apache -R /usr/local/ledgersmb
> > >
> > > I can contribute installation instruction for "gentoo" but right now I
> > > got stuck on point #2
> > >
> > > 2.) Create a postgresql admin database role, by convention named
> > > 'ledgersmb':
> > > $ createuser --no-superuser --createdb --no-createrole -U postgres
> > > --pwprompt --encrypted ledgersmb createuser: unrecognized option
> > > `--no-superuser'
> > >
> > > createuser --help
> > > createuser creates a new PostgreSQL user.
> > >
> > > Usage:
> > > createuser [OPTION]... [USERNAME]
> > >
> > > Options:
> > > -a, --adduser user can add new users
> > > -A, --no-adduser user cannot add new users
> > > -d, --createdb user can create new databases
> > > -D, --no-createdb user cannot create databases
> > > -P, --pwprompt assign a password to new user
> > > -E, --encrypted encrypt stored password
> > > -N, --unencrypted do not encrypt stored password
> > > -i, --sysid=SYSID select sysid for new user
> > > -e, --echo show the commands being sent to the server
> > > -q, --quiet don't write any messages
> > > --help show this help, then exit
> > > --version output version information, then exit
> > >
> > > Connection options:
> > > -h, --host=HOSTNAME database server host or socket directory
> > > -p, --port=PORT database server port
> > > -U, --username=USERNAME user name to connect as (not the one to
> > > create) -W, --password prompt for password to connect
> > >
> > > Since I'm already running sql-ldeger I have user "postgres" on my
> > > system, though I'm not sure about the rest of the command:
> > > --pwprompt --encrypted ledgersmb
> > >
> > > Apology for the basic questions but postresql is not something I do on
> > > day to day basis, like most of us.
> > >
> > > There is a second part:
> > > If you prefer to work in postgresql's psql console, the equivalent SQL
> > > statement to create the ledgersmb role is:
> > >
> > > => CREATE ROLE ledgersmb LOGIN PASSWORD 'MYROLEPASSWORD' NOINHERIT
> > > CREATEDB;
> > >
> > > ==> is postgre prompt, isn't it?
> > > Shouldn't I type before: su postgres
> > >
> > > [EMAIL PROTECTED] /home/joseph $ CREATE ROLE ledgersmb LOGIN PASSWORD
> > > 'MYROLEPASSWORD' NOINHERIT CREATEDB; bash: CREATE: command not found
> > >
> >
> >
>
>
> -------------------------------------------------------------------------
> 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
>
-------------------------------------------------------------------------
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
