Cerberus Helpdesk
From SME Server
Cerberus Helpdesk
Cerberus Helpdesk is a web based email management software created using PHP and MySQL which gives you the ability for your support staff to submit and update support tickets, create SLA plans for supported clients, Knowledgebase integration and more.
cd /usr/local/src
wget http://www.cerberusweb.com/downloads/cerberus-gui-3.6.431.tar.gz
wget http://www.cerberusweb.com/downloads/cerberus-support-center-3.6.431.tar.gz
tar xvzf cerberus-gui-3.6.431.tar.gz
mv /usr/local/src/cerberus-gui/ /opt/cerberus/
tar xvzf cerberus-support-center-3.6.431.tar.gz
mv /usr/local/src/support-center/ /opt/cerberus/support-center/
chown -R www.www /opt/cerberus
chmod 777 /opt/cerberus/config.php
chmod 777 /opt/cerberus/install/siteconfig/index.php
chmod 777 /opt/cerberus/support-center/cerberus-support-center/config.php
Create Cerberus Database
mysql -e "create database cerberusdb"
mysql -e "grant all privileges on cerberusdb.* to cerberus@localhost identified by 'yourpassword'"
mysql -e "flush privileges"
Create a Template Fragement
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
pico 88cerberus
# Cerberus - Help Desk Support Center Alias /cerberus /opt/cerberus Alias /support-center /opt/cerberus/support-center <Directory /opt/cerberus> order deny,allow deny from all allow from all AuthName "Cerberus" AuthType Basic AuthExternal pwauth Satisfy all AddType application/x-httpd-php .php .php3 .phtml php_admin_value open_basedir /opt/cerberus:/tmp </Directory>
Save by pressing Ctrl x, press y to save changes and press enter
expand-template /etc/httpd/conf/httpd.conf
/etc/rc.d/init.d/httpd-e-smith restart
Change into the cerberus directory and edit the file config.php, Set the values for your database configuration on the following lines with the database, user name & password that was used when creating the database steps above:
cd /opt/cerberus
example of config.php
<?php // Database connection information // Type your information in between the single quotes ('s) below define("DB_SERVER",'localhost'); define("DB_NAME",'cerberusdb'); define("DB_USER",'cerberus'); define("DB_PASS",'yourpassword'); // [JAS]: IPs that we'll allow to view upgrade.php. // Add yours here at the end, or replace a 0.0.0.0 // Partial IP masks are allowed. $authorized_ips = array("127.0", "192.168.1", "0.0.0.0", "0.0.0.0" );