[slurm-users] Rename account or move user from one account to another

[Christoph Brüning]

Hi,

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!

Best,
Christoph





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...
>>
>> Best,
>> Christoph
>>
>>
>> --
>> Dr. Christoph Brüning
>> Universität Würzburg
>> Rechenzentrum
>> Am Hubland
>> D-97074 Würzburg
>> Tel.: +49 931 31-80499
>>

-- 
Dr. Christoph Brüning
Universität Würzburg
Rechenzentrum
Am Hubland
D-97074 Würzburg
Tel.: +49 931 31-80499