[Halld-offline] [EXTERNAL] Proper CCDB hygiene

[Sean Dobbs]

Good question!

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.

The wiki page to refer to is this one:
https://halldweb.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database

---Sean

On Thu, Feb 20, 2020 at 10:38 AM Colin Gleason <gleasonc at jlab.org> wrote:

> Last email got bounced back due to wrong email. Resending:
>
> Hi All,
>
> 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
> https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB
> <https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$> 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:
>
> setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite
> setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite
>
> 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)?
>
> On Thu, Feb 20, 2020 at 10:36 AM Colin Gleason <gleasonc609 at gmail.com>
> wrote:
>
>> Hi All,
>>
>> 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
>> https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB
>> <https://urldefense.com/v3/__https://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-95zMz_Z5w$> 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:
>>
>> setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite
>> setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite
>>
>> 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)?
>>
>> On Wed, Feb 19, 2020 at 5:05 PM Sean Dobbs <sdobbs at fsu.edu> wrote:
>>
>>> Dear Offliners,
>>>
>>> PLEASE exercise caution when modifying the master CCDB - this goes for
>>> new users and old alike.  If you think you are working with an SQLite
>>> copy, while it is good to check the value of the CCDB_CONNECTION
>>> environment variable, it doesn't hurt to use "ccdb -i" to boot the
>>> CCDB CLI into interactive mode and check what output you see there.
>>> Especially if you have something like 50 terminal windows open, as
>>> many of us do.
>>>
>>> Thanks for your consideration,
>>> Sean
>>> _______________________________________________
>>> Halld-offline mailing list
>>> Halld-offline at jlab.org
>>> https://mailman.jlab.org/mailman/listinfo/halld-offline
>>> <https://urldefense.com/v3/__https://mailman.jlab.org/mailman/listinfo/halld-offline__;!!PhOWcWs!h-eg_g6eTbt5YZAgqOze3M-EYOKk3NVqHQkzPLnnVfrh4S2eR9fd-96qE7u2iA$>
>>>
>>
>>
>> --
>> Colin Gleason
>> Postdoctoral Fellow
>> Indiana University
>> Department of Physics
>>
>
>
> --
> Colin Gleason
> Postdoctoral Fellow
> Indiana University
> Department of Physics
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20200220/bfb9e4a3/attachment-0002.html>