How to update WHM’s Basic WebHost Manager from command line

You need to update the following file:

/etc/wwwacct.conf

Output example:

NS yournameservhere.com
CONTACTEMAIL
HOMEDIR /home
ETHDEV eth0
NS4
SCRIPTALIAS y
NSTTL 86400
ADDR6
TTL 14400
HOST yourhostnamehere.com
LOGSTYLE combined
CONTACTPAGER
DEFMOD paper_lantern
ADDR 11.22.33.44
NS2 yournameservhere2.com

Read the rest

cPanel whmapi1 modifyacct notes

Example of the command:

whmapi1 modifyacct user=XXXX QUOTA=XXXX

Some popular parameters:

BWLIMIT=unlimited
QUOTA=unlimited
CGI=y
CPMOD=paper_lantern
DIGESTAUTH=n
FEATURELIST=default
HASSHELL=n
MAXADDON=unlimited
MAXFTP=unlimited
MAXLST=unlimited
MAXPARK=unlimited
MAXPOP=unlimited
MAXSQL=unlimited
MAXSUB=unlimited
MAX_DEFER_FAIL_PERCENTAGE=100
MAX_EMAILACCT_QUOTA=unlimited
MAX_EMAIL_PER_HOUR=100
FRONTPAGE=n
IP=n
LANG=en
domain=domain.com
user=cpaneluser
MAX_DEFER_FAIL_PERCENTAGE=5
MAX_EMAILACCT_QUOTA=100
BACKUP=0
HASCGI=1
FEATURELIST=featurelist
OWNER=owner
HASDKIM=1
HASSPF=1
[email protected]
Read the rest

How to fix “no title” issue for just uploaded images under WordPress dashboard

The symptoms are looking as the following:

Not sure how this happened probably because of some media plugin but this occurs under your WordPress –> Media when you’re trying to upload any new picture

Anyway I have fixed it by  altering wp_posts table to make ID as index table and enabled AUTO_INCREMENT as showed below

Detailed steps:

- login your phpMyAdmin
- click your database 
- click wp_posts table (watch your prefix)
- click "Structure" tab
- click "More" to set Index/Primary
- click "Change" to enable A_I (AUTO_INCREMENT)
- click "Save"

Should be going well now.… Read the rest

How to disable Mailman archiving

Sudenly you may find that your mailing list archive has grown too large.

So you need to decide if you’re really need to keep your archives and if not then go ahead and disable it:

- Login your cPanel 
- 'Maillist'
- select your mail list
- 'Archiving Options'
- set 'Archive messages?'
Read the rest

How to set up SMTP for Office 365 using WordPress plugin Easy WP SMTP

- Install WordPress Easy WP SMTP Plugin
- WordPress --> Settings --> Easy WP SMTP --> SMTP Setting and append the following settings:
- From Email Address : (your email address here)
- SMTP Host : smtp.office365.com
- SMTP Port : 587
- Type of Encryption: TLS/STARTTLS
- SMTP Authentication: YES
- SMTP Username : (your email address here)
- SMTP Password : (your email address password here)
- Click Save.
Read the rest

How to fix CSF’s error Another app is currently holding the xtables lock

The error should be looking as below:

You have an unresolved error when starting csf:
Error: Error processing command for line [339] (6 times): [Another app is currently holding the xtables lock. Perhaps you want to use the -w option?], at line 339 in /usr/sbin/csf

You need to restart csf successfully to remove this warning, or delete /etc/csf/csf.errorRead the rest

How to fix a login issue after WordPress Multisite split

The slave installation will lose users

wp user list

+—-+————+————–+————+—————–+——-+
| ID | user_login | display_name | user_email | user_registered | roles |
+—-+————+————–+————+—————–+——-+
+—-+————+————–+————+—————–+——-+

And you won’t be able to create new admin user because you don’t have appropriate MySQL tables

wp user create admin [email protected]
Read the rest

How to enable Slow Query Log

Append into /etc/my.cnf the following:

slow_query_log = 1
slow-query_log_file = /var/log/mysql-slow.log
long_query_time = 2

Create /var/log/mysql-slow.log log file and set it as mysql user:

touch /var/log/mysql-slow.log
chown mysql:mysql /var/log/mysql-slow.log

Restart MySQL server:

/scripts/restartsrv_mysql

Monitor the logs using mysqldumpslow command:

mysqldumpslow -a /var/log/mysql-slow.log
Read the rest