2 Replies Latest reply on Jul 27, 2006 4:03 PM by sappenin

    MailListManager not installed?

    lcoetzee
    lcoetzee Jun 27, 2006 6:31 AM

      Hi,

      I recently decided to try out the Collaboration (btw I am very excited about it). I have checked out the source from CVS (jboss-mail module) which I built against jboss404.GA.

      I am running on Linux (with postgresql 8.1). I installed using the install.jar. I created a new install of jboss with the collab stuff in there (I have also created the database instanceas well as db user). I am running as root (and have switched off my other mta agent to allow access to port 25). When starting jboss I can see the tables being created in my db instance. However I get the following message (and don't really know where to look to solve it):

      ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.mail:type=MailServices,name=MailListJMSListener
 State: CONFIGURED
 I Depend On:
 jboss.mq:service=DestinationManager
 jboss.mq.destination:service=Queue,name=maillist
 jboss.mail:type=MailServices,name=MailListManager

ObjectName: jboss.mail:type=MailServices,name=ListDeliveryChain
 State: CONFIGURED
 I Depend On:
 jboss.mail:type=MailServices,name=ListDelivery

ObjectName: jboss.mail:type=MailServices,name=ListDelivery
 State: CONFIGURED
 I Depend On:
 jboss.mail:type=MailServices,name=MailListManager
 jboss.mail:type=MailServices,name=MailListenerChain
 Depends On Me:
 jboss.mail:type=MailServices,name=ListDeliveryChain

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mail:type=MailServices,name=MailListManager
 State: NOTYETINSTALLED
 Depends On Me:
 jboss.mail:type=MailServices,name=MailListJMSListener
 jboss.mail:type=MailServices,name=ListDelivery


      Any suggestions as to what I am missing ?

      As another test (with the above error in mind) I tried to access my mailbox using mozilla's Mail client.. when trying to mail a message I see the following in the log file: 

      12:15:11,924 INFO [Server] Got request
12:15:11,924 INFO [Server] waiting for request
12:15:11,925 INFO [ConnectionHandler] connected: /146.64.28.3 to: /146.64.28.3 until: 1151403431924
12:15:11,980 WARN [CmdUSER] pop username set to lcoetzee
12:15:12,243 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42601
12:15:12,243 ERROR [JDBCExceptionReporter] ERROR: syntax error at or near "b"
12:15:12,285 INFO [ConnectionHandler] ConnectionHandler finished
12:15:12,285 ERROR [STDERR] Exception in thread "Thread-31"
12:15:12,285 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
12:15:12,285 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:567)
12:15:12,285 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:46)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl.org$jboss$mail$mailbox$MailboxServiceImpl$fastExpunge$aop(MailboxServiceImpl.java:744)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl.access$3(MailboxServiceImpl.java)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl$fastExpunge_1383726929380080844.invokeNext(MailboxServiceImpl$fastExpunge_1383726929380080844.java)
12:15:12,286 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
12:15:12,286 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:201)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl$fastExpunge_1383726929380080844.invokeNext(MailboxServiceImpl$fastExpunge_1383726929380080844.java)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl.fastExpunge(MailboxServiceImpl.java)
12:15:12,286 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl.org$jboss$mail$mailbox$MailboxServiceImpl$deleteMarked$aop(MailboxServiceImpl.java:490)
12:15:12,287 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl$deleteMarked_N734570016776585460.invokeNext(MailboxServiceImpl$deleteMarked_N734570016776585460.java)
12:15:12,287 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
12:15:12,287 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:275)
12:15:12,287 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl$deleteMarked_N734570016776585460.invokeNext(MailboxServiceImpl$deleteMarked_N734570016776585460.java)
12:15:12,287 ERROR [STDERR] at org.jboss.mail.mailbox.MailboxServiceImpl.deleteMarked(MailboxServiceImpl.java)
12:15:12,287 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:15:12,288 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
12:15:12,288 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
12:15:12,288 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
12:15:12,288 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
12:15:12,288 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
12:15:12,289 ERROR [STDERR] at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
12:15:12,289 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
12:15:12,289 ERROR [STDERR] at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
12:15:12,289 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
12:15:12,289 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
12:15:12,290 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
12:15:12,290 ERROR [STDERR] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
12:15:12,290 ERROR [STDERR] at $Proxy111.deleteMarked(Unknown Source)
12:15:12,290 ERROR [STDERR] at org.jboss.mail.pop3.POP3ProtocolInstance.deleteMarked(POP3ProtocolInstance.java:427)
12:15:12,290 ERROR [STDERR] at org.jboss.mail.pop3.handlers.CmdQUIT.handleRequest(CmdQUIT.java:66)
12:15:12,291 ERROR [STDERR] at org.jboss.mail.pop3.POP3ProtocolInstance.handleRequest(POP3ProtocolInstance.java:211)
12:15:12,291 ERROR [STDERR] at org.jboss.mail.ConnectionHandler.runSocket(ConnectionHandler.java:205)
12:15:12,291 ERROR [STDERR] at org.jboss.mail.ConnectionHandler.run(ConnectionHandler.java:97)
12:15:12,291 ERROR [STDERR] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743)
12:15:12,291 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
12:15:12,292 ERROR [STDERR] Caused by: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
12:15:12,292 ERROR [STDERR] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
12:15:12,292 ERROR [STDERR] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
12:15:12,293 ERROR [STDERR] at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:173)
12:15:12,293 ERROR [STDERR] at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1156)
12:15:12,293 ERROR [STDERR] at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:323)
12:15:12,293 ERROR [STDERR] at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:43)
12:15:12,293 ERROR [STDERR] ... 34 more
12:15:12,294 ERROR [STDERR] Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "b"
12:15:12,297 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
12:15:12,297 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
12:15:12,297 ERROR [STDERR] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
12:15:12,297 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
12:15:12,297 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
12:15:12,297 ERROR [STDERR] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)
12:15:12,297 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
12:15:12,298 ERROR [STDERR] at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:164)
12:15:12,298 ERROR [STDERR] ... 37 more


      (I have removed the provided pg74.215.jdbc3.jar and replaced it with postgresql-jdbc3-8.1.jar to allow access into my postgres8.1 installation).

      Any suggestions would be appreciated.

      Thanks

      Louis


      • 43853 Views
      • Tags:
        • 1. Re: MailListManager not installed?
          gohip
          gohip Jun 27, 2006 12:19 PM (in response to lcoetzee)

          in the Jboss-service.xml, there is an mBean for the MailListManager, it should already be commented out, but sounds as if it is not in your instance.

          the file is located in jboss_home/server/default/deploy/mail.ear/mail.sar/meta-inf

          attempt to comment it out, and see if it solves your problem, that is, unless you are trying to use a maillist?

          You might try, just getting the full install working first, rather than building then installing what
          you compiled.

          not sure on the postgresql, do you have the ds xml file in jboss_home/server/default/deploy folder, I use mySQL, so i have to copy the mySql ds file over to the directory, as it seems it is not always created, then you have to modify this file, to possibly point to your data store, and add the required credentials.

          the mySQL ds file is "mysql-ds.xml" I got it from jboss_home/docs/examples/jca

          i just looked in there, and their are pertinent postgre files as well, you need to copy them to deploy folder, if they dont already exist.

          if you still have issues on dbase, search this and dev forum, as we were just describing how to get ms sql going, and is generic enough for postgre

          good luck

            • Actions
          • 2. Re: MailListManager not installed?
            sappenin
            sappenin Jul 27, 2006 4:03 PM (in response to lcoetzee)

            I had the same error after building a new DIST install file (also from JBAS 4.0.4_patch1), using Postgresql. It looks like the JBOSS-HOME/server\default\deploy\mail.ear\mail.sar\META-INF/jboss-service.xml file is missing an entry for the MailListManager, so all of the other MailList MBeans fail to load. The Mbean name that we need is "jboss.mail:type=MailServices,name=MailListManager".

            In the 1.0M5 code (and before?), there is an entry for this mBean that is commented out (by default) in the jboss-service.xml file. It specifies the use of the org.jboss.mail.maillist.memory.MemoryMailListManager class. Since this class appears to have been removed from the HEAD, we need to use a different class for the MailListManager.

            So, I added the following bit of XML configuration to my jboss-service.xml file, rebooted the server, and everything works now.

            <mbean code="org.jboss.mail.maillist.hn.HnMailListManager"
 name="jboss.mail:type=MailServices,name=MailListManager">
 </mbean>


            Notice that JBCS is now using the HnMailListManager code (which I believe stands for Hibernate MLM code).

            david


              • Actions