updating OwnCloud loses all saved Owncloud users
When updating ownCloud from 6.0.2 to 6.0.3 via the pbi plugin jail it seems the users db is not kept in tact. All users that are in the ownCloud system are lost except for the admin user. old user data is safe but the accounts are gone. The internets say the problem is because of the SQLite db that is used be default. all suggestions say to user MySQL instead.
#2 Updated by Cyber Jock about 6 years ago
This was asked for a few weeks ago. There's 2 problems:
1. SQLite works very well for small servers with one or two users. It doesn't provide good performance with large numbers of users, but doesn't have much overhead.
2. MySQL scales to very large sizes and provides good performance but has horrendous overhead. One forum user tried to setup MySQL for Owncloud and MySQL needed 1GB of RAM with no user accounts created yet. For the vast majority of FreeNAS users this overhead is far too high and would make the pbi something that they cannot handle because of hardware constraints.
In short, you may want to research what you really want. You may find that you can solve the problem yourself by not using the pbi and instead creating your own jail that you can manage however you see fit. I run my own jail for unrelated reasons and I recommend users that plan to use Owncloud as a long-term option choose to build and manage their own jail. There are several guides in the forum on how to make your own Owncloud jail and some of them are step-by-step.
#8 Updated by Joshua Ruehlig over 5 years ago
- Status changed from Screened to Resolved
I fixed this with version 8 of this plugin as verified with my local testing.