[Halld-offline] [EXTERNAL] Proper CCDB hygiene

[Colin Gleason]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/halld-offline/attachments/20200220/fae853eb/attachment-0002.html>