Skip to main content

Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED!

bitpt
Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator. I got this error for a few accounts only and after migrate from a server with roundcube in mysql all accounts migrated with transfer tool. New server have sqlite roundcube db. A few email accounts have this issue not all in server. Fix permissions do nothing. Create new email in same domain/cpanel user account, work fine. Delete email account without roundcube access and create newone don't solve this. Some of this accounts with issues have mdbox before. Convert to maildir or mdbox don't change nothing. Horde work fine in all accounts. Can someone help me with this one? Thanks

Comments

8 comments

Date Votes
  • andrew.n
    It seems you missed to include the error itself :D
    0
  • bitpt
    Sorry!!! Only for a few email accounts Roundcube - sqlite DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
    0
  • andrew.n
    So its only happening for a few email accounts? Can you try to convert the database for those users? /scripts/convert_roundcube_mysql2sqlite
    0
  • cPRex Jurassic Moderator
    Try that conversion script and let us know!
    0
  • bitpt
    In same cpanel user account (domain.com), some emails mail1@domain.com are ok, others mail2@domain.com fail. New email account works fine. /scripts/convert_roundcube_mysql2sqlite fail with error : all accounts already in sqlite "warn [convert_roundcube_mysql2sqlite] mysql database roundcube is missing The optional user argument is to be used only when Roundcube has been converted to sqlite. Use bin/update-roundcube-sqlite-db Exiting." When email account deleted and create same email after deleting, same error. But, if new email, work fine without any issue. Changing email password do nothing, error again.
    0
  • andrew.n
    Have you tried the script it says? bin/update-roundcube-sqlite-db
    0
  • bitpt
    Solved!!! after search for bin/update-roundcube-sqlite-db path is # /home/virtfs//usr/local/cpanel/bin/update-roundcube-sqlite-db Roundcube is up to date. Execute '/home/virtfs//usr/local/cpanel/bin/update-roundcube-sqlite-db --force' to force an update. # /home/virtfs//usr/local/cpanel/bin/update-roundcube-sqlite-db --force /home/virtfs//usr/local/cpanel/bin/update-roundcube-sqlite-db: running in the background. all accounts ok Thanks for your time
    0
  • nlaruelle
    Hello, Sorry, I had this error today for 1 mailbox of 1 user : Roundcube database error : connection failed. Unable to connect to the database" I was already on SQLite and all rebuild commands shared around did not the trick. The solution was for me" finally archiving / removing the rcube.db files in the /etc/ cPanel user folder" /home/$user/etc/example.com/*.rcube.db*
    "works and we get back access to Roundcube without any data loss. Proceed with caution and backup all your files before trying to delete something.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post