flagflag  

Re: Modlos 1.5.0 database issues- FINAL UPDATE

List posts in the topic

なし Re: Modlos 1.5.0 database issues- FINAL UPDATE

msg# 1.14
depth:
1
Previous post - Next post | Parent - No child | Posted on 2011/6/2 14:34
fudge  Not too shy to talk   Posts: 23
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.
Votes:152 Average:3.88

Posts tree

  Advanced search


Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMar 2024Next Month
Su Mo Tu We Th Fr Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
Today

Who's Online

55 user(s) are online (1 user(s) are browsing Forum)

Members: 0
Guests: 55

more...

Access Counter

Today : 4657465746574657
Yesterday : 6869686968696869
Total : 2317894023178940231789402317894023178940231789402317894023178940
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com