로그인 계정 문의
- 작성자 :
- 윤*희
- 작성일 :
- 2016-09-22 17:55:06
- 조회수 :
- 1,910
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
공통컴포넌트 설치 및 테이블 생성/데이터 입력 등 적용 후 로그인하면
사용자 정보가 잘못되었다고 합니다.
테이블 조회해보면 아이디가 2개 있는데요. admin, user1 이 등록되어 있는데, 암호가 무엇인가요?
[참고 로그]
==================
2016-09-22 17:43:42,847 INFO [jdbc.sqltiming] INSERT INTO LETTNLOGINLOG ( LOG_ID , CONECT_MTHD , CONECT_ID , CONECT_IP , ERROR_OCCRRNC_AT
, ERROR_CODE , CREAT_DT ) VALUES ( 'LOGIN_00000000000009' , 'I' , '' , '' , 'N' , '' , sysdate())
{executed in 1 msec}
2016-09-22 17:43:42,849 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@3011b950] for iBATIS operation
2016-09-22 17:43:42,849 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@4a86b7f8]] for iBATIS operation
2016-09-22 17:43:42,851 INFO [jdbc.sqltiming] SELECT EMPLYR_ID AS id , USER_NM AS name , PASSWORD AS password , IHIDNUM AS ihidNum , EMAIL_ADRES
AS email , 'USR' AS userSe , ORGNZT_ID AS orgnztId , ESNTL_ID AS uniqId FROM LETTNEMPLYRINFO
WHERE EMPLYR_ID = 'admin' AND PASSWORD = 'NyJb8uzcAsrFpUn83GxshiISHAnfqfWKK5KV5QZBOJo=' AND
EMPLYR_STTUS_CODE = 'P'
{executed in 1 msec}
2016-09-22 17:43:42,854 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@8b7d5c] for iBATIS operation
2016-09-22 17:43:42,854 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@4a86b7f8]] for iBATIS operation
2016-09-22 17:43:42,856 INFO [jdbc.sqltiming] SELECT A.USER_ID, A.USER_NM, A.USER_SE, B.IP_INFO, B.DPLCT_PERM_AT, IF(B.LMTT_AT IS NULL, 'N',
B.LMTT_AT) AS LMTT_AT, B.LAST_UPDUSR_ID, B.LAST_UPDT_PNTTM, IF(B.EMPLYR_ID IS NULL, 'N', 'Y')
AS REG_YN FROM COMVNUSERMASTER A LEFT OUTER JOIN LETTNLOGINPOLICY B ON A.USER_ID = B.EMPLYR_ID
WHERE 1 = 1 AND A.USER_ID = NULL
{executed in 1 msec}
2016-09-22 17:43:42,866 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
2016-09-22 17:43:42,866 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
2016-09-22 17:43:42,870 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
사용자 정보가 잘못되었다고 합니다.
테이블 조회해보면 아이디가 2개 있는데요. admin, user1 이 등록되어 있는데, 암호가 무엇인가요?
[참고 로그]
==================
2016-09-22 17:43:42,847 INFO [jdbc.sqltiming] INSERT INTO LETTNLOGINLOG ( LOG_ID , CONECT_MTHD , CONECT_ID , CONECT_IP , ERROR_OCCRRNC_AT
, ERROR_CODE , CREAT_DT ) VALUES ( 'LOGIN_00000000000009' , 'I' , '' , '' , 'N' , '' , sysdate())
{executed in 1 msec}
2016-09-22 17:43:42,849 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@3011b950] for iBATIS operation
2016-09-22 17:43:42,849 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@4a86b7f8]] for iBATIS operation
2016-09-22 17:43:42,851 INFO [jdbc.sqltiming] SELECT EMPLYR_ID AS id , USER_NM AS name , PASSWORD AS password , IHIDNUM AS ihidNum , EMAIL_ADRES
AS email , 'USR' AS userSe , ORGNZT_ID AS orgnztId , ESNTL_ID AS uniqId FROM LETTNEMPLYRINFO
WHERE EMPLYR_ID = 'admin' AND PASSWORD = 'NyJb8uzcAsrFpUn83GxshiISHAnfqfWKK5KV5QZBOJo=' AND
EMPLYR_STTUS_CODE = 'P'
{executed in 1 msec}
2016-09-22 17:43:42,854 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Opened SqlMapSession [com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl@8b7d5c] for iBATIS operation
2016-09-22 17:43:42,854 DEBUG [egovframework.rte.psl.orm.ibatis.SqlMapClientTemplate] Obtained JDBC Connection [Transaction-aware proxy for target Connection from DataSource [org.apache.commons.dbcp.BasicDataSource@4a86b7f8]] for iBATIS operation
2016-09-22 17:43:42,856 INFO [jdbc.sqltiming] SELECT A.USER_ID, A.USER_NM, A.USER_SE, B.IP_INFO, B.DPLCT_PERM_AT, IF(B.LMTT_AT IS NULL, 'N',
B.LMTT_AT) AS LMTT_AT, B.LAST_UPDUSR_ID, B.LAST_UPDT_PNTTM, IF(B.EMPLYR_ID IS NULL, 'N', 'Y')
AS REG_YN FROM COMVNUSERMASTER A LEFT OUTER JOIN LETTNLOGINPOLICY B ON A.USER_ID = B.EMPLYR_ID
WHERE 1 = 1 AND A.USER_ID = NULL
{executed in 1 msec}
2016-09-22 17:43:42,866 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
2016-09-22 17:43:42,866 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
2016-09-22 17:43:42,870 DEBUG [egovframework.rte.fdl.security.userdetails.util.EgovUserDetailsHelper] ## username is anonymousUser
A
안녕하세요.
표준프레임워크센터입니다.
공통 컴포넌트 비밀번호 : rhdxhd12(공통12)
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:com:v3:init_table
샘플 홈페이지 비밀번호 : 1
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:let:function
해당 위키를 참고하시면 되겠습니다.
감사합니다.
표준프레임워크센터입니다.
공통 컴포넌트 비밀번호 : rhdxhd12(공통12)
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:com:v3:init_table
샘플 홈페이지 비밀번호 : 1
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:let:function
해당 위키를 참고하시면 되겠습니다.
감사합니다.