Opened 17 years ago

Closed 17 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

Change History (1)

comment:1 by Nicklas Nordborg, 17 years ago

Resolution: invalid
Status: newclosed

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

Note: See TracTickets for help on using tickets.