Alfresco - MySQL and LDAP configuration

LDAP notes
As per: http://wiki.alfresco.com/wiki/Alfresco_Subsystems#Configuring_Subsystemshttp://forums.alfresco.com/en/viewtopic.php?f=9&t=25377&p=82530&hilit=ldap#p82530 you are NOT SUPPOSED to edit ../WEB-INF/ files under Alfresco 3.2 systems. Editing any files under ../WEB-INF/.. will not disable it - it will break the subsystem as you are removing one of the defaults referenced by the Spring configuration.

I want to authenticate users against Active Directory.
I do not use Single Sign On.
I am not sure whether I want to query groups, etc.
I do not want to change Active Directory password from Alfresco.

So my basic ldap configuration, in alfresco-global.properties, is:
authentication.chain=ldap1:ldap-ad

You first need to makedir these directories: subsystems/Authentication/ldap/ldap-ad under /opt/Alfresco/tomcat/shared/classes/alfresco/extension/
Then you need to copy /opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/subsystems/Authentication/ldap-ad/ldap-ad-authentication.properties to /opt/Alfresco/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/ldap/ldap-ad
since your authentication.chain follows this directory path.
ldap1:ldap is authentication folder : authentication type

By default, the default product configuration has a simple chain with one member. This is an instance of the alfrescoNtlm subsystem type with ID alfrescoNtlm1.

This is expressed in the built-in defaults (in /opt/Alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties) as

authentication.chain=alfrescoNtlm1:alfrescoNtlm

To add log4j LDAP debugging, you need to add the following to /opt/Alfresco/tomcat/
webapps/alfresco/WEB-INF/classes/log4j.properties
#LDAP Server Debug
log4j.logger.org.alfresco.repo.security.authentication.ldap=debug

MySQL notes:

• To set alfresco user password for MySQL:

mysql> set password for 'alfresco'@'localhost' = PASSWORD('newpassword');  

• With community 3.2r2, in alfresco-global.properties, the database driver probably reads:

db.driver=org.gjt.mm.mysql.Driver This is for older Alfresco versions and my not connect to new MySQL versions. To fix, change db.driver to:

db.driver=com.mysql.jdbc.Driver

Verify that you have mysql-connector-java-###-##.jar installed.
It should be located in /opt/Alfresco/tomcat/lib/