As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
[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
<?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>
############################### ## 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
# # 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
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/libI feel like I'm just shooting in the dark!
CATALINA_LIBDIR=/usr/share/tomcat-6/lib/ CLASSPATH=${CATALINA_LIBDIR}:${TOMCAT_HOME}/shared/classes