On 9/10/07, Joseph <..hidden..> 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 <..hidden..> 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
> >
> > ..hidden.. /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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users