I have the example-mysql.php LightOpenID provider script running on a localhost virtualhost on my machine. I updated the table names and mysql_connect() parameters to work on my local machine. I also created a user in the users table.
I'm using the example.php LightOpenID consumer script to test the provider script. Everything works up until I get to "http://site1" wants access, Allow Once, Allow Always, Cancel. Pressing either of the allow buttons creates a new allowedsites row, but the page just refreshes with the buttons again. It verifies my login against the database or I would get "wrong user/pass" but never finishes the process and redirects me...
Provider script: https://gist.github.com/1072612 Consumer script: https://gist.github.com/1072613