JBossDeveloper

I think that other person may have been me. I got blindsided with a surprise project, so since then, I've had absolutely no time to mess with my nukes project. I plan to grab the RC2 code tonight and try again.

Incidentally, my problem (which went unnoticed) was that I was unable to upload any files other than HTML ones. Some filter installed into tomcat would immediately throw an exception and I would get 500 errors.

Anybody else seen that? So far, I've been unable to manage files other than HTML via the manager module.

gary.

rc2 will not build...


_default:compile-classes:
[depend] Deleted 20 out of date files in 4 seconds
[javac] Compiling 131 source files to D:\nukesrc2\nukes\output\classes
[execmodules] D:\nukesrc2\nukes\src\main\org\jboss\nukes\core\modules\html\File.
java:50: cannot resolve symbol
[execmodules] symbol : variable BASIC
[execmodules] location: class org.jboss.nukes.common.util.EntityTable
[execmodules] this.contentAsString = EntityTable.BASIC.convertEntities(
new String(content, "UTF-8"));
[execmodules] ^
[execmodules] D:\nukesrc2\nukes\src\main\org\jboss\nukes\core\modules\html\plugi
ns\TextPlugin.java:86: cannot resolve symbol
[execmodules] symbol : variable FULL
[execmodules] location: class org.jboss.nukes.common.util.EntityTable
[execmodules] text = EntityTable.FULL.convertEntities(text);
[execmodules] ^
[execmodules] D:\nukesrc2\nukes\src\main\org\jboss\nukes\core\modules\mail\MailM
odule.java:390: warning: Name(java.lang.String) in org.xbill.DNS.Name has been d
eprecated
[execmodules] Name _name = new Name(name); // Name _name = Name.fromString
(name); does not work, why ?
[execmodules] ^
[execmodules] 2 errors
[execmodules] 1 warning

BUILD FAILED
file:D:/nukesrc2/nukes/../tools/etc/buildfragments/targets.ent:45: Compile faile
d; see the compiler error output for details.

Gentlemen,


Any resolution on this?

Another sql problem in the bb sql, it seems that the ddl has less columns then the insert statement.

Check it out:

16:55:10,135 INFO [ForumEJB] issuePostCreateSQL::sql: [INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0);] on table phpbb_forums
16:55:10,135 INFO [ForumEJB] Executing SQL: INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0);
16:55:10,145 WARN [ForumEJB] Issuing sql INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order,forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read,auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote,auth_pollcreate, auth_attachments) VALUES (0,0,'My forum','This is a sample forum',0,10,0,0,NULL,NULL,false,0,0,1,1,1,1,3,3,3,3,0); failed: java.sql.SQLException: Column not found, message from server: "Unknown column 'false' in 'field list'"
16:55:10,165 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException: Error while issuing sql in post-table-create; - nested throwable: (java.sql.SQLException: Column not found, message from server: "Unknown column 'false' in 'field list'")
 at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.issuePostCreateSQL(JDBCStartCommand.java:392)
 at

Hi All,

Is the nukes_filestat table still needed? I have noticed that the following create table statement is missing from setup.ddl.

CREATE TABLE `nukes`.`nuke_filestat`
( `pn_vmid` varchar(16) NOT NULL,
`pn_id` bigint NOT NULL,
`pn_from` bigint NOT NULL,
`pn_length` bigint NOT NULL default '0',
`pn_view_count` bigint NOT NULL default '0',
PRIMARY KEY (`pn_vmid`,`pn_id`,`pn_from`) );

10:51:06,656 ERROR [html] Problem when saving snapshots
 javax.ejb.CreateException: Error checking if entity exists:
 java.sql.SQLException: Base table or view not found,
 message from server: "Table 'nukes.nuke_filestat' doesn't exist"

I'm getting error The file id is not indicated while trying to download file from the server.

Any ideas?

I tried to use the web based nukes-installer for a mysql database on my server but it failed to setup tables properly due to some security restrictions with the way mysql is setup with my Linux OS. Could a ddl file also be included in the nukes distribution directory to create database tables. That way a person can use either the web based nukes-installer or use a script file to setup the database tables. The web based installer is nice but I would prefer a single script file that does it all. For a person doing a nukes install, a single script file is straight forward and easier to fix if their is a problem.

Danny

The propose of a ddl is to keep everything synchronized, it's already a pain to keep everything synchronized between mysql/postgresql and oracle, adding another support is just not maintanable. We are looking for a better way to be generic but it's not as easy as it seems.

Anyway, the installer must be able to create/modify the tables and so Nukes do.

You need to give all privileges to a user (nukes by default) to a database (nukes by default)

I wrote something about doing that in the wiki pages, on a linux machine using mysql.

Make sure you can connect to the server by typing:
(first nukes is the username, second is the database name)
mysql -u nukes -p nukes
It will ask for password.
Depending on how your box is configured you may want to add access from your machine, by using your hostname (if you don't know how to do, ask again) Try:
mysql -u nukes -p nukes -h `hostname`

"vbrodsky" wrote:
Gentlemen,


Any resolution on this?

Another sql problem in the bb sql, it seems that the ddl has less columns then the insert statement.

Check it out:

16:55:10,135 INFO [ForumEJB] issuePostCreateSQL::sql: [INSERT INTO phpbb_forums[..]