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 […]
How To Upgrade To PHP7.2 in Ubuntu
Check your PHP version: $ php -v 1. Add PPA $ sudo add-apt-repository ppa:ondrej/php $ sudo apt update 2. Save current PHP packages Note down the current PHP packages you have, so we can reinstall them for PHP 7.2 $ dpkg -l | grep php | tee packages.txt This will save your current packages to […]
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 […]
Nextcloud Upgrade from 13.x.x to 14.x.x
Errors & Solutions When Upgrading from Nextcloud 13.x.x to 14.x.x Issue/Error 1: A. After updating you can not login and are receiving a ‘wrong password’ message. B. When you try to reset the user password via the cli using occ and see a message stating that the ‘User does not exit’ (but you can see in […]
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 […]
How To Install SuiteCRM On Ubuntu 16.04/18.04
SuiteCRM is a fully featured Open Source CRM, as powerful as Salesforce and Microsoft Dynamics. https://suitecrm.com/solutions/compare-with-salesforce/. To add an SSL certificate (LetsEncrypt), see here. 1. Create a new database Create a new database in MySQL/MariaDB. The easiest way is to use phpMyAdmin. You can also use the command line. 2. Download and unzip SuiteCRM files […]
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 LEMP Stack on Ubuntu 18.04
This will install a LEMP stack on Ubuntu 18.04 but with no SSL certificate (local developement). To add a LetsEncrypt certificate on a development server, see here 1. Update Software $ sudo apt update $ sudo apt upgrade 2. Install Nginx $ sudo apt install nginx Enable Nginx to auto start when Ubuntu is booted […]
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 Rocketchat on Ubuntu 16.04 Using Docker & Docker Compose
1. Install Docker see How To Install Docker On Ubuntu 16.04 2. Install Docker Compose see How to Install Docker Compose on Linux Systems 3. Creating the docker-compose file First, we create a space for our docker-compose.yml file. We will place this in our user’s home directory: $ cd ~ $ mkdir rocket.chat && cd […]
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
How To Issue Lets Encrypt ACMEv2 Wildcard Certs
I will be using the Lets Encrypt ACME v2 Client acme.sh to issue LetsEncrypt wildcard certificates. I will also be using a DigitalOcean server. You can find an additional list of other compatible clients here. You don’t need to renew the certs manually. All the certs will be renewed automatically every 60 days. 1. Install […]