Difference between revisions of "Solid mysql database"
| Line 1: | Line 1: | ||
| − | + | == soliddb.jlab.org == | |
| − | + | GEMC read geometry/material/sensitivity ,magnetic field map info and output banks info in mysql database. | |
| + | |||
| + | For solid, the database server currently used is soliddb.jlab.org, which is mysql server 5.x and runs on a mysql cluster within virtual machine nodes and is managed by Jlab computer center. | ||
| + | |||
| + | You need to access it when you running the simulation or update detector info into the database. | ||
| + | |||
| + | There's two user accounts. | ||
| + | |||
| + | read only account for running simulation: user "soliduser" password "ilovesolid" | ||
| + | read/write account for updating database : user "soliddev" password ask solid developer, eg Zhiwen zwzhao@jlab.org | ||
| + | |||
| + | On the server, two database are used. "solid_geometry" is used for detector geometry/material/sensitivity and magnetic field map info. "solid_banks" is used for output banks info. | ||
| + | |||
| + | mysql-workbench, a gui tool to view database content http://dev.mysql.com/downloads/workbench/ | ||
| + | |||
| + | ==ssh tunnel to access the server== | ||
| + | |||
| + | The soliddb server is behind Jlab firewall, if you are not on jlab internal network, you only can access it by ssh tunneling with the command line below in linux | ||
ssh -X -N -g -L 3306:soliddb:3306 your_jlab_username@login.jlab.org | ssh -X -N -g -L 3306:soliddb:3306 your_jlab_username@login.jlab.org | ||
| − | then mysql command to 127.0.0.1 will be redirect to soliddb.jlab.org | + | then mysql command to host 127.0.0.1 will be redirect to soliddb.jlab.org |
| + | |||
| + | ==clas12 server== | ||
| + | |||
| + | As GEMC is built for clas12 initially, we still take clas12 database as a reference. | ||
| + | |||
| + | The database server currently used is clasdb.jlab.org. The user name is clasuser with no password which has read and write privilege. | ||
| + | |||
| + | On the server, there are many databases. "clas12_geometry" and "clas_banks" are used for official clas12 detector. "user_geometry" is used for user modified geometry | ||
| + | |||
| + | mysqlcc, a gui tool to view clasbd which runs the 4x version mysql server http://hallaweb.jlab.org/12GeV/SoLID/download/mysqlcc-0.9.4-linux-glibc23.tgz | ||
Revision as of 00:03, 10 February 2011
soliddb.jlab.org
GEMC read geometry/material/sensitivity ,magnetic field map info and output banks info in mysql database.
For solid, the database server currently used is soliddb.jlab.org, which is mysql server 5.x and runs on a mysql cluster within virtual machine nodes and is managed by Jlab computer center.
You need to access it when you running the simulation or update detector info into the database.
There's two user accounts.
read only account for running simulation: user "soliduser" password "ilovesolid" read/write account for updating database : user "soliddev" password ask solid developer, eg Zhiwen zwzhao@jlab.org
On the server, two database are used. "solid_geometry" is used for detector geometry/material/sensitivity and magnetic field map info. "solid_banks" is used for output banks info.
mysql-workbench, a gui tool to view database content http://dev.mysql.com/downloads/workbench/
ssh tunnel to access the server
The soliddb server is behind Jlab firewall, if you are not on jlab internal network, you only can access it by ssh tunneling with the command line below in linux
ssh -X -N -g -L 3306:soliddb:3306 your_jlab_username@login.jlab.org
then mysql command to host 127.0.0.1 will be redirect to soliddb.jlab.org
clas12 server
As GEMC is built for clas12 initially, we still take clas12 database as a reference.
The database server currently used is clasdb.jlab.org. The user name is clasuser with no password which has read and write privilege.
On the server, there are many databases. "clas12_geometry" and "clas_banks" are used for official clas12 detector. "user_geometry" is used for user modified geometry
mysqlcc, a gui tool to view clasbd which runs the 4x version mysql server http://hallaweb.jlab.org/12GeV/SoLID/download/mysqlcc-0.9.4-linux-glibc23.tgz
