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

Mysqldump error: The user specified as a definer does not exist

Error:

mysqldump myuser_db > myuser_db.sql

mysqldump: Got error: 1449: “The user specified as a definer (‘user_db’@’localhost’) does not exist” when using LOCK TABLES

To pass this error try to use –single-transaction

mysqldump --single-transaction myuser_db > myuser_db.sql

Should be good now

Source: https://stackoverflow.com/questions/26583103/mysqldump-got-error-1449/26583311Read the rest