Re: Modlos 1.5.0 database issues- FINAL UPDATE

I worked out what caused this problem and probably what has caused the problem for others as listed in the top post here (I see from the forum posts that a few other have had these issues in the past).

The issue is basically a result of (my) laziness- you need to define a dedicated database user for moodle and opensim. If you simply use the default root user credentials for both the moodle and opensim databases you will get errors due to the lack of synchronization between the databases. Therefore, out of all the things we did as outlined above, the critical element was this:

mysql> grant all on moodle_1_9_10.* to moodle_user identified by 'moodle_pass';
mysql> grant all on opensim_0702.* to opensim_user identified by 'opensim_pass';
mysql> flush privileges;

Doing the above will solve all these types of issues. I was able to reproduce the errors on another server by doing an install where I used the defauly mysql root user credentials for both the opensim and moodle databases.

cheers :)

Hoperfully this will help others that run into these problems.