Roundcube Prepared Responses storage location

Mar 8, 2017
8
0
1
Bradford, West Yorkshire, UK
cPanel Access Level
Root Administrator
A client says they have lost 50 or so prepared responses for a particular address in Roundcube. I am looking for the user configuration but can't find anything that seems to relate to the documentation at all in the Roundcube configuration dumps. Any idea of where else I should be looking?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,903
2,226
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @Simon Greenwood,

Roundcube data is stored in SQLite databases at the following location for each email user:

/home/$username/etc/$domain/$emailuser.rcube.db

Is it possible the user deleted any of the contents within the /home/$username/etc/ directory?

Thank you.
 
Mar 8, 2017
8
0
1
Bradford, West Yorkshire, UK
cPanel Access Level
Root Administrator
Hello @Simon Greenwood,

Roundcube data is stored in SQLite databases at the following location for each email user:

/home/$username/etc/$domain/$emailuser.rcube.db

Is it possible the user deleted any of the contents within the /home/$username/etc/ directory?

Thank you.
It's unlikely. There isn't any sign of an SQLite database in that directory and the SQL dumps in /var/cpanel/roundcube don't seem to have any data. Apparently the user was using the responsive skin for Roundcube but I don't know if that would make any difference. I suspect they may actually be logging in somewhere else.

Thanks
Simon
 
Mar 8, 2017
8
0
1
Bradford, West Yorkshire, UK
cPanel Access Level
Root Administrator
It's unlikely. There isn't any sign of an SQLite database in that directory and the SQL dumps in /var/cpanel/roundcube don't seem to have any data. Apparently the user was using the responsive skin for Roundcube but I don't know if that would make any difference. I suspect they may actually be logging in somewhere else.

Thanks
Simon

Just to update this, the client's server runs a database on another machine. Roundcube was configured to work with MySQL on the local machine. For some reason, a recent update seems to have taken on the system settings, which are for the remote machine so the configuration disappeared.
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,903
2,226
363
cPanel Access Level
DataCenter Provider
Twitter
Just to update this, the client's server runs a database on another machine. Roundcube was configured to work with MySQL on the local machine. For some reason, a recent update seems to have taken on the system settings, which are for the remote machine so the configuration disappeared.
Hello @Simon Greenwood,

Is it possible the default_host entry in the /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php file was manually modified at some point on this system? Can you verify which version of cPanel & WHM is installed on the affected system? Also, can you check to ensure the /root/.my.cnf file is configured with the correct details for the remote MySQL server?

Thank you.
 
Mar 8, 2017
8
0
1
Bradford, West Yorkshire, UK
cPanel Access Level
Root Administrator
Hello @Simon Greenwood,

Is it possible the default_host entry in the /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php file was manually modified at some point on this system? Can you verify which version of cPanel & WHM is installed on the affected system? Also, can you check to ensure the /root/.my.cnf file is configured with the correct details for the remote MySQL server?

Thank you.
This just happened again and it appears that /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php reverted to a local setting where it connected by a unix socket rather than by IP to the remote server. I assume that will be the default setting but where would that be?
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,903
2,226
363
cPanel Access Level
DataCenter Provider
Twitter
This just happened again and it appears that /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php reverted to a local setting where it connected by a unix socket rather than by IP to the remote server. I assume that will be the default setting but where would that be?
Hello @Simon Greenwood,

Could you open a support ticket so we can take a closer look at the affected system and verify what's happening? You can post the ticket number here and we will link this thread to the support ticket.

Thank you.