1. Documentation
  2. Installation of queXS from scratch on Ubuntu >= 16.04 (may work on Debian)

Installation of queXS from scratch on Ubuntu >= 16.04 (may work on Debian)

  1. Install Ubuntu Server (or run the Ubuntu Cloud AMI)
    • (Note: you should be able to replace quexs-1.3.0 with the version you wish to install)
  2. Log in as the root user
    sudo su
  3. Install the following required packages using the command below:
    apt install php mysql-server php-mysql unzip php-mbstring libphp-adodb

    4. (From here on I'll assume you did not set a root password for the mysql database)

  4. Go to the web root
    cd /var/www/html
  5. Download queXS
    wget http://excellmedia.dl.sourceforge.net/project/quexs/quexs/quexs-2.2.3/quexs-2.2.3.zip
  6. Unzip queXS
    unzip quexs-1.3.0.zip
  7. Make a shortcut from quexs -> quexs-1.3.0
    ln -s quexs-1.3.0 quexs
  8. Install the timezone database to mysql
    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
  9. Create the database and user
    mysql
  10. Then in the mysql client
    CREATE DATABASE quexs;
    CREATE USER 'quexs'@'localhost' IDENTIFIED BY 'password' ;
    GRANT ALL PRIVILEGES ON quexs.* TO 'quexs'@'localhost';
    GRANT select on mysql.time_zone_transition_type to 'quexs'@'localhost';
    GRANT select on mysql.time_zone_transition to 'quexs'@'localhost' ;
    GRANT select on mysql.time_zone_leap_second to 'quexs'@'localhost' ;
    GRANT select on mysql.time_zone to 'quexs'@'localhost';
    GRANT select on mysql.time_zone_name to 'quexs'@'localhost';
    exit
  11. Install the queXS database
    mysql quexs < quexs/database/quexs.sql
  12. Now to configure queXS.Start by going to the queXS directory:
    cd /var/www/html/quexs
  13. Create the default config file
    cp config.inc.local.php.example config.inc.local.php
  14. Edit the default config file
    nano config.inc.local.php
  15. Change the Path to ADODB line to read (Not required for queXS versions >= 1.6.x):
    define('ADODB_PATH','/usr/share/php/adodb/');
  16. Change the database configuration to match the username and password set above
    define('DB_USER', 'quexs');
    define('DB_PASS', 'password');
    define('DB_HOST', 'localhost');
    define('DB_NAME', 'quexs');

    17. Save and exit
    Ctrl + x
    Choose "Yes" to save changes

  17. Restart apache for changes to take effect
    service apache2 restart

    18. Now you can access your installation at the URL of your webserver