Convert database Roundcube MySQL to SQLite fail

HuyND

• October 30, 2019 04:32

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

  • October 30, 2019 19:36

  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?

  0
• 

  HuyND

  • October 31, 2019 17:05

  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.

  0
• 

  cPanelLauren

  • October 31, 2019 18:47

  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
  

  0
• 

  HuyND

  • November 12, 2019 07:39

  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.

  0
• 

  cPanelLauren

  • November 12, 2019 22:59

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

  0
• 

  HuyND

  • November 14, 2019 01:50

  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

  0
• 

  cPanelLauren

  • November 14, 2019 16:40

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

  0

Please sign in to leave a comment.