Skip to main content Skip to main menu

Support

We introduce all kinds of eGovFrame related documents, training and technical support information in this corner.
Also, we provide the contact information and the location of the eGovFrame center.

PRINT HOME SUPPORT Q&A

Q&A

Posted Question Details View This table provides TITLE, DIVISION, VIEWS, WRITER, DATE ASKED, NATIONALITY, EMAIL, EMAIL REPLY, STATUS, Question, Answer.
Title General login is not normally processed.
Division Common Components Views 2249
Writer S*****a Date Asked 2017-03-23 Nationality AR
Email Reply N STATUS Complete
Question
When using general login common component, in case of normal user login, the login process does not work properly.

Please check the problem.
Answer
Hello

"Normal" users to the login process will need to modify the query part.

When you see egovframework/spring/context-security.xml, located in /src/main/resource directory, there is "usersByUsernameQuery" query part for user authentication.

This section will be changed, according to project member management part, later.

In order to handle “normal” user login processing, changes as below


SELECT USER_ID, UNIQ_ID AS PASSWORD, 1 ENABLED, USER_NM, USER_ZIP,
USER_ADRES, USER_EMAIL, USER_SE, ORGNZT_ID, UNIQ_ID,
(select a.ORGNZT_NM from COMTNORGNZTINFO a where a.ORGNZT_ID = ORGNZT_ID) ORGNZT_NM
FROM COMVNUSERMASTER WHERE CONCAT(USER_SE, USER_ID) = ?
List