RC 1.1 Candidate Fails On This Install

[lane]

env:
mysql 4.0.20a
win2000

error on exection of ddl scripts per the install instruction:

C:\mysql\bin>mysql -u root -e "create database nukes"

C:\mysql\bin>mysql -u root -D nukes -e "source e:\deploy\releases\nukes\prepare.
ddl"
ERROR 1221 at line 20 in file: 'e:\deploy\releases\nukes\prepare.ddl': Wrong usa
ge of DB GRANT and GLOBAL PRIVILEGES

[lane]

The user is created but the grant command fails. I am now using this instead as my grants:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER,
INDEX ON nukes.* TO 'nukes'@'localhost' WITH GRANT OPTION;

GRANT FILE, RELOAD,
REFERENCES ON *.* TO 'nukes'@'localhost';

I am trying this out instead.

[lane]

Following the install.txt script to the letter. this is the start of the error report to the console:

13:18:03,750 INFO [EARDeployer] Init J2EE application: file:/E:/deploy/releases/jboss-3.2.5/server/default/deploy/nukes.ear
13:18:04,968 WARN [DeploymentInfo] Only the root deployment can set the loader repository, ingoring config=null
13:18:05,296 WARN [NestedThrowable] Duplicate throwable nesting of same base type: class org.jboss.deployment.DeploymentException is assignable from: class org.jboss.deployment.DeploymentException
13:18:05,296 ERROR [MainDeployer] could not create deployment: file:/E:/deploy/releases/jboss-3.2.5/server/default/tmp/deploy/tmp55215nukes.ear-contents/nukes.sar
org.jboss.deployment.DeploymentException: create operation failed for package file:/E:/deploy/releases/jboss-3.2.5/server/default/tmp/deploy/tmp55215nukes.ear-contents/nukes.sar; - nested throwable: (org.jboss.deployment.DeploymentException: - nested throwable: (java.lang.reflect.UndeclaredThrowableException))
 at org.jboss.deployment.SARDeployer.create(SARDeployer.java:227)

[jae77]

i am aware of the problems w/ the grant syntax and am working on a solution for this. (i already know what the correct syntax is, i'm looking to see if i can make the setup even easier).

as for the other problem, nukes will not be >= 3.2.4 compatible until after the 1.1 release. you will not be able to run it using jboss 3.2.5.

[milesparker]

"lane" wrote:


GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER,
INDEX ON nukes.* TO 'nukes'@'localhost' WITH GRANT OPTION;

GRANT FILE, RELOAD,
REFERENCES ON *.* TO 'nukes'@'localhost';

Thanks, that worked for me. (same issue)