Could james be trying to start the pop server more than once?
INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,433 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | LMTP Service disabled by configuration INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,450 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | POP3 Service bound to: nsep1u9254:110 INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,450 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | POP3 Service is running on: nsep1u9254 INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,450 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | POP3 Service handler hello name is: nsep1u9254 INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,451 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | POP3 Service handler connection timeout is: 1200 INFO | jvm 1 | 2019/03/26 08:51:03 | INFO 08:51:03,451 | org.apache.james.protocols.lib.netty.AbstractConfigurableAsyncServer | POP3 Service connection backlog is: 200 INFO | jvm 1 | 2019/03/26 08:51:03 | WARN 08:51:03,548 | org.apache.james.container.spring.context.JamesServerApplicationContext | Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pop3server': Invocation of init method failed; nested exception is org.jboss.netty.channel.ChannelException: Failed to bind to: nsep1u9254/10.33.117.54:110 -----Original Message----- From: cryptearth [mailto:cryptea...@cryptearth.de] Sent: Tuesday, March 26, 2019 8:24 AM To: server-user@james.apache.org Subject: Re: sqlResources.xml Well, I don't use pop3 - but looks like an config issue. Please post your conf/pop3server.xml Matt Am 26.03.2019 um 11:57 schrieb Marans.Jeffrey: > Thanks guys. > You're right, 3.3 does have the fix, and it creates the tables, but throws > this exception: > WrapperSimpleApp: Encountered an error running main: > org.springframework.beans.factory.BeanCreationException: Error creating bean > with name 'pop3server': Invocation of init method failed; nested exception is > java.lang.ArrayIndexOutOfBoundsException: 1 > INFO | jvm 1 | 2019/03/25 15:01:27 | > org.springframework.beans.factory.BeanCreationException: Error creating bean > with name 'pop3server': Invocation of init method failed; nested exception is > java.lang.ArrayIndexOutOfBoundsException: 1 > > Jeff. > > -----Original Message----- > From: cryptearth [mailto:cryptea...@cryptearth.de] > Sent: Tuesday, March 26, 2019 2:13 AM > To: server-user@james.apache.org > Subject: Re: sqlResources.xml > > Hey Jeffrey, hey Garry, > > as I look through the source from 3.4 it seems this is already fixed, at > least it was in master-branch as of Feb 28th 08:05 UTC (a quick check: > 3.2.x doesn't contain the fix, but the 3.3.x does). > > Once I encountered a similar issue as I once didn't set database type > correctly in james-database.properties file. > > So, possible fix: update to 3.3.x branch. > > > greetings, > > Matt > > Am 25.03.2019 um 21:09 schrieb Garry Hurley: >> Yeah, I had put up a bug report on that issue. I had to fix that in the >> source code. The problem is the MailboxAnnotation class uses the column name >> ‘KEY’ which is a reserved word in SQL, so most real SQL databases balk at >> it. I thought that had been fixed before the 3.3 tag was finalized. All we >> need to do is change the column name to ‘ANNOTATION_KEY’. That has to be >> done in source code though, not in the sqlResources file. Welcome to JPA. >> >> Sent from my iPhone >> >>> On Mar 25, 2019, at 12:49 PM, Marans.Jeffrey <jeffrey.mar...@cic.gc.ca> >>> wrote: >>> >>> When I start james 3.0.2 the log contains Connected to Microsoft SQL Server >>> version 12.12 using JDBC driver Microsoft JDBC Driver 7.2 for SQL Server >>> version 7.2.1.0, and 3 tables were created. >>> >>> But this warning turns fatal >>> WARN 12:21:51,120 | >>> org.apache.james.container.spring.context.JamesServerApplicationCont >>> e xt | Exception encountered during context initialization - >>> cancelling refresh attempt: >>> org.springframework.beans.factory.UnsatisfiedDependencyException: >>> Error creating bean with name 'authenticator' defined in class path >>> resource >>> [META-INF/org/apache/james/spring-mailbox-authenticator.xml]: >>> Unsatisfied dependency expressed through constructor argument with >>> index 0 of type [org.apache.james.user.api.UsersRepository]: : Error >>> creating bean with name 'usersrepository': Injection of autowired >>> dependencies failed; nested exception is >>> org.springframework.beans.factory.BeanCreationException: Could not >>> autowire method: public void >>> org.apache.james.user.lib.AbstractUsersRepository.setDomainList(org. >>> a pache.james.domainlist.api.DomainList); nested exception is >>> org.springframework.beans.factory.BeanCreationException: Error >>> creating bean with name 'domainlist': Initialization of bean failed; >>> nested exception is org.springframework.beans.FatalBeanException: >>> Unable to execute lifecycle method on beandomainlist; nested >>> exception is <openjpa-3.0.0-r422266:1833209 nonfatal general error> >>> org.apache.openjpa.persistence.PersistenceException: Incorrect >>> syntax near the keyword 'KEY'. {stmnt 1664030951 CREATE TABLE >>> JAMES_MAILBOX_ANNOTATION (KEY VARCHAR(200) NOT NULL, MAILBOX_ID >>> BIGINT NOT NULL, VALUE VARCHAR(255), PRIMARY KEY (KEY, MAILBOX_ID))} >>> [code=156, state=S0001]; nested exception is >>> org.springframework.beans.factory.BeanCreationException: Error >>> creating bean with name 'usersrepository': Injection of autowired >>> dependencies failed; nested exception is >>> org.springframework.beans.factory.BeanCreationException: Could not >>> autowire method: public void >>> org.apache.james.user.lib.AbstractUsersRepository.setDomainList(org. >>> a pache.james.domainlist.api.DomainList); nested exception is >>> org.springframework.beans.factory.BeanCreationException: Error >>> creating bean with name 'domainlist': Initialization of bean failed; >>> nested exception is org.springframework.beans.FatalBeanException: >>> Unable to execute lifecycle method on beandomainlist; nested >>> exception is <openjpa-3.0.0-r422266:1833209 nonfatal general error> >>> org.apache.openjpa.persistence.PersistenceException: Incorrect >>> syntax near the keyword 'KEY'. {stmnt 1664030951 CREATE TABLE >>> JAMES_MAILBOX_ANNOTATION (KEY VARCHAR(200) NOT NULL, MAILBOX_ID >>> BIGINT NOT NULL, VALUE VARCHAR(255), PRIMARY KEY (KEY, MAILBOX_ID))} >>> [code=156, state=S0001] >>> >>> I can't find anything on the web regarding how to modify sqlResources.xml >>> to work with MS SQL Server. >>> >>> >>> Jeffrey Marans >>> >>> Enterprise Architect Biometrics, Domestic Network Immigration, >>> Refugees and Citizenship Canada / Government of Canada >>> jeffrey.mar...@cic.gc.ca<mailto:jeffrey.mar...@cic.gc.ca> / Tel: >>> 613-437-9890 >>> >>> Architecte de biométrie (Consultant), Solutions et gestion de >>> l'information Immigration, Réfugiés et Citoyenneté Canada / >>> Gouvernement du Canada >>> jeffrey.mar...@cic.gc.ca<mailto:jeffrey.mar...@cic.gc.ca> / Tél.: >>> 613-437-9890 >>> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org >> For additional commands, e-mail: server-user-h...@james.apache.org >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org > For additional commands, e-mail: server-user-h...@james.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org > For additional commands, e-mail: server-user-h...@james.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org For additional commands, e-mail: server-user-h...@james.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org For additional commands, e-mail: server-user-h...@james.apache.org
