Good afternoon,
During our beta testing, I created a number of generic local accounts
(using vcld --setup). Now that we're moving into production, we're using
Shib and LDAP and I need to delete those local accounts. When I try
manually removing the user from the vcl.user table, I get the followi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I believe I've seen this before. It won't let you delete things
that are referenced in the log/querylog (stored in the database).
Have you tried zeroing out the log, and then removing the account?
__Jim
On 5/22/2012 10:16 AM, Mike Haudenschild wrote
I have also encountered this. What I did was to alter the database schema so
that deleting a user causes the relevant log entries to also be deleted.
something like this:
ALTER TABLE `log` ADD FOREIGN KEY (`userid`) REFERENCES `user` (`id`) ON DELETE
CASCADE;
ALTER TABLE `querylog` ADD FOREIGN