Alfresco Custom JDBC Authenticator

Showing results for 
Search instead for 
Did you mean: 
Alfresco Employee

Alfresco Custom JDBC Authenticator

It is designed for users integration between an Alfresco repository and a custom application. You can use it with any type of database (mysql, postgresql, oracle....) with its corresponding jdbc driver and it is fully customizable through authentication properties. You can also use CIFS with this authentication if your password field is stored in MD4.

Installation guide: The installation is tracked via AMP package. Stop Alfresco, copy the file in ${ALF_HOME}/amps and use ${ALF_HOME}/bin/apply_amps script to install de AMP. Then copy configuration files to the extension directory: zylk@alf:/opt/alfresco34/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/jdbc/myjdbc/jdbc-authentication-context.xml zylk@alf:/opt/alfresco34/tomcat/shared/classes/alfresco/extension/subsystems/Authentication/jdbc/myjdbc/ In, an example of authentication chain can be: authentication.chain=alfrescoNtlm1:alfrescoNtlm,myldap:ldap,myjdbc:jdbc It is important to note that the other CIFS-able subsystems must be deactivated (only one of the subsystems can use CIFS - in fact the first one in the chain). In alfresco.authentication.authenticateCIFS=false passthru.authentication.authenticateCIFS=false An example of custom properties are: jdbc.username=root jdbc.password=secret jdbc.url=jdbc:mysql://localhost:3306/mydb jdbc.query=SELECT password FROM myusers WHERE id='{1}' # Default administrators jdbc.authentication.defaultAdministratorUserNames=zylk,mysql # CIFS # If = true set jdbc.authentication.password.type = md4 # Password storage / encryption type in DB: plain|md5|md4|DES|jcrypt jdbc.authentication.password.type=md4 And finally, restart your Alfresco instance.

OwnerWill Abson

Community 3.3.x

Community 3.4.x

Community 4.0.x

Enterprise 3.3.x

Enterprise 3.4.x

Enterprise 4.0.x

License TypeProprietary
Project Page- Alfresco custom JDBC authentication addon - zylk 
Download PageContact - zylk, authenticator, cifs, jDBC, subsystem
Component TypeIntegration
Extension PointsAuthenticator
InstallationAMP, Manual