coefficient-users

[Coefficient-users] Re: Coefficient lacks install support?

[Thomas F. <tfo...@cs...>]

I CC the coefficient users list, as this may help other people, too.
It's also the logical place to ask and answer questions. You can
subscribe here:
http://lists.sourceforge.net/lists/listinfo/coefficient-users


On Wed, 2005-01-12 at 22:44 -0500, Carlos Serpa wrote:
> I tried downloading jboss and tomcat, they both run fine, but I can=92t
> seem to install coefficient in it=85 I tried to follow all the steps bu=
t
> in my opinion the install guide is a little vague. How do I create the
> datasource?

You only need to setup a datasource for the JBoss installation. The
datasource can be set up by creating a file in the deploy directory:
e.g.	${JBOSS_HOME}/server/default/deploy/
For instance, to create a postgresql datasource, create a file (call it,
say, postgres-ds.xml) with the following contents (obviously
substituting reasonable values for ${HOST} , ${DB_NAME} , ${DB_USERNAME}
and ${PASSWORD})

<?xml version=3D"1.0" encoding=3D"UTF-8"?>
<datasources>
   <local-tx-datasource>
      <jndi-name>CoefficientDS</jndi-name>
	<connection-url>jdbc:postgresql://${HOST}/${DB_NAME}</connection-url>
      <driver-class>org.postgresql.Driver</driver-class>
      <user-name>${DB_USERNAME}</user-name>
      <password>${PASSWORD}</password>
   </local-tx-datasource>
</datasources>

For the tomcat install, you need to setup up your connection properties
as per http://coefficient.sourceforge.net/install/installWA.html
In Tomcat, coefficient connects directly to the database. In JBoss, it
connects via the datasource.


> If you=92d be so kind to provide me (if you have the time) with a more
> detailed list of processes in order to get coefficient running I=92d
> appreciate it! In return I can provide you bug and issue reports.

Cool, and good luck getting it going. If you have more trouble, please
mail the users list (which I'm subscribed to).

Regards
--=20
Thomas Fogwill <tfo...@cs...>


--=20
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.

[Coefficient-users] RE: Coefficient lacks install support?

[Carlos S. <zga...@gm...>]

I followed the instructions on how to set up coefficient in JBOSS, but
I am still not able to get it going...

This is what I did. 
1. Downloaded jboss-3.2.6RC1 and installed it. I ran it by itself and
connect to it via port 8080 just fine. Set up a db in phpMyadmin and
called coef with a user of jboss and pw of password.
2. Download coefficient jboss deploy. Removed the hibernate.jar from
both dirs mentioned in the install file. created a datasource called:
mysql-ds.xml which contained:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
      <jndi-name>CoefficientDS</jndi-name>
        <connection-url>jdbc:mysql:///coef</connection-url>
      <driver-class>org.gjt.mm.mysql.Driver</driver-class>
      <user-name>jboss</user-name>
      <password>password</password>
   </local-tx-datasource>
</datasources>

3. Copied the files: mysql-connector-java-3.0.15-ga-bin.jar and
mysql-connector-java.jar to jboss-3.2.6RC1/server/default/lib and
jboss-3.2.6RC1/lib
4. Edited the hibernate.properties file with:

hibernate.connection.datasource java:/CoefficientDS
hibernate.connection.username jboss
hibernate.connection.password password
#hibernate.show_sql true
hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
#hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect
#hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
#hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
hibernate.session_factory_name net.sf.hibernate.SessionFactory
hibernate.transaction.factory_class
net.sf.hibernate.transaction.JTATransactionFactory
hibernate.connection.pool_size 0

5. Ran the .sh updater and copied the updated .ear file into the
default/deploy folder along with the other .ear files from the modules
folder.
6. Ran jboss, a lot files seemed to have been worked on as I saw jboss
load in the console...
7. Went into my.server:8080 and after 5-10 seconds I see the header
and footer of coefficient but in the body of the page I see a bunch of
red java code which I will paste at the end and the console I see
this:

22:31:50,745 ERROR [ExceptionInterceptor] at:
ExceptionInterceptor.java:50 | operation: unhandled system e
xception | exception type:
org.jboss.tm.JBossTransactionRolledbackException | exception message:
null; Cau
sedByException is:
        null; nested exception is:
        java.lang.NullPointerException; - nested throwable:
(java.lang.NullPointerException)


Any ideas will be much appreciated!



There has been a system exception

org.jboss.tm.JBossTransactionRolledbackException: null; CausedByException is:
null; nested exception is: 
java.lang.NullPointerException; - nested throwable:
(java.lang.NullPointerException)
at org.jboss.ejb.plugins.LogInterceptor.handleException(LogInterceptor.java:262)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
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:723)
at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:97)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:53)
at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy235.invokeOpOnModule(Unknown Source)
at za.org.coefficient.interceptors.ConfigurationInterceptor.handleInvoke(ConfigurationInterceptor.java:45)
at za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:79)
at za.org.coefficient.core.CoefficientInterceptor.invoke_aroundBody0(CoefficientInterceptor.java:90)
at za.org.coefficient.core.CoefficientInterceptor$AjcClosure1.run(CoefficientInterceptor.java)
at za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at za.org.coefficient.core.CoefficientInterceptor.invoke(CoefficientInterceptor.java:90)
at za.org.coefficient.interceptors.ExceptionInterceptor.invoke(ExceptionInterceptor.java:54)
at za.org.coefficient.servlet.CoefficientServlet.invoke_aroundBody0(CoefficientServlet.java:152)
at za.org.coefficient.servlet.CoefficientServlet$AjcClosure1.run(CoefficientServlet.java)
at za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecbproceed(CoefficientLoggingAspect.java)
at za.org.coefficient.aspects.logging.CoefficientLoggingAspect.ajc$around$za_org_coefficient_aspects_logging_CoefficientLoggingAspect$ecb(CoefficientLoggingAspect.java:111)
at za.org.coefficient.servlet.CoefficientServlet.execute(CoefficientServlet.java:152)
at za.org.coefficient.servlet.CoefficientServlet.doGet(CoefficientServlet.java:118)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:72)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:418)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NullPointerException
at za.org.coefficient.modules.configuration.Configuration.canExecuteForRole(Configuration.java:68)
at za.org.coefficient.modules.configuration.beans.ConfigurationBean.canExecuteForRole(ConfigurationBean.java:64)
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:585)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
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:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
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:723)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:364)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
at $Proxy230.canExecuteForRole(Unknown Source)
at za.org.coefficient.invokers.base.BaseInvoker.invokeOpOnModule(BaseInvoker.java:177)
at za.org.coefficient.invokers.ejb.beans.EjbInvokerBean.invokeOpOnModule(EjbInvokerBean.java:82)
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:585)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
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:315)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:148)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:120)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
... 63 more

Re: [Coefficient-users] RE: Coefficient lacks install support?

[Thomas F. <tfo...@cs...>]

On Fri, 2005-01-14 at 22:36 -0500, Carlos Serpa wrote:
> 3. Copied the files: mysql-connector-java-3.0.15-ga-bin.jar and
> mysql-connector-java.jar to jboss-3.2.6RC1/server/default/lib and
> jboss-3.2.6RC1/lib

I don't really use mysql, so excuse my cluelessness :)
Why 2 jar files? Also, just checking - what version of mysql are you
running? Could it be some version incompatibility (i.e. between the
driver and the server)?

> ...
> 6. Ran jboss, a lot files seemed to have been worked on as I saw jboss
> load in the console...
> 7. Went into my.server:8080 and after 5-10 seconds I see the header
> and footer of coefficient but in the body of the page I see a bunch of
> red java code which I will paste at the end and the console I see
> this:
> 
> 22:31:50,745 ERROR [ExceptionInterceptor] at:
> ExceptionInterceptor.java:50 | operation: unhandled system e
> xception | exception type:
> ...

Are there any errors/exceptions logged? Messages are usually logged to
the console and to a file here:
${JBOSS_HOME}/server/default/log/server.log 
so you can check there.

My guess is that (for some reason) coefficient is unable to connect to
the db (maybe because it cannot load the driver). Please check your log
file for exceptions, as this will give us a clue as to what the problem
is.


Cheers
-- 
Thomas Fogwill <tfo...@cs...>


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.

Re: [Coefficient-users] RE: Coefficient lacks install support?

[Thomas F. <tfo...@cs...>]

On Tue, 2005-01-18 at 17:40 -0500, Carlos Serpa wrote:
> I apologize for my clumsiness, a few days ago I checked the log files
> in tomcat and it was a mysql user error. The user I created couldn't
> access the DB. Since then I have fixed the problem and Coef runs
> perfectly

Cool! Glad to hear it's running :)


> ... except for the fact that under any theme but the default one
> the buttons do not load, like the upload, and vote images, even though
> I verified the images exist.

Weird. It does load them on my installation (although mine is built from
cvs). The images are served by org.coefficient.servlet.ImageServlet -
can you see any exceptions being thrown?

Cheers
-- 
Thomas Fogwill <tfo...@cs...>


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.