Alfresco Custom JDBC Authenticator

Document created by alfresco Employee on Jun 14, 2018
Version 1Show Document
  • View in full screen mode

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/jdbc-authentication.properties In alfresco-global.properties, 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-global.properties alfresco.authentication.authenticateCIFS=false passthru.authentication.authenticateCIFS=false An example of custom properties are: jdbc.driver=org.gjt.mm.mysql.Driver jdbc.username=root jdbc.password=secret jdbc.name=mydb 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 jdbc.authentication.cifs.active = true set jdbc.authentication.password.type = md4 jdbc.authentication.cifs.active=true # Password storage / encryption type in DB: plain|md5|md4|DES|jcrypt jdbc.authentication.password.type=md4 And finally, restart your Alfresco instance.

 

OwnerWill Abson
Versions

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 
Tagszylk.net, authenticator, cifs, jDBC, subsystem
Component TypeIntegration
Extension PointsAuthenticator
InstallationAMP, Manual
ProductsRepository

Attachments

    Outcomes