[Halld-offline] how to make ccdb.sqlite?

Dmitry Romanov romanov at jlab.org
Mon Dec 8 15:11:48 EST 2014


Hi! 
In this case it is MySql user name. All parameters here are MySQL staff. 
ccdb_user is the default MySql user to works with ccdb database. 
So it shouldn't be changed. Just run the script as in example and it should work. 

Dmitry

----- Original Message -----
From: "Matthew Shepherd" <mashephe at indiana.edu>
To: "HallD Software Group" <HallD-Offline at jlab.org>
Sent: Monday, December 8, 2014 10:50:52 PM
Subject: [Halld-offline] how to make ccdb.sqlite?


Hi all,

I'd like to make a ccdb.sqlite file.  This page:

https://halldweb1.jlab.org/wiki/index.php/SQLite-form_of_the_CCDB_database

Says that I need to run this command:

$CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -hhalldweb1.jlab.org -uccdb_user ccdb | sqlite3 ccdb.sqlite

I tried this replacing ccdb_user with anonymous:

shepherd at ifarm1101> $CCDB_HOME/scripts/mysql2sqlite/mysql2sqlite.sh -hhalldweb1.jlab.org -uanonymous | sqlite3 ccdb.sqlite
Error: near line 1: disk I/O error
memory

Is this the correct command?  Does anyone know
what the problem is?

Thanks in advance,

Matt

---------------------------------------------------------------------
Matthew Shepherd, Associate Professor
Department of Physics, Indiana University, Swain West 265
727 East Third Street, Bloomington, IN 47405

Office Phone:  +1 812 856 5808


_______________________________________________
Halld-offline mailing list
Halld-offline at jlab.org
https://mailman.jlab.org/mailman/listinfo/halld-offline


More information about the Halld-offline mailing list