Convert database Roundcube MySQL to SQLite fail

HuyND

Active Member
Oct 29, 2019
26
4
3
Viet Nam
cPanel Access Level
Root Administrator
Hi all,
I'm from Viet Nam. At the present, i'm administrator of cPanel root, I have the plan to upgrade cloudlinux and cPanel to latest version. So, my solution is that i'll build the new VPS with Centos 7 (convert to Cloudlinux after) + cPanel latest version and then migrate all account from old server to the new one.

Now, I'm in stuck like this. cPanel highly recommends that the source server run the same Roundcube database type at least 24 hours to ensure that email accounts using Roundcube will transfer properly. I read the cPanel's document ( How to Convert Roundcube to SQLite - cPanel Knowledge Base - cPanel Documentation ). I used this command line to convert Roundcube database ( /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite ), so this error display

" install_driver(SQLite) failed: Can't locate DBD/SQLite.pm: /home/sshosting/perl5/lib/perl5/DBD/SQLite.pm: Permission denied at (eval 13) line 3.
at /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite line 669"


1572427732286.png

I hope everyone can help me to fix this error.

Thanks all.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,262
313
Houston
Hello,


Can you run the following:

Code:
/scripts/perlinstaller DBD::mysql
Then, since you're running CloudLinux run you'll need to update CageFS:

Code:
cagefsctl --force-update
And let me know if it resolves the issue?
 

HuyND

Active Member
Oct 29, 2019
26
4
3
Viet Nam
cPanel Access Level
Root Administrator
Hi cPanel team,
Thanks for the solution you provided to me, I run this command " /scripts/perlinstaller DBD::mysql ", and then run " /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user ", It still be in stuck, this error still displaying like above. Please help me, thanks you.

1572541512175.png
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,262
313
Houston
Hello,

1. When you installed DBD::mysql what was the output?
2. Did you update CloudLinux's CageFS?
3. What is the output of the following:
Code:
/scripts/check_cpanel_rpms --fix
 

HuyND

Active Member
Oct 29, 2019
26
4
3
Viet Nam
cPanel Access Level
Root Administrator
Thanks you for your support,
I could migrate all accounts to the another server by transfer tool without convert database roundcube to SQLite on old server.
 

HuyND

Active Member
Oct 29, 2019
26
4
3
Viet Nam
cPanel Access Level
Root Administrator
Hi team,
Unfortunately, I migrated all account to new server completely. So on the new server, database roundcube is SQLite, everything seem fine. The output is on the old server and i turned off it, I can't turn it on, that will make a trouble to my customer's service