roundcube database type

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
I know there are plenty of resources on how to convert roundcube from mysql to sql lite. However, Is there a way to tell what I am running without using the transfer tool and viewing the warning?
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
Ok, the only way I found so far is to use mysql to see if there is a database called roundcube. I know the conversion is one way. So the only way to go back is rebuild the server from scratch? I don't how this got converted.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,275
313
Houston
Yes if you were still using MySQL for some reason you would see the roundcube db there - the conversion is a one-way street and there's no supported method to convert it back to MySQL I'm curious what would prompt you to need to go back to MySQL from SQLite?
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
To be honest, (and to my embarrassment), since we do not use the email part of cPanel on our servers. I didn't know much about this. I only learned about it when I was using the transfer tool and the warning popped up about Roundcube SQL type not being the same on the source and destination server. For some reason, we have one server that is different. The others all match with MySQL. I am not sure if a previous colleague converted it or how it was converted. I'm not sure why it would have been converted since we do not use it.

I know this is unlikely, but does any of the MySQL upgrade paths convert Roundcube automatically? Additionally, I know the warning said there could be issues in migration from one to the other, but if we do not use the email part, have you heard of any major problems? I hope to read up on this more. I just thought I would ask as well while I'm here :)
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,275
313
Houston
If you don't even use email on the servers I wouldn't even worry about the conversion process you can run the script here: /scripts/convert_roundcube_mysql2sqlite if it can't complete for some reason it won't proceed with the conversion process.

The MySQL upgrade wouldn't have done this but I believe we may have suggested doing this at one point and even included automation for performing this conversion but I can't find confirmation of this now. What version of cPanel is the server which is still using MySQL on?
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
if I try to transfer an account from a server using SQLlite for roundcube to another using MySQL for roundcube. What would the dangers be? I know I mentioned we don't use/support email through cpanel. But there looks to be default accounts created for catch all etc. If we tried to transfer, then would the email just get lost? The email accounts would be gone / not transferred? I think I tried a transfer once and the account on the source server was deleted.

if I just transferred the account manually would that be better. Just manually transferring the database and public_html (and maybe public_ftp if that is used). Would this be better.
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
I'm not sure if it is related to the database type difference. But in a test account test. it fails to transfer completely, says in warnings/errors that it connection times out, it transfers the files, but not databases (this was a wordpress test site)

ok, found time out settings under tweak settings, I raised it and will try again
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
figured out the timeouts/transfer errors. It was due to port being closed between servers on 2087. After that, it seems to transfer OK? I'm still not sure if there are issues with the database type.
 
  • Like
Reactions: cPanelLauren

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
Ok, got a successful transfer, even with a email account that I added, that seemed to transfer as well. with the roundcube mismatch it seems. However, I'm not sure if there are any unknown issues that might arise?
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,275
313
Houston
Port 2087 will most definitely cause issues in the transfers, I don't know of any issues that would occur due to the roundcube mismatch, it's not going to use both and since you don't use mail concerns about data that was stored in the previous roundcube is not needed.
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider
Thanks,

However, (for curiosity sake) if we did use email and the source server is using SQLite for email, if I transfer to a destination server with MySQL roudcube, would it loose email or use MySQL or convert the roundcube DB to SQL, or just not transfer it? I guess I'm still not sure what would happen, though you did say no known issues.
 

andrew.n

Well-Known Member
Jun 9, 2020
766
275
63
EU
cPanel Access Level
Root Administrator
Based on my past experience cPanel will do it's job and other than warns you have the environment of the source and destination systems are different it will move everything correctly.
 

ca2236

Well-Known Member
Feb 2, 2018
229
23
18
Nebraska
cPanel Access Level
DataCenter Provider