">Answer from hat > Your permissions are wrong and your db is regecting "You will need to set the permissions on the sequence.
Your were right, my pgsql log looks like this: ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq ERROR: permission denied for sequence radacct_radacctid_seq
I got this book on postgresql, and it actually seems to completely omit stuff on permissions. I have the radius logging via the postgres database superuser (postgres), since I was getting a similar error when I had it running as the radius user I had setup. I gave that user ownership and it could read, write and manipulate the database as long as it didn't have insert a new record and ahve the db auto-generate the 'id' column (which i assume is the auto-gen primary key).
If you know how to grant sequence permissions in postgre that would much appreciated if you could share that.
Daniel Baughman
I created the tables and sequences as user radius, so I didn't have to mess with those permissions.
Check the archives for postgresql for more details.
http://archives.postgresql.org/pgsql-general/
I saw someone respond on how to set permisions on sequences not too long ago.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
