cPanel servers use Exim as the Mail Transfer agent. The main Exim log file is (appropriately) named exim_mainlog. The entries in the log are terse…
Category: Server management
Creating cPanel accounts using WHM API 1
In previous articles I looked at how to view and format account information using whmapi1 and how to update the PHP version for one or…
Batch-updating PHP versions using WHM API 1
PHP versions are supported for two years, and it is recommended to always use the latest and greatest version. In theory, that is quite easy…
An introduction to whmapi1
cPanel servers have APIs that let you do most of the admin tasks you can do via the grahpical interface from the command line. cPanel…
Parsing Apache access logs
Extracting specific data from Apache access logs is tricky. The files don’t use a single delimiter, so you can’t simply, say, open an access log…
How to set up passwordless access to MariaDB/MySQL
If you regularly access databases on the command line, or if you want to run SQL commands from a script, then you might want to…
Why innodb_file_per_table is important
Although the InnoDB storage engine has many advantages over MyISAM, there are some downsides as well. One disadvantage you may have encountered is that InnoDB…
Converting MyISAM and InnoDB tables
Changing the storage engine for a database table is surprisingly easy, but there are a few things to be aware of. This article looks at…
Advantages of InnoDB over MyISAM
There are quite a few storage engines available for MariaDB. As at June 2021 the default storage engine is InnoDB. However, cPanel servers still use…
Investigating memory usage with sar
The free and top utilities are handy if you want information about the current memory usage on your system. If you want to view historic…