[slurm-users] Rename account or move user from one account to another
christoph.bruening at uni-wuerzburg.de
Wed Jun 19 11:46:48 UTC 2019
yes, modifying the database directly seems to be the only way.
Part of the story is, I think, that the account name is used as the
primary key instead of some account ID... which would at least make it
possible to rename an account.
Associations are however referenced by an ID, so ... yes one can modify
the entries of the clustername_assoc_table to move an association
together with its recorded usage (note that Fairshare is apparently
calculated from the assoc_usage file inside the StateSaveLocation
directory, so remember to also copy it when setting up a test scenario).
The downside is that the sreport-ed usage shows up twice, with both the
old and the new account.
Also the state of the database is then inconsistent with its own log
table containing all modifications made to the db. I haven't seen the
system complain about it, but who knows ...
Anyway, thanks for your replies!
On 17/06/2019 16.33, Henkel, Andreas wrote:
> Hi Christoph,
> I think the only way is to modify the database directly. I don’t know if Slurm likes it and personally would try it in a copy of the DB with a separate slurmdbd to see if the values reported are still correct.
> Best regards,
> Andreas Henkel
>> Am 14.06.2019 um 16:16 schrieb Sam Gallop (NBI) <sam.gallop at nbi.ac.uk>:
>> Hi Christoph,
>> I suspect that the answer to both of these is no. When I tried to modify an account I got ...
>> $ sudo sacctmgr modify account where name=user1 set account=newaccount1
>> Can't modify the name of an account
>> Also, the sacctmgr can only reset a user's rawusage, as it only supports a value of 0.
>> While not exactly what you want you could add the user to the new account, change the defaultaccount and then remove the user from the old account. However it doesn't retain the user's historical usage which I guess is ultimately what you want.
>> Sam Gallop
>> -----Original Message-----
>> From: slurm-users <slurm-users-bounces at lists.schedmd.com> On Behalf Of Christoph Brüning
>> Sent: 12 June 2019 10:58
>> To: slurm-users at lists.schedmd.com
>> Subject: [slurm-users] Rename account or move user from one account to another
>> Hi everyone,
>> is it somehow possible to move a user between accounts together with his/her usage? I.e. transfer the historical resource consumption from one association to another?
>> In a related question: is it possible to rename an account?
>> While I could, of course, tamper with the underlying MariaDB, it does not exactly appear to be a convenient or elegant solution...
>> Dr. Christoph Brüning
>> Universität Würzburg
>> Am Hubland
>> D-97074 Würzburg
>> Tel.: +49 931 31-80499
Dr. Christoph Brüning
Tel.: +49 931 31-80499
More information about the slurm-users