Install OpenSupports on Fedora 29

JaredBusch

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.

JaredBusch

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

gjacobse

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...

JaredBusch

@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.

StuartJordan

@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.

IRJ

Demo link if anyone is interested.

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

IRJ

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.

JaredBusch

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

stacksofplates

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

JaredBusch

@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.