Unable to terminate an account

[Vs Nu]

[2021-02-10 10:43:14 +0530] info [xml-api] Cpanel::Exception/(XID ns5a8y) The system failed to load and to parse the file “/var/cpanel/databases/policeho.json” because of an error: (XID 3aymk2) The system failed to parse the JSON stream data “{"MYSQL":{"owner":"policeho","dbs":{"policeho_wp200":"SERVERIP"},"noprefix":{},"dbusers":{},"server":"SERVERIP"},"version":1}'ns301” for the caller “(eval)” because of an error: garbage after JSON object, at character offset 135 (before "'ns301") at /usr/local/cpanel/Cpanel/JSON.pm line 123.


How to solve it and terminate the account policeho

 

[cPRex]

Hey hey! I checked my personal server and in my json files that ended in "version" that is the very last thing on the line:

./username.json:{"MYSQL":{"server":"1.2.3.4","owner":"username","dbs":{"username_wp":"1.2.3.4"},"dbusers":{"username":{"dbs":{"username_wp":"1.2.3.4"},"server":"1.2.3.4"}},"noprefix":{}},"PGSQL":{"server":"1.2.3.4","owner":"username","noprefix":{},"dbs":{"username_cptest":"1.2.3.4"},"dbusers":{}},"version":1}

It seems like you may just be able to delete the 'ns301" entry from the end of that line to see if that resolves the issue. If that doesn't get things working, it may be easier to actually restore the account from a backup and then delete it.

 

[kodeslogic]

- Take backup of the file /var/cpanel/databases/policeho.json

cp  /var/cpanel/databases/policeho.json   /var/cpanel/databases/x_policeho.json

- Now edit /var/cpanel/databases/policeho.json to remove ns301 from this file and save the changes.

- Now try to terminate the account. If successful, you can delete the backup file /var/cpanel/databases/x_policeho.json as well