analytics/sdk/java/AuthenticationProvider/JDBCSample/JDBCSample.java

/**
 * Licensed Materials - Property of IBM
 * 
 * IBM Cognos Products: CAMAAA
 * 
 * (C) Copyright IBM Corp. 2005, 2015
 * 
 * US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
 */

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.PrintStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Locale;

import com.cognos.CAM_AAA.authentication.IBiBusHeader;
import com.cognos.CAM_AAA.authentication.IBiBusHeader2;
import com.cognos.CAM_AAA.authentication.INamespaceAuthenticationProvider2;
import com.cognos.CAM_AAA.authentication.INamespaceConfiguration;
import com.cognos.CAM_AAA.authentication.IQuery;
import com.cognos.CAM_AAA.authentication.IQueryResult;
import com.cognos.CAM_AAA.authentication.ISearchExpression;
import com.cognos.CAM_AAA.authentication.ISearchFilter;
import com.cognos.CAM_AAA.authentication.ISearchStep;
import com.cognos.CAM_AAA.authentication.ISearchStep.SearchAxis;
import com.cognos.CAM_AAA.authentication.IVisa;
import com.cognos.CAM_AAA.authentication.QueryResult;
import com.cognos.CAM_AAA.authentication.ReadOnlyDisplayObject;
import com.cognos.CAM_AAA.authentication.SystemRecoverableException;
import com.cognos.CAM_AAA.authentication.TextDisplayObject;
import com.cognos.CAM_AAA.authentication.TextNoEchoDisplayObject;
import com.cognos.CAM_AAA.authentication.UnrecoverableException;
import com.cognos.CAM_AAA.authentication.UserRecoverableException;

/**
 * A Namespace implementation that uses JDBC to connect to a database that contains users and groups.
 */
public class JDBCSample extends Namespace implements INamespaceAuthenticationProvider2
{

	/**
	 * A utility class for handling username and password pairs.
	 */
	static class Credential
	{
		private String password;
		private String username;

		public String getPassword()
		{
			return this.password;
		}

		public String getUsername()
		{
			return this.username;
		}

		public boolean isEmpty()
		{
			return null == this.getUsername() && null == this.getPassword();
		}

		public void setPassword(final String thePassword)
		{
			this.password = thePassword;
		}

		public void setUsername(final String theUsername)
		{
			this.username = theUsername;
		}
	}

	protected static Credential getCredentialValues(final IBiBusHeader authRequest)
	{
		final Credential credential = new Credential();
		final String[] usernames = authRequest.getCredentialValue("username");
		final String[] passwords = authRequest.getCredentialValue("password");

		if (null != usernames && 0 < usernames.length)
			credential.setUsername(usernames[0]);

		if (null != passwords && 0 < passwords.length)
			credential.setPassword(passwords[0]);

		return credential;
	}

	private static String getErrorDetails(final UnrecoverableException e)
	{
		final ByteArrayOutputStream out = new ByteArrayOutputStream();
		final PrintStream ps = new PrintStream(out);

		ps.println(e.getClass().getName() + " : ");
		final String[] messages = e.getMessages();
		for (int i = 0; i < messages.length; i++)
			ps.println(messages[i]);
		ps.close();
		return out.toString();
	}

	protected static Credential getFormFieldValues(final IBiBusHeader authRequest)
	{
		final Credential credential = new Credential();
		final String[] usernames = authRequest.getFormFieldValue("CAMUsername");
		final String[] passwords = authRequest.getFormFieldValue("CAMPassword");

		if (null != usernames && 0 < usernames.length)
			credential.setUsername(usernames[0]);

		if (null != passwords && 0 < passwords.length)
			credential.setPassword(passwords[0]);

		return credential;
	}

	protected static Credential getTrustedCredentialValues(final IBiBusHeader2 authRequest)
	{
		final Credential credential = new Credential();
		final String[] usernames = authRequest.getTrustedCredentialValue("username");
		final String[] passwords = authRequest.getTrustedCredentialValue("password");

		if (null != usernames && 0 < usernames.length)
			credential.setUsername(usernames[0]);

		if (null != passwords && 0 < passwords.length)
			credential.setPassword(passwords[0]);

		return credential;
	}

	protected static Credential getTrustedEnvironmentVaribleValue(final IBiBusHeader2 authRequest)
	{
		final Credential credential = new Credential();
		final String[] userNames;
		userNames = authRequest.getTrustedEnvVarValue("REMOTE_USER");

		if (userNames != null && userNames.length > 0)
		{
			credential.setUsername(userNames[0]);
			// To simplified the case, we set up the password the same as userName
			credential.setPassword(userNames[0]);
		}

		return credential;
	}

	private ConnectionManager connectionManager;

	public Connection getConnection()
	{
		return this.connectionManager.getConnection();
	}

	/*
	 * @see com.cognos.CAM_AAA.provider.INamespace#init(com.cognos.CAM_AAA.provider .INamespaceConfiguration)
	 */
	@Override
	public void init(final INamespaceConfiguration theNamespaceConfiguration) throws UnrecoverableException
	{
		super.init(theNamespaceConfiguration);

		this.addName(Locale.getDefault(), theNamespaceConfiguration.getDisplayName());

		try
		{
			this.connectionManager = connectionManager.get();
			this.connectionManager.init(theNamespaceConfiguration);
		}
		catch (final IOException e)
		{
			throw new UnrecoverableException("Configuration Error", "Provider initialization failure. Reason: " + e.toString());
		}
		catch (final ClassNotFoundException e)
		{
			throw new UnrecoverableException("Configuration Error", "Provider initialization failure. Reason: " + e.toString());
		}
	}

	/*
	 * @see com.cognos.CAM_AAA.provider.INamespaceAuthenticationProvider#logoff(com .cognos.CAM_AAA.provider.IVisa,
	 * com.cognos.CAM_AAA.provider.IBiBusHeader)
	 */
	public void logoff(final IVisa theVisa, final IBiBusHeader theAuthRequest)
	{
		try
		{
			// We can safely assume that we'll get back the same Visa that we
			// issued.
			final JDBCVisa visa = (JDBCVisa) theVisa;
			visa.destroy();
		}
		catch (final UnrecoverableException e)
		{
			e.printStackTrace();
		}
	}

	/*
	 * @see com.cognos.CAM_AAA.provider.INamespaceAuthenticationProvider2#logon(com .cognos.CAM_AAA.provider.IBiBusHeader2)
	 */
	public IVisa logon(final IBiBusHeader2 theAuthRequest) throws UserRecoverableException, SystemRecoverableException,
			UnrecoverableException
	{
		JDBCVisa visa = null;

		// 1 - Look for trusted credentials
		Credential credential = JDBCSample.getTrustedCredentialValues(theAuthRequest);
		if (credential.isEmpty())
			credential = JDBCSample.getCredentialValues(theAuthRequest);

		if (credential.isEmpty())
			credential = JDBCSample.getFormFieldValues(theAuthRequest);

		// here, should be something for the single signon case
		if (credential.isEmpty() && this.connectionManager.singleSignOnEnabled())
			credential = JDBCSample.getTrustedEnvironmentVaribleValue(theAuthRequest);

		if (credential.isEmpty() && this.connectionManager.singleSignOnEnabled())
		{
			// null implies the provider has to start the dance so throw a SysRecov.
			// the SysRecov needs to have the name of the variable we look for in
			// the second parameter
			SystemRecoverableException e = new SystemRecoverableException("Challenge for REMOTE_USER", "REMOTE_USER");
			throw e;
		}

		if (credential.isEmpty())
		{
			// Assume this is the initial logon and pass null for errorDetails
			generateAndThrowExceptionForLogonPrompt(null);
		}

		try
		{
			//
			// Create a Visa for the new user.
			//
			visa = new JDBCVisa();
			visa.init(this, this.connectionManager, credential.getUsername(), credential.getPassword());
		}
		catch (final UnrecoverableException ex)
		{
			final String errorDetails = JDBCSample.getErrorDetails(ex);

			// Something went wrong, probably because the user's credentials
			// are invalid.
			generateAndThrowExceptionForLogonPrompt(errorDetails);
		}
		return visa;
	}

	/*
	 * @see com.cognos.CAM_AAA.provider.INamespaceAuthenticationProvider#search(com .cognos.CAM_AAA.provider.IVisa,
	 * com.cognos.CAM_AAA.provider.IQuery)
	 */
	public IQueryResult search(final IVisa theVisa, final IQuery theQuery) throws UnrecoverableException
	{
		// We can safely assume that we'll get back the same Visa that we
		// issued.
		final JDBCVisa visa = (JDBCVisa) theVisa;
		final QueryResult result = new QueryResult();
		try
		{
			final ISearchExpression expression = theQuery.getSearchExpression();
			final String objectID = expression.getObjectID();
			final ISearchStep[] steps = expression.getSteps();
			// It doesn't make sense to have multiple steps for this provider
			// since the objects are not hierarchical.
			if (steps.length != 1)
				throw new UnrecoverableException("Internal Error",
						"Invalid search expression. Multiple steps is not supported for this namespace.");
			final StringBuffer sqlCondition = new StringBuffer();
			final int searchType = steps[0].getAxis();
			final ISearchFilter filter = steps[0].getPredicate();
			String tenantId = QueryUtil.getTenantId(visa.getAccount());
			switch (searchType)
			{
				case SearchAxis.Self:
				case SearchAxis.DescendentOrSelf:
					if (objectID == null)
					{
						if (filter == null || this.matchesFilter(filter))
							result.addObject(this);
						// Add current namespace
						if (searchType == SearchAxis.Self)
							return result;
						else
							sqlCondition.append(QueryUtil.getSqlCondition(filter));
					}
					else if (objectID.startsWith("u:") && objectID.equals(visa.getAccount().getObjectID()))
					{
						if (filter == null || this.matchesFilter(filter))
							result.addObject(visa.getAccount());
						// Add current user
						return result;
					}
					else if (objectID.startsWith("u:"))
					{
						final String sqlID = objectID.substring(2);
						sqlCondition.append(QueryUtil.getSqlCondition(filter));
						if (sqlCondition.length() > 0)
							sqlCondition.append(" AND ");
						sqlCondition.append("ID = " + sqlID + " AND ISUSER = 1");
					}
					else if (objectID.startsWith("g:"))
					{
						final String sqlID = objectID.substring(2);
						sqlCondition.append(QueryUtil.getSqlCondition(filter));
						if (sqlCondition.length() > 0)
							sqlCondition.append(" AND ");
						sqlCondition.append("ID = " + sqlID + " AND ISGROUP = 1");
					}

					break;
				default:
					sqlCondition.append(QueryUtil.getSqlCondition(filter));

					break;
			}
			sqlCondition.append(getTenantSql(tenantId));
			QueryUtil.searchQuery(this.connectionManager, sqlCondition.toString(), theQuery.getQueryOption(),
					theQuery.getProperties(), theQuery.getSortProperties(), result, this);
		}
		catch (final SQLException e)
		{
			e.printStackTrace();
		}
		catch (final UnrecoverableException e)
		{
			e.printStackTrace();
		}

		return result;
	}

	private static String getTenantSql(String tenantId)
	{
		return " AND (TENANT='' OR TENANT='" + tenantId + "'" + ")";
	}

	/*
	 * Generate an exception with applicable display objects for the login prompt Note: If this is the initial logon, to avoid an
	 * empty logon log, be sure to throw either: a) a UserRecoverableException with null errorDetails b) a
	 * SystemRecoverableException
	 */
	private void generateAndThrowExceptionForLogonPrompt(String errorDetails) throws UserRecoverableException
	{
		final UserRecoverableException e =
				new UserRecoverableException("Please type your credentials for authentication.", errorDetails);
		e.addDisplayObject(new ReadOnlyDisplayObject("Namespace:", "CAMNamespaceDisplayName", this.getName(Locale.getDefault())));
		e.addDisplayObject(new TextDisplayObject("User ID:", "CAMUsername"));
		e.addDisplayObject(new TextNoEchoDisplayObject("Password:", "CAMPassword"));
		throw e;
	}
}