Re: Stock Debian Wheezy (stable) install troubles

[fmiser <..hidden..>]

> > 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users