The system on which I'm developing was running dovecot. Even though I turned off and chkconfig'd off dovecot, the portreserve file contained the entries imap, imaps, pop3, pop3s. Those entries didn't specify TCP or UDP, so the portreserve program read /etc/services which contains pop3 110/tcp pop-3 # POP version 3 pop3 110/udp pop-3 pop3s 995/tcp # POP-3 over SSL pop3s 995/udp # POP-3 over SSL
I believe that's why both udp and tcp were occupied, but I didn't see that until I used the command lsof -i -P -n | grep ':110' Turning off portreserver, a program I've never seen before, fixed the issue. Hope that's a reasonable explanation. Again, thanks for help, it's much appreciated. Jeffrey Marans. -----Original Message----- From: cryptearth [mailto:cryptea...@cryptearth.de] Sent: Tuesday, March 26, 2019 2:31 PM To: server-user@james.apache.org Subject: Re: sqlResources.xml Well, if something runs on UDP/110 - you should still be able to bind to TCP/110 - as TCP and UDP are independent, unless the "portreserve" you speak about also binds/blocks TCP/110. Unless you have a multi-homed system or any other specific reason, 0.0.0.0:110 should be used (maybe also *:110 - but I don't know if this works). Matt Am 26.03.2019 um 19:13 schrieb Marans.Jeffrey: > The reason james would not run on port 110 is that the portreserve program is > on UDP 110. > I don't know why I didn't see that earlier, but Matt and Gary, thanks for > your time, patience, and in-depth knowledge. > > Regards, > Jeffrey Marans > > -----Original Message----- > From: cryptearth [mailto:cryptea...@cryptearth.de] > Sent: Tuesday, March 26, 2019 1:16 PM > To: server-user@james.apache.org > Subject: Re: sqlResources.xml > > Well, > > the "error" you got is "cannot bind - address already in use" - this usually > means, that there is already something bound to the port you try to use. > Altough the config somehow doesn't match to the latest log (config says > 0.0.0.0:110 but log shows hostname), the one you shown only contains one pop3 > server entry and should only try to start pop3 once on tcp/110. If nothing > else runs on TCP/110 the next issue I could come up with is that some other > config contains a server part wich is started before pop3 and already uses > 110. Check your other configs wich other service mind bind to TCP/110. > > One more "stupid" question: You do start james as root? > > Matt > > Am 26.03.2019 um 15:59 schrieb Marans.Jeffrey: >> I've rebooted the system twice and am still getting the same exception. >> Nothing's listening on 110 as evidenced by "telnet nsep1u9254 110 >> Trying 10.33.117.54... >> telnet: connect to address 10.33.117.54: Connection refused" >> >> This also returns nothing: lsof -i -P -n | grep LISTEN >> >> Is the popserver bind code the same in 3.2 and 3.3? >> >> I've attached the wrapper log. >> >> -----Original Message----- >> From: cryptearth [mailto:cryptea...@cryptearth.de] >> Sent: Tuesday, March 26, 2019 9:03 AM >> To: server-user@james.apache.org >> Subject: Re: sqlResources.xml >> >> Well, first: the stack is incomplete - there should be an IOException as >> lowest exception. >> second: this stack doesn't fit to the config you send earlier. >> So somethings blocking TCP/110. >> >> Just do a complete system reboot (if possible) cause it seems somethings >> "hung up". >> >> Matt >> >> Am 26.03.2019 um 13:59 schrieb Marans.Jeffrey: >>> 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.JamesServerApplicationC >>>>>> o n 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 >> --------------------------------------------------------------------- >> 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