My configuration on a Sun v210 with Solaris 8...
* jboss-4.0.3SP1.zip
* mysql-standard-5.0.20-solaris8-sparc.tar.gz
* mysql-connector-java-3.1.12-bin.jar
* jboss-portal-2.2.1.zip
* jdk-1_5_0_06-solaris-sparc(2).sh
I got the AS and Portal to come with in the URL with /web-console/ and /portal/, but I see some errors and warnings that I did not expect. I have yet to try with a 4.x version of MySQL, but I thought I woud try 5.x by disabling the strict mode with SET @@global.sql_mode='';
First error:
18:30:37,196 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
18:30:37,711 ERROR [LocaleUtils] Locale name null or empty, ignoring
18:30:39,577 INFO [StartupServletContextListener] ServletContext '/usr/local/jboss-4.0.3SP1/server/default/./deploy/jboss-portal.sar/portal-c
ore.war/' initialized.
Second error(s):
18:31:49,071 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:49,071 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_SECURITY_POLICY' doesn't exist
18:31:49,096 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:49,096 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_SECURITY_CONSTRAINT' doesn't exist
18:31:49,123 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
First warning(s):
18:31:49,449 INFO [SessionFactoryImpl] building session factory
18:31:49,488 WARN [Configurator] No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/
local/jboss-4.0.3SP1/server/default/tmp/deploy/tmp55670ehcache.jar!/ehcache-failsafe.xml
18:31:49,529 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl]; using defaults.
18:31:49,734 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl]; using defaults.
18:31:49,850 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl]; using defaults.
18:31:49,955 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl]; using defaults.
18:31:50,014 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl]; using defaults.
18:31:50,052 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.dynamic]; using defaults.
18:31:50,063 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.role.RoleImpl.users]; using defaults.
18:31:50,066 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesImpl.content]; using defaults.
18:31:50,069 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferenceImpl.strings]; using defaults.
18:31:50,071 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.PreferencesGroupImpl.prefMap]; using defaul
ts.
18:31:50,074 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.user.UserImpl.roles]; using defaults.
18:31:50,109 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
18:31:50,109 INFO [NamingHelper] JNDI InitialContext properties:{}
18:31:50,115 INFO [UpdateTimestampsCache] starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
18:31:50,124 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
18:31:50,133 INFO [StandardQueryCache] starting query cache at region: org.hibernate.cache.StandardQueryCache
18:31:50,133 WARN [EhCacheProvider] Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.
18:31:50,135 INFO [SessionFactoryImpl] Checking 0 named queries
There are other JDBC-like errors that seem related:
18:31:50,183 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:50,184 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_users' doesn't exist
18:31:50,218 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:50,218 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_pref' doesn't exist
18:31:50,232 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:50,232 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_roles' doesn't exist
18:31:50,246 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:50,246 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_pref_set' doesn't exist
18:31:50,263 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:50,263 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_user_prefs_group' doesn't exist
18:31:50,264 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
18:31:50,266 INFO [Configuration] processing extends queue
More warnings:
18:31:50,991 INFO [SessionFactoryImpl] building session factory
18:31:50,994 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl]; using defaults.
18:31:51,076 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl]; using defaults.
18:31:51,120 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.InstanceImpl.preferencesMap]; usi
ng defaults.
18:31:51,122 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.instance.PreferenceImpl.strings]; using de
faults.
18:31:51,133 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
More JDBC-like errors:
18:31:51,141 INFO [SessionFactoryImpl] Checking 0 named queries
18:31:51,164 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:51,165 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_INSTANCE' doesn't exist
18:31:51,182 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:51,182 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_INSTANCE_PREF' doesn't exist
18:31:51,184 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
More warnings:
18:31:51,364 INFO [SessionFactoryImpl] building session factory
18:31:51,367 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl]; using defaults.
18:31:51,650 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode]; using defaults.
18:31:51,830 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.windowStates]; using def
aults.
18:31:51,840 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalObjectImpl.declaredProperties
]; using defaults.
18:31:51,842 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.ObjectNode.children]; using default
s.
18:31:51,845 WARN [EhCacheProvider] Could not find configuration [org.jboss.portal.core.impl.model.portal.PortalImpl.modes]; using defaults.
18:31:51,936 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
More JDBC-like errors:
18:31:51,938 INFO [SessionFactoryImpl] Checking 0 named queries
18:31:52,007 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,007 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_PORTAL_OBJECT' doesn't exist
18:31:52,020 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,020 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_CONTEXT' doesn't exist
18:31:52,092 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,093 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_PORTAL' doesn't exist
18:31:52,107 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,107 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_PAGE' doesn't exist
18:31:52,121 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,121 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_OBJECT_NODE' doesn't exist
18:31:52,134 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:31:52,134 ERROR [JDBCExceptionReporter] Table 'jbossportal.JBP_WINDOW' doesn't exist
18:31:52,136 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
The last startup error:
18:32:08,186 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
18:32:08,260 ERROR [LocaleUtils] Locale name null or empty, ignoring
18:32:08,266 INFO [RenderKitFactoryImpl] RenderKit with renderKitId 'HTML_BASIC' was replaced.
1
At run-time, if I click on Portal Samples I get this:
18:32:09,381 INFO [Server] JBoss (MX MicroKernel) [4.0.3SP1 (build: CVSTag=JBoss_4_0_3_SP1 date=200510231054)] Started in 2m:5s:168ms
18:34:56,476 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.jboss.console.plugins.helpers.servlet.ServletHelper.filter(ServletHelper.java:29)
at org.apache.jsp.WebModule_jsp._jspService(org.apache.jsp.WebModule_jsp:157)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
For the out of box I did not expect these many, but there might something else nagging at me here. I am going to try with MySQL 4x, but if anyone has any feedback for me I'll be happy to hear it. Cheers!