This installation process works for both Ubuntu 16.04 and 18.04. However, at the time of this writing, Ubuntu 18.04 can only be used for local dev and using yourdomain:8000 but NOT for yourdomain.com (without using port 8000). When trying to install the production version (without port 8000) on Ubuntu 18.04, there seems to be a […]
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: config.vm.network “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 https://www.odoo.com/documentation/12.0/setup/deploy.html#worker-number-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 […]
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 […]