 |
 |
Hi Maurik, thanks.. concerning passwords, you’re completely right, that’s my fault! Bests, Andrea > On Jul 5, 2019, at 14:33, maurik <[log in to unmask]> wrote: > > Hello Andrea, > > The database connection was changed a little while ago from a properties file to command line parameters. The current way to specify which conditions to use is documented here: https://confluence.slac.stanford.edu/display/hpsg/Detector+Conditions <https://confluence.slac.stanford.edu/display/hpsg/Detector+Conditions> > > So instead you need to do: > java -Dorg.hps.conditions.url=jdbc:mysql://hpsdb.jlab.org:3306/hps_conditions <mysql://hpsdb.jlab.org:3306/hps_conditions> -Dorg.hps.conditions.user=hpsuser -Dorg.hps.conditions.password=xxxxxxx ... > > Note also that the CC at JLab is not happy with passwords in email :-) > > Best, > Maurik > >> On Jul 5, 2019, at 5:32 AM, Andrea Celentano <[log in to unmask] <mailto:[log in to unmask]>> wrote: >> >> Dear HPS, >> in the past, I was able to start the monitoring app with a custom connection file, that allows me to write to the condition systems (only the LED table!). I was using: >> >> -Dorg.hps.conditions.connection.file=$DBFILE >> >> when launching the monitoring app. >> >> The content of the $DBFILE is ($DBFILE is readable) >> >> hostname = hpsdb.jlab.org <http://hpsdb.jlab.org/> >> user = hpscalibrations >> password = xxxxxxxxx >> database = hps_conditions >> >> >> It seems that now this file is not considered, when I launch the monitoring app, I see: >> >> NFO: Opening conditions db connection ... >> url: jdbc:mysql://hpsdb.jlab.org:3306/hps_conditions <mysql://hpsdb.jlab.org:3306/hps_conditions> >> user: hpsuser >> >> >> it looks like this is ignored. >> >> How can I specify the connection properties? It looks the file is completely ignored, if I enter a non-existing file, the system does not complain.. >> >> Txs >> Andrea >> >> >> Use REPLY-ALL to reply to list >> >> To unsubscribe from the HPS-SOFTWARE list, click the following link: >> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1 <https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1> ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the HPS-SOFTWARE list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=HPS-SOFTWARE&A=1