Convert database Roundcube MySQL to SQLite fail

[HuyND]

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"



I hope everyone can help me to fix this error.

Thanks all.

 

[cPanelLauren]

Hello,


Can you run the following:

/scripts/perlinstaller DBD::mysql

Then, since you're running CloudLinux run you'll need to update CageFS:

cagefsctl --force-update

And let me know if it resolves the issue?

 

[HuyND]

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.

 

[cPanelLauren]

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:

/scripts/check_cpanel_rpms --fix

 

[HuyND]

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.

 

[cPanelLauren]

Hello,


yes that is an option, though the fix for this is most likely fairly simple. Can you provide the output I requested?

 

[HuyND]

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

 

[cPanelLauren]

Thanks for the update and do let us know if you experience any further issues.