topic Re: How to check which config-files are used in Alfresco Archive

How to check which config-files are used

prijke — Thu, 24 Apr 2008 19:53:37 GMT

Dear all,I used the wiki to create extensions in <TOMCAT>/shared/classes/alfresco/extensionIn my case that is /usr/local/apache-tomcat6.0/shared/classes/alfresco/extensionI changed some settings, but after restarting tomcat, the changes are ineffective.I cannot see nor understand why they aren

Re: How to check which config-files are used

sdavis — Fri, 25 Apr 2008 07:35:44 GMT

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

Re: How to check which config-files are used

prijke — Fri, 25 Apr 2008 15:35:39 GMT

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/data
dir.root=/home/alfresco/alf_data
#
# Sample database connection properties
#
db.username=error
db.password=error
db.pool.initial=10
db.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.Driver
db.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 configuration
mail.host=localhost
mail.port=25
mail.username=anonymous
mail.password=
# Set this value to UTF-8 or similar for encoding of email messages as required
mail.encoding=UTF-8
# Set this value to 7bit or similar for Asian encoding of email headers as required
mail.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‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to check which config-files are used

prijke — Fri, 25 Apr 2008 18:50:46 GMT

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

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

Re: How to check which config-files are used

sdavis — Sun, 27 Apr 2008 08:59:31 GMT

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

Re: How to check which config-files are used

matthewboh — Fri, 25 Jul 2008 19:35:18 GMT

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!

Re: How to check which config-files are used

rbergstrom — Thu, 31 Jul 2008 17:47:53 GMT

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