[ 
https://issues.apache.org/jira/browse/JAMES-3580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17342479#comment-17342479
 ] 

Cosimo Damiano Prete commented on JAMES-3580:
---------------------------------------------

Hi [~btellier].
 Could you at least tell me if the environment variables replacement works in 
the same way?
 According to the [docs|https://james.apache.org/server/config.html], 
{{${env:FOO}}} should be replaced in the config files and this was actually the 
case in the Guice version, but with Spring my database properties are not 
replaced in the {{james-database.properties}} file leading to an invalid JDBC 
URL like {{jdbc:postgresql://DB_HOST:DB_PORT/DB}}.

If needed, this is my {{run_james.sh}} script
{code:shell}
#!/usr/bin/env bash
if [ "$GLOWROOT_ACTIVATED" == "true" ]; then
    GLOWROOT_OPTIONS="-javaagent:/root/glowroot/glowroot.jar"
fi
if [ "$DEBUG" == "true" ]; then
    
DEBUG_OPTIONS="-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=*:5005"
fi
JAVA_OPTS="$GLOWROOT_OPTIONS $DEBUG_OPTIONS"
env
exec ./wrapper-linux-x86-64 ../conf/wrapper.conf wrapper.syslog.ident=james 
wrapper.pidfile=../var/james.pid wrapper.daemonize=FALSE $JAVA_OPTS
{code}
and I can see that the variables are correctly there

> Can't integrate PostgreSQL completely
> -------------------------------------
>
>                 Key: JAMES-3580
>                 URL: https://issues.apache.org/jira/browse/JAMES-3580
>             Project: James Server
>          Issue Type: Bug
>          Components: guice, jpa
>    Affects Versions: 3.6.0
>            Reporter: Cosimo Damiano Prete
>            Priority: Blocker
>
> Hi guys.
> I'm migrating from James 2 to 3.6.0 and I cannot find any way to make it work 
> completely with PostgreSQL.
> By following the documentation, I set the DB connection properties in the 
> james-database.properties file but, somehow, in the logs I always get: 
> 15:35:33.924 [INFO ] o.a.j.m.m.MemoryMailRepositoryStore - JamesMailStore 
> init... 
> org.apache.james.mailrepository.memory.MemoryMailRepositoryStore@33827b88
> As a result, I don't see any data in the database at all. Unfortunately the 
> documentation doesn't really help much more, so I don't know where else I 
> should have a look at.
> Moreover, in James 2 I had the possibility to specify my own datasource 
> implementation. Is it possible with James 3 as well and, if it's so, how?
> Finally, I would need to create the users on the fly if they don't exist. Is 
> there something already available? I was trying by using an extension which 
> defines a Guice module providing an interceptor: 
> {code:java}
> public class CreateUserIfMissingModule extends AbstractModule {
>     @Override
>     protected void configure() {
>         final CreateUserIfMissingInterceptor interceptor = new 
> CreateUserIfMissingInterceptor();
>         requestInjection(interceptor); // Inject the repository
>         bindInterceptor(subclassesOf(UsersRepository.class), 
> returns(subclassesOf(Boolean.class)), interceptor);
>     }
> } {code}
> but, also this one, is not picked up at all.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to