Bob: 1 revision

2013-09-19T06:20:02Z

1 revision

New page

==Server Prep==
*apt-get install postgresql php5-pgsql libapache2-mod-php5

==Obtain and Prepare OpenUpload==
*<b>Find latest downloads here:</b> 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

Install OpenUpload - Revision history

Bob: 1 revision