-
1. Re: Basic site setup
milesparker Jul 9, 2004 1:40 PM (in response to milesparker)Perhpas I have something misconfigured...when I do "manage html" I can create a new page, but it doesn't look as though anything gets created...I have searched through the Jboss dir's to find the created web page, and when I select it in the "manage html" page, nothing gets displayed...hmmm..
-
2. Re: Basic site setup
milesparker Jul 9, 2004 1:47 PM (in response to milesparker)Checked the server logs and getting this:
004-07-09 11:40:18,609 ERROR [STDERR] javax.ejb.FinderException: Find failed: java.sql.SQLException: General error, message from server: "Table 'nukes.nuke_filestat' doesn't exist"
At least I know its not just me...:-) I'll try to run the setup.ddl again and see if that takes care of it.. -
3. Re: Basic site setup
milesparker Jul 9, 2004 1:53 PM (in response to milesparker)OK, this looks like it is not part of the ddl setup but perhaps is created by nukes internal setup...? Here is the error I'm getting:
2004-07-09 11:43:25,578 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FileStatEJB] Error checking if entity exists
java.sql.SQLException: General error, message from server: "Table 'nukes.nuke_filestat' doesn't exist"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:83)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
at org.jboss.ejb.Container.invoke(Container.java:720)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
at $Proxy46.create(Unknown Source)
at org.jboss.nukes.core.modules.html.HtmlModule$4.execute(HtmlModule.java:1223)
at org.jboss.nukes.core.ejb.UtilsEJB$Executable.execute(UtilsEJB.java:119)
at org.jboss.nukes.core.ejb.UtilsEJB.requiresNew(UtilsEJB.java:95)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:375)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy61.requiresNew(Unknown Source)
at org.jboss.nukes.core.modules.html.HtmlModule$3.run(HtmlModule.java:1214)
at org.jboss.nukes.utils.Scheduler$MutexTask.run(Scheduler.java:87)
at java.util.TimerThread.mainLoop(Timer.java:432)
at java.util.TimerThread.run(Timer.java:382) -
4. Re: Basic site setup
milesparker Jul 9, 2004 1:57 PM (in response to milesparker)
OK, I see this issue is also occuring here:
http://www.jboss.org/index.html?module=bb&op=viewtopic&t=51377
Guess that's why its called a release "candidate". :-D -
-
6. Re: Basic site setup
julien1 Jul 9, 2004 6:16 PM (in response to milesparker)try to source the file nukes/nukes/output/resources/mysql/setup.ddl it contains the statement to create the table nuke_filestat
-
7. Re: Basic site setup
milesparker Jul 9, 2004 6:54 PM (in response to milesparker)"cooper" wrote:
try to source the file nukes/nukes/output/resources/mysql/setup.ddl it contains the statement to create the table nuke_filestat
Thx. Unfortunatly, build is giving weird errors (I'm stuck on a windows machine right now). Could someone just post the correct setup.ddl text here? -
8. Re: Basic site setup
julien1 Jul 9, 2004 7:31 PM (in response to milesparker)-- module : nukes - Nukes Core Module -- database : mysql - MySQL -- -- WARNING: -- This file is generated automatically, please do not modify it -- directly, your changes will be lost during next generation. -- Modify the setup.xml file to make permanent changes. -- -- Drop tables -- -- Drops Users table DROP TABLE IF EXISTS nuke_users; -- Drops Groups table DROP TABLE IF EXISTS nuke_groups; -- Drops Group Membership table DROP TABLE IF EXISTS nuke_group_membership; -- Drops Files table DROP TABLE IF EXISTS nuke_file; -- Drops Files Stat table DROP TABLE IF EXISTS nuke_filestat; -- Drops Services table DROP TABLE IF EXISTS nuke_services; -- Drops Services Attributes table DROP TABLE IF EXISTS nuke_services_attributes; -- -- Create tables -- -- Creates Users table CREATE TABLE `nuke_users` ( `pn_uid` int(11) NOT NULL auto_increment, `pn_uname` varchar(25) NOT NULL, `pn_user_regdate` datetime NOT NULL, `pn_user_viewemail` tinyint(1) NOT NULL default '1', `pn_name` varchar(60) NOT NULL default '', `pn_email` varchar(60) NOT NULL default '', `pn_femail` varchar(60) NOT NULL default '', `pn_url` varchar(254) NOT NULL default '', `pn_timezone_offset` tinyint(4) NOT NULL default '0', `pn_user_avatar` varchar(30) NOT NULL default 'blank.gif', `pn_user_icq` varchar(15) NOT NULL default '', `pn_user_aim` varchar(18) NOT NULL default '', `pn_user_yim` varchar(25) NOT NULL default '', `pn_user_msnm` varchar(25) NOT NULL default '', `pn_user_from` varchar(100) NOT NULL default '', `pn_user_lang` int(3) NOT NULL default '0', `pn_user_occ` varchar(100) NOT NULL default '', `pn_user_intrest` varchar(150) NOT NULL default '', `pn_user_sig` varchar(255) NOT NULL default '', `pn_bio` tinytext NOT NULL default '', `pn_pass` varchar(40) NOT NULL default '', `pn_theme` varchar(255) NOT NULL default '', `pn_umode` varchar(10) NOT NULL default '', `pn_uorder` tinyint(1) NOT NULL default '0', `pn_thold` tinyint(1) NOT NULL default '0', `pn_noscore` tinyint(1) NOT NULL default '0', `pn_commentmax` int(11) NOT NULL default '4096', `pn_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', `pn_prev_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', `pn_question` tinytext NOT NULL default '', `pn_answer` tinytext NOT NULL default '', `pn_enabled` tinyint(1) NOT NULL default '1', PRIMARY KEY (`pn_uid`), UNIQUE INDEX (`pn_uname`) ); -- Create Group Membership table CREATE TABLE `nuke_group_membership` ( `pn_gid` int(11) NOT NULL, `pn_uid` int(11) NOT NULL, PRIMARY KEY (`pn_uid`, `pn_gid`) ); -- Creates Groups table CREATE TABLE `nuke_groups` ( `pn_gid` int(11) NOT NULL auto_increment, `pn_name` varchar(255) NOT NULL default '', PRIMARY KEY (`pn_gid`) ); -- Creates File table CREATE TABLE `nuke_file` ( `pn_id` int(11) NOT NULL auto_increment, `pn_fid` varchar(255) NOT NULL, `pn_uid` int(11) NULL, `pn_content_type` varchar(50) NOT NULL, `pn_content` longblob NOT NULL, `pn_timest` datetime NOT NULL, `pn_public` tinyint(1) NOT NULL default '0', PRIMARY KEY (`pn_id`), INDEX (`pn_fid`) ); -- Creates File Statistics table CREATE TABLE `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`) ); -- Creates Services table CREATE TABLE `nuke_services` ( `pn_sid` varchar(128) NOT NULL, `pn_last_modified` bigint NOT NULL, `pn_class_name` varchar(255) NOT NULL, PRIMARY KEY (`pn_sid`) ); -- Creates Services Attributes table CREATE TABLE `nuke_services_attributes` ( `pn_sid` varchar(128) NOT NULL, `pn_aid` varchar(128) NOT NULL, `pn_value` text NULL default NULL, PRIMARY KEY(pn_sid, pn_aid) ); -- -- Insert default init values -- -- Insert Admin account INSERT INTO nuke_users VALUES (1,'admin','2003-12-11 18:57:21.074',1,'Administrator','admin@none.com','fake-admin@none.com','http://www.mysite.com',0,'blank.gif','','','','','',0,'','','Nukes CMS Administrator','','21232F297A57A5A743894A0E4A801FC3','imagic','',0,0,0,4096,'2003-12-14 01:15:27.8','2003-12-14 01:15:27.8','','', 1); -- Insert User account INSERT INTO nuke_users VALUES (2,'user','2003-12-11 18:57:21.08',1,'','user@none.com','','',0,'blank.gif','','','','','',0,'','','','','EE11CBB19052E40B07AAC0CA060C23EE','','',0,0,'0',4096,'1974-09-21 00:00:00.0','1974-09-21 00:00:00.0','','', 1); -- Insert Admins group INSERT INTO nuke_groups (pn_gid,pn_name) VALUES (1,'Admins'); -- Insert Users group INSERT INTO nuke_groups (pn_gid,pn_name) VALUES (2,'Users'); -- Insert Admin as an Admins member INSERT INTO nuke_group_membership (pn_gid, pn_uid) VALUES (1,1); -- Insert User as a Users member INSERT INTO nuke_group_membership (pn_gid, pn_uid) VALUES (2,2); -- Insert Index file INSERT INTO nuke_file VALUES (1,'/index',1,'text/html','blah','2003-12-14 19:26:50',1) ;
-
9. Re: Basic site setup
milesparker Jul 9, 2004 8:01 PM (in response to milesparker)Excellent, that worked. Now that I have access to the html manager hopefully I can figure a bit more out...
-
10. Re: Basic site setup
ariebaas Jul 20, 2004 9:25 AM (in response to milesparker)I am also looking for a step by step document to setup a complete site like jboss.org (setting up pages and menus).
-
11. Re: Basic site setup
milesparker Jul 21, 2004 7:34 PM (in response to milesparker)I put a basic (and probably incorrect) guide based on my expereinces on Wiki. Look for SettingSiteUp in Help.
-