Thanks, I check port 110 and found nothing there. I also telneted to localhost 110 and got a connection refused, which means nothing's listening.
-----Original Message----- From: cryptearth [mailto:cryptea...@cryptearth.de] Sent: Tuesday, March 26, 2019 8:53 AM To: server-user@james.apache.org Subject: Re: sqlResources.xml Well, the issue is, that you have anything else already running on TCP/110 - like another POP3 server. Check your system what other POP3 server is running ... Matt Am 26.03.2019 um 13:38 schrieb Marans.Jeffrey: > The error is > 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 > org.jboss.netty.channel.ChannelException: Failed to bind to: /0.0.0.0:110 > INFO | jvm 1 | 2019/03/26 08:35:36 | > 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: /0.0.0.0:110 > > Caused by: java.net.BindException: Address already in use > > > -----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.JamesServerApplicationCon >>>> t 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