<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    Check the ownership and permissions of /var/zendto/zendto.sqlite. It
    needs to be read+writeable by the web server, so basically the same
    ownership and r/w permissions as the /var/zendto/incoming directory
    has.<br>
    <br>
    Cheers,<br>
    Jules.<br>
    <br>
    <div class="moz-cite-prefix">On 18/04/2018 07:51, Giddings, Bret via
      ZendTo wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:WM!fd6222225cdd87160b3bf06df565882ac0ab2b3483a70b716ce9b7b80f2d26bf86fe8f33c12477cd63bfa9d94c9e4ace!@mx.jul.es">
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
      <style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
      <div id="divtagdefaultwrapper"
style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;"
        dir="ltr">
        <div class="_rp_G5 rpHighlightAllClass rpHighlightBodyClass
          allowTextSelection">
          <div>
            <div class="_rp_H5 ms-font-weight-regular
              ms-font-color-neutralDark" role="presentation"
              id="Item.MessageNormalizedBody" style="font-family:
              "wf_segoe-ui_normal", "Segoe UI",
              "Segoe WP", Tahoma, Arial, sans-serif, serif,
              "EmojiFont";" tabindex="-1">
              <div class="rps_b94b">
                <div>
                  <div lang="EN-GB">
                    <div class="x_WordSection1">
                      <p class="x_MsoNormal">Hello,</p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal">I’m trying to do a
                        migration from 3.71(!!) to the latest version.
                        Using information at
                        <a
                          href="http://jul.es/pipermail/zendto/2014-February/002309.html"
                          target="_blank" rel="noopener noreferrer"
                          id="LPlnk354644" previewremoved="true"
                          moz-do-not-send="true">
http://jul.es/pipermail/zendto/2014-February/002309.html</a>, I have
                        successfully been able to port the DB (sqlite2
                        to sqlite3) and dropped off files from the older
                        server to a new one. This lets me pick up files
                        that we’re previously on the old server.
                        However, when trying to drop off anything on the
                        new server, I am getting an error of</p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal"><i><span
                            style="font-family: Consolas, serif,
                            "EmojiFont";">Database Error</span></i></p>
                      <p class="x_MsoNormal"><i><span
                            style="font-family: Consolas, serif,
                            "EmojiFont";"> </span></i></p>
                      <p class="x_MsoNormal"><i><span
                            style="font-family: Consolas, serif,
                            "EmojiFont";">Database failure
                            writing authentication key. Please notify
                            the system administrator.</span></i></p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal">In the GUI and </p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal"><i><span
                            style="font-family: Consolas, serif,
                            "EmojiFont";">Error: failed to add
                            authdata for <a class="moz-txt-link-abbreviated" href="mailto:bret@essex.ac.uk">bret@essex.ac.uk</a> to authtable</span></i></p>
                      <p class="x_MsoNormal"><i> </i></p>
                      <p class="x_MsoNormal">In the zendto.log. I’ve
                        checked that the authtable structure is the same
                        between versions and can insert the data that
                        DBWriteAuthData attempts to write if I interact
                        with the DB via the command line.
                      </p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal">Have I missed anything?</p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal">Thanks,</p>
                      <p class="x_MsoNormal"> </p>
                      <p class="x_MsoNormal">Bret</p>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
        <br>
      </div>
      <!--'"--><br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://jul.es/mailman/listinfo/zendto">http://jul.es/mailman/listinfo/zendto</a>
</pre>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">Jules

-- 
Julian Field MEng CEng CITP MBCS MIEEE MACM

'No more impressive warning can be given to those who would confine
 knowledge and rsearch to what is apparently useful, than the
 reflection that conic sections were studied for eighteen hundred
 years merely as an abstract science, without regard to any utility
 other than to satisfy the craving for knowledge on the part of
 mathematicians, and that then at the end of this long period of
 abstract study, they were found to be the necessary key with which
 to attain the knowledge of the most important laws of nature.'
 - Alfred North Whitehead

<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
</pre>
  </body>
</html>