Reply to thread

Message

<blockquote data-quote="Stronginthearm" data-source="post: 6450902" data-attributes="member: 6786296">That was actually quite helpful guys <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" />sparkle: no, i hadn't found that. I haven't implemented it yet, but apache modules are familiar enough, so I think I'll manage to get that running in the next days.Isiloki: yeah, I have that siterip, but it's some 500MB and lacks the filter, while the dynamic version is ~60MB. With the integration of the sqlite db i got rid of the last exceptions and as far as I can see I now have a fully functional clone running on the development server on port 8000. I even found the admin page, but haven't managed yet to set a valid password.Here is what I did in more detail (I still assume that you can do basic stuff in linux - and be root):installing the software- installed Debian Wheezy on a VM (every other linux will probably work, but i find Debian convenient)- cd /where/ever/you/want/it- apt-get install python python-imaging python-mysqldb python-recaptcha python-textile mysql-server sqlite3- apt-get install python-pip (I used the easy_install method from the github docu, but I don't think that's neccessary)- pip install Django==1.2.7- pip install South==0.8.4- pip install django-debug-toolbar==0.9.4- pip install django-filter==0.5.3- pip install django-pagination==1.0.7- pip install recaptcha-client==1.0.6since the oldest available django-reversion version in pip is 1.5.1 I installed it manually- apt-get install git- git clone <a href="https://github.com/etianen/django-reversion.git" target="_blank">https://github.com/etianen/django-reversion.git</a>- cd django-reversion- git checkout release-1.3.3- python setup.py install- cd ..- git clone <a href="https://github.com/dndtools/dndtools.git" target="_blank">https://github.com/dndtools/dndtools.git</a>prepare the database- aquire both the 2013 version (from line 33 of the github INSTALL document) and the 2014 sqlite database (archive.org wayback machine lets you find the linked dropbox file)- download the converter script <a href="http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py" target="_blank">http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py</a>- sqlite3 dnd.sqlite .dump &gt;dnd.dump.sql- cat dnd.dump.sql | python sqlite3-to-mysql.py &gt; dnd.conv.sqledit dnd.conv.sql (Notepad++ on Windows works reasonably well, as does of course vi on Linux, nano is alittle clumsy):- insert as 2nd line: SET FOREIGN_KEY_CHECKS=0;- insert as last line: SET FOREIGN_KEY_CHECKS=1;- from the CREATE TABLE statements remove everything from CONSTRAINT to ); (75 occurences)- in line 174550 replace CREATE TABLE dnd_rules_conditions (id , name , description );with[CODE]CREATE TABLE `dnd_rules_conditions` (&nbsp; `id` int(11) NOT NULL ,&nbsp; `name` varchar(32) NOT NULL,&nbsp; `description` longtext NOT NULL,&nbsp; PRIMARY KEY (`id`));[/CODE]- in lines 241799 and following shorten every index name to 64 characters or less (as far as I have researched the index name is not relevant for the db query)import both databases:- mysql -u root -p dndtools &lt; dndtools_prod_backup_2013_03_02_clear_accounts_no_reversions.sql-&nbsp; mysql -u root -p dndtools &lt; dnd.conv.sqledit the config- cd dndtools/dndtools- cp local.py.sample local.py- nano local.py[CODE]DEBUG = True (so you get maybe helpful exceptions instead of a blank 500 http error)DATABASES = {&nbsp; &nbsp; 'default': {&nbsp; &nbsp; &nbsp; &nbsp; 'ENGINE': 'django.db.backends.mysql',&nbsp; &nbsp; &nbsp; &nbsp; 'NAME': 'dndtools',&nbsp; &nbsp; &nbsp; &nbsp; 'USER': 'root',&nbsp; &nbsp; &nbsp; &nbsp; 'PASSWORD': 'yourdbpassword',&nbsp; &nbsp; &nbsp; &nbsp; 'HOST': '',&nbsp; &nbsp; &nbsp; &nbsp; 'PORT': '',&nbsp; &nbsp; &nbsp; &nbsp; 'OPTIONS': {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'init_command': 'SET storage_engine=INNODB',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; }}SECRET_KEY = 'somethingunique' (I don't know if this is neccessary)[/CODE]start the debug server- python manage.py runserverNow dndtools runs on 127.0.0.1 port 8000 ... and if you haven't installed an x-server and a browser you have to forward the port ... fortunately putty does that quite nice:- load your stored connection and go to Connection -&gt; SSH -&gt; Tunnels- add new forwarded port-- source port: 8000-- destination: 127.0.0.1:8000- save and connect- open <a href="http://127.0.0.1:8000" target="_blank">http://127.0.0.1:8000</a> in your browserThe admin interface runs on <a href="http://127.0.0.1:8000/admin" target="_blank">http://127.0.0.1:8000/admin</a>, the password is probably stored in the table auth_user, but how exactly I haven't figured out yet.Please let me know if this works for you. I plan to install it on my real server in the next few days.appendix: all the packages (in case I forgot a relevant)[CODE]# dpkg-query -l | grep pythonii&nbsp; python&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2.7.3-4+deb7u1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; interactive high-level object-oriented language (default version)ii&nbsp; python-apt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0.8.8.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Python interface to libapt-pkgii&nbsp; python-apt-common&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.8.8.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Python interface to libapt-pkg (locales)ii&nbsp; python-chardet&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2.0.1-2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; universal character encoding detectorii&nbsp; python-crypto&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.6-4+deb7u3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; cryptographic algorithms and protocols for Pythonii&nbsp; python-debian&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.1.21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Python modules to work with Debian-related data formatsii&nbsp; python-debianbts&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Python interface to Debian's Bug Tracking Systemrc&nbsp; python-django&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.4.5-1+deb7u8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High-level Python web development frameworkii&nbsp; python-fpconst&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0.7.2-5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Utilities for handling IEEE 754 floating point special valuesii&nbsp; python-imaging&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.1.7-4+deb7u1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Python Imaging Libraryii&nbsp; python-minimal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2.7.3-4+deb7u1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; minimal subset of the Python language (default version)ii&nbsp; python-mysqldb&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.2.3-2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Python interface to MySQLii&nbsp; python-pkg-resources&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 0.6.24-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Package Discovery and Resource Access using pkg_resourcesii&nbsp; python-pygments&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.5+dfsg-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; syntax highlighting package written in Pythonii&nbsp; python-recaptcha&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.0.6-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; client library for reCAPTCHA and Mailhideii&nbsp; python-reportbug&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 6.4.4+deb7u1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Python modules for interacting with bug tracking systemsii&nbsp; python-soappy&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.12.0-4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SOAP Support for Pythonii&nbsp; python-sqlite&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.0.1-9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Python interface to SQLite 2ii&nbsp; python-support&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1.0.15&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; automated rebuilding support for Python modulesii&nbsp; python-textile&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1:2.1.5-1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; all&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Python parser for the Textile markupii&nbsp; python2.6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.6.8-1.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Interactive high-level object-oriented language (version 2.6)ii&nbsp; python2.6-minimal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.6.8-1.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Minimal subset of the Python language (version 2.6)ii&nbsp; python2.7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7.3-6+deb7u2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Interactive high-level object-oriented language (version 2.7)ii&nbsp; python2.7-minimal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.7.3-6+deb7u2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; i386&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Minimal subset of the Python language (version 2.7)[/CODE][CODE]# pip freezeDjango==1.2.7MySQL-python==1.2.3PIL==1.1.7Pygments==1.5SOAPpy==0.12.0South==0.8.4argparse==1.2.1chardet==2.0.1django-debug-toolbar==0.9.4django-filter==0.5.3django-pagination==1.0.7django-reversion==1.3.3fpconst==0.7.2pycrypto==2.6pysqlite==1.0.1python-apt==0.8.8.2python-debian==0.1.21python-debianbts==1.11recaptcha-client==1.0.6reportbug==6.4.4sqlparse==0.1.13textile==2.1.5wsgiref==0.1.2[/CODE]</blockquote>

[QUOTE="Stronginthearm, post: 6450902, member: 6786296"] That was actually quite helpful guys :) sparkle: no, i hadn't found that. I haven't implemented it yet, but apache modules are familiar enough, so I think I'll manage to get that running in the next days. Isiloki: yeah, I have that siterip, but it's some 500MB and lacks the filter, while the dynamic version is ~60MB. With the integration of the sqlite db i got rid of the last exceptions and as far as I can see I now have a fully functional clone running on the development server on port 8000. I even found the admin page, but haven't managed yet to set a valid password. Here is what I did in more detail (I still assume that you can do basic stuff in linux - and be root): [B][U]installing the software[/U][/B] - installed Debian Wheezy on a VM (every other linux will probably work, but i find Debian convenient) - cd /where/ever/you/want/it - apt-get install python python-imaging python-mysqldb python-recaptcha python-textile mysql-server sqlite3 - apt-get install python-pip (I used the easy_install method from the github docu, but I don't think that's neccessary) - pip install Django==1.2.7 - pip install South==0.8.4 - pip install django-debug-toolbar==0.9.4 - pip install django-filter==0.5.3 - pip install django-pagination==1.0.7 - pip install recaptcha-client==1.0.6 since the oldest available django-reversion version in pip is 1.5.1 I installed it manually - apt-get install git - git clone [URL]https://github.com/etianen/django-reversion.git[/URL] - cd django-reversion - git checkout release-1.3.3 - python setup.py install - cd .. - git clone [URL]https://github.com/dndtools/dndtools.git[/URL] [B][U]prepare the database [/U][/B]- aquire both the 2013 version (from line 33 of the github INSTALL document) and the 2014 sqlite database (archive.org wayback machine lets you find the linked dropbox file) - download the converter script [URL]http://www.redmine.org/attachments/download/6239/sqlite3-to-mysql.py[/URL] - sqlite3 dnd.sqlite .dump >dnd.dump.sql - cat dnd.dump.sql | python sqlite3-to-mysql.py > dnd.conv.sql [U]edit dnd.conv.sql[/U] (Notepad++ on Windows works reasonably well, as does of course vi on Linux, nano is alittle clumsy): - insert as 2nd line: SET FOREIGN_KEY_CHECKS=0; - insert as last line: SET FOREIGN_KEY_CHECKS=1; - from the CREATE TABLE statements remove everything from CONSTRAINT to ); (75 occurences) - in line 174550 replace CREATE TABLE dnd_rules_conditions (id , name , description ); with [CODE]CREATE TABLE `dnd_rules_conditions` ( `id` int(11) NOT NULL , `name` varchar(32) NOT NULL, `description` longtext NOT NULL, PRIMARY KEY (`id`) );[/CODE] - in lines 241799 and following shorten every index name to 64 characters or less (as far as I have researched the index name is not relevant for the db query) import both databases: - mysql -u root -p dndtools < dndtools_prod_backup_2013_03_02_clear_accounts_no_reversions.sql - mysql -u root -p dndtools < dnd.conv.sql [U][B]edit the config[/B][/U] - cd dndtools/dndtools - cp local.py.sample local.py - nano local.py [CODE]DEBUG = True (so you get maybe helpful exceptions instead of a blank 500 http error) DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'dndtools', 'USER': 'root', 'PASSWORD': 'yourdbpassword', 'HOST': '', 'PORT': '', 'OPTIONS': { 'init_command': 'SET storage_engine=INNODB', }, } } SECRET_KEY = 'somethingunique' (I don't know if this is neccessary) [/CODE] [U][B]start the debug server[/B][/U] - python manage.py runserver Now dndtools runs on 127.0.0.1 port 8000 ... and if you haven't installed an x-server and a browser you have to forward the port ... fortunately putty does that quite nice: - load your stored connection and go to Connection -> SSH -> Tunnels - add new forwarded port -- source port: 8000 -- destination: 127.0.0.1:8000 - save and connect - open [URL]http://127.0.0.1:8000[/URL] in your browser The admin interface runs on [URL]http://127.0.0.1:8000/admin[/URL], the password is probably stored in the table auth_user, but how exactly I haven't figured out yet. Please let me know if this works for you. I plan to install it on my real server in the next few days. [U][B]appendix: all the packages (in case I forgot a relevant)[/B][/U] [CODE] # dpkg-query -l | grep python ii python 2.7.3-4+deb7u1 all interactive high-level object-oriented language (default version) ii python-apt 0.8.8.2 i386 Python interface to libapt-pkg ii python-apt-common 0.8.8.2 all Python interface to libapt-pkg (locales) ii python-chardet 2.0.1-2 all universal character encoding detector ii python-crypto 2.6-4+deb7u3 i386 cryptographic algorithms and protocols for Python ii python-debian 0.1.21 all Python modules to work with Debian-related data formats ii python-debianbts 1.11 all Python interface to Debian's Bug Tracking System rc python-django 1.4.5-1+deb7u8 all High-level Python web development framework ii python-fpconst 0.7.2-5 all Utilities for handling IEEE 754 floating point special values ii python-imaging 1.1.7-4+deb7u1 i386 Python Imaging Library ii python-minimal 2.7.3-4+deb7u1 all minimal subset of the Python language (default version) ii python-mysqldb 1.2.3-2 i386 Python interface to MySQL ii python-pkg-resources 0.6.24-1 all Package Discovery and Resource Access using pkg_resources ii python-pygments 1.5+dfsg-1 all syntax highlighting package written in Python ii python-recaptcha 1.0.6-1 all client library for reCAPTCHA and Mailhide ii python-reportbug 6.4.4+deb7u1 all Python modules for interacting with bug tracking systems ii python-soappy 0.12.0-4 all SOAP Support for Python ii python-sqlite 1.0.1-9 i386 Python interface to SQLite 2 ii python-support 1.0.15 all automated rebuilding support for Python modules ii python-textile 1:2.1.5-1 all Python parser for the Textile markup ii python2.6 2.6.8-1.1 i386 Interactive high-level object-oriented language (version 2.6) ii python2.6-minimal 2.6.8-1.1 i386 Minimal subset of the Python language (version 2.6) ii python2.7 2.7.3-6+deb7u2 i386 Interactive high-level object-oriented language (version 2.7) ii python2.7-minimal 2.7.3-6+deb7u2 i386 Minimal subset of the Python language (version 2.7) [/CODE] [CODE] # pip freeze Django==1.2.7 MySQL-python==1.2.3 PIL==1.1.7 Pygments==1.5 SOAPpy==0.12.0 South==0.8.4 argparse==1.2.1 chardet==2.0.1 django-debug-toolbar==0.9.4 django-filter==0.5.3 django-pagination==1.0.7 django-reversion==1.3.3 fpconst==0.7.2 pycrypto==2.6 pysqlite==1.0.1 python-apt==0.8.8.2 python-debian==0.1.21 python-debianbts==1.11 recaptcha-client==1.0.6 reportbug==6.4.4 sqlparse==0.1.13 textile==2.1.5 wsgiref==0.1.2 [/CODE] [/QUOTE]

Verification