<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<p>Your slurm needs built with the support. If you have mysql-devel
installed it should pick it up, otherwise you can specify the
location with --with-mysql when you configure/build slurm</p>
<p>Brian Andrus<br>
</p>
<div class="moz-cite-prefix">On 12/2/2021 12:40 PM, Giuseppe G. A.
Celano wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CANypsJT=PqgNShjb=rHoy7DUFTCztUoT5KQd3qH5aHOiHYc-cQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div class="gmail_default">
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">Hi everyone,<br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">I am having trouble
getting <i>slurmdbd</i> to work. This is the error I get:</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><i>error: Couldn't
find the specified plugin name for
accounting_storage/mysql looking at all files<br>
error: cannot find accounting_storage plugin for
accounting_storage/mysql<br>
error: cannot create accounting_storage context for
accounting_storage/mysql<br>
fatal: Unable to initialize accounting_storage/mysql
accounting storage plugin</i></span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">I have installed <i>mysql</i>
(<i>apt install mysql</i>) on Ubuntu 20.04.03 and followed
the instructions on the slurm <a
href="https://slurm.schedmd.com/accounting.html"
target="_blank" moz-do-not-send="true">website</a>; <i>mysql</i>
is running (<i>port 3306</i>) and these are the relevant
parts in my <i>.conf</i> files: <br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><i>slurm.conf</i><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"># LOGGING AND
ACCOUNTING<br>
AccountingStorageHost=</span><span
style="font-family:verdana,sans-serif">localhost<br>
AccountingStoragePort=3306<br>
AccountingStorageType=</span><span
style="font-family:verdana,sans-serif">accounting_storage/slurmdbd<br>
AccountingStorageUser=slurm<br>
JobCompType=jobcomp/none<br>
JobAcctGatherFrequency=30<br>
JobAcctGatherType=jobacct_</span><span
style="font-family:verdana,sans-serif">gather/linux<br>
SlurmctldDebug=info<br>
SlurmctldLogFile=/var/log/</span><span
style="font-family:verdana,sans-serif">slurmctld.log<br>
SlurmdDebug=info<br>
SlurmdLogFile=/var/log/slurmd.</span><span
style="font-family:verdana,sans-serif">log</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><i>slurmdbd.conf</i><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">AuthType=auth/munge<br>
DbdAddr=localhost<br>
DbdHost=localhost<br>
DbdPort=3306<br>
LogFile=/var/log/slurmdbd.log<br>
PidFile=/var/run/slurmdbd.pid<br>
PluginDir=/usr/lib/slurm<br>
SlurmUser=slurm<br>
StoragePass=password<br>
StorageType=accounting_</span><span
style="font-family:verdana,sans-serif">storage/mysql<br>
StorageUser=slurm <br>
StorageLoc=slurm_acct_db</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">I changed the port
to 3306 because otherwise <i>slurmdbd </i>could not
communicate with <i>mysql</i>. If I run <i>sacct</i>,
for example, I get:</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><i>sacct: error:
_slurm_persist_recv_msg: read of fd 3 failed: No error<br>
sacct: error: _slurm_persist_recv_msg: only read 126 of
2616 bytes<br>
sacct: error: slurm_persist_conn_open: No response to
persist_init<br>
sacct: error: Sending PersistInit msg: No error<br>
JobID JobName Partition Account AllocCPUS
State ExitCode <br>
------------ ---------- ---------- ---------- ----------
---------- -------- <br>
sacct: error: _slurm_persist_recv_msg: read of fd 3
failed: No error<br>
sacct: error: _slurm_persist_recv_msg: only read 126 of
2616 bytes<br>
sacct: error: Sending PersistInit msg: No error<br>
sacct: error: DBD_GET_JOBS_COND failure: Unspecified
error</i></span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><i><br>
</i></span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">Does anyone have a
suggestion to solve this problem? Thank you very much.</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif"><br>
</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">Best,</span></div>
<div class="gmail_default"><span
style="font-family:verdana,sans-serif">Giuseppe</span></div>
</div>
</div>
</blockquote>
</body>
</html>