5 Replies Latest reply on Jan 13, 2004 5:12 AM by Viet

    Prepare.ddl fails

    brodle Newbie

      When I try to run prepare.ddl I get the below error. The other two ddl files work fine.


      ERROR 1062 at line 2 in file: 'prepare.ddl': Duplicate entry 'localhost-nukes' for key 1..

        • 1. Re: Prepare.ddl fails
          Viet Master

           

          "cooper" wrote:
          which prepare.ddl ? when you mean run, you mean sourcing it in your database ? what's you DB ?


          • 2. Re: Prepare.ddl fails
            brodle Newbie

             

            "cooper" wrote:
            which prepare.ddl ? when you mean run, you mean sourcing it in your database ? what's you DB ?


            I'm using the mysql prepare.ddl

            yes I mean sourcing it to my DB

            mysql -u root -D nukes -e "source prepare.ddl"



            • 3. Re: Prepare.ddl fails
              Viet Master

               

              "cooper" wrote:
              there are two commands (or three) in this file, they setup the nukes user for the database as well as the database itself.

              it seems that you already have that user in the database and you are trying to creating another one by sourcing the file more than once.

              you can check that by doing :

              select * from mysql.users;

              you will see all the users in the database, you can remove one by removing the line with a delete statement.

              julien


              • 4. Re: Prepare.ddl fails
                brodle Newbie



                Thanks I'm making progress now. I started using the install notes located at http://www.jboss.org/developers/projects/nukes/build. They are different then whats I am on this step where I need to copy the local.properties-mysql to the build directory as local.properties

                when In run the build.bat I get the below error


                G:\nukes-1.0.0RC1-src\build>build
                Executing G:\nukes-1.0.0RC1-src\build\..\tools\bin\ant.bat -logger org.apache.t
                ools.ant.NoBannerLogger
                Exception in thread "main" java.lang.NoClassDefFoundError: Files\j2sdk_nb\j2sdk1
                /4/2\lib\tools/jar;G:\nukes-1/0/0RC1-src\build\//\tools\lib\xml-apis/jar;G:\nuke
                s-1/0/0RC1-src\build\//\tools\lib\xercesImpl/jar;G:\nukes-1/0/0RC1-src\build\//\
                tools\lib\xalan/jar;G:\nukes-1/0/0RC1-src\build\//\tools\lib\saxon/jar;G:\nukes-
                1/0/0RC1-src\build\//\tools\lib\optional/jar;G:\nukes-1/0/0RC1-src\build\//\tool
                s\lib\junit/jar;G:\nukes-1/0/0RC1-src\build\//\tools\lib\buildmagic-tasks/jar;G:
                \nukes-1/0/0RC1-src\build\//\tools\lib\bsf/jar;G:\nukes-1/0/0RC1-src\build\//\to
                ols\lib\ant/jar;G:\nukes-1/0/0RC1-src\build\//\tools\lib\crimson/jar;

                • 5. Re: Prepare.ddl fails
                  Viet Master

                  actually if you really want to build nukes from the sources you should consider download the CVS dayly archive you can find the link on the nukes project page.