Search found 826 matches

by LHammonds
Sun May 24, 2020 3:31 pm
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Styles

Installing New Styles Visit this sites: https://www.phpbb.com/customise/db/styles-2 Browse for the style(s) you want. Right-click the download link and copy the URL. In Putty, download, unzip and remove the archive. Then set the owner/permissions and move to its final destination. Example: cd /tmp ...
by LHammonds
Sun May 24, 2020 3:31 pm
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Upgrading phpBB

Upgrading phpBB The download page for phpbb does a pretty-good job of telling you how to upgrade phpBB. It can get a bit confusing if you are upgrading very old versions of phpBB so here is what I did to upgrade 3.0.8 to 3.2.0 which required (for me) upgrading to specific versions in between. Pre-U...
by LHammonds
Sun May 24, 2020 9:34 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Install phpBB

Install phpBB At the login prompt, login with your administrator account ( administrator / myadminpass ) and then temporarily grant yourself super user privileges by typing sudo su Type the following commands: mkdir /var/www/forum.mydomain.com cd /tmp wget https://download.phpbb.com/pub/release/3.3...
by LHammonds
Sun May 24, 2020 9:21 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Configure Apache Web Server

Add Non-SSL Apache Site Configuration

Refer to this tutorial but substitute the example domain name and path for yours.

Add SSL Apache Site Configuration

Please refer to this tutorial but substitute the example domain name and path for yours.
by LHammonds
Sun May 24, 2020 9:20 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Required and Optional Libraries

Install Required phpBB Libraries Type the following to install the required libraries: apt -y install php7.4-json Install Optional phpBB Libraries Type the following to install the optional libraries: apt -y install php7.4-gd php7.4-xml php-imagick PHP Module Verification Make sure the modules you ...
by LHammonds
Sun May 24, 2020 9:19 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Configure Database

Configure MariaDB / MySQL In this scenario, a dedicated and general-purpose database server already exists and it will be used to hold the application's database. Connect to the MariaDB/MySQL server using PuTTY. At the login prompt, login with your administrator account ( administrator / myadminpas...
by LHammonds
Sun May 24, 2020 9:10 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

Server Preparation

Create Ubuntu Web Server Click here for detailed instructions on setting up a production-quality Ubuntu Server . Once you have the base operating system installed, proceed to follow these instructions to install Apache web server . When it talks about setting up your web root, be sure to substitute...
by LHammonds
Sun May 24, 2020 9:04 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 10069

How to install and configure phpBB on Ubuntu 20.04

Overview phpBB is a free PHP-based bulletin board forum software. This documentation will describe the steps to manually install the software onto a dedicated web server and tie it into a separate dedicated database server which is typical of a production environment rather than having an entire LA...
by LHammonds
Fri May 22, 2020 8:50 am
Forum: Miscellaneous
Topic: Apple iPhone Must-Have Apps
Replies: 0
Views: 3582

Apple iPhone Must-Have Apps

These are the apps I use on a regular basis: Compress Photos & Pictures by New Marketing Lab, Inc. - If I have to send a screenshot/picture via text, I'd rather compress the 5 to 10 MB picture to just 0.2 MB to save time uploading for myself and bandwidth/data for the recipient...wished this was bui...
by LHammonds
Tue May 19, 2020 10:36 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Additional Security Measures

Rename root For increased security, you can rename the root account to something else with the following commands: USE mysql; UPDATE USER SET User='NewSecretRoot' WHERE User='root'; FLUSH PRIVILEGES; Review User Accounts SELECT User,Host,Password FROM mysql.user; Make sure everyone has a password s...
by LHammonds
Tue May 19, 2020 10:25 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Fail2Ban

Fail2Ban If you have Fail2Ban installed and protecting SSH as part of the base install. You can add these few changes to also watch for database login failures. vi /etc/fail2ban/jail.local Add the following to the bottom. If your data path is different, be sure to update "logpath" [DEFAULT] ## 127....
by LHammonds
Tue May 19, 2020 10:21 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Crontab Schedule

Crontab Schedule I would not advise anyone to ever "edit" a live crontab schedule by typing "crontab -e" but rather edit a saved schedule file and then load the schedule file. This will allow you to make backups of the schedule so you can always go back to a known-good schedule or at least back to ...
by LHammonds
Tue May 19, 2020 10:20 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Migration

Migrate Database from Old Server You can use the full backup automatically made by the "db-backup.sh" script (/bak/mysql/db-all.sql) if you have that already running or you can create a manual backup. The steps below will document how to do it manually but you could just as easily use your existing...
by LHammonds
Tue May 19, 2020 10:19 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Backup On Demand

Database Backup On Demand This script is designed to run every minute looking for key files. If a specific file shows up on the share folder, it will trigger an immediate backup of the specified database. This is helpful when scheduling the backup of an app server and coordinating the backup of the...
by LHammonds
Tue May 19, 2020 10:08 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Decrypt Restore Script

This script will let you pick an encrypted archive to be decrypted and extracted to the temp folder. Once extracted, you can manually restore the database(s)/table(s) however you see fit. Create the script: touch /var/scripts/prod/db-decrypt.sh chown root:root /var/scripts/prod/db-decrypt.sh chmod 7...
by LHammonds
Tue May 19, 2020 10:08 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Backup All Databases

Database Backup Script This script is designed to perform a full backup of all databases while the server is online. It actually does several tasks which you can tailor to your needs: Extracts the system database, compresses it into a single archive and encrypts it. Extracts all user databases into...
by LHammonds
Tue May 19, 2020 10:07 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Scripting

Scripting Much of the solutions beyond this point involve scripts (programming snippets / automated commands). In particular, they are Bash Scripts. I chose this due to its popularity and the fact it comes with Ubuntu. I try to make use of what comes with the system without requiring additional sof...
by LHammonds
Tue May 19, 2020 10:07 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Usage Examples

Usage Examples Connect to the server using PuTTY. At the login prompt, login with your administrator account. Start a database session and create a database called wordpress and a user called u_wordpress with a password of "mydbpass" and grant the user access to the database: mysql -u root CREATE D...
by LHammonds
Tue May 19, 2020 10:06 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Reset lost root password

Reset lost root password If you ever find yourself in the position of not being able to login (locally) to your database with your root account, you will need to reset the password. For example, phpmyadmin fails to change the password correctly and neither the old nor the new password works. This p...
by LHammonds
Tue May 19, 2020 10:05 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 17
Views: 16076

Relocate the Databases

Relocate the Databases If you do not want to leave your databases in the default location (/var/lib/mysql), then you can follow these steps to move them somewhere else. In this example, we will move them to /opt/mysql At the login prompt, login with your administrator account At the console, type t...