Talk:Tiles@home/Server install guide

From OpenStreetMap Wiki
Jump to navigation Jump to search

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.)

  1. tah/requests/uploadhandler.py - replace "from mysqldb import OperationalError" with "from sqlite3 import OperationalError"
  2. tah/tah_intern/process_uploads.py - as above.
  3. tah/requests/manager.py - remove the " FOR UPDATE" part of the statements - this SQL is not understood by sqlite3
  4. 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)

Windows-specific Edits

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.

(Lines 36-37) 

  read_str[offset - 1] == '\n':
    read_str = read_str[:-1]


Ollie 16:41, 12 January 2009 (UTC)

Retrieved from "https://wiki.openstreetmap.org/w/index.php?title=Talk:Tiles@home/Server_install_guide&oldid=223898"