Saturday, December 24, 2011

Wordy released

I've just worked out how to host my new words with friends cheater using an old pc in my shed.


Please login and try it out. I have not yet gotten around to adding instructions or making it pretty. Leave a comment here if you use it.

mod_wsgi in httpd.conf

Getting an error like this on apache 2.2 on Windows 32?

[Sun Dec 25 11:59:40 2011] [notice] Parent: Received restart signal -- Restarting the server.
[Sun Dec 25 11:59:40 2011] [notice] Child 296: Exit event signaled. Child process is ending.
httpd.exe: Syntax error on line 129 of C:/Program Files/Apache Software Foundation/Apache2.2/conf/httpd.conf: Can't locate API module structure `mod_wsgi_module' in file C:/Program Files/Apache Software Foundation/Apache2.2/modules/mod_wsgi.so: No error
[Sun Dec 25 11:59:41 2011] [notice] Child 296: Released the start mutex
[Sun Dec 25 11:59:42 2011] [notice] Child 296: All worker threads have exited.
[Sun Dec 25 11:59:42 2011] [notice] Child 296: Child process is exiting

You need to have mod_wsgi configured exactly as follow:

LoadModule wsgi_module modules/mod_wsgi.so


Wednesday, December 21, 2011

Add privs for django on mysql

Once user is setup make sure to remember to grant privs on the table space that the user needs.

Thursday, November 10, 2011

Setting up mysql on windows with Django

Install mysql from http://www.mysql.com/

Then you'll need a mysql drive thingo as standard django does not come with it.

Install the windows exe install from http://www.codegood.com/archives/129.

Setup your settings.py as follows:

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'wordy',
'USER': 'wordy',
'PASSWORD': 'nooble',
'HOST': 'localhost', # Set to empty string for localhost. Not used with sqlite3.
'PORT': '', # Set to empty string for default. Not used with sqlite3.
}
}

Then create your user, my example is wordy, using mysql workbench. Put localhost into the 'limit connectivity to hosts matching' field, do not use the default of %.