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.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
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<!--
This template file can be used as example for James Server configuration
DO NOT USE IT AS SUCH AND ADAPT IT TO YOUR NEEDS
-->
<!-- See http://james.apache.org/server/3/config.html for usage -->
<pop3servers>
<!-- The POP3 server is enabled by default -->
<!-- Disabling blocks will stop them from listening, -->
<!-- but does not free as many resources as removing them would -->
<pop3server enabled="true">
<jmxName>pop3server</jmxName>
<!-- Configure this to bind to a specific inetaddress -->
<!-- port 995 is the well-known/IANA registered port for POP3S ie over SSL/TLS -->
<!-- port 110 is the well-known/IANA registered port for Standard POP3 -->
<bind>0.0.0.0:110</bind>
<connectionBacklog>200</connectionBacklog>
<!-- Set to true to support STARTTLS or SSL for the Socket.
To use this you need to copy sunjce_provider.jar to /path/james/lib directory.
-->
<tls socketTLS="false" startTLS="false">
<!-- To create a new keystore execute:
keytool -genkey -alias james -keyalg RSA -keystore /path/to/james/conf/keystore
-->
<keystore>file://conf/keystore</keystore>
<secret>yoursecret</secret>
<provider>org.bouncycastle.jce.provider.BouncyCastleProvider</provider>
</tls>
<!-- This is the name used by the server to identify itself in the POP3 -->
<!-- protocol. If autodetect is TRUE, the server will discover its -->
<!-- own host name and use that in the protocol. If discovery fails, -->
<!-- the value of 'localhost' is used. If autodetect is FALSE, James -->
<!-- will use the specified value. -->
<!--
<helloName autodetect="true">myMailServer</helloName>
-->
<!-- connection timeout in secconds -->
<connectiontimeout>1200</connectiontimeout>
<!-- Set the maximum simultaneous incoming connections for this service -->
<connectionLimit>0</connectionLimit>
<!-- Set the maximum simultaneous incoming connections per IP for this service -->
<connectionLimitPerIP>0</connectionLimitPerIP>
<handlerchain>
<!-- This loads the core CommandHandlers. Only remove this if you really -->
<!-- know what you are doing -->
<handler class="org.apache.james.pop3server.core.CoreCmdHandlerLoader"/>
</handlerchain>
</pop3server>
</pop3servers>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org
For additional commands, e-mail: server-user-h...@james.apache.org
