Subaccounts for users/teams failing after cPanel ELevate upgrade

Paul Fitzgibbons

• September 03, 2024 15:23

Earlier this year, we upgraded our CentOS 7 cPanel install to AlmaLinux 8 using cPanel ELevate and things initially seemed OK. On a side note, it was disappointing that cPanel stopped updating its software prior to the 30th June 2024 EOL of CentOS 7 - it took me a while to realise our CentOS 7 install was lagging behind the latest cPanel release because of this.

However, recently some accounts have been attempting to modify/add/delete subaccounts as users or team members and it's been failing with an SQlite error:

The system failed to connect to the “SQLite” database “/home/<user>/.subaccounts/storage.sqlite” because of an error: SQLITE_CANTOPEN (unable to open database file)

The DB file is present with correct permissions and "sqlite3 storage.sqlite" does show that the file contains tables at least. If I move the file out of the way and run "/scripts/upgrade_subaccount_databases --user=<user>" like some people suggest on the Net, it similarly fails.

I don't think any clients using cPanel reported subaccount issues with SQLite during the several years we were running CentOS 7, so it feels like an AlmaLinux 8 and/or post-CentOS 7 cPanel releases have this issue. Are there any things I should be trying to fix this?

• 

  Andrew

  • September 03, 2024 16:45

  What if you move it out of the way the run a force update with?

  /scripts/upcp --force

  Andrew N. - cPanel Plesk VMWare Certified Professional
  Do you need immediate assistance? 20 minutes response time!* Open a ticket
  EmergencySupport - Professional Server Management and One-time Services

  0

Please sign in to leave a comment.