Adminer – A Simple & Secure Replacement For phpMyAdmin

Why replace phpMyAdmin with Adminer? Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Adminer development priorities are: 1. Security, 2. User experience, 3. Performance, 4. Feature set, 5. Size. Works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB. And it’s only a single PHP file! After playing around […]

How To Upgrade OpenProject

This upgrade was completed on Ubuntu 16.04 and also applies to Ubuntu 18.04. As of 2019.01.06 – OpenProject 8.2.0 1. Backup OpenProject $ sudo openproject run backup This will store the current database dump, attachments and config to ‘/var/db/openproject/backup’. To Restore, see the info at the bottom of this page. 2. Upgrade the package source If you have […]

Nextcloud Upgrade from 14.x.x to 15.0.0

Errors & Solutions When Upgrading from Nextcloud 14.x.x to 15.0.0 Issue/Error 1: A. In Settings > Overview, there is a php-fpm configuration error: https://docs.nextcloud.com/server/14/admin_manual/installation/source_installation.html#php-fpm-tips-label $ sudo nano /etc/php/7.2/fpm/pool.d/www.conf Solution 1 Uncomment these lines: env[HOSTNAME] = $HOSTNAME env[PATH] = /usr/local/bin:/usr/bin:/bin env[TMP] = /tmp env[TMPDIR] = /tmp env[TEMP] = /tmp Issue/Error 2: A. You get a message […]

How To Install LAMP Stack On Ubuntu 18.04

1. Install Apache using Ubuntu’s package manager, apt: $ sudo apt update $ sudo apt install apache2 Modify apache to allow URL rewrites: sudo nano /etc/apache2/sites-available/000-default.conf Create a directory section where we allow overrides: <VirtualHost *:80> ServerAdmin webmaster@localhost DocumentRoot /var/www/html ServerName server_domain_name_or_IP <Directory /var/www/html/> AllowOverride All </Directory> . . . sudo a2enmod rewrite sudo systemctl […]

OnlyOffice vs Collabora: a critical comparison

https://medium.com/onlyoffice/onlyoffice-vs-collabora-a-critical-comparison-18a5ba0dee62 Collabora My analysis is that although OnlyOffice seems to have more features, it needs FAR more hosting resources than Collabora. The minimum resources for OnlyOffice are below. In comparison, Collabora can be setup on a 1GB RAM server (using about 65% of ram). I have also managed to install rocket.chat on the same server […]

PicoCMS for Nextcloud & Nginx

http://picocms.org/about/ Pico is a stupidly simple, blazing fast, flat file CMS. That’s definitely a mouthful, what does it even mean? In the most basic sense, it means that there is no administration backend or database to deal with. You simply create markdown files in the content folder and those files become your pages. There’s much […]

How To Install Collabora Using Docker On Ubuntu 16.04

This Collabora install is used for integration with Nextcloud. 1. Create subdomain for the Collabora online server $ sudo mkdir /var/www/office.example.com/html 2. Install a valid SSL certificate See How To Issue LetsEncrypt ACMEv2 Wildcard Certs 3. Add a new nginx server block https://icewind.nl/entry/collabora-online/ Add this code to the end of an existing server block or […]

How to Install Docker Compose on Linux Systems

https://docs.docker.com/compose/install/#install-compose 1. Run this command to download the latest version of Docker Compose: $ sudo curl -L https://github.com/docker/compose/releases/download/1.21.0/docker-compose-$(uname -s)-$(uname -m) -o /usr/local/bin/docker-compose Use the latest Compose release number in the download command. The above command is an example, and it may become out-of-date. To ensure you have the latest version, check the Compose repository release […]

How To Protect SSH With Fail2Ban

Install Fail2Ban on Ubuntu 16.04 $ sudo apt-get update $ sudo apt-get install fail2ban The default settings are good and for more info see the link below. With the default settings, the fail2ban service will ban a client that unsuccessfully attempts to log in 5 times within a 10 minute window. https://www.digitalocean.com/community/tutorials/how-to-protect-ssh-with-fail2ban-on-ubuntu-14-04