mysql -e 'SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;'
mysql list all databases and size
Leave a reply
Category Archives: Hosting
ERR_TOO_MANY_REDIRECTS prestashop security compromised
index.php/security/compromised?uri= ERR_TOO_MANY_REDIRECTS prestashop
Check session directory access: 1777 /var/lib/php/session
Helo command rejected: Host not found (in reply to DATA postfix
You need to check your hostname, also you can set:
vim /etc/postfix/main.cf
myhostname = myhostname = virtual.domain.tld
service postfix restart
csf enable port
vi /etc/csf/csf.conf
check TCP_IN and TCP_OUT port list and restart csf -r
directadmin panel force ssl
directadmin ssl_port
ssl_cipher=HIGH:!aNULL:!MD5
ssl_port=XXXX
XXXX your port number
*WARNING* URLGET set to use LWP but perl module is not installed, reverting to HTTP::Tiny
*WARNING* URLGET set to use LWP but perl module is not installed, reverting to HTTP::Tiny
Centos:
yum install perl-libwww-perl net-tools perl-LWP-Protocol-https
Debian/Ubuntu:
apt-get install libwww-perl
sni for exim directadmin
It should fix Outlook errors like Cannot verify Security Certificate or Internet security warning
Common name: localhost issue
cd /usr/local/directadmin
echo mail_sni=1 >> conf/directadmin.conf
service directadmin restart
cd custombuild
./build update
./build set eximconf yes
./build set eximconf_release 4.5
./build set dovecot_conf yes
./build exim_conf
./build dovecot_conf
cpanel list account and domain
cat /etc/trueuserdomains | awk '{ print $2" "$1}' | sed 's/://'
Checking C compiler….Could not locate an executable “gcc” binary….Done ** Unrecoverable Error ** The C compiler is not functional and auto repair failed. Perl module installs require a working C compiler.
Checking C compiler….Could not locate an executable “gcc” binary….Done ** Unrecoverable Error ** The C compiler is not functional and auto repair failed. Perl module installs require a working C compiler
You should find Compiler Access in WHM and enable it for some users.
kubeadm [ERROR Swap]: running with swap on is not supported. Please disable swap
swapoff -a
Remove swap from /etc/fstab
directadmin relay mail exim.routers.pre.conf
vi /etc/exim.routers.pre.conf
smart_route:
driver = manualroute
domains = ! +local_domains
ignore_target_hosts = 127.0.0.0/8
condition = “${perl{check_limits}}”
transport = remote_smtp
route_list = * another.smtp.server
no_more
service exim restart
[access_compat:error] [pid 28167:tid 140515211155200] [client xx.xx.xx.xx:37918] AH01797: client denied by server configuration: /var/www/html/
Forbidden You don’t have permission to access / on this server
You should check directory permissions: namei -l /var/www/html/, if permissions are fine you need check virtual host configuration if there are no such options like ‘Deny from all’, if virtual host fine, you need search for .htaccess like this: find / -type f -name .htaccess
PHP Fatal error: Call to undefined function utf8_substr() in /home/xxx/public_html/catalog/model/tool/image.php on line 11
Check you have installed mbstring or iconv PHP extension installed. Because Opencart requires it.
Primary script unknown error in php-fpm httpd rewrite
If you had something like this:
ProxyPassMatch “^/(.*\.php(/.*)?)$” “unix:/var/run/php-fpm/php.sock|fcgi://localhost/some/path” enablereuse=on
Advice is to change to SetHandler:
<Directory "/some/path"> <FilesMatch \.php$> ProxyErrorOverride on SetHandler "proxy:unix:/path/to/sock/php.sock|fcgi://localhost" </FilesMatch> </Directory>
directadmin iMagick
yum install ImageMagick-devel
cd /usr/local/php70/bin
./pecl upgrade-all