Fwd: Teething problem after upgrade from sql-ledger

["Topper Doggle" <..hidden..>]

Forwarding to list again - no response first time, just wondering if I
can get a bite this time.  If I get no response this time, I shall not
send the message again.

================================

Hi,

Have just upgraded from sql-ledger 2.6.25 to ledgersmb 1.2.11.  Have
tried a few times in the past, but never had the time to battle
through the jungle.
But it now seems to work - thanks to the ledgersmb team for their work.

My only remaining issue is to do with database permissions.  I created
a fresh ledgersmb database to store user info, then created a user
that could access a database called ledgersmb-mycompany, which was my
sql-ledger database after going through the migration scripts.

I can login as the user no problem, and all looks fine.  However, it only
works when my ledgersmb postgresql user is a superuser.  If he is not a
superuser, I get:

LedgerSMB/User.pm:206
SELECT value FROM defaults
WHERE setting_key = 'version'
ERROR: permission denied for relation defaults

So clearly there is some sort of hangover in the ledgersmb-mycompany
database. Can anyone advise?  I'd like to remove superuser privileges
from ledgersmb ASAP.

When I've got this sorted, I'll write up a short howto, as there seems to be
limited information out there on this migration.

TD