topic Alfresco Custom JDBC Authenticator in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/alfresco-custom-jdbc-authenticator/m-p/2842#M798 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><STRONG>Installation guide:</STRONG> 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: <CODE> 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 </CODE> In alfresco-global.properties, an example of authentication chain can be: <CODE> authentication.chain=alfrescoNtlm1:alfrescoNtlm,myldap:ldap,myjdbc:jdbc </CODE> 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 <CODE> alfresco.authentication.authenticateCIFS=false passthru.authentication.authenticateCIFS=false </CODE> An example of custom properties are: <CODE> 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 </CODE> And finally, restart your Alfresco instance.</P><P></P><TABLE class="j-table jiveBorder" style="border: 1px solid #c6c6c6;" width="100%"><THEAD><TR style="background-color: #efefef;"><TH style="width: 19.5066%;"></TH><TH style="width: 78.7972%;"></TH></TR></THEAD><TBODY><TR><TD style="width: 19.5066%;">Owner</TD><TD style="width: 78.7972%;"><B>Will Abson</B>‌</TD></TR><TR><TD style="width: 19.5066%;">Versions</TD><TD style="width: 78.7972%;"><P>Community 3.3.x</P><P>Community 3.4.x</P><P>Community 4.0.x</P><P>Enterprise 3.3.x</P><P>Enterprise 3.4.x</P><P>Enterprise 4.0.x</P></TD></TR><TR><TD style="width: 19.5066%;">License Type</TD><TD style="width: 78.7972%;">Proprietary</TD></TR><TR><TD style="width: 19.5066%;">Project Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="http://www.zylk.net/web/guest/web-2-0/blog/-/blogs/alfresco-custom-jdbc-authentication-addon" title="http://www.zylk.net/web/guest/web-2-0/blog/-/blogs/alfresco-custom-jdbc-authentication-addon" rel="nofollow noopener noreferrer">- Alfresco custom JDBC authentication addon - zylk</A>&nbsp;</TD></TR><TR><TD style="width: 19.5066%;">Download Page</TD><TD style="width: 78.7972%;"><A class="link-titled" href="http://www.zylk.net/en/web/guest/alfresco-form" title="http://www.zylk.net/en/web/guest/alfresco-form" rel="nofollow noopener noreferrer">Contact - zylk</A>&nbsp;</TD></TR><TR><TD style="width: 19.5066%;">Tags</TD><TD style="width: 78.7972%;">zylk.net, authenticator, cifs, jDBC, subsystem</TD></TR><TR><TD style="width: 19.5066%;">Component Type</TD><TD style="width: 78.7972%;">Integration</TD></TR><TR><TD style="width: 19.5066%;">Extension Points</TD><TD style="width: 78.7972%;">Authenticator</TD></TR><TR><TD style="width: 19.5066%;">Installation</TD><TD style="width: 78.7972%;">AMP, Manual</TD></TR><TR><TD style="width: 19.5066%;">Products</TD><TD style="width: 78.7972%;">Repository</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 14 Jun 2018 00:38:48 GMT alfresco 2018-06-14T00:38:48Z Alfresco Custom JDBC Authenticator https://connect.hyland.com/t5/alfresco-forum/alfresco-custom-jdbc-authenticator/m-p/2842#M798 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 au Thu, 14 Jun 2018 00:38:48 GMT https://connect.hyland.com/t5/alfresco-forum/alfresco-custom-jdbc-authenticator/m-p/2842#M798 alfresco 2018-06-14T00:38:48Z