4 Replies Latest reply on Jul 8, 2004 8:33 PM by milesparker

    RC 1.1 Candidate Fails On This Install

    Lane Sharman Newbie

      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

        • 1. Re: RC 1.1 Candidate Fails On This Install
          Lane Sharman Newbie

          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.

          • 2. Re: RC 1.1 Candidate Fails On This Install
            Lane Sharman Newbie

            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)
            




            • 3. Re: RC 1.1 Candidate Fails On This Install
              jae Master

              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.

              • 4. Re: RC 1.1 Candidate Fails On This Install
                milesparker Newbie

                 

                "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)