<div dir="ltr">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. <div><br></div><div>Naomi.</div></div><br><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">gleasonc@jlab.org</a>> wrote:<br></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"><div>Last email got bounced back due to wrong email. Resending:</div><div><br></div>Hi All,<div><br></div><div>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://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB" target="_blank">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><br></div>setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite<br>setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite<div><br></div><div>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><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">gleasonc609@gmail.com</a>> wrote:<br></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">Hi All,<div><br></div><div>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://halldweb.jlab.org/wiki/index.php/HOWTO_build_the_CCDB" target="_blank">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><br></div>setenv JANA_CALIB_URL sqlite:///<private directory>/ccdb.sqlite<br>setenv CCDB_CONNECTION sqlite:///<private directory>/ccdb.sqlite<div><br></div><div>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><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">sdobbs@fsu.edu</a>> wrote:<br></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>
<br>
PLEASE exercise caution when modifying the master CCDB - this goes for<br>
new users and old alike. If you think you are working with an SQLite<br>
copy, while it is good to check the value of the CCDB_CONNECTION<br>
environment variable, it doesn't hurt to use "ccdb -i" to boot the<br>
CCDB CLI into interactive mode and check what output you see there.<br>
Especially if you have something like 50 terminal windows open, as<br>
many of us do.<br>
<br>
Thanks for your consideration,<br>
Sean<br>
_______________________________________________<br>
Halld-offline mailing list<br>
<a href="mailto:Halld-offline@jlab.org" target="_blank">Halld-offline@jlab.org</a><br>
<a href="https://mailman.jlab.org/mailman/listinfo/halld-offline" rel="noreferrer" target="_blank">https://mailman.jlab.org/mailman/listinfo/halld-offline</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div>Colin Gleason</div><div>Postdoctoral Fellow<br>Indiana University <br>Department of Physics</div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr"><div dir="ltr"><div>Colin Gleason</div><div>Postdoctoral Fellow<br>Indiana University <br>Department of Physics</div></div></div>
_______________________________________________<br>
Halld-offline mailing list<br>
<a href="mailto:Halld-offline@jlab.org" target="_blank">Halld-offline@jlab.org</a><br>
<a href="https://mailman.jlab.org/mailman/listinfo/halld-offline" rel="noreferrer" target="_blank">https://mailman.jlab.org/mailman/listinfo/halld-offline</a></blockquote></div>