leginon install problem - database tools admin
Added by Anonymous over 19 years ago
We're just installing Leginon on a linux system here and have run into an error when we try to access the Administration section of the Database tools. Instead of working like the laptop version does it gives us the following:
Error: CREATE TABLE IF NOT EXISTS SessionData ( `DEF_id` int(16) NOT NULL auto_increment, `DEF_timestamp` timestamp(14) , `name` text NOT NULL , `REF|UserData|user` int(20) NOT NULL , `REF|InstrumentData|instrument` int(20) NOT NULL , `image path` text NOT NULL , `comment` text NOT NULL , PRIMARY KEY (`DEF_id`), KEY `DEF_timestamp` (`DEF_timestamp`), KEY `REF|UserData|user` (`REF|UserData|user`), KEY `REF|InstrumentData|instrument` (`REF|InstrumentData|instrument`), FULLTEXT KEY `name` (`name`) ) ;No database selected
Any idea on what we are doing wrong here?
Cheers,
Jamie
Replies (1)
- Added by Anonymous over 19 years ago
Check you database config in config.php:
cd [wwwdir]/dbem
vi config.php
// --- Set your leginon MySQL database server parameters $DB_HOST = "[your database host]"; $DB_USER = "[db user]"; $DB_PASS = ""; $DB = "[db name]";
to check your connection with the DB type in shell:
mysql -h [your database host] -u [db user] [db name]
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18032712 to server version: 4.1.11-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
-Denis.