Talk:Tiles@home/Server install guide
how many actual references are there to user ojw? the only ones I can think of offhand are the mod-rewrite (which requires full filenames) and anything that requires a URL to be used from outside of the website (e.g. crontab wget entries) Ojw 15:03, 8 July 2007 (BST)
SQLite3 vs MySQL
The config defaults to using sqlite3 but the code breaks when sqlite3 is used, unless the following changes are made. (I'm on Mac OS X 10.5 "Leopard", and using sqlite3 rather than mysql, as MySQLdb does not build under 10.5 against the Apple-compiled 64-bit MySQL server and 32-bit python from MacPorts - even if both architectures are 32-bit, it still requires fiddling around.)
- tah/requests/uploadhandler.py - replace "from mysqldb import OperationalError" with "from sqlite3 import OperationalError"
- tah/tah_intern/process_uploads.py - as above.
- tah/requests/manager.py - remove the " FOR UPDATE" part of the statements - this SQL is not understood by sqlite3
- tah/requests/manager.py - remove the 'is_locked' and "where %s=0" sections.
3 & 4 probably horribly break the locking model used, and at a guess cause big problems when multiple clients start uploading things concurrently, but it's a dirty hack I needed to get the server (and the post-upload processing script) working.
I also had to change tah/tah_intern/Tileset.py, changing self.base_z, self.x and self.y in __init__ to only be set if the corresponding variable was not "None"
Ollie 15:48, 12 January 2009 (UTC)
Even I had to do the Tileset.py changes as mentioned above. After my install uploader did run without error but I realized it is just unzipping one tile from the zip file. all other zoom tiles are not touched and not moved in the directories. thevikas 04:03, 9 February 2009 (UTC)
To get tahngo working fully on my Windows Vista box, I had to comment out these lines in tah/tah_intern/views.py - otherwise the log wouldn't display, instead showing an index out of range error.
read_str[offset - 1] == '\n': read_str = read_str[:-1]
Ollie 16:41, 12 January 2009 (UTC)