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)

  5. Go to the web root
    cd /var/www/html
  6. Download queXS
  7. Unzip queXS
  8. Make a shortcut from quexs -> quexs-1.3.0
    ln -s quexs-1.3.0 quexs
  9. Install the timezone database to mysql
    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
  10. Create the database and user
  11. Then in the mysql client
    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';
  12. Install the queXS database
    mysql quexs < quexs/database/quexs.sql
  13. Now to configure queXS.Start by going to the queXS directory:
    cd /var/www/html/quexs
  14. Create the default config file
  15. Edit the default config file
  16. Change the Path to ADODB line to read (Not required for queXS versions >= 1.6.x):
  17. 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');
  18. Save and exit
    Ctrl + x
    Choose "Yes" to save changes

  19. Restart apache for changes to take effect
    service apache2 restart
  20. Now you can access your installation at the URL of your webserver