Database error on roundcube on CWP Panel


Notice: WP_Theme_JSON_Resolver::get_user_data(): Error when decoding a theme.json schema for user data. Syntax error in /home/onlinesu/public_html/kb/wp-includes/functions.php on line 6170

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 Query: SELECT * FROM carddav_addressbooks WHERE ((user_id = ‘3’))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /?_task=mail&_token=tee6Pl7prS5tNWlXRyKRmdBY6p2cXU3o)
[18-Jun-2026 19:39:09 +0000]: <3c79m5k8> DB Error: [1146] Table ’roundcube.carddav_addressbooks’ doesn’t exist (GET /?_task=mail&_token=tee6Pl7prS5tNWlXRyKRmdBY6p2cXU3o)

logged into Mysql and went to roundcube database

[root@ok1129 ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 52184
Server version: 10.4.34-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]> use roundcube;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Created the 2 missing tables using below commands

Database changed


MariaDB [roundcube]> CREATE TABLE IF NOT EXISTS carddav_addressbooks (
-> id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-> user_id INT(10) UNSIGNED NOT NULL,
-> name VARCHAR(255) NOT NULL,
-> url VARCHAR(255) NOT NULL,
-> username VARCHAR(255) DEFAULT NULL,
-> password VARCHAR(255) DEFAULT NULL,
-> active TINYINT(1) NOT NULL DEFAULT 1,
-> PRIMARY KEY (id),
-> CONSTRAINT fk_carddav_addressbooks_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.016 sec)

MariaDB [roundcube]> CREATE TABLE IF NOT EXISTS carddav_accounts (
-> id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-> user_id INT(10) UNSIGNED NOT NULL,
-> name VARCHAR(255) NOT NULL,
-> discovery_url VARCHAR(255) NOT NULL,
-> username VARCHAR(255) DEFAULT NULL,
-> password VARCHAR(255) DEFAULT NULL,
-> active TINYINT(1) NOT NULL DEFAULT 1,
-> PRIMARY KEY (id),
-> CONSTRAINT fk_carddav_accounts_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.012 sec)

MariaDB [roundcube]> exit
Bye

This fixed the issue and Roundcube was working perfectly fine

Change user in Ubuntu OS

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 and restart sshd using command

service sshd restart

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

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 the DNS error while domain was pointing to local server with DNS on third party registrar

The issue was due to DNSSEC enabled at domain registrar for the domain name

This was causing failure for auto SSL to install SSL

Disabling DNSSEC fixed the issue and AutoSSL worked fine

/tmp in read only mode cPanel server

/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 mysql
systemctl stop cpanel

umount -f /var/tmp

rm -fv /usr/tmpDSK

/scripts/securetmp

The /tmp is recreated and all services are working fine

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

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

— END HARDENING —

Ping Check for /24 ?

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

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

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

Test Post for WordPress

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.

  1. Step one
  2. Step two
  3. Step three

This content is only for demonstration purposes. Feel free to edit or delete it.

Change wordpress user password from CLI

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 |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+————————–+
13 rows in set (0.01 sec)

select * from wp_users;

Note down the username password you want to reset

and run below command to reset username password

mysql> UPDATE wp_users SET user_pass = MD5(‘Akaomxxx’) WHERE user_login =’username’ ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Issues in emails after changing MX records cPanel

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 fix this isssue

ONce MX records are changed run command /scripts/checkalldomainsmxs –yes

Now check the domain entries in grep /etc/remotedomains

The domain entry will be present in this file

Now remote emails should work fine