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.JamesServerApplicationCo
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