<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Yes. What David says.<br>
    </p>
    <div class="moz-cite-prefix">On 2/20/20 11:40 AM, David Lawrence
      wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:80C91135-8AE5-4293-B007-6071C0005DAD@jlab.org">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      I don’t think diss is going away. Just the version.xml files are
      no longer going to be copied there.
      <div class="">The ccdb.sqlite file will still be there as I
        understand it.</div>
      <div class=""><br class="">
        <div class="">
          <div dir="auto" style="caret-color: rgb(0, 0, 0); color:
            rgb(0, 0, 0); letter-spacing: normal; text-align: start;
            text-indent: 0px; text-transform: none; white-space: normal;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            text-decoration: none; word-wrap: break-word;
            -webkit-nbsp-mode: space; line-break: after-white-space;"
            class="">
            Regards,<br class="">
            -David<br class="">
            <br class="">
-------------------------------------------------------------<br
              class="">
            David Lawrence Ph.D.<br class="">
            Staff Scientist, Thomas Jefferson National Accelerator
            Facility<br class="">
            Newport News, VA<br class="">
            <a href="mailto:davidl@jlab.org" class=""
              moz-do-not-send="true">davidl@jlab.org</a><br class="">
            (757) 269-5567 W<br class="">
            (757) 746-6697 C<br class="">
            <br class="">
          </div>
        </div>
        <div><br class="">
          <blockquote type="cite" class="">
            <div class="">On Feb 20, 2020, at 10:46 AM, Sean Dobbs <<a
                href="mailto:seandobbs@gmail.com" class=""
                moz-do-not-send="true">seandobbs@gmail.com</a>>
              wrote:</div>
            <br class="Apple-interchange-newline">
            <div class="">
              <div dir="ltr" class="">Good question!
                <div class=""><br class="">
                </div>
                <div class="">What you describe is very good practice. 
                  That SQLite file is regenerated at midnight every
                  night.  If your friends needs a fresher version, you
                  have to make your own.</div>
                <div class=""><br class="">
                </div>
                <div class="">The wiki page to refer to is this one:</div>
                <div class=""><a
href="https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database"
                    class="" moz-do-not-send="true">https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database</a><br
                    class="">
                </div>
                <div class=""><br class="">
                </div>
                <div class="">---Sean</div>
              </div>
              <br class="">
              <div class="gmail_quote">
                <div dir="ltr" class="gmail_attr">On Thu, Feb 20, 2020
                  at 10:38 AM Colin Gleason <<a
                    href="mailto:gleasonc@jlab.org" class=""
                    moz-do-not-send="true">gleasonc@jlab.org</a>>
                  wrote:<br class="">
                </div>
                <blockquote class="gmail_quote" style="margin:0px 0px
                  0px 0.8ex;border-left:1px solid
                  rgb(204,204,204);padding-left:1ex">
                  <div dir="ltr" class="">
                    <div class="">Last email got bounced back due to
                      wrong email. Resending:</div>
                    <div class=""><br class="">
                    </div>
                    Hi All,
                    <div class=""><br class="">
                    </div>
                    <div class="">Asking for a friend- how does one
                      build their own private ccdb so we can modify and
                      test calibrations with out altering the master? I
                      see this link <a
href="https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$"
                        target="_blank" class="" moz-do-not-send="true">https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB</a> on
                      the wiki, but the instructions are not clear and I
                      think one ends up using the master ccdb. My friend
                      seems to run into this same problem every 6 months
                      when calibrations are due. This person's work
                      around in the past was to copy the master sqlite
                      file (
                      /group/halld/www/halldweb/html/dist/ccdb.sqlite)
                      to a private directory, then put this in their
                      environment file:</div>
                    <div class=""><br class="">
                    </div>
                    setenv JANA_CALIB_URL sqlite:///<private
                    directory>/ccdb.sqlite<br class="">
                    setenv CCDB_CONNECTION sqlite:///<private
                    directory>/ccdb.sqlite
                    <div class=""><br class="">
                    </div>
                    <div class="">Is this proper etiquette/form? Should
                      my friend go about this another way? Can clear
                      instructions be added to the wiki so this doesn't
                      happen in the future (if the above way is good
                      form, I can add a section to the wiki)?</div>
                  </div>
                  <br class="">
                  <div class="gmail_quote">
                    <div dir="ltr" class="gmail_attr">On Thu, Feb 20,
                      2020 at 10:36 AM Colin Gleason <<a
                        href="mailto:gleasonc609@gmail.com"
                        target="_blank" class="" moz-do-not-send="true">gleasonc609@gmail.com</a>>
                      wrote:<br class="">
                    </div>
                    <blockquote class="gmail_quote" style="margin:0px
                      0px 0px 0.8ex;border-left:1px solid
                      rgb(204,204,204);padding-left:1ex">
                      <div dir="ltr" class="">Hi All,
                        <div class=""><br class="">
                        </div>
                        <div class="">Asking for a friend- how does one
                          build their own private ccdb so we can modify
                          and test calibrations with out altering the
                          master? I see this link <a
href="https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$"
                            target="_blank" class=""
                            moz-do-not-send="true">https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB</a> on
                          the wiki, but the instructions are not clear
                          and I think one ends up using the master ccdb.
                          My friend seems to run into this same problem
                          every 6 months when calibrations are due. This
                          person's work around in the past was to copy
                          the master sqlite file (
                          /group/halld/www/halldweb/html/dist/ccdb.sqlite)
                          to a private directory, then put this in their
                          environment file:</div>
                        <div class=""><br class="">
                        </div>
                        setenv JANA_CALIB_URL sqlite:///<private
                        directory>/ccdb.sqlite<br class="">
                        setenv CCDB_CONNECTION sqlite:///<private
                        directory>/ccdb.sqlite
                        <div class=""><br class="">
                        </div>
                        <div class="">Is this proper etiquette/form?
                          Should my friend go about this another way?
                          Can clear instructions be added to the wiki so
                          this doesn't happen in the future (if the
                          above way is good form, I can add a section to
                          the wiki)?</div>
                      </div>
                      <br class="">
                      <div class="gmail_quote">
                        <div dir="ltr" class="gmail_attr">On Wed, Feb
                          19, 2020 at 5:05 PM Sean Dobbs <<a
                            href="mailto:sdobbs@fsu.edu" target="_blank"
                            class="" moz-do-not-send="true">sdobbs@fsu.edu</a>>
                          wrote:<br class="">
                        </div>
                        <blockquote class="gmail_quote"
                          style="margin:0px 0px 0px
                          0.8ex;border-left:1px solid
                          rgb(204,204,204);padding-left:1ex">
                          Dear Offliners,<br class="">
                          <br class="">
                          PLEASE exercise caution when modifying the
                          master CCDB - this goes for<br class="">
                          new users and old alike.  If you think you are
                          working with an SQLite<br class="">
                          copy, while it is good to check the value of
                          the CCDB_CONNECTION<br class="">
                          environment variable, it doesn't hurt to use
                          "ccdb -i" to boot the<br class="">
                          CCDB CLI into interactive mode and check what
                          output you see there.<br class="">
                          Especially if you have something like 50
                          terminal windows open, as<br class="">
                          many of us do.<br class="">
                          <br class="">
                          Thanks for your consideration,<br class="">
                          Sean<br class="">
_______________________________________________<br class="">
                          Halld-offline mailing list<br class="">
                          <a href="mailto:Halld-offline@jlab.org"
                            target="_blank" class=""
                            moz-do-not-send="true">Halld-offline@jlab.org</a><br
                            class="">
                          <a
href="https://urldefense.com/v3/__https://mailman.jlab.org/mailman/listinfo/halld-offline__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-96qE7u2iA$"
                            rel="noreferrer" target="_blank" class=""
                            moz-do-not-send="true">https://mailman.jlab.org/mailman/listinfo/halld-offline</a><br
                            class="">
                        </blockquote>
                      </div>
                      <br class="" clear="all">
                      <div class=""><br class="">
                      </div>
                      -- <br class="">
                      <div dir="ltr" class="">
                        <div dir="ltr" class="">
                          <div class="">Colin Gleason</div>
                          <div class="">Postdoctoral Fellow<br class="">
                            Indiana University <br class="">
                            Department of Physics</div>
                        </div>
                      </div>
                    </blockquote>
                  </div>
                  <br class="" clear="all">
                  <div class=""><br class="">
                  </div>
                  -- <br class="">
                  <div dir="ltr" class="">
                    <div dir="ltr" class="">
                      <div class="">Colin Gleason</div>
                      <div class="">Postdoctoral Fellow<br class="">
                        Indiana University <br class="">
                        Department of Physics</div>
                    </div>
                  </div>
                </blockquote>
              </div>
              _______________________________________________<br
                class="">
              Halld-offline mailing list<br class="">
              <a href="mailto:Halld-offline@jlab.org" class=""
                moz-do-not-send="true">Halld-offline@jlab.org</a><br
                class="">
              <a class="moz-txt-link-freetext" href="https://mailman.jlab.org/mailman/listinfo/halld-offline">https://mailman.jlab.org/mailman/listinfo/halld-offline</a></div>
          </blockquote>
        </div>
        <br class="">
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
Halld-offline mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Halld-offline@jlab.org">Halld-offline@jlab.org</a>
<a class="moz-txt-link-freetext" href="https://mailman.jlab.org/mailman/listinfo/halld-offline">https://mailman.jlab.org/mailman/listinfo/halld-offline</a></pre>
    </blockquote>
  </body>
</html>