[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Role blues

Hi Erik

Ok. Can you add a  short description of the use-case to support creating it in an existing database? Maybe we want to support it out of the box,  but currently there's a bit of tweaking required to get things working and operational.

OK, then. I want to create some links to the products from an existing CMS. E.g. products and inventory. Even customers, I think. But it's OK, it might be an item to consider, but it's not high-priority to me.

 It's an error that comes from Roles.sql. There is a step you need to execute when moving a schema from one database to another, which you didn't know about:

INSERT INTO defaults VALUES ('role_prefix', 'lsmb_<name-of-your-old-databas>__');

Hm, sneaky :-) But alas it didn't work. I don't know what hole I've fallen into, but obviously it's deeper than that :-)

So I decided to try from fresh, backup and drop the database, remove alle lsmb_<database> roles, install ledgersmb into a new database and recreate my CMS db schema.

So now I can create users again. But! I still get some (to me) random permission problems. I will report them when I can describe them.

pg_dumpall: query failed: ERROR: permission denied for relation
pg_authid at

Hmm. that seems to be another problem; I'll need to look at that one later. However, you're not likely to encounter this problem when you have the INSERT statement executed as listed above, so I'm going to mark it as non-blocking for now.

Definitely non-blocking. But perhaps I can describe the problem closer when I get the time to try again.

Yea. Good you did, because chances are slim that you would have found out about the role_prefix any time soon.

Thanks for your help. Really appreciate that.

PS I encountered another error, but I think it best to make a new thread about it.

What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Ledger-smb-devel mailing list