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 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;
  }