I have tried and it makes no difference. The problem appears to be MySQL autocommit options.. Here is the mysql log: 100915 15:12:58 11 Connect [email protected] on policyd 11 Query set autocommit=0 11 Query UPDATE policies SET Name = 'sdfg', Priority = '123', Description = 'dfsg' WHERE ID = '5'
I have no idea why it is sending "set autocommit=0" though. It's not in your code and it only appears to happen on this cluster. If I change the code to send a COMMIT after the update statement it works correctly.. Thanks Ian -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Robert Anderson Sent: 15 September 2010 15:20 To: [email protected] Subject: Re: [policyd-users] policyd v2 and MySQL Cluster > I'm attempting to setup a policyd server using a MySQL cluster backend. > There appears to be a problem with the webui talking to the database > properly. Policy list displays correctly but if you change the Action > to Change, make some changes and submit them they are never updated.. > Quotas do not display at all even if manually inserted into the > database. The only change I have made is to change the mysql table > creation script from TYPE=InnoDB to TYPE=NDBCLUSTER. Has anyone got > any experience of using policyd with MySQL cluster and could possibly > point me in the right direction? Hi Ian, Please try using v2.0.11 RC1. Robert _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
