How to check which config-files are used

[prijke]

Dear all,

I used the wiki to create extensions in <TOMCAT>/shared/classes/alfresco/extension

In my case that is /usr/local/apache-tomcat6.0/shared/classes/alfresco/extension

I changed some settings, but after restarting tomcat, the changes are ineffective.

I cannot see nor understand why they aren't used.

The exact steps I did were these:
http://wiki.alfresco.com/wiki/Installing_Alfresco_Community_WAR_on_Centos_5#Modifying_the_basic_Alfr...

How can I check which files are used and in what order?

Any help will be highly appreciated

[sdavis]

Can you post these files that are noted in the Wiki:

[root@localhost alfresco]# cp custom-repository-context.xml.sample custom-repository-context.xml[root@localhost alfresco]# cp custom-repository.properties.sample custom-repository.properties[root@localhost alfresco]# cp custom-hibernate-dialect.properties.sample custom-hibernate-dialect.properties ‍‍‍‍‍‍

BTW, another great reference on Content Modeling specifically is at http://ecmarchitect.com/images/articles/alfresco-content/content-article.pdf

[prijke]

Hi SDavis,

Thanks for the interest in my problem.

Of the mentioned files, I only changed the custom-repository.properties. The other two are default. I've created them in <TOMCAT>/shared/classes/alfresco/extension

Here's the custom-repository-context.xml

<?xml version='1.0' encoding='UTF-8'?><!DOCTYPE beans PUBLIC '-//SPRING//DTD BEAN//EN' 'http://www.springframework.org/dtd/spring-beans.dtd'><!–       This shows the common minimum configuration overrides.       By default, the content and indexes are located at a relative location, which should only       be used when doing a quick preview of the Alfresco server.–><beans>       <!– overriding to point to custom properties –>    <bean id="repository-properties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">        <property name="ignoreUnresolvablePlaceholders">            <value>true</value>        </property>        <property name="locations">            <list>                <value>classpath:alfresco/repository.properties</value>                <value>classpath:alfresco/version.properties</value>                <value>classpath:alfresco/domain/transaction.properties</value>                <!– Override basic repository properties –>                <value>classpath:alfresco/extension/custom-repository.properties</value>            </list>        </property>    </bean>    <bean id="hibernateConfigProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">        <property name="locations">            <list>                <value>classpath:alfresco/domain/hibernate-cfg.properties</value>                <!– Override hibernate dialect –>                <value>classpath:alfresco/extension/custom-hibernate-dialect.properties</value>            </list>        </property>    </bean>    </beans>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here's the custom-repository.properties. I deliberatly gave the user and password a false name, to see if startup would fail (it didn't fail)

################################# Common Alfresco Properties ################################## Sample custom content and index data location##dir.root=/srv/alfresco/datadir.root=/home/alfresco/alf_data## Sample database connection properties#db.username=errordb.password=errordb.pool.initial=10db.pool.max=100## Property to control whether schema updates are performed automatically.# Updates must be enabled during upgrades as, apart from the static upgrade scripts,# there are also auto-generated update scripts that will need to be executed.  After# upgrading to a new version, this can be disabled.##db.schema.update=true## HSQL connection##db.driver=org.hsqldb.jdbcDriver#db.url=jdbc:hsqldb:file:alf_data/hsql_data/alfresco;ifexists=true;shutdown=true;## MySQL connection (This is default and requires mysql-connector-java-5.0.3-bin.jar, which ships with the Alfresco server)#db.driver=org.gjt.mm.mysql.Driverdb.url=jdbc:mysql://localhost/alfresco## Oracle connection (requires ojdbc14_g.jar or equivalent jar in shared libraries location)##db.driver=oracle.jdbc.OracleDriver#db.url=jdbc:oracle:thin:@localhost:1521:alfresco## Sybase connection (requires jconn2d.jar or equivalent jar in shared libraries location)##db.driver=com.sybase.jdbc2.jdbc.SybDriver#db.url=jdbc:sybase:Tds:localhost:2638/alfresco## SQLServer connection (requires jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/)##db.driver=net.sourceforge.jtds.jdbc.Driver#db.url=jdbc:jtds:sqlserver://localhost/alfresco## SQLServer connection using Microsoft JDDB driver##db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver#db.url=jdbc:sqlserver://localhost;DatabaseName=alfresco## PostgreSQL connection (requires postgresql-8.2-504.jdbc3.jar or equivalent)##db.driver=org.postgresql.Driver#db.url=jdbc:postgresql://localhost:5432/alfresco# Email configurationmail.host=localhostmail.port=25mail.username=anonymousmail.password=# Set this value to UTF-8 or similar for encoding of email messages as requiredmail.encoding=UTF-8# Set this value to 7bit or similar for Asian encoding of email headers as requiredmail.header=mail.from.default=blabla@blabla.nl‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And here's the last one, the custom-hibernate-dialect.properties (didn't change a thing here)

## Sample Hibernate configuration for changing Database dialect# For a full list: http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#configuration-optional-dialects### HSQL dialect##hibernate.dialect=org.hibernate.dialect.HSQLDialect## MySQL dialect (default)##hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect## Oracle dialect##hibernate.dialect=org.hibernate.dialect.Oracle9Dialect## Sybase dialect##hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSybaseAnywhereDialect## SQLServer dialect##hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect## PostgreSQL dialect##hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect#hibernate.query.substitutions=true TRUE, false FALSE‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[prijke]

In the end it appears that Tomcat6 is doing differently….

This was my solution
http://wiki.alfresco.com/wiki/Install_Tomcat6

[sdavis]

Ah, that's definitely news to me with Tomcat6.  Did following the process noted correct your problem?

[matthewboh]

I'm installing this with Java 6 and tomcat 6 and I'm having a lot of problems.  I think I have it down to the fact that it can't find the mysql connector/j file - where does it go?

I've put mysql-connector-java-5.1.6-bin.jar in
[tomcat]/lib
[tomcat]/common/lib
[tomcat]/webapps/alfresco/WEB-INF/lib

I feel like I'm just shooting in the dark!

[rbergstrom]

I'm installing this with Java 6 and tomcat 6 and I'm having a lot of problems.  I think I have it down to the fact that it can't find the mysql connector/j file - where does it go?

I've put mysql-connector-java-5.1.6-bin.jar in
[tomcat]/lib
[tomcat]/common/lib
[tomcat]/webapps/alfresco/WEB-INF/lib

I feel like I'm just shooting in the dark!

Mat:

I'm running 2.1 community on tomcat 6 with java 6 and placing the jdbc drivers in $TOMCAT_HOME/lib does work.  However, I'd caveat that with the fact that in my tomcat configuration the jvm CLASSPATH is set to:

CATALINA_LIBDIR=/usr/share/tomcat-6/lib/CLASSPATH=${CATALINA_LIBDIR}:${TOMCAT_HOME}/shared/classes‍‍‍‍

The other path is for the configuration extensions.  The wiki entry mentioned earlier addresses this in another fashion, but this is working for me.

HTH,

// RAB