openssl_generations
openssl_history
openssl_keypair
openssl_keypair_expires
Once these entries had been completely removed I was able to login to Mahara as administrator and the appropriate entries were regenerated along with a new key :)
It was then necessary to re-enable Moodle/Mahara networking from within Moodle.
]]>Please ignore the last posting as I've just answered my own question!
It was the mahconfig table that contained all the ssl options
]]>
Looking at the Mahara database there are lots of tables with config in their name. i.e.
public.mahartefact_config public.mahauth_config public.mahauth_instance_config public.mahblocktype_config public.mahconfig public.mahgrouptype_config public.mahinteraction_config public.mahinteraction_forum_instance_config public.mahnotification_config public.mahsearch_configWhich of these tables contains the openssl related fields please?
Thanks :)
Clive
]]>
[Thu Jul 02 10:08:04 2009] [error] [client 10.60.29.160] [WAR] 73 (api/xmlrpc/client.php:132) Time drift (0, 3505) is too large., referer: http://www.prentonmoodle.co.uk/
]]>
I then went through configuring the site and then the mahoodle documentation BUT at the end of it all I stiil got Sorry, could not log you in :(
Could the problem be on the moodle side perhaps?
I can't start moodle again from scratch as it is in full use
]]>So this will work on a postgresql database as well?
I'll try it out when I get to work.
]]>DELETE FROM config WHERE field LIKE 'openssl%';
That will clear out all the openssl related fields, including the key.
In Mahara, there's no easy way to re-generate a key save deleting it in the database and then hitting the Networking page in the admin section again. If you do this, you'll have to paste the new public key (which you'll see on that page) into Moodle on the right screen in the Networking config so it knows about the change.
Is that why Mahara would not talk to Moodle and the XMLRPC certificates didn't match, without a re-install of Mahara?
Please let me know as I have to repeat the process in mid-August and knowing this could help a lot :)
Thanks
Clive
]]>
I have written a new blog to help others use rsync to successfully synchronize servers running CentOS Linux, DSpace, LAMS, Mahara and Moodle. It covers synchronization between servers with identical hardware architectures and different hardware architectures. It is also a guide to using rsync to create a mirrored copy server.
Please select this link for more information.
Best wishes
Clive
]]>