Installing msqt on Mac OS X =============================== 1. Install a webserver and PostgreSQL: -------------------------------------- You need a proper installation of postgresql and Apache; We recommend you ask your system administrator or dive into fink or darwinports. Once this is set up please continue with the database user setup. 2. Create the users needed by MSQT: ----------------------------------- > su postgres > createuser -D -A msqt > createuser -D -A msqtwebuser 3. Setting up a password for the msqt users: -------------------------------------------- > psql template1 template1=# ALTER USER msqt WITH PASSWORD 'msqtpass'; template1=# ALTER USER msqtwebuser WITH PASSWORD 'msqtpass'; template1=# \q You must use the identical password for both, msqt and msqtwebuser. 4. Create the MSQT database: ---------------------------- > createdb -O msqt msqt 5. Download and extract the MSQT-Archive ---------------------------------------- > cd /tmp > curl -O host/msqt-0.7.1.tar.gz > tar -xvzf msqt-0.7.1.tar.gz 6. Create the administrative tables: ------------------------------------ > cd msqt-0.7.1/install/ > psql msqt < ./sql/setup_msqtconfig.sql > exit 7. Install the web application ------------------------------ > cd ../config Edit msqt.conf in an editor of your choice Set the following parameters: DBPASS="msqtpass" DBHOST="" #the paths to webserroot and cgiroot depend on your installation; #this example is for apache2 installed via darwinports: MSQTWEBROOT="/opt/local/apache2/htdocs/msqt-0.7.1" MSQTCGIROOT="/opt/local/apache2/cgi-bin/msqt-0.7.1" STATIC_URL_PREFIX="http:///msqt-0.7.1" CGI_URL_PREFIX="http:///cgi-bin/msqt-0.7.1" WEBSERVERUSER=www WEBSERVERGROUP=www For password protection of MSQT/Admin provide an username and password: MSQTADMINUSER="admin" MSQTADMINPASS="xxx" Then change into the install subdirectory and execute the installation script: > cd ../install > ./install.sh If you are missing some perl module dependencies, install them with the following command: perl -MCPAN -e 'install ', e.G. > perl -MCPAN -e 'install DBD::Pg' 8. Post installation --------------------- The first thing to do now ist to upload a dataset using the MSQT/Admin module, and define it as the default dataset (dataset manager). Otherwise you will get a software error.