How to install Odoo 12 on Ubuntu 18.04

This will install Odoo, PostgreSQL and Apache on Ubuntu 18.04. If installing using Vagrant, the forwarding port mapping in Vagrantfile should be something like: “forwarded_port”, guest: 8069, host: 8080 where host can be 80 or anything else you choose. Odoo runs on port 8069 and will map to the host port you choose to access in your browser. 1. Server requirements calculation […]

How To Manually Upgrade phpMyAdmin

1. Back up phpMyAdmin You should back up your current phpMyAdmin folder by renaming it: $ sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak 2. Create a new phpMyAdmin folder: $ sudo mkdir /usr/share/phpmyadmin/ Change to directory: $ cd /usr/share/phpmyadmin/ 3. Download and Extract phpMyAdmin Go to the phpMyAdmin download page and look for the latest .tar.gz URL and download […]

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: $ 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 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 on the same server […]

PicoCMS for Nextcloud & Nginx 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/ 2. Install a valid SSL certificate See How To Issue LetsEncrypt ACMEv2 Wildcard Certs 3. Add a new nginx server block Add this code to the end of an existing server block or […]