nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

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

Find more posts tagged with

Comments

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/alfresco/ibatis/. Also will need the dbscripts/upgrade/3.2 for postgresql http://svn.alfresco.com/repos/alfresco-open-mirror/alfresco/HEAD/root/projects/repository/config/alfresco/dbscripts/upgrade/3.2/. 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???

ed_mann

Luca,

I have asked the same question and i have not gotten a definitive answer on it. I have another thread going where this very same question is asked. I did get this response from an "Alfresco Engineer":

I don't know why the PostgreSQL scripts were also dropped, it may have just been lack of opportunity to test and validate with that db.

So somebody forgot to configure the build system to test PostgreSQL and did not have time to make the necessary scripts. You would think someone from Alfresco would come out and let the community know why the scripts were not included. Granted this is just one example of why more "Community" members need to get involved with the development of Alf. My goal was to start with 3.2, but i am not 100% sure of the direction Alfresco wants to take the project. I do welcome feedback.

Thanks.

robl

I do hope PostgreSQL support returns. I have been migrating most of my apps from MySQL to PostgreSQL during the past 9 months or so. It would be nice to consolidate all of my apps to use a single type of database server, from a support perspective.

I hope this was just an oversight during the release and will be rectified soon.

mikef

Support for PostgreSQL has not been dropped, however, it is not included in the initial 3.2 release. An update will provided shortly to include PostgreSQL support. We will make an announcement on the forum as soon as it is available.

kbootz

I installed the 3.2 community release of alfresco with the default mysql db. To install postgres on Windows as local administrator here's what I did:

    Stop the tomcat/alfresco instance.

    Create a local machine user named 'postgres' using "administrative tools:computer Mgt/Local users and groups/users"(path?)

    Install Postgres. I used "postgresql-8.4.0-1-windows.exe". Record the path specified for the 'data' directory and set an env var - PGDATA - to that value

    Copy the postgres driver jar to the tomcat lib dir. I used 'postgresql-8.4-701.jdbc4.jar' from the postgres downloads page; http://jdbc.postgresql.org/download/postgresql-8.4-701.jdbc4.jar

    Get and install the postgres amp from alfresco wiki: postgresql-3.2-community.amp ; http://process.alfresco.com/ccdl/?file=release/community/build-2039/postgresql-3.2-community.amp

   Alter your alfresco.bat file in the alfresco install location so mysql doesn't start. An annoyance more than anything else. "goto tomcat" prior to mysql startup section, something similar prior to the mysql shutdown section

     Alter your %ALF_HOME%\tomcat\shared\classes\alfresco-global.properties file to use postgres, ie.;

#

# Sample database connection properties

#————-

db.name=alfresco

db.username=alfresco

db.password=alfresco

# db.host=localhost

# db.port=3306

#

# MySQL connection

#————-

# db.driver=org.gjt.mm.mysql.Driver

# db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}

# hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

# PostgresQL

db.driver=org.postgresql.Driver

db.url=jdbc

ostgresql://localhost:5432/${db.name}

hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

hibernate.query.substitutions=true TRUE, false FALSE

    Remove your lucene indexes directories from your alfresco data location . %ALF_HOME%\alf_data\lucene-indexes\"remove these dirs!"

    Execute the postgresql sql shell - psql - accepting the defaults to connect as postgres using the password you set when you created the postgres user locally. "C:\Program Files\PostgreSQL\8.4\scripts\runpsql.bat" OR the PostgresQL program group SQL Shell item

•         create database alfresco;

•         \connect alfresco

•         create user alfresco password 'alfresco';

•         \q

trialot

Some remarks with respect to PostgreSQL installation:

First of all, note that the installation manual is not entirely correct (if i am not mistaken). In this manual, the postgresql setup on page 64/65 is mentioning:

"To allow password-authenticated connections through TCP/IP, ensure the PostgreSQL
configuration file contains the following:

host all all 127.0.0.1/32 password

For PostgreSQL version 8.1.3, the file name is pg_hba.conf. For every other version, the file
name is postgresql.conf."

Note that the line "host … " should be in pg_hba.conf, even for versions other than PostgreSQL version 8.1.3.

Second, note that the order of listing the "host … " does seem to matter. My advice: put it on the first line of the pg_hba.conf file.

Third, another piece of advice: do not use "host all all 127.0.0.1/32 password" but use ""host [alfresco_database_name] all 127.0.0.1/32 password" or "host [alfresco_database_name] [alfresco_database_user] 127.0.0.1/32 password" instead, in order to have some degree of safety with respect to connections to the PostgreSQL database.

Finally, a question arises: somebody has experience with the change of "password" method into "md5" method? It should not make any difference in theory, but it seems that there are some issues with md5 encryption.

Can anyone shed a light on this? Does the community edition (and the PostgreSQL amp file in particular) support that md5 method?