Moodle theme hack
Friday, November 14th, 2008Hacked Moodle theme, instead of echoing $menu I now echo user_login_string(). Then the navigation is never shown and users are not able to access other topics 'via the backdoor'.
Archive for November, 2008
Hacked Moodle theme, instead of echoing $menu I now echo user_login_string(). Then the navigation is never shown and users are not able to access other topics 'via the backdoor'.
Reporting Moodle
Friday, November 14th, 2008updated some reporting routines: created sql scripts in /path/to/transfermood/clientreport so I can run: [bash] mysql -u moodleuser -p moodle_help > course_month.sql | sed -e "s/\t/:/g" > output.txt [/bash] to list and sort files to creation time: [bash] ll -Rt --time-style=long-iso | grep -v ^d | grep - | awk '{print $6 , $8}' [/bash]
Create index on geoip table
Friday, November 14th, 2008For report, created index on geoip table and geoip column in log file [sql] CREATE INDEX log_ip ON prefix_log (ip); CREATE INDEX geocoded_ip_ip ON geocoded_ip (ip); [/sql] First query halted the whole server, now query is done in 8 seconds
Added remote server to Nagios
Wednesday, November 12th, 2008Client opened ports 161 and 199 TCP and UDP for Nagios monitoring. Installed snmpd and nrpe on server: apt-get install snmpd apt-get install nagios-nrpe-server Configured snmpd config in /etc/snmp/snmp.conf: Cannot get into server. Scan of server from nagios server showed no open ports. Checked firewall status at Ubuntu server with: [bash] ufw status [/bash]
Installed wsdl2php via PEAR
Wednesday, November 12th, 2008downloaded wsdl2php from sourceforge pear install wsdl2php-0.2.1-pear.tgz
Moodle geo-reporting
Tuesday, November 11th, 2008Continued from this post. Client requested reports I already created once. Updated geocoded_ip table in moodle database with php script (geocodeMoodle.php) updated mdl_log table to hold country info (query takes a long time) -> couldn't finish yet ran queries on database edited results in Excel Sent to client
Installed Moodle 2.0 dev
Tuesday, November 11th, 2008Installed Moodle 2.0 dev version to start testing eportfolios. okiedokie for everything, except Moodle 2.0 needs php 5.2.x and CentOS 5.x does not yet support PHP 5.2.x in it's repositories. There is a method to get PHP 5.2.x. Just add a new repository and upgrade php from there. Didn't want to do ...
Install Mahara
Tuesday, November 11th, 2008Installed Mahara on shared server: installed php-json (other mahara required php extensions were already installed) mkdir maharadev in webroot mkdir mahara in mahara dataroot createdb maharadev (as postgresql db user) downloaded code extract code and copy to mahara webroot edited httpd.conf run web-installer Voila, easy does it
MS Licensing
Tuesday, November 11th, 2008About licensing costs for MS EE servers: OS: 40 Euro OS EE: 140 Euro SQL: 80 Euro SQL EE: 700 Euro Damn, that's a lot of money; I think we have about 100 - 150 licenses. I hope the boss does the math.
