[Case 63364] cptmpdb databases and tables

patchwork

Well-Known Member
Nov 2, 2001
95
0
316
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

cPanel Development
Staff member
Apr 7, 2006
4,608
77
308
cPanel Access Level
Root Administrator
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

Well-Known Member
Nov 2, 2001
95
0
316
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

Member
Aug 9, 2011
7
0
51
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.

Well-Known Member
Sep 28, 2010
164
15
68
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:

Code:
[[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:

Code:
[[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.

Well-Known Member
Sep 28, 2010
164
15
68
I have filed case ID # 63364 with our developers regarding this issue. We hope to hear an update soon.

Thanks!
 

Prateek

Member
Aug 9, 2011
7
0
51
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

Member
Feb 28, 2013
22
0
1
cPanel Access Level
Root Administrator
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

cPanel Development
Staff member
Apr 7, 2006
4,608
77
308
cPanel Access Level
Root Administrator
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

Member
Feb 28, 2013
22
0
1
cPanel Access Level
Root Administrator
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