[Halld-offline] [EXTERNAL] Proper CCDB hygiene

[Naomi Jarvis]

The workaround is exactly what I do - I have a local sqlite file which I
test things on.  I think that Mark said that 'dist' is going away so that
location will change.  I didn't read the instructions.   It's harder (but
not impossible) for me to accidentally alter the master as my local copy is
not on a jlab machine.

Naomi.

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 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 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
>>>
>>
>>
>> --
>> Colin Gleason
>> Postdoctoral Fellow
>> Indiana University
>> Department of Physics
>>
>
>
> --
> Colin Gleason
> Postdoctoral Fellow
> Indiana University
> Department of Physics
> _______________________________________________
> Halld-offline mailing list
> Halld-offline at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld-offline
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20200220/6d9a71c0/attachment-0002.html>