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.
-- #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
