Install OpenSupports on Fedora 29



  • OpenSupports is a go at a helpdesk system by basically one guy. It looks nice, but it is lacking in so many features it is just useless.

    Don't believe my review? Try it yourself. Start with the awesome install guide. Sadly you will not be able to turn anything up following that.

    So here is a guide for Fedora so you can judge for yourself.

    ######################################################
    ############## EDIT THESE APPROPRIATELY ##############
    ############### BEFORE YOU COPY/PASTE ################
    ######################################################
    # Database name to use for application
    export DB_NAME='opensupports'
    # Database user to use for application
    export DB_USER='os_user'
    # Folder to install application into
    export APP_DIR='/var/www/html/support/'
    # OpenSupports Version number to download
    export APP_VER='v4.3.2'
    
    # Specify your own password for MariaDB root user
    export DB_ROOT_PASS="somebigpasswordgoeshere"
    
    # Generate a random password for MariaDB root user
    export DB_ROOT_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)"
    echo "This is your MariaDB root password: $DB_ROOT_PASS"
    
    # Specify your own password for the application's database user
    export DB_PASS="somebigpasswordgoeshere"
    
    # Generate a random password for the application's database user
    export DB_PASS="$(head /dev/urandom | tr -dc A-Za-z0-9 | head -c 30)"
    echo "This is your password for the application user: $DB_PASS"
    

    I wasn't going to spend time narrowing this list down to only the essentials after my first test of the software.

    dnf install -y httpd nano mariadb mariadb-server php php-gd php-pdo php-pear php-mbstring php-xml php-json php-mcrypt php-mysqli sendmail wget unzip
    
    # not even going to bother to figure out how to make this work with SELinux
    setenforce 0
    
    systemctl enable --now mariadb
    systemctl enable --now httpd
    
    firewall-cmd --add-service=http --permanent
    firewall-cmd --reload
    
    mysql -e "CREATE DATABASE $DB_NAME;"
    mysql -e "CREATE USER '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';"
    mysql -e "GRANT ALL ON $DB_NAME.* TO '$DB_USER'@'localhost';"
    mysql -e "FLUSH PRIVILEGES;"
    
    # Secure MariaDB (this does what mysql_secure_installation performs without interaction)
    mysql -e "UPDATE mysql.user SET Password=PASSWORD('$DB_ROOT_PASS') WHERE User='root';"
    mysql -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');"
    mysql -e "DELETE FROM mysql.user WHERE User='';"
    mysql -e "FLUSH PRIVILEGES;"
    
    wget https://github.com/opensupports/opensupports/releases/download/$APP_VER/opensupports_$APP_VER.zip
    unzip opensupports_$APP_VER.zip -d $APP_DIR
    chown -R apache:apache $APP_DIR
    
    nano /etc/httpd/conf.d/opensupports.conf
    

    Put this in the nano window

    Alias /support "/var/www/html/support/"
    <Directory "/var/www/html/support">
      Options +FollowSymLinks
      AllowOverride All
    
      <IfModule mod_dav.c>
            Dav off
      </IfModule>
    
      SetEnv HOME /var/www/html/support
      SetEnv HTTP_HOME /var/www/html/support
    </Directory>
    
    systemctl restart httpd
    
    cat << EOF
    
    MySql Database Name     : $DB_NAME
    Database User           : $DB_USER
    Database User Password  : $DB_PASS
    Database Root Password  : $DB_ROOT_PASS
    
    EOF
    

    Navigate to http://your.IP.or.FQDN/support and follow the wizard.



  • Any errors above were copy/paste errors when I grabbed some of the syntax form the IceHRM install guide super quickly.



  • I'll take your word for it. But - software evolves. Maybe this one will also. Every version comes with improvements and errors... well at least generally...



  • @gjacobse said in Install OpenSupports on Fedora 29:

    I'll take your word for it. But - software evolves. Maybe this one will also. Every version comes with improvements and errors... well at least generally...

    Definitely true, and one glaring missing feature (allow email for ticket creation) is supposedly scheduled for the next release. But still a lot of features not there.



  • @JaredBusch said in Install OpenSupports on Fedora 29:

    @gjacobse said in Install OpenSupports on Fedora 29:

    I'll take your word for it. But - software evolves. Maybe this one will also. Every version comes with improvements and errors... well at least generally...

    Definitely true, and one glaring missing feature (allow email for ticket creation) is supposedly scheduled for the next release. But still a lot of features not there.

    I would say the email for ticket is quite an important feature of any ticketing product. The interface is nice though Jared.

    Some type of allowed domain white list is quite handy as well, because you will get loads of crap ticket entries otherwise.



  • Demo link if anyone is interested.

    https://www.opensupports.com/demo/



  • It has huge glaring issues as mentioned. On the user side, user cannot even sort his tickets by title, ticket number, or date. No search, no file uploads, no real organization on menu.

    I just logged into user side using an android device. I didn't log into admin or try from a desktop. It looks pretty nice and is fast though.



  • My summary is it is years away from ready unless a lot more dev hours are able to be added to it.



  • It does look nice though which can't be said for a lot of them.



  • @stacksofplates said in Install OpenSupports on Fedora 29:

    It does look nice though which can't be said for a lot of them.

    That is the reason I looked at it. The view was solid.