Install OpenUpload

Server Prep

• apt-get install postgresql php5-pgsql libapache2-mod-php5

Obtain and Prepare OpenUpload

• 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

Configure Postgres

• > /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

Configure OpenUpload

• 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

Configure Apache

• 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

Configure OpenUpload Plugins and Rights

• 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

Helpful Reading

• http://sourceforge.net/apps/mediawiki/openupload