Change a Password for PostgreSQL on Linux via Command Line

Reading Time: < 1 minute

PostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.

Note: The default authentication method for PostgreSQL is ident. If you’d like to change the PostgreSQL authentication method from ident to md5, then visit the linked tutorial!

Continue reading “Change a Password for PostgreSQL on Linux via Command Line”

How to List Compiled PHP Modules from Command Line

Reading Time: 2 minutes
Pre-Flight Check
  • These instructions are intended specifically for listing the existing compiled PHP modules from the command line.
  • Your server environment may be different, but we will go over several options that you might run into. We’ll be using an Ubuntu Server with only a single PHP version on it, and two CentOS 7 servers, one with cPanel and one with InterWorx.
Continue reading “How to List Compiled PHP Modules from Command Line”

Changes To CSF Country Blocking

Reading Time: 5 minutes

Issue

Have you seen this error when restarting csf?

*ERROR*: Country Code Lookups setting MM_LICENSE_KEY must be set in 
 /etc/csf/csf.conf to continue using the MaxMind databases

Recently MaxMind, the company that provides the IP lookup database based on country of origin for CSF, has decided to require a free license to be able to access that database now.  They had to do this, so they can conform to the new state law in California for the CCPA act as noted here.

Continue reading “Changes To CSF Country Blocking”

Select a MySQL Database on Linux via Command Line

Reading Time: 2 minutes

Pre-Flight Check

  • These instructions are intended for selecting a MySQL database on Linux via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

Continue reading “Select a MySQL Database on Linux via Command Line”

Show (List) MySQL Databases on Linux via Command Line

Reading Time: < 1 minute

Pre-Flight Check

  • These instructions are intended for showing (listing) all MySQL databases via the command line.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

Continue reading “Show (List) MySQL Databases on Linux via Command Line”

How To Use The YUM History Command

Reading Time: 6 minutes

Have you ever wanted to review past updates or roll back an update that broke your sites or negatively affected some aspect of your server’s operations? Well, you can accomplish this easily by using the yum history command.

Continue reading “How To Use The YUM History Command”

WHM Tutorial: DNS Functions and Tools

Reading Time: 3 minutesIf you have a VPS or Dedicated server running cPanel, and your server is also running private nameservers, you will find the Web Host Manager’s (WHM’s) interface very useful when it comes to updating, creating, or removing DNS zone files for your domains.

Continue reading “WHM Tutorial: DNS Functions and Tools”

How To Create A Software Install List

Reading Time: 3 minutes

Purpose

The purpose of this article is to describe and explore ways to copy or backup your currently existing installed software titles into a single file for later use. We can then use this file to reinstall the software onto another system or clone the existing software across multiple Linux systems on or across a network. This method also prevents the need to install software titles one by one.

Continue reading “How To Create A Software Install List”

Update: WHMCS CURL Bug

Reading Time: 2 minutes

WHMCS has discovered a problem in an earlier EA4 Curl Package introduced on CentOS servers.

Update!

UPDATE: This is reportedly fixed in ea-libcurl-7.67.0-2.2.1, so it should no longer be necessary to downgrade. (https://github.com/CpanelInc/libcurl/commit/7ca2bbb724ac54a3c41950c8736076953bf1429b)

Working versions:
* ea-libcurl-7.66.0-1.1.2.cpanel.x86_64
* ea-libcurl-7.67.0-2.2.1.cpanel.x86_64

Buggy version:
*ea-libcurl-7.67.0-1.1.2.cpanel.x86_64

Per https://forums.cpanel.net/threads/cpanel-curl-update-breaks-whmcs-enom-module.663449/ it may be necessary to restart PHP-FPM to apply the changes to the running PHP binaries.

Continue reading “Update: WHMCS CURL Bug”