Search/Navigation:
Related:
SLAC/EPP/HPS Public
Jefferson Lab/Hall B/HPS Run Wiki
S30XL-LESA/LDMX
Confluence will be down for maintenance June 14 2024 at 6AM PT.
...
Code Block | ||
---|---|---|
| ||
java -Dorg.hps.conditions.url=jdbc:mysql://mysql-node03.slac.stanford.edu:3306/rd_hps_cond \ -Dorg.hps.conditions.user=rd_hps_cond_ro \ -Dorg.hps.conditions.password=-p2jumpinphotons2jumpinphotons. [...] |
This database is updated only periodically, not automatically, so you may need to check if it is up-to-date before using it for your jobs.
...
Code Block | ||
---|---|---|
| ||
https://github.com/JeffersonLab/hps-conditions-backup/raw/master/hps_conditions.db.tar.gz tar -zxvf hps_conditions.db.tar.gz |
This file may not be up to date with the current master in the JLab conditions database!
The local db file can be used by using this option when running Java:
...
No username or password is required when connecting locally in this way.IMPORTANT: the
Warning |
---|
The |
...
. If not |
...
then an error |
...
may occur: "Caused by: org.sqlite.SQLiteException: [SQLITE_IOERR_LOCK] I/O error in the advisory file locking logic (disk I/O error)" |
...
Creating a Local SQLite Database
In order to create a local SQLite database, you will need to create a snapshot of the MySQL database and then convert it to a SQLite db file.
...