cPanelAaronH
- Total activity 949
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 0
- Subscriptions 614
Articles
Recent activity by cPanelAaronH-
MySQL Database appear within cPanel, but they do not appear within phpMyAdmin.
Symptoms MySQL databases are being created successfully by cPanel but not showing up in phpMyAdmin Description First check /usr/local/cpanel/logs/error_log - if you see the following: DBD::mys...
-
Removing an email account produces an error from “SQLite”: SQLITE_ERROR (no such table: annotations)
Symptoms When removing an email account in the cPanel user interface, you encounter an SQLite error where SQLite cannot find the table annotations, but you still see the email account was removed f...
-
How do I restore a Postgres database?
Question How do I restore a copy of my Postgres database? Answer To restore the databases as user Postgres, first, move your archive into /var/lib/pgsql and change its owner/group to user Postgr...
-
How to determine the size of PostgreSQL database?
Question How can I verify the size of a database for PostgreSQL? Answer Repace dbname with your database name. psql -U postgres -l SELECT pg_size_pretty( pg_database_size('dbname') );
-
How to clear out the archives for Mailman
QuestionHow do you clear out the archives for Mailman? AnswerAn administrator may sometimes want to clear the Mailman archives for a particular mailing list. However, there is no method to do this ...
-
How do I reinitialize MySQL or MariaDB without reinstalling the RPMs?
QuestionHow do I reinitialize MySQL or MariaDB without reinstalling the RPMs? AnswerWarning: The steps outlined in this guide move the existing data. You will need cPanel backups or SQL dumps in or...
-
MySQL fails to start: Errcode: 30 - Read-only file system
Symptoms There may be times you log in to the WHM or your servers command-line interface and try to restart MySQL. However, MySQL reports MySQL fails to start: Errcode: 30 - Read-only file system...
-
Does cPanel support MariaDB Galera Cluster?
Question Does cPanel support clustering with MariaDB Galera? Answer Due to the limitations of the Galera cluster, this would not be something that cPanel can offer support or advice on in regar...
-
How can I update the SPF record shown under cPanel Email Deliverability from the command line?
Introduction When I log in to cPanel how can I change the SPF record that is listed for all of my users under Email Deliverability? Procedure Utilize the UAPI to update the record for each user. ...
-
How to configure mailhelo for Exim
QuestionHow do you configure mailhelo for Exim? Answer Log in to WHM as the ‘root’ user. Navigate to Home / Exim / Configuration Manager. Click the Domains and IPs tab. Set the Use the reverse DNS ...