<div dir="ltr"><div><div>Also - make sure you have MariaDB-devel when you make the RPMs - that's the first bit. <br>The second bit is you might have to find the accounting_storage_mysql.so and place it in /usr/lib64/slurm.<br><br>I think it might end up in /path/to/rpmbuild/BUILD/sec/plugins/accounting/.libs/ or something like that<span class="gmail-im"></span></div><div><br></div><div>Cheers</div><div>L.<br></div><div><span class="gmail-im"></span></div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>------<br>"The antidote to apocalypticism is 
<strong>apocalyptic civics</strong>. Apocalyptic civics is the 
insistence that we cannot ignore the truth, nor should we panic about 
it. It is a shared consciousness that our institutions have failed and 
our ecosystem is collapsing, yet we are still here — and we are creative
 agents who can shape our destinies. Apocalyptic civics is the 
conviction that the only way out is through, and the only way through is
 together. "<br><br><i>Greg Bloom</i> @greggish <a href="https://twitter.com/greggish/status/873177525903609857" target="_blank">https://twitter.com/greggish/status/873177525903609857</a><br></div></div></div></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 21 November 2017 at 06:35, Philip Kovacs <span dir="ltr"><<a href="mailto:pkdevel@yahoo.com" target="_blank">pkdevel@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"><div id="m_-6920238970089115468yui_3_16_0_ym19_1_1511206144144_3768"><span>Try adding this to your conf:</span></div><div id="m_-6920238970089115468yui_3_16_0_ym19_1_1511206144144_3768"><span><br></span></div><div id="m_-6920238970089115468yui_3_16_0_ym19_1_1511206144144_3768"><span id="m_-6920238970089115468yui_3_16_0_ym19_1_1511206144144_4364"><font id="m_-6920238970089115468yui_3_16_0_ym19_1_1511206144144_4626" face="Courier New, courier, monaco, monospace, sans-serif">PluginDir=/usr/lib64/slurm</font></span></div> <div class="m_-6920238970089115468qtdSeparateBR"><br><br></div><div class="m_-6920238970089115468yahoo_quoted" style="display:block"> <div style="font-family:Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"> <div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"><span class=""> <div dir="ltr"><font size="2" face="Arial"> On Monday, November 20, 2017 6:48 AM, Juan A. Cordero Varelaq <<a href="mailto:bioinformatica-ibis@us.es" target="_blank">bioinformatica-ibis@us.es</a>> wrote:<br></font></div>  <br><br> </span><div class="m_-6920238970089115468y_msg_container"><div id="m_-6920238970089115468yiv6044690762"><div><span class="">
    <div>I did that but got the same errors.</div>
    <div>slurmdbd.log contains by the way the following:</div>
    <blockquote>
      <div><tt>[2017-11-20T12:39:04.178] error: Couldn't find the
          specified plugin name for accounting_storage/mysql looking at
          all files</tt><tt><br clear="none">
        </tt><tt>[2017-11-20T12:39:04.179] error: cannot find
          accounting_storage plugin for accounting_storage/mysql</tt><tt><br clear="none">
        </tt><tt>[2017-11-20T12:39:04.179] error: cannot create
          accounting_storage context for accounting_storage/mysql</tt><tt><br clear="none">
        </tt><tt>[2017-11-20T12:39:04.179] fatal: Unable to initialize
          accounting_storage/mysql accounting storage plugin</tt><br clear="none">
      </div>
    </blockquote>
    <div>It seems it lacks the accounting_storage_mysql.so:</div>
    <blockquote>
      <div><tt>$ ls /usr/lib64/slurm/accounting_<wbr>storage_*</tt><tt><br clear="none">
        </tt><tt>/usr/lib64/slurm/accounting_<wbr>storage_filetxt.so 
          /usr/lib64/slurm/accounting_<wbr>storage_none.so 
          /usr/lib64/slurm/accounting_<wbr>storage_slurmdbd.so</tt></div>
    </blockquote>
    <div>However, I did install the slurm-sql rpm package.</div>
    <div>Any idea about what's failing?</div>
    <div><br clear="none">
    </div>
    <div>Thanks<br clear="none">
    </div>
    </span><div class="m_-6920238970089115468yiv6044690762yqt8019780185" id="m_-6920238970089115468yiv6044690762yqt87584"><span class=""><div class="m_-6920238970089115468yiv6044690762moz-cite-prefix">On 20/11/17 12:11, Lachlan Musicman
      wrote:<br clear="none">
    </div>
    </span><blockquote type="cite">
      <div dir="ltr"><span class="">On 20 November 2017 at 20:50, Juan A. Cordero
        Varelaq <span dir="ltr"><<a rel="nofollow" shape="rect" href="mailto:bioinformatica-ibis@us.es" target="_blank">bioinformatica-ibis@us.es</a>></span>
        wrote:<br clear="none">
        </span><div class="m_-6920238970089115468yiv6044690762gmail_extra">
          <div class="m_-6920238970089115468yiv6044690762gmail_quote">
            <blockquote class="m_-6920238970089115468yiv6044690762gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">    $
              systemctl start slurmdbd<br clear="none">
                  Job for slurmdbd.service failed because the control
              process exited with error code. See "systemctl status
              slurmdbd.service" and "journalctl -xe" for details.<br clear="none">
                  $ systemctl status slurmdbd.service<br clear="none">
                  ● slurmdbd.service - Slurm DBD accounting daemon<br clear="none"></span>
                     Loaded: loaded (/etc/systemd/system/slurmdbd. service;
              enabled; vendor preset: disabled)<div><div class="h5"><br clear="none">
                     Active: failed (Result: exit-code) since lun
              2017-11-20 10:39:26 CET; 53s ago<br clear="none">
                    Process: 27592 ExecStart=/usr/sbin/slurmdbd
              $SLURMDBD_OPTIONS (code=exited, status=1/FAILURE)<br clear="none">
              <br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Starting Slurm
              DBD accounting daemon...<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]:
              slurmdbd.service: control process exited, code=exited
              status=1<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Failed to start
              Slurm DBD accounting daemon.<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Unit
              slurmdbd.service entered failed state.<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]:
              slurmdbd.service failed.<br clear="none">
                  $ journalctl -xe<br clear="none">
                  nov 20 10:39:26 login_node polkitd[1078]: Registered
              Authentication Agent for unix-process:27586:119889015
              (system bus name :1.871 [/usr/bin/pkttyagent --notify-fd 5
              --fallback], object path /or<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Starting Slurm
              DBD accounting daemon...<br clear="none">
                  -- Subject: Unit slurmdbd.service has begun start-up<br clear="none">
                  -- Defined-By: systemd<br clear="none">
                  -- Support: <a rel="nofollow" shape="rect" href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" target="_blank">http://lists.freedesktop.org/m ailman/listinfo/systemd-devel</a><br clear="none">
                  --<br clear="none">
                  -- Unit slurmdbd.service has begun starting up.<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]:
              slurmdbd.service: control process exited, code=exited
              status=1<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Failed to start
              Slurm DBD accounting daemon.<br clear="none">
                  -- Subject: Unit slurmdbd.service has failed<br clear="none">
                  -- Defined-By: systemd<br clear="none">
                  -- Support: <a rel="nofollow" shape="rect" href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" target="_blank">http://lists.freedesktop.org/m ailman/listinfo/systemd-devel</a><br clear="none">
                  --<br clear="none">
                  -- Unit slurmdbd.service has failed.<br clear="none">
                  --<br clear="none">
                  -- The result is failed.<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]: Unit
              slurmdbd.service entered failed state.<br clear="none">
                  nov 20 10:39:26 login_node systemd[1]:
              slurmdbd.service failed.<br clear="none">
                  nov 20 10:39:26 login_node polkitd[1078]: Unregistered
              Authentication Agent for unix-process:27586:119889015
              (system bus name :1.871, object path
              /org/freedesktop/PolicyKit1/Au thenticationAgent,<br clear="none">
                  nov 20 10:40:06 login_node gmetad[1519]: data_thread()
              for [HPCSIE] failed to contact node 192.168.2.10<br clear="none">
                  nov 20 10:40:06 login_node gmetad[1519]: data_thread()
              got no answer from any [HPCSIE] datasource<br clear="none">
                  nov 20 10:40:13 login_node dhcpd[2320]: DHCPREQUEST
              for 192.168.2.19 from XX:XX:XX:XX:XX:XX via enp6s0f1<br clear="none">
                  nov 20 10:40:13 login_node dhcpd[2320]: DHCPACK on
              192.168.2.19 to XX:XX:XX:XX:XX:XX via enp6s0f1<br clear="none">
                  nov 20 10:40:39 login_node dhcpd[2320]: DHCPREQUEST
              for 192.168.2.13 from XX:XX:XX:XX:XX:XX via enp6s0f1<br clear="none">
                  nov 20 10:40:39 login_node dhcpd[2320]: DHCPACK on
              192.168.2.13 to XX:XX:XX:XX:XX:XX via enp6s0f1<br clear="none">
              <br clear="none">
              I've just found out the file `/var/run/slurmdbd.pid` does
              not even exist.<br clear="none">
            </div></div></blockquote><div><div class="h5">
            <div><br clear="none">
            </div>
            <div><br clear="none">
            </div>
            <div>The pid file is the "process id" - it's only there if
              the process is running. So when slurmdbd is not running,
              it wont be there. Supposedly. Sometimes I do "touch
              /var/run/slurmdbd.pid" and try again?</div>
            <div><br clear="none">
            </div>
            <div>I've also found that using the host's short name is
              preferable to localhost. Make sure the host's short name
              is in /etc/hosts too.</div>
            <div><br clear="none">
            </div>
            <div>hostname -s <br clear="none">
            </div>
            <div><br clear="none">
            </div>
            <div>will give you the short name</div>
            <div><br clear="none">
            </div>
            <div>Cheers</div>
            <div>L.<br clear="none">
            </div>
            <div> </div>
          </div></div></div>
        </div>
      </div>
    </blockquote></div>
    <br clear="none">
  </div></div><br><br></div>  </div> </div>  </div></div></div></blockquote></div><br></div>