Search found 769 matches

by LHammonds
Tue May 26, 2020 7:32 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 76

Script - Fix Web Permissions

Fix Web Permissions I use a script to automatically set the web permissions on a regular basis to ensure compliance to standards for each site. The script will set standard ownership, directory and file permissions and then fine-tune the changes needed beyond that. For phpBB, I made a function that...
by LHammonds
Mon May 25, 2020 7:12 am
Forum: Tutorials
Topic: How to install and configure phpBB on Ubuntu 20.04
Replies: 9
Views: 76

Reset Admin Password

Reset Admin Password If you do not know your admin password, you can set the password via the database. Login via SSH to your database server and access the mysql console mysql Look at the databases you have and select the correct one: MariaDB [(none)]> show databases; +--------------------+ | Data...
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: 76

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

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

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

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

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

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

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

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

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: 16
Views: 398

Export User Grants/Revokes

Export User Grants/Revokes The Percona Toolkit comes with a handy utility called pt-show-grants which will allow you to export an SQL file of all the grants for all your databases into a single file that you can use to audit permissions or help with a restore or help with database migrations. This ...
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: 16
Views: 398

Graphical User Interfaces

NOTE: I have not tested most of these since I tend to use the command-line. However, Adminer is enjoying frequent updates and is a single php file. Web-based interfaces There are a few web-based tools you can get for a GUI front-end to MariaDB. It is not recommended to install a web server on your ...
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: 16
Views: 398

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

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

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

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

Backup Individual Database

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: 16
Views: 398

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 three kinds of backups. First, it pulls all the databases into a single file which is good for restoring everything on new servers. It then pulls by database to crea...
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: 16
Views: 398

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...