<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>I guess mariadb-devel was not installed by the time another
      person installed slurm. I have a bunch of slurm-* rpms I installed
      using "yum localinstall ...". Should I installed them in another
      way or remove slurm?<br>
    </p>
    The file accounting_storage_mysql.so is bythe way absent on the
    machine.<br>
    <br>
    Thanks<br>
    <div class="moz-cite-prefix">On 20/11/17 21:52, Lachlan Musicman
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAGBeqiMekYzoNF85a2ZaewcOda1LNuSYpD3G86unWDGJP=nomA@mail.gmail.com"
      type="cite">
      <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
                                  moz-do-not-send="true"
                                  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 moz-do-not-send="true"
              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 face="Arial" size="2"> On
                            Monday, November 20, 2017 6:48 AM, Juan A.
                            Cordero Varelaq <<a
                              moz-do-not-send="true"
                              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
                                        moz-do-not-send="true"
                                        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
                                              moz-do-not-send="true"
                                              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
                                              moz-do-not-send="true"
                                              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>
    </blockquote>
    <br>
  </body>
</html>