Questions about Alfresco 3.2

[luisg]

Hi there…
I just install Alfresco 3.2, and tried to configure with my needs.

The 1st thing I notice is that, some configuration files just changed its place. One example is the files for LDAP configuration.

In file ldap-authentication.properties we have, for example, ldap.authentication.userNameFormat=uid\=%s,ou\=People,dc\=company,dc\=com. To configure to my needs, I need to changed the values. The thing is, should the '/' and '\' remain, or we should change that to, for example, ldap.authentication.userNameFormat=uid=%s,ou=People,dc=company,dc=com?

In directory <Alfresco_Directory>/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/subsystems/Authentication we have many types of authentication. How we know the one that is used Alfresco?

Is the configuration of kerberos easier than the last versions? I ask this because I suppose that in this version CIFS's not workin with LDAP authentication yet, right (due MD4 and MD5 incompatibility)?

Finally, I would like to thank to all Alfresco engineers, by his excellent work.

Luis

[mikef]

In 3.2 a number of the core services have been moved into subsystems as described here: http://wiki.alfresco.com/wiki/Alfresco_Subsystems
Specific details on the Authentication Subsystems are described here: http://wiki.alfresco.com/wiki/Alfresco_Authentication_Subsystems

One of the benefits is you can now configure much of core Alfresco server and the new subsystems using a single property file called alfresco-global.properties (see previous links for details) rather than multiple spring config/property files.

[pero]

Hi.

Is PostgreSQL database supported in new Alfresco Community release?

Regards,
Petar.

[mikef]

3.2 Community requires mySQL, database scripts for PostgreSql are not currently available.

[ed_mann]

Will the scripts for Postgresql make it to the Community version?

[pero]

On page 61 of the configuration manual there are instructions for PostgreSql database configuration. It really doesn't make sense if PostrgeSql is not supported.

http://wiki.alfresco.com/w/images/e/e4/ECM_InstallConfigure_CommunityEdition32.pdf

And this also:

http://wiki.alfresco.com/wiki/Database_Configuration

Regards,
Petar.

[ed_mann]

pero & others,

They may have instructions on how to configure the database, however the files needed to get postgresql db to work are missing. I just tried this on my test system and it has several errors. See following:

The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
Caused by: 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeService' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'dbNodeServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'nodeDaoService' while setting bean property 'nodeDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeDaoService' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'nodeDaoServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeDaoServiceImpl' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'contentDataDAO' while setting bean property 'contentDataDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentDataDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'contentSqlMapClientTemplate' while setting bean property 'sqlMapClientTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentSqlMapClientTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'contentSqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentSqlMapClient' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
Caused by: 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbNodeServiceImpl' defined in class path resource [alfresco/node-services-context.xml]: Cannot resolve reference to bean 'nodeDaoService' while setting bean property 'nodeDaoService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeDaoService' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'nodeDaoServiceImpl' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'nodeDaoServiceImpl' defined in class path resource [alfresco/hibernate-context.xml]: Cannot resolve reference to bean 'contentDataDAO' while setting bean property 'contentDataDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentDataDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'contentSqlMapClientTemplate' while setting bean property 'sqlMapClientTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentSqlMapClientTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'contentSqlMapClient' while setting bean property 'sqlMapClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'contentSqlMapClient' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error occurred.  Cause: com.ibatis.common.xml.NodeletException: Error parsing XML.  Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/sqlMap'.  Cause: com.ibatis.sqlmap.client.SqlMapException: The <sqlMap> resource is missing: alfresco/ibatis/#resource.dialect#/content-insert-SqlMap.xml
‍‍‍‍‍‍

This release is broken. I understand them not supporting the proprietary db's, but dropping postgresql is just nuts. I will check the repo see if i can find the files, but would someone from alfresco comment on why postgresql was not included with this release, and when/if we can expect to see the needed files to use postgresql?

[ed_mann]

Did not find the files in svn http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/config/alf.... Also will need the dbscripts/upgrade/3.2 for postgresql http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/config/alf.... I believe those are the correct links to where the src should be.

[pero]

I think this is just another way to make people buy enterprise license.  :evil:  :evil:  :evil:

[luca]

Does anyone can tell us if there is a way to run Alfresco with Postgres?

Does the Alfresco team have the intention to update some patch to use Postgres???