Opened 16 years ago
Closed 16 years ago
#1061 closed defect (invalid)
Error: Run plugin: Formula intensity calculator
Reported by: | base | Owned by: | everyone |
---|---|---|---|
Priority: | major | Milestone: | |
Component: | web | Version: | |
Keywords: | Cc: | marad@… |
Description
When attempting to run this plugin, I get this MySQL error:
CREATE command denied to user 'base2'@'myserver.edu' for table 'D1Spot'
But when I look at MySQL, everything looks fine:
mysql> show grants for 'base2'@'myserver.edu';
+----------------------------------------------------------------------------------------------------+
| Grants for base2@… |
+----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'base2'@'web-03.gs.washington.edu' IDENTIFIED BY PASSWORD 'xxxxxxxxxx' |
| GRANT ALL PRIVILEGES ON base2
.* TO 'base2'@'myserver.edu' |
+----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
Here is my BASE Help -> About -> Configuration output:
Version BASE 2.6.3 (build #4283; schema #52) Web server Apache Tomcat/5.5.23 Database Server MySQL 5.0.45 Database Dialect org.hibernate.dialect.MySQLInnoDBDialect JDBC Driver com.mysql.jdbc.Driver (version 5.0) Java runtime Java(TM) SE Runtime Environment (1.6.0_05-b13), Sun Microsystems Inc. Operating system Linux amd64 2.6.18-53.1.14.el5 Memory Total: 892.8 MB Free: 213.6 MB Max: 910.3 MB
You need to give the
base2@myserver.edu
user access to the dynamic database also. See http://base.thep.lu.se/chrome/site/latest/html/admindoc/installation_upgrade/installation_upgrade.installation.html