Archive for March, 2008
Friday, March 28th, 2008
Prepare for postgres migration.
Moodle forum post on migration: the idea is to let moodle create an empty pg database and then upload the mysql data (which is edited with some grep to overcome differences).
Continued from this post.
Have to setup a new dedicated server for a client. Decided to go with ...
Posted in BrnDmp | No Comments »
Friday, March 28th, 2008
set up server for client. Setup postgres environment:
create dbuser (as user postgres): createuser -s P
edit postgresql.conf (listen to address and port)
edit pg_hba.conf (allowed access for maintenance host -> NOTE! first comment all default settings and start with a clean sheet, only allow specific hosts to connect)
Later optimize postgres settings
Posted in BrnDmp | No Comments »
Wednesday, March 26th, 2008
We are having a problem with some SCORM modules in Moodle. SCORM should track if a user clicks / enters a module. But it seems that the data is only recorded when the user clicks on 'exit activity'.
Turned on debugging in Moodle (Server, debugging) and SCORM seems to generate proper ...
Posted in BrnDmp | No Comments »
Wednesday, March 26th, 2008
For client, who uses branches around the world as groups, we made a custom login procedure which allow the user to select his branch from a drop down list. In the code, this branch is also the enrolment key to force seperate groups so the user will end up in ...
Posted in BrnDmp | No Comments »
Tuesday, March 25th, 2008
Enabling global search in Moodle 1.9 doesn't work because the xpdf and antiword libs are not included in the distro. So, either copy it from another, working, instance, or find the code in the Moodle sc. Not found in Moodle sc, copied it from another, working instance and no problems ...
Posted in BrnDmp | No Comments »
Thursday, March 13th, 2008
Analyzing MySQL instances on Moodle servers with tuning scripts:
mysqltuner.pl
tuning-primer.sh
mysqlreport
Damn, can't seem to set mysql variables at runtime. Should be able with mysql --variable_name=value or, when in mysql, with set global variable_name = value or, when changing the running session: set @@variable_name=value;
Does not work for open_files_limit but it does work for ...
Posted in BrnDmp | No Comments »
Thursday, March 13th, 2008
Built custom report for viewing number of attempts and succesfull attempts of SCORM modules in Moodle. Read the attempts and success from grade_grades table but comparing number of attempts to other data they seemed a bit low. Checked the SCORM tracker ""scorm_scoes_track" table for SCORM collected data -> SC ORM ...
Posted in BrnDmp | No Comments »
Tuesday, March 11th, 2008
Removed prospect client.
backed up database
backed up codebase
backed up moodledata
removed apache entry
reload webserver
removed maintenance entry
removed crontab entry
removed codebase
removed moodledata
Posted in BrnDmp | No Comments »
Tuesday, March 11th, 2008
Upgraded client to 1.9 from 1.9 beta3.
backed up database
backed up datadir
set maintenance mode
set theme to standard
download moodle code
untar moodle code
cp -a newcode oldcode
go to admin
set back theme -> copied closed.gif and open.gif
Client wanted to dump and restore database of 1.8 environment but that is not possible because database has ...
Posted in BrnDmp | No Comments »
Monday, March 10th, 2008
Mind you that, when upgrading PHP, you also have to recompile eAccelerator for that is compiled using a specific PHP version. Something to note when upgrading PHP versions on my servers.
Posted in BrnDmp | No Comments »
