[Case 63364] cptmpdb databases and tables

[patchwork]

Hi

I have been transferring sites to a new server and for some reason I have started seeing a lot of temporary databases and tables being created.

All the database names look like this and they all contain 3 tables

cptmpdb_account_cQzM125hgsaHoLSW
--- contactgroupmembers
--- contactgroups
--- cp_schema_version

Does anybody know what they are, what they are for or if they can be deleted?


Pete

 

[cPanelKenneth]

That looks like tables for horde or roundcube. Please open a support ticket with us so we can determine what is causing this (and help resolve it).

 

[patchwork]

They were all created when I used the multi account feature from WHM.

After using the script again I noticed it created more and tried to delete them, after seeing that I decided they were probably safe to delete, so I did.

 

[Prateek]

I can see the same database with data restore done from backup hard disk

can some 1 please confirm its not risky to delete this database

 

[JeffP.]

Another customer has reported this issue today on our helpdesk, and the problem was that the Horde password stored in the /var/cpanel/hordepass file contained a newline, which prevented authentication to the Horde db. As such, when an account was restored on the server, a db at /var/lib/mysql/cptmpdb_${USER}_${RANDOMSTUFF} would remain.

It is not clear how the file had a newline. I'm going to open a case about this with our developers now.

To resolve this issue, I simply echoed the password back into the file, but without a newline:

[[email protected] ~]# cat /var/cpanel/hordepass
passwordhere
[[email protected] ~]

[[email protected] ~]# echo -n passwordhere > /var/cpanel/hordepass
[[email protected] ~]

This is how it should look without the newline:

[[email protected] ~]# cat /var/cpanel/hordepass
passwordhere[[email protected] ~]

Then after restoring an account, I verified that there were no authentication errors to the Horde db, and that no temporary cptmpdb_ database remained.

Also, in my testing, it is safe to remove the temporary cptmpdb_ MySQL databases.

 

[JeffP.]

I have filed case ID # 63364 with our developers regarding this issue. We hope to hear an update soon.

Thanks!

 

[Prateek]

I have filed case ID # 63364 with our developers regarding this issue. We hope to hear an update soon.

Thanks!

hello

i would like to add some information to this issue

i found out that if you terminate such account account get terminated but website function remains normal

 

[jamesterror]

Hi,

We're having the same issue with Remote SQL when restoring backyps - do the passwords on both servers for Horde have to be identical? It seems like every time we restore a user the error rather than create the database it creates a cptmpdb entry.

Thanks,
James

 

[cPanelKenneth]

Hi,

We're having the same issue with Remote SQL when restoring backyps - do the passwords on both servers for Horde have to be identical? It seems like every time we restore a user the error rather than create the database it creates a cptmpdb entry.

Thanks,
James

The passwords cPanel & WHM use to maintain Horde must the same across all servers when using a centralized MySQL server. These passwords are stored in /var/cpanel/hordepass

 

[jamesterror]

The passwords cPanel & WHM use to maintain Horde must the same across all servers when using a centralized MySQL server. These passwords are stored in /var/cpanel/hordepass

Hi Kenneth,

Would any services (EXIM) require to be restarted in order for this to work as when I type "cat /var/cpanel/hordepass" in console after updating the conf.php file it still shows the old pass?

Thanks,
James