Not only can you experience AnswerHub firsthand, but you can also ask and explore questions and answers about AnswerHub.
To get started, try typing a question in the search bar. If your question hasn't been asked, try posting a new question.
If you are a current customer, please use the Customer Success portal instead of this communtiy.
OSQA Installation on Windows 2008 Server, IIS 7, MySQL, SQL Server 2008
1. Install Python 2.6 (32bit) from http://www.python.org/download/releases/2.6.6/ - using Windows x86 MSI Installer (I installed to D:\Software\Python26)
NOTE: It may also work with 2.7 but it seemed to me that 2.6 is more "compatible" with some of the dependencies - e.g. PyISAPI is currently only available as a 2.6-build (might work with 2.7, too, though).
2. Install setup tools installer for Python 2.6 from http://pypi.python.org/pypi/setuptools - using setuptools-0.6c11.win32-py2.6.exe
3. Make sure you have python and python/scripts in PATH (D:\Software\Python26;D:\Software\Python26\scripts in my case)
4. Install Dependencies (open console - make sure to open a new console, otherwise your PATH may not include the new Python-paths)
easy_install django easy_install markdown easy_install html5lib easy_install south easy_install python-openid
5.a. Only if you want to use MySQL (I have a MySQL database available, so I simply used this for testing the base installation):
Install MySQL-python 1.2.3 (unfortunately, easy_install python-mysql doesn't work … you might try this first, maybe it works by now; if it doesn't, go to http://www.codegood.com/archives/4 - note that in case you used Python 2.7, you can directly go tohttp://www.codegood.com/archives/129). Use MySQL-python-1.2.3c1.win32-py2.6.exe
NOTE: Assuming you have the database already installed … if not: http://dev.mysql.com/downloads/mysql/
5.b. Only if you want to use MS SQL Server:
... which you probably don't really want ATM as adding questions currently doesn't really work, see also:
Anyways, the steps could be something like:
Install django-mssql - first you need to install Pywin32. I tried using easy_install for that, but didn't work ("Unable to find vcvarsall.bat"), so instead, I installed from http://sourceforge.net/projects/pywin32/files/ - using Build 214 for Python 2.6, 32bit: pywin32-214.win32-py2.6.exe
Then, you need to be able to get the package … get "TortoiseHg 1.1.8 with Mercurial 1.7.3 - x64 Windows" fromhttp://mercurial.selenic.com/downloads/ (if you are on 64bit). Then create a folder somewhere, right-click and do "Clone…" entering the pathhttps://django-mssql.googlecode.com/hg/django-mssql to the source path.
Follow the installation instructions (copy sqlserver_ado to lib/site-packages).
Watch out - you need to have the IP-address as host (names won't work) and the port right behind the IP-address. Example database settings
// MS SQL Server Settings DATABASE_NAME = 'OSQA' DATABASE_USER = 'secretDBUser' DATABASE_PASSWORD = 'secretPassword' DATABASE_ENGINE = 'sqlserver_ado' DATABASE_HOST = '127.0.0.1,1433' DATABASE_PORT = ''
Most likely you don't have to enter the default port (1433) when the DB runs on the default port - but if you have a non-default port, this is the way to add the port number (comma-separated).
APP_URL = 'http://www.mydomain.com:8000/' #used by email notif system and RSS
6. Install TortoiseSVN from http://tortoisesvn.net/downloads.html
7. Create folder for OSQA below D:\Software\Python26\Lib\site-packages (or your Python/site-packages path), e.g. D:\Software\Python26\Lib\site-packages\osqa
8. Get current version of OSQA: Right-click on "osqa" (the new folder), select "SVN Checkout" from the context menu (requires that you properly installed TortoiseSVN), set URL to http://svn.osqa.net/svnroot/osqa/trunk/ - make sure Checkout Depth is "Fully recursive"
9. Configuration: Rename settings_local.py.dist to settings_local.py, change DATABASE-Settings according to how you had your MySQL database set up (you may have to create a user and database first).
10. Database Setup: In the console, go to the osqa-path, D:\Software\Python26\Lib\site-packages\osqa - and execute:
Do NOT create a user when prompted!
11. First test: Test if OSQA is working so far by running
and connecting to the given URL (http://127.0.0.1:8000/). You could also call
manage.py runserver 126.96.36.199:8080 to start listening on a specific IP and port.
12. Create the first user (which will be the admin). login / Create account … choose appropriate screen name (admin or something like that).
13. Admin Settings Go to http://127.0.0.1:8000/admin/ to apply any necessary admin settings and switch on bootstrap mode if you wish so.
Getting OSQA running in IIS
14. I tried it with PyISAPIe ... but that was a major failure, even the test/proj fromhttp://code.djangoproject.com/wiki/DjangoOnWindowsWithIISAndSQLServer didn't work (got a 500 error, did some research and tried a couple of things but in the end I guess the problem is that the instructions don't fully match with the current PyISAPIe version, see Examples/Django/Readme.txt) ... so then I tried
but that also didn't get me anywhere due to lack of documentation that I could conveniently work with.
I guess the best solution would probably be using WSGI with PyISAPIe but I wasn't able to find proper instructions on how to get that accomplished (and as I'm not a Python / Django developer, I guess I'm out of luck for now).
EDIT: I haven't tried those instructions, yet - but from the memory of my experiences, this might help with some (or even all) of the issues I ran into trying to use PyISAPIe: