Re: new installation help

[Vladimir Botka <..hidden..>]

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
> 


-- 
Dr.Vladimir Botka
..hidden..