Print

Print


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 -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]> 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