Spotted @ #102 Group Therapy Radio with Above & Beyond

My Macbook was recently running very slow. I've noticed Spotlight was constantly rebuilding the index. By executing the following lines of code in my terminal, the corrupted index was fixed:

$ sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist
$ sudo launchctl load -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist

Query to list all the indexes which are disabled in your database:

SELECT
    sys.objects.name,
    sys.indexes.name
FROM sys.indexes
    INNER JOIN sys.objects ON sys.objects.object_id = sys.indexes.object_id
WHERE
    sys.indexes.is_disabled = 1
ORDER BY
    sys.objects.name,
    sys.indexes.name

My webhosting recently upgraded to PHP 5.4.X - my website is currently running on an old installation of Drupal 6 (version 33). I was suffering a lot of PHP warnings when browsing through some of my webpages. An interesting patch could be found at https://www.drupal.org/node/1543434, which actually cleared all warnings.

Thanks Peter Bowey!

Spotted @ Armin Van Buuren - A State of Trance - podcast 338!

Spotted @ Armin Van Buuren - A State of Trance - podcast 338!

Sinds 2014 heeft Deinze er een nieuwe logopedie bij. De praktijk is gevestigd te Petegem-aan-de-Leie, dichtbij het centrum van Deinze. Wie op zoek is naar een goede logopediste kan heel wat informatie terug vinden op de site van Aline Delezie: http://www.adlogo.be

Introduction

To install Trac 1.0.1 on a Windows 8.1 installation, I used the following dependencies:

Installing Python

• Python is required to startup Trac as Trac is built on top of Python
• Download from: https://www.python.org/download/
• Choose version: 2.7.8 - 32 bit
• When installing, make sure you select: Install for all users, and not the current user. If you don't do this, the Apache service will not be able to access Python eggs
• When installing, also check Add python.exe to Path
• After installation, restart your machine so the new system variable Path will be in memory. Otherwise, you cannot use the python.exe command from whatever folder you're currently working in

Installing setuptools

• setuptools is required to install a Python package like Trac. setuptools will have a look at the dependencies, and will automatically download/install the dependencies for you (e.g.: Genshi)
• Download from: https://pypi.python.org/pypi/setuptools
• Choose version: 5.4.2 - Windows 7
• Download the file ez_setup.py
• When downloaded, double click the file to install setuptools
• Add C:\Python27\Scripts to Path variable
• After installation, restart your machine so the new system variable Path will be in memory. Otherwise, you cannot use the easy_install.exe command from whatever folder you're currently working in (and also later on trac-admin.exe)

Installing trac

• Open command prompt and type: $ easy_install trac
• The command prompt will install Trac and its dependencies. At the end, a message Congratulations! will be visible in the command prompt

Create trac environment

• Open command prompt and type: $ trac-admin C:\Trac initenv
• Follow steps to create your project

Configuring mod_wsgi

• mod_wsgi is used to connect Trac with Apache HTTPD. In this case, you won't need to run Trac on a specific port like 8000
• Download from http://www.lfd.uci.edu/~gohlke/pythonlibs/#mod_wsgi
• Choose version: mod_wsgi‑3.5.ap22.win32‑py2.7.zip
• Unzip and move contents to C:/Program Files/Apache Software Foundation/Apache2.2/modules/. Make sure the Apache service can read this .so file
• Create Apache HTTPD directories by executing the command: $ trac-admin C:\Trac deploy C:\Temp
• Copy C:\Temp\cgi-bin and C:\Temp\htdocs to C:\Trac
• Enable module mod_wsgi.so in Apache HTTPD by adding the following the line in the load modules section: LoadModule wsgi_module modules/mod_wsgi.so
• Add the following configuration at the bottom of the httpd.conf file
  

  WSGIScriptAlias /trac C:\Trac\cgi-bin\trac.wsgi               # Process Trac requets
  Alias /trac/chrome/common C:\Trac\htdocs\common               # Serve static content directly from disk (don't send to .cgi script)
  Alias /trac/chrome/site C:\Trac\htdocs\site                   # Serve static content directly from disk (don't send to .cgi script)
   
  <Directory C:\Trac\cgi-bin>
      WSGIApplicationGroup %{GLOBAL}
      Order allow,deny
      Allow from all
  </Directory>
   
  <Directory C:\Trac\htdocs>
    Order allow,deny
    Allow from all
  </Directory>
   
  <Location "/trac/login">
    AuthType Basic
    AuthName "Trac"
    AuthUserFile C:\SVN\conf\svn-auth-file
    Require valid-user
  </Location>

• Restart Apache HTTPD and check if you can access: http://localhost/trac/

Cannot load C:/Program Files/Apache Software Foundation/Apache2.2/modules/mod_wsgi.so into server: The specified module could not be found