[tega2020]

In my last post I meant to say I ran into the 500 error when pointing my browser at the following URL http://localhost:8080/nukes/

[jae77]

is the nukes.ear deployed? tomcat will give that error if it can't map to the URI.

[tega2020]

finally I can run the installer. mysqld was down.
The tutorial at http://www.jboss.org/developers/projects/nukes/build appears to be out of date. I found the wiki at
http://jboss.org/wiki/Wiki.jsp?page=InstallUninstallUpgrade quite helpful.

Good stuff.

Thanks guys.

[tega2020]

jae - to answer your question I also missed out the following step sh build.sh deploy-installer

which I assume deploys nukes.ear.

Thanks for you help.

[sgwood]

deploy-installer moves the installer WAR into your JBoss deploy directory. As part of the process of running the install process, the nukes.ear is pushed out at the right time.

You should remove the installer from your deploy directory now.


Sherman

[hxp]

"tega2020" wrote:
I found the wiki at
http://jboss.org/wiki/Wiki.jsp?page=InstallUninstallUpgrade quite helpful.

Tega2020 ---

Please let me know if there is anything, no matter how small, that is inaccurate on the InstallUninstallUpgrade wiki, because I am working to get it perfected.

--hxp

[tega2020]

I only just had the time to proceed with the installer web application & it seems to have failed to create some tables. Below is the error displayed :-

Error

* CREATE TABLE nuke_sections ( pn_secid INTEGER NOT NULL IDENTITY, pn_secname VARCHAR(40) DEFAULT '' NOT NULL, pn_image VARCHAR(50) DEFAULT '' NOT NULL ): error Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'IDENTITY, pn_secname VARCHAR(40) DEFAULT '' NOT NULL, pn_image VARCH' at line 4"
* CREATE TABLE nuke_seccont ( pn_artid INTEGER NOT NULL IDENTITY, pn_secid INTEGER DEFAULT 0, pn_title VARCHAR(256) NOT NULL, pn_content VARCHAR(256) NOT NULL, pn_counter INTEGER DEFAULT 0 NOT NULL, pn_language VARCHAR(30) DEFAULT '' NOT NULL ): error Syntax error or access violation, message from server: "You have an error in your SQL syntax near 'IDENTITY, pn_secid INTEGER DEFAULT 0, pn_title VARCHAR(256) NOT NULL' at line 5"
* INSERT INTO nuke_sections VALUES (2,'Nukes','transparent.gif'): error General error, message from server: "Table 'nukes.nuke_sections' doesn't exist"

Any ideas?.

[tega2020]

I am using the below version of mysql on redhat.

mysql --version
mysql Ver 11.18 Distrib 3.23.54, for redhat-linux-gnu (i386)

It doesnt seem to like creating the table with the IDENTITY keyword. I was able to manually run the create table command sucessfully without this keyword.

Is this keyword for auto incrementing keys?

[kgelner]

"hxp" wrote:

Tega2020 ---

Please let me know if there is anything, no matter how small, that is inaccurate on the InstallUninstallUpgrade wiki, because I am working to get it perfected.

--hxp

You may have seen this in the other forum, but I found in my snapshot that there was no "local.properties" file and I had to create one from the sample one in etc, and also I think there is a tag mismatch between the application.xml template and that local.propertes entry for the application context mapping (though that's really a bug and not a doc error).

Thanks much for that WIKI entry as it was very helpful. I would probably not have figured out for a while to go into distrib for a second build...

[tega2020]

I forgot to update my earlier post.....

Just so you know, I did not deselect the buggy Sections module while running the web installer, and that was why I ran into the SQL exceptions.

Here is the relevant section of the Install Wiki (http://jboss.org/wiki/Wiki.jsp?page=InstallUninstallUpgrade) that says to deselect the Sections module

# Select which modules you want + whether you want to drop tables first.

* (yes, you should drop tables, unless you have been using Nukes in production and have important data to keep.)
* (Note: As of 20040401, you need to deselect the "Sections" module; it has bugs.)