No Roundcube DB in phpMyAdmin

gwen_the_hen

• October 22, 2018 02:21

Hello, I've just set up a new server with cPanel, running on a dedicated server. However, I've checked in phpMyAdmin and I can't see a DB for Roundcube. That's not really an issue at the moment as we don't host any email currently, but I just wanted to check in case we ever need it. Should there be a database for Roundcube?

• 

  rpvw

  • October 22, 2018 08:20

  Roundcube uses SQLite for its database now. (I think this was first introduced back at cPanel v11.26 and made default at 11.4x - A cPanel staff member can correct this if I got the wrong versions - anyway it was a long time ago ;) ) A new cPanel install will probably set up the DB as a Lite by default See Hope this helps.

  0
• 

  gwen_the_hen

  • October 22, 2018 08:50

  Thanks for the update, that's great. How does SQLite work from an administration point of view? Can the database be access directly in any way?

  0
• 

  rpvw

  • October 22, 2018 09:13

  I don't think there is anything in WHM like phpMyAdmin to manage SQLite databases. There is a php solution called phpliteadmin.org/ phpLiteAdmin but it would either have to be included in a user-space as part of a domain website or subdomain, or open a feature request to ask to have it included in WHM at administrative level. You may be able to manipulate SQLite from a shell : see

  0
• 

  gwen_the_hen

  • October 22, 2018 09:16

  That's great, thanks for the info. I don't have any specific need to do this at the moment, but it's good to know how it works for future reference.

  0
• 

  cPanelLauren

  • October 24, 2018 19:46

  I can answer some of these follow-up questions :) SQLite was the default for Roundcube I believe in v62 for new installations

  I don't think there is anything in WHM like phpMyAdmin to manage SQLite databases.

  
  There isn't anything at this time, you are correct

  There is a php solution called phpliteadmin.org/ phpLiteAdmin but it would either have to be included in a user-space as part of a domain website or subdomain, or open a feature request to ask to have it included in WHM at administrative level.

  
  I have used this a bit as it was recommended to me and it's proven extremely handy though I don't know how much you'd actually need to manipulate the sqlite dbs present now. I checked the feature request site and didn't come across any sqlite specific feature requests that matched this so I think this would be an awesome request. We did have an internal case open to add phpliteadmin but due to a lack of interest in the ability to manage SQLite applications, it was shot down. A feature request would show us if this is something that's growing some interest

  You may be able to manipulate SQLite from a shell : see

  0

Please sign in to leave a comment.