public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
String support = "support"; // valid username
HttpSession session = null;
session = req.getSession(false); // Get user's session object (no new one)
if (session == null) {
invalidUser(out); // Intruder - reject
return;
}
String userName = (String) session.getAttribute("user"); // get username
if (!userName.equals(support)) {
invalidUser(out); // Intruder - reject
return;
}
String action = "";
if (req.getParameter("todo") != null) action = req.getParameter("todo");
if (action.equals("update")) {
doUpdate(out);
return;
}
out.println("<p>Nothing to do.</p>todo=" + action);
}
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
String support = "support"; // valid username
HttpSession session = null;
session = req.getSession(false); // Get user's session object (no new one)
if (session == null) {
invalidUser(out); // Intruder - reject
return;
}
String userName = (String) session.getAttribute("user"); // get username
if (!userName.equals(support)) {
invalidUser(out); // Intruder - reject
return;
}
out.println("<HTML><HEAD><TITLE>Database Upgrade</TITLE></HEAD>");
out.println("<BODY><CENTER>");
out.println(
"<BR><BR><H3>This job will check all clubs' session logs for caller=clubster.</H3>");
out.println("<BR><BR>Click 'Continue' to start the job.");
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A><BR><BR>");
out.println(
"<form method=post><input type=submit value=\"Continue\" onclick=\"return confirm('Are you sure?')\">");
out.println(" <input type=hidden value=\"update\" name=\"todo\"></form>");
/*
out.println("<form method=post><input type=submit value=\" Test \">");
out.println(" <input type=hidden value=\"test\" name=\"todo\"></form>");
*
*/
out.println("</CENTER></BODY></HTML>");
out.close();
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
final String S_ProcName = "doGet";
ICFInternetSchemaObj schemaObj;
HttpSession sess = request.getSession(false);
if (sess == null) {
sess = request.getSession(true);
schemaObj = new CFInternetSchemaPooledObj();
sess.setAttribute("SchemaObj", schemaObj);
} else {
schemaObj = (ICFInternetSchemaObj) sess.getAttribute("SchemaObj");
if (schemaObj == null) {
schemaObj = new CFInternetSchemaPooledObj();
sess.setAttribute("SchemaObj", schemaObj);
}
}
ICFInternetSchema dbSchema = null;
try {
CFSecurityAuthorization auth = schemaObj.getAuthorization();
if (auth != null) {
response.sendRedirect("CFInternetSMWarSecurityMainHtml");
return;
}
dbSchema = (ICFInternetSchema) CFInternetSchemaPool.getSchemaPool().getInstance();
schemaObj.setBackingStore(dbSchema);
schemaObj.beginTransaction();
ICFSecuritySecUserObj systemUser =
schemaObj.getSecUserTableObj().readSecUserByULoginIdx("system");
String passwordHash = systemUser.getRequiredPasswordHash();
if ((passwordHash == null)
|| (passwordHash.length() <= 0)
|| passwordHash.equals("bootstrap")) {
response.sendRedirect("CFInternetSMWarSetSystemPasswordHtml");
return;
}
ICFSecuritySysClusterObj sysCluster =
schemaObj.getSysClusterTableObj().readSysClusterByIdIdx(1, false);
if (sysCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "sysCluster");
}
ICFSecurityClusterObj resolvedCluster = sysCluster.getRequiredContainerCluster();
if (resolvedCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, "resolvedCluster");
}
String clusterDomainName = resolvedCluster.getRequiredFullDomainName();
String clusterDescription = resolvedCluster.getRequiredDescription();
String confirmationUUIDStr = (String) request.getParameter("ConfirmationUUID");
if ((confirmationUUIDStr == null) || (confirmationUUIDStr.length() <= 0)) {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFInternetSMWarConfirmEMailAddressHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">ERROR</H2>");
out.println("<p>");
out.println("<center>");
out.println("<p>");
out.println(
"The ConfirmationUUID parameter was missing in your request. Please use the link provided by your confirmation email.");
out.println("</BODY>");
out.println("</HTML>");
return;
}
UUID confirmationUUID = UUID.fromString(confirmationUUIDStr);
if (confirmationUUID == null) {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFInternetSMWarConfirmEMailAddressHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">ERROR</H2>");
out.println("<p>");
out.println("<center>");
out.println("<p>");
out.println(
"Invalid ConfirmationUUID \""
+ confirmationUUIDStr
+ "\". Please use the link provided by your confirmation email.");
out.println("</BODY>");
out.println("</HTML>");
return;
}
ICFSecuritySecUserObj confirmUser = null;
Iterator<ICFSecuritySecUserObj> secUserForUUID =
schemaObj.getSecUserTableObj().readSecUserByEMConfIdx(confirmationUUID).iterator();
if (secUserForUUID.hasNext()) {
confirmUser = secUserForUUID.next();
if (secUserForUUID.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Multiple SecUser instances found for ConfirmationUUID \""
+ confirmationUUIDStr
+ "\"");
}
} else {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFInternetSMWarConfirmEMailAddressHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">ERROR</H2>");
out.println("<p>");
out.println("<center>");
out.println("<p>");
out.println(
"Invalid ConfirmationUUID \""
+ confirmationUUIDStr
+ "\". Please use the link provided by your confirmation email.");
out.println("</BODY>");
out.println("</HTML>");
return;
}
ICFSecurityClusterObj systemCluster =
schemaObj.getClusterTableObj().readClusterByUDomainNameIdx("system");
ICFSecurityTenantObj systemTenant =
schemaObj
.getTenantTableObj()
.readTenantByUNameIdx(systemCluster.getRequiredId(), "system");
ICFSecuritySecSessionObj systemSession = schemaObj.getSecSessionTableObj().newInstance();
ICFSecuritySecSessionEditObj editSystemSession =
(ICFSecuritySecSessionEditObj) systemSession.beginEdit();
editSystemSession.setRequiredContainerSecUser(systemUser);
editSystemSession.setRequiredStart(Calendar.getInstance());
systemSession = editSystemSession.create();
editSystemSession.endEdit();
auth = new CFSecurityAuthorization();
auth.setSecCluster(systemCluster);
auth.setSecTenant(systemTenant);
auth.setSecSession(systemSession);
schemaObj.setAuthorization(auth);
ICFSecuritySecUserEditObj editConfirmUser = confirmUser.beginEdit();
editConfirmUser.setOptionalEMailConfirmationUuid(null);
editConfirmUser.update();
editConfirmUser.endEdit();
editSystemSession = (ICFSecuritySecSessionEditObj) systemSession.beginEdit();
editSystemSession.setOptionalFinish(Calendar.getInstance());
editSystemSession.update();
editSystemSession.endEdit();
schemaObj.commit();
schemaObj.setAuthorization(null);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFInternetSMWarConfirmEMailAddressHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">EMail Address Confirmed</H2>");
out.println("<p>");
out.println("<center>");
out.println("<table style=\"width:75%\">");
out.println(
"<tr><th style=\"text-align:left\">Confirmation UUID:</th><td><input type=\"text\" name=\"ConfirmationUUID\" value=\""
+ confirmationUUID.toString()
+ "\"/></td></tr>");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\">You may now <A HRef=\"CFInternetSMWarLoginHtml\">log in</A> to the "
+ clusterDescription
+ " Security Manager</td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
} catch (RuntimeException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught RuntimeException -- " + e.getMessage(), e);
} finally {
if (dbSchema != null) {
try {
if (schemaObj.isTransactionOpen()) {
schemaObj.rollback();
}
} catch (RuntimeException e) {
}
schemaObj.setBackingStore(null);
CFInternetSchemaPool.getSchemaPool().releaseInstance(dbSchema);
}
}
}
/** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
final String S_ProcName = "doGet";
ICFAsteriskSchemaObj schemaObj;
HttpSession sess = request.getSession(false);
if (sess == null) {
sess = request.getSession(true);
schemaObj = new CFAsteriskSchemaPooledObj();
sess.setAttribute("SchemaObj", schemaObj);
} else {
schemaObj = (ICFAsteriskSchemaObj) sess.getAttribute("SchemaObj");
if (schemaObj == null) {
schemaObj = new CFAsteriskSchemaPooledObj();
sess.setAttribute("SchemaObj", schemaObj);
}
}
ICFAsteriskSchema dbSchema = null;
try {
CFSecurityAuthorization auth = schemaObj.getAuthorization();
if (auth != null) {
response.sendRedirect("CFAsteriskSMWarSecurityMainHtml");
return;
}
dbSchema = (ICFAsteriskSchema) CFAsteriskSchemaPool.getSchemaPool().getInstance();
schemaObj.setBackingStore(dbSchema);
schemaObj.beginTransaction();
ICFSecuritySecUserObj systemUser =
schemaObj.getSecUserTableObj().readSecUserByULoginIdx("system");
String passwordHash = systemUser.getRequiredPasswordHash();
if ((passwordHash == null)
|| (passwordHash.length() <= 0)
|| passwordHash.equals("bootstrap")) {
response.sendRedirect("CFAsteriskSMWarSetSystemPasswordHtml");
return;
}
ICFSecuritySysClusterObj sysCluster =
schemaObj.getSysClusterTableObj().readSysClusterByIdIdx(1, false);
if (sysCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "sysCluster");
}
ICFSecurityClusterObj resolvedCluster = sysCluster.getRequiredContainerCluster();
if (resolvedCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, "resolvedCluster");
}
String clusterDomainName = resolvedCluster.getRequiredFullDomainName();
String clusterDescription = resolvedCluster.getRequiredDescription();
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFAsteriskSMWarRequestResetPasswordHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println(
"<H2 style=\"text-align:center\">Enter the login you'd like to request a password reset for.</H2>");
out.println("<p>");
out.println("<center>");
out.println("<table style=\"width:60%\">");
out.println(
"<tr><th style=\"text-align:left\">Login Id:</th><td><input type=\"text\" name=\"LoginId\"/></td></tr>");
out.println(
"<tr><td colspan=\"2\" style=\"text-align:center\"><button type=\"submit\" name=\"Ok, Request Password Reset\"\">Ok</button></td></tr>");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\"><A HRef=\"CFAsteriskSMWarLoginHtml\">Back to "
+ clusterDescription
+ " Security Manager Login</A></td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
} catch (RuntimeException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught RuntimeException -- " + e.getMessage(), e);
} finally {
if (dbSchema != null) {
try {
if (schemaObj.isTransactionOpen()) {
schemaObj.rollback();
}
} catch (RuntimeException e) {
}
schemaObj.setBackingStore(null);
CFAsteriskSchemaPool.getSchemaPool().releaseInstance(dbSchema);
}
}
}
/** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
final String S_ProcName = "doPost";
ICFAsteriskSchemaObj schemaObj;
HttpSession sess = request.getSession(false);
if (sess == null) {
sess = request.getSession(true);
schemaObj = new CFAsteriskSchemaPooledObj();
sess.setAttribute("SchemaObj", schemaObj);
} else {
schemaObj = (ICFAsteriskSchemaObj) sess.getAttribute("SchemaObj");
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "schemaObj");
}
}
ICFAsteriskSchema dbSchema = null;
try {
CFSecurityAuthorization auth = schemaObj.getAuthorization();
if (auth != null) {
response.sendRedirect("CFAsteriskSMWarSecurityMainHtml");
return;
}
dbSchema = (ICFAsteriskSchema) CFAsteriskSchemaPool.getSchemaPool().getInstance();
schemaObj.setBackingStore(dbSchema);
schemaObj.beginTransaction();
ICFSecuritySecUserObj systemUser =
schemaObj.getSecUserTableObj().readSecUserByULoginIdx("system");
String passwordHash = systemUser.getRequiredPasswordHash();
if ((passwordHash == null)
|| (passwordHash.length() <= 0)
|| passwordHash.equals("bootstrap")) {
response.sendRedirect("CFAsteriskSMWarSetSystemPasswordHtml");
}
ICFSecurityClusterObj resolvedCluster;
ICFSecuritySysClusterObj sysCluster =
schemaObj.getSysClusterTableObj().readSysClusterByIdIdx(1, false);
if (sysCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "sysCluster");
}
resolvedCluster = sysCluster.getRequiredContainerCluster();
if (resolvedCluster == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, "resolvedCluster");
}
String clusterDomainName = resolvedCluster.getRequiredFullDomainName();
String clusterDescription = resolvedCluster.getRequiredDescription();
String loginId = (String) request.getParameter("LoginId");
if ((loginId == null) || (loginId.length() <= 0)) {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println(
"<form method=\"post\" formaction=\"CFAsteriskSMWarRequestResetPasswordHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">ERROR</H2>");
out.println("<p style=\"text-align:center\">");
out.println("You must specify a login id to reset.");
out.println("<p style=\"text-align:center\">");
out.println("Enter the login you'd like to request a password reset for.");
out.println("<p>");
out.println("<center>");
out.println("<table style=\"width:60%\">");
out.println(
"<tr><th style=\"text-align:left\">Login Id:</th><td><input type=\"text\" name=\"LoginId\"/></td></tr>");
out.println(
"<tr><td colspan=\"2\" style=\"text-align:center\"><button type=\"submit\" name=\"Ok, Request Password Reset\"\">Ok</button></td></tr>");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\"><A HRef=\"CFAsteriskSMWarLoginHtml\">Back to "
+ clusterDescription
+ " Security Manager Login</A></td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
return;
}
ICFSecuritySecUserObj authenticatingUser =
schemaObj.getSecUserTableObj().readSecUserByULoginIdx(loginId, true);
if (authenticatingUser == null) {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println(
"<form method=\"post\" formaction=\"CFAsteriskSMWarRequestResetPasswordHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">ERROR</H2>");
out.println("<p style=\"text-align:center\">");
out.println("Login id not found.");
out.println("<p style=\"text-align:center\">");
out.println("Enter the login you'd like to request a password reset for.");
out.println("<p>");
out.println("<center>");
out.println("<table style=\"width:60%\">");
out.println(
"<tr><th style=\"text-align:left\">Login Id:</th><td><input type=\"text\" name=\"LoginId\"/></td></tr>");
out.println(
"<tr><td colspan=\"2\" style=\"text-align:center\"><button type=\"submit\" name=\"Ok, Request Password Reset\"\">Ok</button></td></tr>");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\"><A HRef=\"CFAsteriskSMWarLoginHtml\">Back to "
+ clusterDescription
+ " Security Manager Login</A></td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
return;
}
if (null != authenticatingUser.getOptionalPasswordResetUuid()) {
sendPasswordResetEMail(request, authenticatingUser, resolvedCluster);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println(
"<form method=\"post\" formaction=\"CFAsteriskSMWarRequestResetPasswordHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">INFO</H2>");
out.println("<p style=\"text-align:center\">");
out.println("Password reset email resent.");
out.println("<center>");
out.println("<table style=\"width:60%\">");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\"><A HRef=\"CFAsteriskSMWarLoginHtml\">Back to "
+ clusterDescription
+ " Security Manager Login</A></td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
}
ICFSecurityClusterObj systemCluster =
schemaObj.getClusterTableObj().readClusterByUDomainNameIdx("system");
ICFSecurityTenantObj systemTenant =
schemaObj
.getTenantTableObj()
.readTenantByUNameIdx(systemCluster.getRequiredId(), "system");
ICFSecuritySecSessionObj systemSession = schemaObj.getSecSessionTableObj().newInstance();
ICFSecuritySecSessionEditObj editSystemSession =
(ICFSecuritySecSessionEditObj) systemSession.beginEdit();
editSystemSession.setRequiredContainerSecUser(systemUser);
editSystemSession.setRequiredStart(Calendar.getInstance());
systemSession = editSystemSession.create();
editSystemSession.endEdit();
auth = new CFSecurityAuthorization();
auth.setSecCluster(systemCluster);
auth.setSecTenant(systemTenant);
auth.setSecSession(systemSession);
schemaObj.setAuthorization(auth);
ICFSecuritySecUserEditObj editAuthenticatingUser = authenticatingUser.beginEdit();
editAuthenticatingUser.setOptionalPasswordResetUuid(UUID.randomUUID());
editAuthenticatingUser.update();
editAuthenticatingUser.endEdit();
editSystemSession = (ICFSecuritySecSessionEditObj) systemSession.beginEdit();
editSystemSession.setOptionalFinish(Calendar.getInstance());
editSystemSession.update();
editSystemSession.endEdit();
schemaObj.setAuthorization(null);
schemaObj.commit();
sendPasswordResetEMail(request, authenticatingUser, resolvedCluster);
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\">");
out.println("<HTML>");
out.println("<BODY>");
out.println("<form method=\"post\" formaction=\"CFAsteriskSMWarRequestResetPasswordHtml\">");
out.println(
"<H1 style=\"text-align:center\">" + clusterDescription + " Security Manager</H1>");
out.println("<H2 style=\"text-align:center\">INFO</H2>");
out.println("<p style=\"text-align:center\">");
out.println(
"Password reset email sent. Please use the links in the email to set a new password or to cancel the request.");
out.println("<center>");
out.println("<table style=\"width:60%\">");
out.println(
"<tr><td colSpan=\"2\" style=\"text-align:center\"><A HRef=\"CFAsteriskSMWarLoginHtml\">Back to "
+ clusterDescription
+ " Security Manager Login</A></td></tr>");
out.println("</table>");
out.println("</center>");
out.println("</form>");
out.println("</BODY>");
out.println("</HTML>");
} catch (MessagingException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught MessagingException -- " + e.getMessage(), e);
} catch (NamingException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught NamingException -- " + e.getMessage(), e);
} catch (RuntimeException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught RuntimeException -- " + e.getMessage(), e);
} finally {
if (dbSchema != null) {
try {
if (schemaObj.isTransactionOpen()) {
schemaObj.rollback();
}
} catch (RuntimeException e) {
}
schemaObj.setBackingStore(null);
CFAsteriskSchemaPool.getSchemaPool().releaseInstance(dbSchema);
}
}
}
public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html");
PrintWriter out = resp.getWriter();
String support = "support"; // valid username
HttpSession session = null;
session = req.getSession(false); // Get user's session object (no new one)
if (session == null) {
invalidUser(out); // Intruder - reject
return;
}
String userName = (String) session.getAttribute("user"); // get username
if (!userName.equals(support)) {
invalidUser(out); // Intruder - reject
return;
}
Connection con1 = null; // init DB objects
Connection con2 = null;
Statement stmt1 = null;
Statement stmt2 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
out.println("<HTML><HEAD><TITLE>Database Query</TITLE></HEAD>");
out.println("<BODY><H3>List Each Club With a Custom Style Sheet</H3>");
out.println(
"<table border=1><tr><td><b>Site</b></td><td><b>Club Name</b></td><td><b>Style Sheet</b></td></tr>");
out.flush();
String club = "";
String fullname = "";
String styles = "";
try {
con1 = Connect.getCon(rev); // connect to v5
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
//
// Get the club names from the 'clubs' table
//
// Process each club in the table
//
try {
stmt1 = con1.createStatement();
rs1 =
stmt1.executeQuery(
"SELECT clubname, fullname FROM v5.clubs WHERE inactive=0 ORDER BY clubname");
while (rs1.next()) {
club = rs1.getString(1); // get a club name
fullname = rs1.getString(2); // get club's full name
if (!club.startsWith("demo")) { // if NOT a demo site
con2 = Connect.getCon(club); // get a connection to this club's db
stmt2 = con2.createStatement(); // create a statement
try {
rs2 = stmt2.executeQuery("SELECT custom_styles FROM club5");
if (rs2.next()) {
styles = rs2.getString("custom_styles"); // get the custom styles name, if any
if (!styles.equals("")) {
out.println(
"<tr><td>"
+ club
+ "</td><td>"
+ fullname
+ "</td><td>"
+ styles
+ "</td></tr>");
}
}
} catch (Exception exc) {
out.println(club + " failed!!!!!!!!!!!!!!!!!!!! " + exc.toString());
}
stmt2.close();
con2.close();
}
} // end if WHILE clubs
out.println("</table>");
} catch (Exception exc) {
// Error connecting to db....
out.println("<BR><BR>Unable to connect to the DB.");
out.println("<BR>Exception: " + exc.getMessage());
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
return;
}
try {
stmt1.close();
con1.close();
} catch (Exception ignore) {
}
out.println("<BR><BR> <A HREF=\"/v5/servlet/Support_main\">Return</A>.");
out.println("</BODY></HTML>");
out.close();
}