// This method returns the destination list for a message
private Vector<SocketInfo> getDestinationList(Element element, boolean senderIsMailUser) {
Vector<SocketInfo> usersVector = new Vector<SocketInfo>();
String target = element.getChildText("toName");
// If sender is a POS user
if (!senderIsMailUser) {
usersVector = SocketServer.getAllClients(groupID);
}
// If sender is a POP user
else {
// If destination is one user
if (target != null) {
SocketInfo destination = getUserData(target, false);
if (destination != null) {
usersVector.add(destination);
return usersVector;
}
}
// If destination is a group
usersVector = SocketServer.getAllClients(target);
}
return usersVector;
}
private SocketInfo getUserData(String login, boolean senderIsMailUser) {
SocketInfo user = null;
QueryRunner qRunner = null;
ResultSet resultSet = null;
if (!senderIsMailUser) {
// Check is POS user is online
user = SocketServer.getSocketInfo(login);
if (user != null) {
return user;
}
}
// If user is POP or if is a POS user offline
int i = 0;
try {
if (senderIsMailUser) {
qRunner = new QueryRunner("SEL0036", new String[] {login});
} else {
qRunner = new QueryRunner("SEL0026", new String[] {login});
}
resultSet = qRunner.select();
if (resultSet.next()) {
i++;
user = SocketServer.getInstaceOfSocketInfo();
user.setUid(resultSet.getInt(1));
user.setLogin(resultSet.getString(2));
user.setNames(resultSet.getString(3));
user.setEmail(resultSet.getString(4));
user.setAdmin(resultSet.getBoolean(5));
user.setAudit(resultSet.getBoolean(6));
user.setGroupID(resultSet.getInt(7));
user.setWsName(resultSet.getString(9));
user.setGroupName(resultSet.getString(12));
}
} catch (SQLNotFoundException e) {
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
e.printStackTrace();
} catch (SQLException e) {
LogWriter.write("ERROR: Falla mientras se consultaba la informacion del usuario: " + login);
e.printStackTrace();
} finally {
QueryClosingHandler.close(resultSet);
qRunner.closeStatement();
}
return user;
}
// This method returns the sender data structure
private SocketInfo getSenderInfo(boolean senderIsMailUser) {
SocketInfo sender = null;
// Sender is a POS user
if (!senderIsMailUser) {
// Querying the info of the sender (a pos user)
sender = SocketServer.getSocketInfo(from);
// If sender doesn't exist, this operation is aborted
if (sender == null) {
String msg = "ERROR: El Colocador {" + from + "} no esta registrado en el sistema.";
LogWriter.write(msg);
sendAlarm("Error procesando mensaje de colocador", msg);
return null;
}
}
// Sender is a POP user
else {
// Querying users from the pop server (admin user)
sender = getUserData(from, senderIsMailUser);
if (LOTTERY_MODE) {
if (sender == null) {
sender = insertPopUser(from);
if (sender == null) {
return null;
}
}
}
}
return sender;
}
// This method insert a pop user into the CoMeet system
private SocketInfo insertPopUser(String login) {
SocketInfo socketInfo = null;
String line = "";
String names = "";
boolean userExists = false;
try {
BufferedReader in = new BufferedReader(new FileReader("/etc/passwd"));
while ((line = in.readLine()) != null) {
if (line.startsWith(login)) {
userExists = true;
String[] userData = line.split(":");
names = userData[4];
if (names.length() == 0) {
names = "Usuario de Correo";
}
int index = names.indexOf(',');
if (index > 0) {
names = names.substring(0, index);
}
break;
}
}
in.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
// If the user doesn't exist in the file /etc/passwd, do not add him to the CoMeet server
if (!userExists) {
LogWriter.write("ERROR: El usuario {" + login + "} no existe en el servidor de correo");
return null;
}
String[] userInfoArray = {
login,
"d41d8cd98f00b204e9800998ecf8427e",
names,
login + "@" + Pop3Handler.getHost(),
"true",
"false",
ServerConstants.ADMINGROUP + ""
};
QueryRunner qRunner = null;
try {
qRunner = new QueryRunner("INS0001", userInfoArray);
qRunner.setAutoCommit(false);
qRunner.executeSQL();
qRunner.commit();
LogWriter.write("INFO: Usuario {" + login + "} adicionado satisfactoriamente al sistema");
} catch (SQLNotFoundException SNFE) {
qRunner.rollback();
SNFE.printStackTrace();
} catch (SQLBadArgumentsException SBAE) {
qRunner.rollback();
SBAE.printStackTrace();
} catch (SQLException SQLE) {
qRunner.rollback();
String msg =
"ERROR: Falla mientras se ingresaba un nuevo usuario de correo\n"
+ "que no estaba registrado en el sistema.\nLogin: "******"Error adicionando usuario", msg);
SQLE.printStackTrace();
return null;
} finally {
qRunner.closeStatement();
qRunner.setAutoCommit(true);
}
ResultSet resultSet = null;
int uid = -1;
String groupName = "";
try {
qRunner = new QueryRunner("SEL0008", new String[] {login});
resultSet = qRunner.select();
int i = 0;
if (resultSet.next()) {
i++;
uid = resultSet.getInt(1);
groupName = resultSet.getString(2);
}
} catch (SQLNotFoundException e) {
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
e.printStackTrace();
} catch (SQLException e) {
LogWriter.write("ERROR: Falla mientras se consultaba la informacion del usuario: " + login);
e.printStackTrace();
return null;
} finally {
QueryClosingHandler.close(resultSet);
qRunner.closeStatement();
}
socketInfo = SocketServer.getInstaceOfSocketInfo();
socketInfo.setUid(uid);
socketInfo.setLogin(userInfoArray[0]);
socketInfo.setNames(userInfoArray[2]);
socketInfo.setEmail(userInfoArray[3]);
socketInfo.setAdmin(new Boolean(userInfoArray[4]).booleanValue());
socketInfo.setAudit(new Boolean(userInfoArray[5]).booleanValue());
socketInfo.setGroupID(Integer.parseInt(userInfoArray[6]));
socketInfo.setWsName("");
socketInfo.setGroupName(groupName);
return socketInfo;
}
// This method sends an alarm message to the CoMeet group when the system fails
public static void sendAlarm(String subject, String body) {
Vector<SocketInfo> usersVector = SocketServer.getAllClients("COMEET");
int groupSize = usersVector.size();
Date date = Calendar.getInstance().getTime();
String dateString = formatDate.format(date);
String hourString = formatHour.format(date);
for (SocketInfo destination : usersVector) {
EmailSender mail = new EmailSender();
mail.setFrom(Pop3Handler.getUser() + "@" + Pop3Handler.getHost());
mail.setSender(destination.getEmail());
mail.setSubject("[Error CoMeet]: " + subject);
mail.setDate(date);
mail.setMessage(body);
mail.setSenderFullName("Sistema CoMeet");
mail.setWorkStation("Servidor");
mail.send();
LogWriter.write(
"INFO: Enviando notificacion de alarma a {"
+ destination.getEmail()
+ "} / Asunto: ["
+ subject
+ "]");
String isValid = groupSize > 0 ? "true" : "false";
String[] argsArray = {
String.valueOf(destination.getUid()),
String.valueOf(0),
dateString,
hourString,
subject.trim(),
body.trim(),
isValid,
String.valueOf(ConfigFileHandler.getMessageLifeTimeForClients()),
"false",
"-1"
};
QueryRunner qRunner = null;
try {
LogWriter.write("INFO: Almacenando registro de alarma en la base de datos...");
qRunner = new QueryRunner("INS0003", argsArray);
qRunner.setAutoCommit(false);
qRunner.executeSQL();
qRunner.commit();
} catch (SQLNotFoundException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Instruccion SQL no encontrada");
e.printStackTrace();
} catch (SQLBadArgumentsException e) {
qRunner.rollback();
LogWriter.write(
"ERROR: No se pudo almacenar mensaje en la base de datos. Argumentos Invalidos");
e.printStackTrace();
} catch (SQLException e) {
qRunner.rollback();
LogWriter.write("ERROR: No se pudo almacenar mensaje en la base de datos. Excepcion SQL");
e.printStackTrace();
} finally {
qRunner.closeStatement();
qRunner.setAutoCommit(true);
}
}
}
