Linear Collider Forum



Home » Software Tools » Marlin et al » lccd::DBInterface folder creation
lccd::DBInterface folder creation [message #1942] Fri, 16 April 2010 03:05 Go to previous message
daniel_jeans
Messages: 6
Registered: April 2010
I am trying to write LCCD to a non-existant folder in a local mySQL database.


Quote:


lccd::DBInterface * db =
new lccd::DBInterface( "localhost:calice:modify:*thePassword*",
"/test2_dj/Tracking/cern/AlnConstants", true);



however this fails as follows:

Quote:


db write to localhost:calice:modify:modifyPSWD /test2_dj/Tracking/cern/AlnConstants
DBInterface::init: folder does not exist, creating folder /test2_dj/Tracking/cern/AlnConstants
terminate called after throwing an instance of 'CondDBException'
what(): Assertion failed: res->countRows()==1
*** in file: /grid_mnt/data__DATA__data.polcalice/data/flc/jeans/ilcsoft_ v01-08-01_calice/CondDBMySQL/CondDBMySQL_ILC-0-7-4/src/CondF olderMgr.cxx line: 131
Aborted



...so it looks like it cannot create the new folder.

the "modify" user has ALL privileges on the mySQL database (named calice):

Quote:


mysql> show grants for 'modify'@'localhost';
| Grants for modify@localhost
| GRANT USAGE ON *.* TO 'modify'@'localhost' IDENTIFIED BY PASSWORD '*****' |
| GRANT ALL PRIVILEGES ON `calice`.* TO 'modify'@'localhost'



I can successfully write data to an existing folder.

Nothing shows up in the mysql error log, and in the general log I see

Quote:


100416 11:57:30 3 Connect modify@localhost on
3 Init DB calice
3 Init DB calice
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking/cern/AlnConstants'
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking/cern/AlnConstants'
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking/cern' && is_set=1
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking/cern'
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking' && is_set=1
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj/Tracking'
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj' && is_set=1
3 Query SELECT * FROM folders_tbl WHERE fpath='/test2_dj'
3 Query SELECT * FROM folders_tbl WHERE fpath='/' && is_set=1
3 Query SELECT db_id FROM databases_tbl WHERE dbname='calice' AND srvname='localhost'




I am using ilcsoft v01-08-01 (so including lccd v00-06-01), and
mysql version 5.0.67.

Does anyone have any ideas what I am doing wrong?


Thanks, Daniel.
 
Read Message
Read Message
Read Message
Previous Topic:VTXNoiseClusters processor fails to install
Next Topic:[solved] cernlib problem with ilcsoft install v01-08-01
Goto Forum:
  


Current Time: Thu Oct 17 17:05:02 Pacific Daylight Time 2019
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.1.
Copyright ©2001-2010 FUDforum Bulletin Board Software