Spotted @ #105 Group Therapy Radio with Above & Beyond

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

Providing a user admin permissions

• It would be better to create groups, but for this simple tutorial, I use a command to make 1 user admin: $ trac-admin C:\Trac permission add #USERNAME# TRAC_ADMIN

Configuring Subversion as a repository (browser)

• To be able to let Trac communicate with Subversion, you need the Python SVN bindings
• Download from: http://alagazam.net/
• Choose version: svn-win32-1.8.9_py27.zip
• Extract contents of ZIP file to C:\Python27\Lib\site-packages
• Create a components section add the following lines to enable the SVN bindings:
  

  [components]
  tracopt.versioncontrol.svn.* = enabled

• Login to Trac with an admin account and go to Admin > Repositories and add your SVN repository
• Open a command prompt and execute the following command to resync previous changesets: $ trac-admin C:\Trac repository resync #REPOSITORYNAME# (required for Timeline)
• You should also set up a post-commit hook on the repository to keep Trac in sync with your Subversion repository (required for Timeline). Go to C:\SVN\hooks and create a file post-commit.bat (copy it from the existing template). Add the following line at the bottom of the script: trac-admin C:\Trac changeset added #REPOSITORYNAME# $REV. File should look like:
  

  #!/bin/sh
   
  REPOS="$1"
  REV="$2"
  TXN_NAME="$3"
   
  trac-admin C:\Trac changeset added #REPOSITORYNAME# $REV

• When you now click Browse source in Trac, you should be able to see your source code. The timeline will also be updated every time you make a commit

Spotted @ #418 Trance Around The World with Above & Beyond