Mysql - OnlineSupport4u

Linux

Database error on roundcube on CWP Panel

By Prasad Naik

June 25, 2026

While rest of the website were working fine and while accessing my email account via auto-login it was showing an error Database error connection failed Please contact server administrator After checking the logs in /usr/local/cwpsrv/var/services/roundcube/logs/errors.log found the error due to missing table roundcube.carddav_addressbook 18-Jun-2026 19:39:09 +0000]: <3c79m5k8> DB Error: [1146] Table ’roundcube.carddav_addressbooks’ doesn’t exist (SQL […]

Mysql

Change user in Ubuntu OS

By Prasad Naik

June 25, 2026

Normally Ubuntu allows you to install OS as non root username So you need to login to server as non root user and run command mentioned below to login as root user sudo -i Once you login as root user change below mentioned parameter in /etc/ssh/sshd_config and uncomment PermitRootLogin paramter and change to to yes […]

Mysql

ERROR “Let’s Encrypt™” DNS DCV error on autoSSL cpanel

By Prasad Naik

June 24, 2026

ERROR “Let’s Encrypt™” DNS DCV error (*.xtklaos.com): 400 urn:ietf:params:acme:error:dns (There was a problem with a DNS query) (DNS problem: looking up TXT for _acme-challenge.xxxtklaos.com: DNSSEC: DNSKEY Missing: validation failure <_acme-challenge.xxxtklaos.com. TXT IN>: No DNSKEY record [misc failure] from 142.214.184.xxx for key xxxtklaos.com. while building chain of trust) Was getting an issue where autoSSL was giving […]

Mysql

/tmp in read only mode cPanel server

By Prasad Naik

June 12, 2026

/tmp in server was not allowing any write on it causing mysql to fail below is the solution to fix it Stop all services using /tmp using below command systemctl stop httpd systemctl stop mysqlsystemctl stop cpanel umount -f /var/tmp rm -fv /usr/tmpDSK /scripts/securetmp The /tmp is recreated and all services are working fine

Mysql

[authz_core:error] [pid 180487:tid 180487] [client 129.204.9.155:44768] AH01630: client denied by server configuration

By Prasad Naik

January 15, 2026

Was getting this error on one of the website using wordpress where was not able to change theme or plugin and reverting to main page On troubleshooting this issue found this error due code in .htaccess file in account Renamed the .htaccess and this fixed the issue The code in .htaccess was Require all denied […]

Mysql

Ping Check for /24 ?

By Prasad Naik

October 3, 2025

Well you can check which IP are in use using nmap sudo nmap -sP -PR 212.122.161.* It will scan entire /24 and show results

Mysql

Device eth0 does not seem to be present, delaying initialization” Error

By Prasad Naik

October 2, 2025

Device eth0 does not seem to be present, delaying initialization” Error’ Was getting this error after migrating centos 6 VM to new host The best way to fix this isssue was deleting file rm /etc/udev/rules.d/70-persistent-net.rules and rebooting vm.. Network was up and issue fixed

Mysql

Test Post for WordPress

By Prasad Naik

February 21, 2025

This is a sample post created to test the basic formatting features of the WordPress CMS. Subheading Level 2 You can use bold text, italic text, and combine both styles. Bullet list item #1 Item with bold emphasis And a link: official WordPress site Step one Step two Step three This content is only for […]

Mysql

Change wordpress user password from CLI

By Prasad Naik

February 18, 2025

If you are not able to login to wordpress admin and want to reset password Follow below steps Login to server as root user Check database name in wp-config.php file grep DB_NAME wp-config.php mysql use DB_NAME; mysql> show tables; +————————–+| Tables_in_onlinesu_wp637 |+————————–+| wp_commentmeta || wp_comments || wp_links || wp_options || wp_postmeta || wp_posts || wp_swp_testimonial […]

Mysql

Issues in emails after changing MX records cPanel

By Prasad Naik

February 18, 2025

When user faces issues in email it due to domain MX pointing to remote server in This case login to server and check domain entry whether in local or remote domains grep domain.tld /etc/remotedomains If domains name is not in /etc/remotedomains it will be in /etc/localhost Change the domain MX record in zone file to […]

Mysql

Reset bandwidth CWP

By Prasad Naik

February 2, 2025

To reset bandwidth in CWP is tricky by changing package limits Easier way to reset is resetting limits by below command /scripts/cwp_api account reset_bandwidth username The username is account username