Search found 780 matches

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: 806

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: 306

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: 18
Views: 1545

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: 18
Views: 1545

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: 18
Views: 1545

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: 18
Views: 1545

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: 18
Views: 1545

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:09 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

UNUSED

UNUSED
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: 18
Views: 1545

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.

Not Started
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: 18
Views: 1545

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: 18
Views: 1545

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: 18
Views: 1545

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 wordpressuser with a password of "mydbpass" and grant the user access to the database: mysql -u root CREATE...
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: 18
Views: 1545

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: 18
Views: 1545

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...
by LHammonds
Tue May 19, 2020 10:03 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

Firewall Rules

Firewall Rules Edit the firewall script that was created during the initial setup of the server (if you followed my instructions ): sudo vi /var/scripts/prod/en-firewall.sh Add the following rule which allows connectivity from from anything on your local subnet: echo "Adding Database Server rules" ...
by LHammonds
Tue May 19, 2020 10:02 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

Tighten Security

Secure Installation MariaDB comes with a script to tighten-down security for a production server. Perform these steps on the database server. Connect to the server using PuTTY. Start the secure install script: sudo mysql_secure_installation Enter current password for root: Just press ENTER here sin...
by LHammonds
Tue May 19, 2020 9:58 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

Install MariaDB

Add MariaDB repositories Source of information: MariaDB (NOTE: Your flavor of Linux and download location may vary and that page will help) Perform these steps on each database server. Connect to the server using PuTTY and login with your administrator credentials. Type the following to add the Mar...
by LHammonds
Tue May 19, 2020 9:50 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

Install Ubuntu Server

Install Ubuntu Server The Ubuntu Server Long-Term Support (LTS) is free but we have the option of buy support and that is the main reason this server was selected. The steps for setting up the base server are covered in this article: How to install and configure Ubuntu Server It is assumed that the...
by LHammonds
Tue May 19, 2020 9:48 am
Forum: Tutorials
Topic: How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS
Replies: 18
Views: 1545

How to Install MariaDB 10.4.x on Ubuntu Server 20.04 LTS

Greetings and salutations, I hope this thread will be helpful to those who follow in my foot steps as well as getting any advice based on what I have done / documented. To discuss this thread, please participate here: >>> INSERT LINK HERE <<< High-level overview This thread will cover installation o...
by LHammonds
Tue May 19, 2020 8:54 am
Forum: Tutorials
Topic: How to Install Apache Web Server on Ubuntu Server 20.04 LTS
Replies: 7
Views: 736

Enhance Web Server Security

This section covers settings that can be modified to make it a bit more secure. ServerSignature Turn off ServerSignature to prevent Apache from identifying itself and version number. /etc/apache2/conf-available/security.conf ServerSignature Off ServerTokens Set ServerTokens to the least amount of in...