Install OpenUpload

Server Prep

Find latest downloads here: http://openupload.sourceforge.net/
cd /usr/src
wget http://sourceforge.net/projects/openupload/files/openupload/v0.4/openupload-0.4.2.tar.gz
tar zxf openupload-0.4.2.tar.gz
mkdir -p /Computerisms/sites/fetch.computerisms.com
mkdir -p /usr/local/openupload
cd openupload-0.4.2/
cp -r lib/ locale/ plugins/ sql/ templates/ txtdb/ /usr/local/openupload/
cp -r data/ templates_c/ www/ /Computerisms/sites/fetch.computerisms.com/
sed -i 's/admins/Domain Admins/' /usr/src/openupload-0.4.2/sql/pgsql/2_base.sql
sed -i 's/unregistered/Domain Guests/' /usr/src/openupload-0.4.2/sql/pgsql/2_base.sql
sed -i 's/registered/Domain Users/' /usr/src/openupload-0.4.2/sql/pgsql/2_base.sql
sed -i 's/admins/Domain Admins/' /usr/src/openupload-0.4.2/sql/pgsql/3_mode_private.sql
sed -i 's/unregistered/Domain Guests/' /usr/src/openupload-0.4.2/sql/pgsql/3_mode_private.sql
sed -i 's/registered/Domain Users/' /usr/src/openupload-0.4.2/sql/pgsql/3_mode_private.sql

> /etc/postgresql/9.1/main/pg_hba.conf; vi /etc/postgresql/9.1/main/pg_hba.conf
chown postgres:postgres /etc/postgresql/9.1/main/pg_hba.conf
/etc/init.d/postgresql restart
su - postgres
createuser -P -S -D -R -l fetch
createdb --owner=fetch fetch "DB for fetch.computerisms.com"
psql -h 127.0.0.1 -W -U fetch -f /usr/src/openupload-0.4.2/sql/pgsql/1_structure.sql
psql -h 127.0.0.1 -W -U fetch -f /usr/src/openupload-0.4.2/sql/pgsql/2_base.sql
psql -h 127.0.0.1 -W -U fetch -f /usr/src/openupload-0.4.2/sql/pgsql/3_mode_private.sql
exit

vi /Computerisms/sites/fetch.computerisms.com/www/config.inc.php
chown -R fetch:fetch /usr/local/openupload/ /Computerisms/sites/fetch.computerisms.com/
find /Computerisms/sites/fetch.computerisms.com/ -type d -exec chmod 2770 {} \;
find /Computerisms/sites/fetch.computerisms.com/ -type f -exec chmod 0660 {} \;
rm /Computerisms/sites/fetch.computerisms.com/www/.htaccess

sed -i 's/\;date.timezone =/date.timezone = America\/Whitehorse/' /etc/php5/apache2/php.ini
vi /etc/apache2/sites-available/fetch.computerisms.com.conf
mkdir /var/log/apache2/fetch.computerisms.com
chown root:adm /var/log/apache2/fetch.computerisms.com/
a2ensite fetch.computerisms.com
/etc/init.d/apache2 restart
samba-tool dns add houselian computerisms.com fetch A 192.168.26.10

navigate to https://fetch.computerisms.com/
log in as the network Administrator or as any member of Domain Admins, like bob.miller
navigate to the Administration link, then choose plugins.
- select plugin options and configure the plugins how you want to use them==Configure Plugins==
- navigate back to plugins=>plugins ACLs. Click the "plug"in in the top left
- choose the plugin and the group to assign it to, as well as access permissions.
User and Group Administration is not handled in this interface, all users under dc=computerisms,dc=com in the AD will be able to log in.
- restrict this wtih the basedn in the config file, or by setting all groups to full deny and creating specific groups in AD that will have Rights
Groups are not created in this interface, but rights are granted to the group the user belongs too
- navigate Administration=>Rights. Select groups that obviously do not need access, like DNSAdmins, and set them to full deny
  - If you see ERROR: query failed: INSERT INTO with a corresponding duplicate key value violates unique constraint in the apache log just keep doing it, it will get a unique key eventually
  - <credit:>http://howto.landure.fr/gnu-linux/debian-4-0-etch/installer-loutil-de-partage-de-fichiers-open-upload-sur-debian
    - took me 12 times to change the rights on a group