Am 01.09.2012 23:28, schrieb Keith Seyffarth:
The dataset was created in version 2.<something> about four years ago.

...

Thanks for the tip. I can't get admin to log in - but adding @<database>
after my primary username allowed that user to log in again. Everything
appears to be working now. My best guess is that something in the pgsql
upgrade this time forced sql-ledger to check the format of the username
in the members file, which hadn't previously been enforced...

I can't tell you exactly why your logins stopped working, but I'm quite sure it has nothing to do with psql. You should never simply install version 3 over version 2, you have to make some changes to the system described in doc/UPGRADE
https://github.com/Tekki/sql-ledger/blob/master/doc/UPGRADE#L301
The user management in version 3 is completely different from version 2. The login is no longer <my_username>, but <my_username>@<dataset>. You can't access the users in admin.pl anymore, they are "employees" now and you have to go to the HR section to add and edit them. For this and for some other functions you need in any case a working admin@<dataset> login.

Regards
Rolf
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger

Reply via email to