OSQA Install Script with MySQL

Question

Is it possible to use OSQA Install Script to install osqa on mysql database?

Accepted Answer

0

Yes. I was able to get OSQA installed with MySQL using the OSQA install script. All you need to do is:

1.) Copy the raw install script text at https://wiki.webfaction.com/wiki/OSQATrunkInstall?format=txt

2.) Make the following substitutions:

Line 60:
    api.create_db (db_name, pwd,'postgresql' )
    api.create_db (db_name, pwd,'mysql')

Line 69:
    api.system("""sed -i 's/DATABASE_ENGINE =.*/DATABASE_ENGINE = "django.db.backends.postgresql_psycopg2"/g' %s""" % settings_file)
    api.system("""sed -i 's/DATABASE_ENGINE =.*/DATABASE_ENGINE = "django.db.backends.mysql"/g' %s""" % settings_file)

Line 83:
    api.delete_db (db_name,'postgresql')
    api.delete_db (db_name,'mysql')

3.) Create a new application of type "Custom Install Script" and choose "show script source". Then paste all of the text between the -----BEGIN WEBFACTION INSTALL SCRIPT----- and -----END WEBFACTION INSTALL SCRIPT----- header and footer.

This should create a new OSQA instance that uses MySQL.

permanent link

answered 19 Jun '11, 20:24

ryans ♦♦
5.0k●10●39●60
accept rate: 43%

Thanks , but How can I use latest version form SVN?

(20 Jun '11, 00:55) hamed

You can do this by modifying the section under "download osqa and shuffle folders" to use a svn checkout.

That said, our OSQA script actually did originally use the latest svn check-out by default. But it would continuously break, cause strange errors, or be generally unstable. Then later changes in the SVN would fix those problems (and introduce new ones). The result is that there was no consistency in using the latest version from SVN, and this is expected since the latest SVN is just a work-in-progress. It was considered a great improvement when we modified the script to work with the latest released version at the time, rather than relying on the SVN checkout.

So, instead, the best way to get a newer version is just to modify the "wget" line of code in here to download a later release version. Release versions tend to have fewer bugs in general.

(20 Jun '11, 01:05) ryans ♦♦

I installed osqa by hand and configured it to use mysql. However, the search is broken. Is it related to mysql (found reference here: http://meta.osqa.net/questions/8198/why-search-engine-is-not-displaying-nothing-no-matter-what-keyword-i-enter)

Does search work with postgresql?

(31 Jul '11, 13:09) michalis

OSQA Install Script with MySQL

Follow this question

Related questions