[Halld-offline] [EXTERNAL] Proper CCDB hygiene

[Mark Ito]

Yes. What David says.

On 2/20/20 11:40 AM, David Lawrence wrote:
> I don’t think diss is going away. Just the version.xml files are no 
> longer going to be copied there.
> The ccdb.sqlite file will still be there as I understand it.
>
> Regards,
> -David
>
> -------------------------------------------------------------
> David Lawrence Ph.D.
> Staff Scientist, Thomas Jefferson National Accelerator Facility
> Newport News, VA
> davidl at jlab.org <mailto:davidl at jlab.org>
> (757) 269-5567 W
> (757) 746-6697 C
>
>
>> On Feb 20, 2020, at 10:46 AM, Sean Dobbs <seandobbs at gmail.com 
>> <mailto:seandobbs at gmail.com>> wrote:
>>
>> 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 
>> <mailto: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 <mailto: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
>>         <mailto: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 <mailto: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
>>
>> _______________________________________________
>> Halld-offline mailing list
>> Halld-offline at jlab.org <mailto:Halld-offline at jlab.org>
>> https://mailman.jlab.org/mailman/listinfo/halld-offline
>
>
> _______________________________________________
> 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/c4500e25/attachment-0002.html>