Stefan,
Thank you very much for this and your script!
On 9/30/13 3:55 PM, Stefan Vollmar wrote:
Dear CJ,
On 30.09.2013, at 19:17, CJ Keist <[email protected]> wrote:
Could someone send me the the table structure for oc_preferneces? For some
reason my database doesn't have it.
We use the MySQL backend. You can use the mysql commandline tool to take a
closer look at the database:
mysql> use owncloud;
mysql> describe oc_preferences;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| userid | varchar(64) | NO | MUL | | |
| appid | varchar(32) | NO | | | |
| configkey | varchar(64) | NO | | | |
| configvalue | longtext | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
However, the script of my previous mail is probably more suitable for your
problem.
Warm regards,
Stefan
On 30.09.2013, at 19:17, CJ Keist <[email protected]> wrote:
Could someone send me the the table structure for oc_preferneces? For some
reason my database doesn't have it.
On 9/27/13 4:18 PM, Stefan Vollmar wrote:
Dear CJ Keist,
On 27.09.2013, at 22:28, CJ Keist <[email protected]> wrote:
The web interface doesn't look to have the ability to list thousands of users
on my owncloud system. So there is no way for me to set custom disk quotas for
users that are not displayed on the web interface. I have tried the search
function on the page but that doesn't work.
So I tried to see where disk quota settings are stored on the mysql database
but have not had any luck finding where that value is set per user account.
Could someone direct me on how I can set default disk quota for users on my
system?
I am not sure that this is the "official" way of doing things but I would
suggest a different approach: if you use the MySQL backend, it seems to be pretty
straightforward to set all sorts of parameters with a few lines of SQL code. In fact,
this is similar to our own automated method of creating a large number of users in
OwnCloud and sending automatically generated E-mails with activation links (tokens).
With OwnCloud 5, you can look up user data in the oc_user table (here: "aeinstein" is the
"uid" of "Albert Einstein"), you can then set a quota of 10 GB like this:
INSERT INTO `oc_preferences` VALUES
('aeinstein','files','quota','10 GB');
If you have a list of uids it is very easy to repeat that line as often as
required.
Warm regards,
Stefan
--
C. J. Keist Email: [email protected]
Systems Group Manager Solaris 10 OS (SAI)
Engineering Network Services Phone: 970-491-0630
College of Engineering, CSU Fax: 970-491-5569
Ft. Collins, CO 80523-1301
All I want is a chance to prove 'Money can't buy happiness'
_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud
--
C. J. Keist Email: [email protected]
Systems Group Manager Solaris 10 OS (SAI)
Engineering Network Services Phone: 970-491-0630
College of Engineering, CSU Fax: 970-491-5569
Ft. Collins, CO 80523-1301
All I want is a chance to prove 'Money can't buy happiness'
--
C. J. Keist Email: [email protected]
Systems Group Manager Solaris 10 OS (SAI)
Engineering Network Services Phone: 970-491-0630
College of Engineering, CSU Fax: 970-491-5569
Ft. Collins, CO 80523-1301
All I want is a chance to prove 'Money can't buy happiness'
_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud
