> > fmiser wrote: > > > > I'm having troubles with what I think should be a simple, stock > > install on Debian Wheezy using the default Wheezy package > > (1.3.18-2). > > > > I can't seem to setup a database!
> Robert wrote: > > That's coming up because 'testDB' is not actually a LedgerSMB > database; it's an artifact of what has been used as part of the > automatic setup of the LedgerSMB DB administrator (which doesn't > work properly, which is why that's defaulted not to be run). Your saying I should run the debian install script? > Use some other name for the first LedgerSMB database you're > creating. > The LedgerSMB Debian package is defaulted to use the name > 'ledgersmb' for the LSMB Database user to keep that separate from > the the PostgreSQL system and database user 'postgres'. To > properly configure the ledgersmb db admin user, you could use the > following SQL: > > ALTER ROLE ledgersmb WITH SUPERUSER LOGIN NOINHERIT ENCRYPTED > PASSWORD 'newpassword'; Sweet! That works. I'm still puzzled as to why using 'postgres' and it's password didn't work. But I got a database created, so I'm not going to try too hard to figure it out. :) Now I just have to figure out what I want to do different than my existing SQL-Ledger 2.6. ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
