Open justasabc opened 6 years ago
I used the Google Translator because I was sick of English. Thank you for using our products.
Sorry. As we use eclipse as our development environment Intellij IDEA has not yet verified. Let's install and verify Intellij IDEA.
Do you use intellij 2018.1? I've heard from other developers that lombok does not work well. Other developers say that they have deleted and reinstalled the plugin. This is not accurate information.
If you are using a master branch Please update the source to the latest source.
I will reply you within a short time.
When I installed the intellij, the same phenomenon occurred I deleted the Lombok plugin, reloaded it after installation and it worked fine. Please confirm.
I will close this issue because I do not have any further questions.
Thanks @cheonjeongdae. After I install lombok
plugin with Intellij IDEA 2018.1
, all the errors are missing. And now I can start /mago3D-admin/src/main/java/com/gaia3d/mago3DAdminApplication.java
successfully. But when i access http://localhost:9090/login/login.do
, chrome give me HTTP ERROR 404
.
and mago3DAdminApplication.java
console outputs:
2018-04-08 10:25:19.050 INFO com.gaia3d.filter.XSSFilter[doFilter:34] - >>> XSSFilter
2018-04-08 10:25:19.051 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-08 10:25:19.052 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e779884]
2018-04-08 10:25:19.052 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@1143693085 wrapping org.postgresql.jdbc.PgConnection@440b83a8] will be managed by Spring
2018-04-08 10:25:19.052 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Preparing: SELECT NEXTVAL('access_log_seq')
2018-04-08 10:25:19.053 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Parameters:
2018-04-08 10:25:19.054 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - <== Total: 1
2018-04-08 10:25:19.054 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Preparing: /* insertAccessLog */ INSERT INTO access_log( access_log_id, user_id, user_name, client_ip, request_uri, parameters, user_agent, referer ) values( ?, ?, ?, ?, ?, ?, ?, ? )
2018-04-08 10:25:19.055 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Parameters: 17(Long), guest(String), guest(String), 0:0:0:0:0:0:0:1(String), /login/login.do(String), null, Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36(String), null
2018-04-08 10:25:19.056 DEBUG c.g.p.A.insertAccessLog[debug:159] - <== Updates: 0
2018-04-08 10:25:19.056 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e779884]
2018-04-08 10:25:19.057 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e779884]
2018-04-08 10:25:19.057 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e779884]
2018-04-08 10:25:19.057 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e779884]
2018-04-08 10:25:19.058 INFO c.gaia3d.controller.LoginController[login:74] - @@ policy = Policy(server_ip=null, policy_id=1, user_id_min_length=5, user_fail_login_count=3, user_fail_lock_release=30, user_last_login_lock=90, user_duplication_login_yn=N, user_login_type=0, user_update_check=0, user_delete_check=0, user_delete_type=0, password_change_term=30, password_min_length=8, password_max_length=32, password_eng_upper_count=1, password_eng_lower_count=1, password_number_count=1, password_special_char_count=1, password_continuous_char_count=3, password_create_type=0, password_create_char=!@#, password_exception_char=<>&'", geo_view_library=cesium, geo_data_path=/data, geo_data_default_projects=null, geo_data_default_projects_view=null, geo_data_change_request_decision=1, geo_cull_face_enable=false, geo_time_line_enable=false, geo_init_camera_enable=true, geo_init_latitude=37.58199267183209, geo_init_longitude=126.60856869381428, geo_init_height=550, geo_init_duration=5, geo_init_default_terrain=null, geo_init_default_fov=0, geo_lod0=15, geo_lod1=60, geo_lod2=90, geo_lod3=200, geo_lod4=1000, geo_lod5=50000, geo_ambient_reflection_coef=0.5, geo_diffuse_reflection_coef=1.0, geo_specular_reflection_coef=1.0, geo_ambient_color=#d8d8d8, geo_ambient_colorR=null, geo_ambient_colorG=null, geo_ambient_colorB=null, geo_specular_color=#d8d8d8, geo_specular_colorR=null, geo_specular_colorG=null, geo_specular_colorB=null, geo_ssao_radius=0.15, geo_server_enable=false, geo_server_url=http://localhost:8081/geoserver/gaia3d/wms, geo_server_layers=gaia3d:backgroundForSHI, geo_server_parameters_service=WMS, geo_server_parameters_version=1.1.1, geo_server_parameters_request=GetMap, geo_server_parameters_transparent=true, geo_server_parameters_format=image/png, geo_server_add_url=null, geo_server_add_layers=null, geo_server_add_parameters_service=null, geo_server_add_parameters_version=null, geo_server_add_parameters_request=null, geo_server_add_parameters_transparent=null, geo_server_add_parameters_format=null, geo_callback_enable=true, geo_callback_apiresult=showApiResult, geo_callback_dataInfo=null, geo_callback_moveddata=null, geo_callback_selectedobject=showSelectedObject, geo_callback_insertissue=showInsertIssueLayer, geo_callback_listissue=null, geo_callback_clickposition=showClickPosition, notice_service_yn=Y, notice_service_send_type=0, notice_approval_request_yn=N, notice_approval_sign_yn=N, notice_password_update_yn=N, notice_approval_delay_yn=N, notice_risk_yn=N, notice_risk_send_type=0, notice_risk_grade=0, security_session_timeout_yn=N, security_session_timeout=30, security_user_ip_check_yn=N, security_session_hijacking=0, security_sso=0, security_sso_token_verify_time=3, security_log_save_type=0, security_log_save_term=2, security_dynamic_block_yn=N, security_api_result_secure_yn=N, security_masking_yn=Y, content_cache_version=1, content_main_widget_count=6, content_main_widget_interval=65, content_monitoring_interval=1, content_statistics_interval=0, content_load_balancing_interval=10, content_menu_group_root=Mago3D, content_user_group_root=Mago3D, content_server_group_root=Mago3D, content_data_group_root=Mago3D, os_timezone=null, os_ntp=null, os_ntp_day=null, os_ntp_hour=null, os_ntp_minute=null, os_radius_secret=null, site_name=Mago3D, site_admin_name=null, site_admin_mobile_phone=u1Cgl3H66Gx6ruL48dZzgw==, site_admin_email=88qb9Zh2qZAaxa0MR2LXJA==, uploadfile_top_value=null, uploadfile_bottom_value=null, site_product_log=null, site_company_log=null, backoffice_email_host=null, backoffice_email_port=null, backoffice_email_user=null, backoffice_email_password=null, backoffice_user_db_driver=null, backoffice_user_db_url=null, backoffice_user_db_user=null, backoffice_user_db_password=null, solution_name=null, solution_version=null, solution_company=null, solution_company_phone=null, solution_manager=null, solution_manager_phone=null, solution_manager_email=null, insert_date=2018-03-31 16:36:35.669907)
2018-04-08 10:25:19.059 INFO c.gaia3d.controller.LoginController[login:79] - @@ SESSION_TOKEN_AES_KEY = 1364713659570767
2018-04-08 10:25:19.060 INFO c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null
2018-04-08 10:25:19.061 INFO c.g.interceptor.SecurityInterceptor[preHandle:49] - ################################### exception uri
2018-04-08 10:25:19.061 INFO c.g.controller.CustomErrorController[error:32] - @@@@@@@@@@@@@@@@@@@@@@@ CustomErrorController attrs = {timestamp=Sun Apr 08 10:25:19 CST 2018, status=404, error=Not Found, message=/WEB-INF/views//login/login.jsp, path=/login/login.do}
I have changed username
and password
in applications.properties
instead of using the default one.
Please help. Thanks again.
Sorry. The view path setting was incorrect. You have modified and committed. Please accept the latest source. Thank you.
thanks @cheonjeongdae . I have cloned your newest version and start /mago3D-admin/src/main/java/com/gaia3d/mago3DAdminApplication.java
successfully. But when i access http://localhost:9090/login/login.do, the same error occurs.
chrome give me HTTP ERROR 404
and mago3DAdminApplication.java
console outputs:
2018-04-08 16:51:35.120 INFO com.gaia3d.filter.XSSFilter[doFilter:34] - >>> XSSFilter
2018-04-08 16:51:35.121 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-08 16:51:35.121 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@91f92ec]
2018-04-08 16:51:35.121 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@1210226903 wrapping org.postgresql.jdbc.PgConnection@29d798fb] will be managed by Spring
2018-04-08 16:51:35.122 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Preparing: SELECT NEXTVAL('access_log_seq')
2018-04-08 16:51:35.122 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Parameters:
2018-04-08 16:51:35.122 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - <== Total: 1
2018-04-08 16:51:35.123 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Preparing: /* insertAccessLog */ INSERT INTO access_log( access_log_id, user_id, user_name, client_ip, request_uri, parameters, user_agent, referer ) values( ?, ?, ?, ?, ?, ?, ?, ? )
2018-04-08 16:51:35.123 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Parameters: 29(Long), guest(String), guest(String), 0:0:0:0:0:0:0:1(String), /login/login.do(String), null, Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36(String), null
2018-04-08 16:51:35.124 DEBUG c.g.p.A.insertAccessLog[debug:159] - <== Updates: 0
2018-04-08 16:51:35.124 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@91f92ec]
2018-04-08 16:51:35.124 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@91f92ec]
2018-04-08 16:51:35.124 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@91f92ec]
2018-04-08 16:51:35.124 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@91f92ec]
2018-04-08 16:51:35.128 INFO c.gaia3d.controller.LoginController[login:74] - @@ policy = Policy(server_ip=null, policy_id=1, user_id_min_length=5, user_fail_login_count=3, user_fail_lock_release=30, user_last_login_lock=90, user_duplication_login_yn=N, user_login_type=0, user_update_check=0, user_delete_check=0, user_delete_type=0, password_change_term=30, password_min_length=8, password_max_length=32, password_eng_upper_count=1, password_eng_lower_count=1, password_number_count=1, password_special_char_count=1, password_continuous_char_count=3, password_create_type=0, password_create_char=!@#, password_exception_char=<>&'", geo_view_library=cesium, geo_data_path=/data, geo_data_default_projects=null, geo_data_default_projects_view=null, geo_data_change_request_decision=1, geo_cull_face_enable=false, geo_time_line_enable=false, geo_init_camera_enable=true, geo_init_latitude=37.58199267183209, geo_init_longitude=126.60856869381428, geo_init_height=550, geo_init_duration=5, geo_init_default_terrain=null, geo_init_default_fov=0, geo_lod0=15, geo_lod1=60, geo_lod2=90, geo_lod3=200, geo_lod4=1000, geo_lod5=50000, geo_ambient_reflection_coef=0.5, geo_diffuse_reflection_coef=1.0, geo_specular_reflection_coef=1.0, geo_ambient_color=#d8d8d8, geo_ambient_colorR=null, geo_ambient_colorG=null, geo_ambient_colorB=null, geo_specular_color=#d8d8d8, geo_specular_colorR=null, geo_specular_colorG=null, geo_specular_colorB=null, geo_ssao_radius=0.15, geo_server_enable=false, geo_server_url=http://localhost:8081/geoserver/gaia3d/wms, geo_server_layers=gaia3d:backgroundForSHI, geo_server_parameters_service=WMS, geo_server_parameters_version=1.1.1, geo_server_parameters_request=GetMap, geo_server_parameters_transparent=true, geo_server_parameters_format=image/png, geo_server_add_url=null, geo_server_add_layers=null, geo_server_add_parameters_service=null, geo_server_add_parameters_version=null, geo_server_add_parameters_request=null, geo_server_add_parameters_transparent=null, geo_server_add_parameters_format=null, geo_callback_enable=true, geo_callback_apiresult=showApiResult, geo_callback_dataInfo=null, geo_callback_moveddata=null, geo_callback_selectedobject=showSelectedObject, geo_callback_insertissue=showInsertIssueLayer, geo_callback_listissue=null, geo_callback_clickposition=showClickPosition, notice_service_yn=Y, notice_service_send_type=0, notice_approval_request_yn=N, notice_approval_sign_yn=N, notice_password_update_yn=N, notice_approval_delay_yn=N, notice_risk_yn=N, notice_risk_send_type=0, notice_risk_grade=0, security_session_timeout_yn=N, security_session_timeout=30, security_user_ip_check_yn=N, security_session_hijacking=0, security_sso=0, security_sso_token_verify_time=3, security_log_save_type=0, security_log_save_term=2, security_dynamic_block_yn=N, security_api_result_secure_yn=N, security_masking_yn=Y, content_cache_version=1, content_main_widget_count=6, content_main_widget_interval=65, content_monitoring_interval=1, content_statistics_interval=0, content_load_balancing_interval=10, content_menu_group_root=Mago3D, content_user_group_root=Mago3D, content_server_group_root=Mago3D, content_data_group_root=Mago3D, os_timezone=null, os_ntp=null, os_ntp_day=null, os_ntp_hour=null, os_ntp_minute=null, os_radius_secret=null, site_name=Mago3D, site_admin_name=null, site_admin_mobile_phone=u1Cgl3H66Gx6ruL48dZzgw==, site_admin_email=88qb9Zh2qZAaxa0MR2LXJA==, uploadfile_top_value=null, uploadfile_bottom_value=null, site_product_log=null, site_company_log=null, backoffice_email_host=null, backoffice_email_port=null, backoffice_email_user=null, backoffice_email_password=null, backoffice_user_db_driver=null, backoffice_user_db_url=null, backoffice_user_db_user=null, backoffice_user_db_password=null, solution_name=null, solution_version=null, solution_company=null, solution_company_phone=null, solution_manager=null, solution_manager_phone=null, solution_manager_email=null, insert_date=2018-03-31 16:36:35.669907)
2018-04-08 16:51:35.129 INFO c.gaia3d.controller.LoginController[login:79] - @@ SESSION_TOKEN_AES_KEY = 1387893811623466
2018-04-08 16:51:35.131 INFO c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null
2018-04-08 16:51:35.131 INFO c.g.interceptor.SecurityInterceptor[preHandle:49] - ################################### exception uri
2018-04-08 16:51:35.131 INFO c.g.controller.CustomErrorController[error:32] - @@@@@@@@@@@@@@@@@@@@@@@ CustomErrorController attrs = {timestamp=Sun Apr 08 16:51:35 CST 2018, status=404, error=Not Found, message=/WEB-INF/views/login/login.jsp, path=/login/login.do}
Do I have to put /WEB-INF/views/
folder some proper place so that java program can find /WEB-INF/views/login/login.jsp
file?
thanks for your reply.
That file can also be checked in github. https://github.com/Gaia3D/mago3d/blob/develop/mago3d-admin/src/main/webapp/WEB-INF/views/login/login.jsp
We are using springboot, gradle. No special settings are required.
Excuse me Tell me about your local environment. Please also capture directory .... /WEB-INF/views/
Yes, I clone your repository to C:/git/repository/mago3d/
and install all the necessary softwares.
I create mago3d
database and run dbinit.bat
to import data into database.
And start mago3DAdminApplication.java
successfully with Intellij IDEA 2018.1
. I do not change anything yet. But i just can not access http://localhost:9090/login/login.do
(1) web-inf/views
(2) admin started successfully.
(3) access failed
(4) console output
2018-04-08 20:40:25.722 INFO o.a.c.c.C.[Tomcat].[localhost].[/][log:180] - Initializing Spring FrameworkServlet 'dispatcherServlet'
2018-04-08 20:40:25.754 INFO com.gaia3d.filter.XSSFilter[doFilter:34] - >>> XSSFilter
2018-04-08 20:40:25.778 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-08 20:40:25.778 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e]
2018-04-08 20:40:25.779 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@640414143 wrapping org.postgresql.jdbc.PgConnection@43200a37] will be managed by Spring
2018-04-08 20:40:25.779 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Preparing: SELECT NEXTVAL('access_log_seq')
2018-04-08 20:40:25.779 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Parameters:
2018-04-08 20:40:25.781 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - <== Total: 1
2018-04-08 20:40:25.782 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Preparing: /* insertAccessLog */ INSERT INTO access_log( access_log_id, user_id, user_name, client_ip, request_uri, parameters, user_agent, referer ) values( ?, ?, ?, ?, ?, ?, ?, ? )
2018-04-08 20:40:25.782 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Parameters: 16(Long), guest(String), guest(String), 0:0:0:0:0:0:0:1(String), /login/login.do(String), null, Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36(String), null
2018-04-08 20:40:25.787 DEBUG c.g.p.A.insertAccessLog[debug:159] - <== Updates: 0
2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e]
2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e]
2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e]
2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e]
2018-04-08 20:40:25.807 INFO c.gaia3d.controller.LoginController[login:74] - @@ policy = Policy(server_ip=null, policy_id=1, user_id_min_length=5, user_fail_login_count=3, user_fail_lock_release=30, user_last_login_lock=90, user_duplication_login_yn=N, user_login_type=0, user_update_check=0, user_delete_check=0, user_delete_type=0, password_change_term=30, password_min_length=8, password_max_length=32, password_eng_upper_count=1, password_eng_lower_count=1, password_number_count=1, password_special_char_count=1, password_continuous_char_count=3, password_create_type=0, password_create_char=!@#, password_exception_char=<>&'", geo_view_library=cesium, geo_data_path=/f4d, geo_data_default_projects=null, geo_data_default_projects_view=null, geo_data_change_request_decision=1, geo_cull_face_enable=false, geo_time_line_enable=false, geo_init_camera_enable=true, geo_init_latitude=37.58199267183209, geo_init_longitude=126.60856869381428, geo_init_height=550, geo_init_duration=5, geo_init_default_terrain=null, geo_init_default_fov=0, geo_lod0=15, geo_lod1=60, geo_lod2=90, geo_lod3=200, geo_lod4=1000, geo_lod5=50000, geo_ambient_reflection_coef=0.5, geo_diffuse_reflection_coef=1.0, geo_specular_reflection_coef=1.0, geo_ambient_color=#d8d8d8, geo_ambient_colorR=null, geo_ambient_colorG=null, geo_ambient_colorB=null, geo_specular_color=#d8d8d8, geo_specular_colorR=null, geo_specular_colorG=null, geo_specular_colorB=null, geo_ssao_radius=0.15, geo_server_enable=false, geo_server_url=http://localhost:8081/geoserver/gaia3d/wms, geo_server_layers=gaia3d:backgroundForSHI, geo_server_parameters_service=WMS, geo_server_parameters_version=1.1.1, geo_server_parameters_request=GetMap, geo_server_parameters_transparent=true, geo_server_parameters_format=image/png, geo_server_add_url=null, geo_server_add_layers=null, geo_server_add_parameters_service=null, geo_server_add_parameters_version=null, geo_server_add_parameters_request=null, geo_server_add_parameters_transparent=null, geo_server_add_parameters_format=null, geo_callback_enable=true, geo_callback_apiresult=showApiResult, geo_callback_dataInfo=null, geo_callback_moveddata=null, geo_callback_selectedobject=showSelectedObject, geo_callback_insertissue=showInsertIssueLayer, geo_callback_listissue=null, geo_callback_clickposition=showClickPosition, notice_service_yn=Y, notice_service_send_type=0, notice_approval_request_yn=N, notice_approval_sign_yn=N, notice_password_update_yn=N, notice_approval_delay_yn=N, notice_risk_yn=N, notice_risk_send_type=0, notice_risk_grade=0, security_session_timeout_yn=N, security_session_timeout=30, security_user_ip_check_yn=N, security_session_hijacking=0, security_sso=0, security_sso_token_verify_time=3, security_log_save_type=0, security_log_save_term=2, security_dynamic_block_yn=N, security_api_result_secure_yn=N, security_masking_yn=Y, content_cache_version=1, content_main_widget_count=6, content_main_widget_interval=65, content_monitoring_interval=1, content_statistics_interval=0, content_load_balancing_interval=10, content_menu_group_root=Mago3D, content_user_group_root=Mago3D, content_server_group_root=Mago3D, content_data_group_root=Mago3D, os_timezone=null, os_ntp=null, os_ntp_day=null, os_ntp_hour=null, os_ntp_minute=null, os_radius_secret=null, site_name=Mago3D, site_admin_name=null, site_admin_mobile_phone=u1Cgl3H66Gx6ruL48dZzgw==, site_admin_email=88qb9Zh2qZAaxa0MR2LXJA==, uploadfile_top_value=null, uploadfile_bottom_value=null, site_product_log=null, site_company_log=null, backoffice_email_host=null, backoffice_email_port=null, backoffice_email_user=null, backoffice_email_password=null, backoffice_user_db_driver=null, backoffice_user_db_url=null, backoffice_user_db_user=null, backoffice_user_db_password=null, solution_name=null, solution_version=null, solution_company=null, solution_company_phone=null, solution_manager=null, solution_manager_phone=null, solution_manager_email=null, insert_date=2018-04-08 18:02:24.200139+08)
2018-04-08 20:40:25.808 INFO c.gaia3d.controller.LoginController[login:79] - @@ SESSION_TOKEN_AES_KEY = 1401624496769739
2018-04-08 20:40:25.826 INFO c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null
2018-04-08 20:40:25.827 INFO c.g.interceptor.SecurityInterceptor[preHandle:49] - ################################### exception uri
2018-04-08 20:40:25.828 INFO c.g.controller.CustomErrorController[error:32] - @@@@@@@@@@@@@@@@@@@@@@@ CustomErrorController attrs = {timestamp=Sun Apr 08 20:40:25 CST 2018, status=404, error=Not Found, message=/WEB-INF/views/login/login.jsp, path=/login/login.do}
The following line
c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null
may be the reason?
So i dive into the code.
The request URI becomes /error
and it seems something goes wrong?
==================================================================
But when i started mago3DAdminApplication.java
with Eclipse
, I can access http://localhost:9090/login/login.do
The problem may be that I use Intellij IDEA 2018.1
and it conflict with program?
So
(1) Would you please test your code with Intellij IDEA 2018.1
and see if you can access http://localhost:9090/login/login.do
successfully?
(2) What the admin username and password for http://localhost:9090/login/login.do
login page?
Thanks very much.
I was wrong. You are right. There seems to be a bug related to ViewResolver. I'm looking for the cause, but I'm not sure.
The password is admin, admin Please refer to the following file. /mago3d-admin/src/test/java/com/gaia3d/PasswordTest.java
thanks @cheonjeongdae . But I use admin
as username and admin
as password to login, it says that Passwords do not match
. I view magoed
database and see Pssword
as password? I tried Pssword
as password, error also occurs.
2018-04-10 15:40:52.967 INFO com.gaia3d.filter.XSSFilter[doFilter:34] - >>> XSSFilter
2018-04-10 15:40:52.969 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-10 15:40:52.970 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@26111044]
2018-04-10 15:40:52.970 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@1270381305 wrapping org.postgresql.jdbc.PgConnection@340a3bb7] will be managed by Spring
2018-04-10 15:40:52.970 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Preparing: SELECT NEXTVAL('access_log_seq')
2018-04-10 15:40:52.971 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Parameters:
2018-04-10 15:40:52.973 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - <== Total: 1
2018-04-10 15:40:52.973 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Preparing: /* insertAccessLog */ INSERT INTO access_log( access_log_id, user_id, user_name, client_ip, request_uri, parameters, user_agent, referer ) values( ?, ?, ?, ?, ?, ?, ?, ? )
2018-04-10 15:40:52.974 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Parameters: 6(Long), guest(String), guest(String), 0:0:0:0:0:0:0:1(String), /login/process-login.do(String), &user_id=admin&CSRFToken=35634d9d-f0ff-465d-844f-cb2e86427cd2(String), Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36(String), http://localhost:9090/login/process-login.do(String)
2018-04-10 15:40:52.975 DEBUG c.g.p.A.insertAccessLog[debug:159] - <== Updates: 0
2018-04-10 15:40:52.975 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@26111044]
2018-04-10 15:40:52.975 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@26111044]
2018-04-10 15:40:52.975 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@26111044]
2018-04-10 15:40:52.975 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@26111044]
2018-04-10 15:40:52.977 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-10 15:40:52.978 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@571208c2]
2018-04-10 15:40:52.978 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@1377379642 wrapping org.postgresql.jdbc.PgConnection@340a3bb7] will be managed by Spring
2018-04-10 15:40:52.979 DEBUG c.g.p.LoginMapper.getUserSession[debug:159] - ==> Preparing: /* getUserSession */ SELECT A.*, B.group_name AS user_group_name, CASE WHEN A.last_password_change_date < (NOW() - INTERVAL '30 DAY') THEN true ELSE false END AS password_change_term_over, CASE WHEN A.last_login_date IS NULL THEN A.insert_date < (NOW() - INTERVAL '90 DAY') ELSE A.last_login_date < (NOW() - INTERVAL '90 DAY') END AS user_last_login_lock_over FROM user_info A LEFT OUTER JOIN user_group B ON A.user_group_id = B.user_group_id WHERE A.user_id = ?
2018-04-10 15:40:52.979 DEBUG c.g.p.LoginMapper.getUserSession[debug:159] - ==> Parameters: admin(String)
2018-04-10 15:40:52.981 DEBUG c.g.p.LoginMapper.getUserSession[debug:159] - <== Total: 1
2018-04-10 15:40:52.981 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@571208c2]
2018-04-10 15:40:52.981 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@571208c2]
2018-04-10 15:40:52.981 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@571208c2]
2018-04-10 15:40:52.981 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@571208c2]
2018-04-10 15:40:52.982 INFO c.gaia3d.controller.LoginController[processLogin:130] - @@ userSession = UserSession(error_code=null, login_ip=null, user_group_name=SUPER_ADMIN, user_id=admin, user_group_id=1, user_name=SUPER_ADMIN, password=Pssword, salt=salt, telephone=null, mobile_phone=null, email=null, messanger=null, employee_id=null, dept_name=null, position=null, postal_code=null, address=null, address_etc=null, ci=null, di=null, login_count=0, fail_login_count=2, last_login_date=2018-04-10 15:38:24.676764+08, update_date=2018-04-10 15:39:55.956471+08, user_role_check_yn=N, status=0, insert_date=2018-04-10 15:38:24.676764+08, password_change_term=null, password_change_term_over=false, user_last_login_lock=null, user_last_login_lock_over=false)
2018-04-10 15:40:52.983 INFO c.gaia3d.controller.LoginController[validateUserInfo:218] - @@ dbpassword = Pssword, encryptPassword = 4e4696fa7a2c4b3c04569df42de62b1af170a6da8309f939ab66fdc2977e8f918112f4eed1ed358fa95489ba4a96376c68f462a5bceae16b0b2c7747ea6daf54
2018-04-10 15:40:52.983 ERROR c.gaia3d.controller.LoginController[processLogin:140] - @@ 牍勲皜氩堩樃 鞁ろ尐 須熿垬 齑堦臣鞐? 鞚橅暣 鞛犼箑 觳橂Μ霅?
2018-04-10 15:40:52.984 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession
2018-04-10 15:40:52.984 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@208a89f5]
2018-04-10 15:40:52.984 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@421330960 wrapping org.postgresql.jdbc.PgConnection@340a3bb7] will be managed by Spring
2018-04-10 15:40:52.984 DEBUG c.g.p.U.updateUserFailLoginCount[debug:159] - ==> Preparing: /* updateUserFailLoginCount */ UPDATE user_info SET status = ?, fail_login_count = ?, update_date = NOW() WHERE user_id = ?
2018-04-10 15:40:52.985 DEBUG c.g.p.U.updateUserFailLoginCount[debug:159] - ==> Parameters: 2(String), 3(Integer), admin(String)
2018-04-10 15:40:52.985 DEBUG c.g.p.U.updateUserFailLoginCount[debug:159] - <== Updates: 1
2018-04-10 15:40:52.986 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@208a89f5]
2018-04-10 15:40:52.986 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@208a89f5]
2018-04-10 15:40:52.986 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@208a89f5]
2018-04-10 15:40:52.986 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@208a89f5]
2018-04-10 15:40:52.986 ERROR c.gaia3d.controller.LoginController[processLogin:156] - @@ errorCode = usersession.password.invalid
Using /mago3d-admin/src/test/java/com/gaia3d/PasswordTest.java Make your password, salt. Then update the user_info table. update user_info set password = 'xxxx', salt = 'xxxx' where user_id = 'admin'; commit;
update user_info set status = '0', fail_login_count = 0 where user_id = 'admin'; commit;
Run gradle bootRun and look for jsp. However, this is not the right way. I guess I'll have to find another way.
Yes, I clone your repository to
C:/git/repository/mago3d/
and install all the necessary softwares.I create
mago3d
database and rundbinit.bat
to import data into database.And start
mago3DAdminApplication.java
successfully withIntellij IDEA 2018.1
. I do not change anything yet. But i just can not accesshttp://localhost:9090/login/login.do
(1) web-inf/views
(2) admin started successfully.
(3) access failed
(4) console output
2018-04-08 20:40:25.722 INFO o.a.c.c.C.[Tomcat].[localhost].[/][log:180] - Initializing Spring FrameworkServlet 'dispatcherServlet' 2018-04-08 20:40:25.754 INFO com.gaia3d.filter.XSSFilter[doFilter:34] - >>> XSSFilter 2018-04-08 20:40:25.778 DEBUG org.mybatis.spring.SqlSessionUtils[getSqlSession:97] - Creating a new SqlSession 2018-04-08 20:40:25.778 DEBUG org.mybatis.spring.SqlSessionUtils[registerSessionHolder:128] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e] 2018-04-08 20:40:25.779 DEBUG o.m.s.t.SpringManagedTransaction[openConnection:87] - JDBC Connection [HikariProxyConnection@640414143 wrapping org.postgresql.jdbc.PgConnection@43200a37] will be managed by Spring 2018-04-08 20:40:25.779 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Preparing: SELECT NEXTVAL('access_log_seq') 2018-04-08 20:40:25.779 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - ==> Parameters: 2018-04-08 20:40:25.781 DEBUG c.g.p.A.insertAccessLog!selectKey[debug:159] - <== Total: 1 2018-04-08 20:40:25.782 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Preparing: /* insertAccessLog */ INSERT INTO access_log( access_log_id, user_id, user_name, client_ip, request_uri, parameters, user_agent, referer ) values( ?, ?, ?, ?, ?, ?, ?, ? ) 2018-04-08 20:40:25.782 DEBUG c.g.p.A.insertAccessLog[debug:159] - ==> Parameters: 16(Long), guest(String), guest(String), 0:0:0:0:0:0:0:1(String), /login/login.do(String), null, Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36(String), null 2018-04-08 20:40:25.787 DEBUG c.g.p.A.insertAccessLog[debug:159] - <== Updates: 0 2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[closeSqlSession:186] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e] 2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCommit:284] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e] 2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:310] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e] 2018-04-08 20:40:25.787 DEBUG org.mybatis.spring.SqlSessionUtils[beforeCompletion:315] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4dc536e] 2018-04-08 20:40:25.807 INFO c.gaia3d.controller.LoginController[login:74] - @@ policy = Policy(server_ip=null, policy_id=1, user_id_min_length=5, user_fail_login_count=3, user_fail_lock_release=30, user_last_login_lock=90, user_duplication_login_yn=N, user_login_type=0, user_update_check=0, user_delete_check=0, user_delete_type=0, password_change_term=30, password_min_length=8, password_max_length=32, password_eng_upper_count=1, password_eng_lower_count=1, password_number_count=1, password_special_char_count=1, password_continuous_char_count=3, password_create_type=0, password_create_char=!@#, password_exception_char=<>&'", geo_view_library=cesium, geo_data_path=/f4d, geo_data_default_projects=null, geo_data_default_projects_view=null, geo_data_change_request_decision=1, geo_cull_face_enable=false, geo_time_line_enable=false, geo_init_camera_enable=true, geo_init_latitude=37.58199267183209, geo_init_longitude=126.60856869381428, geo_init_height=550, geo_init_duration=5, geo_init_default_terrain=null, geo_init_default_fov=0, geo_lod0=15, geo_lod1=60, geo_lod2=90, geo_lod3=200, geo_lod4=1000, geo_lod5=50000, geo_ambient_reflection_coef=0.5, geo_diffuse_reflection_coef=1.0, geo_specular_reflection_coef=1.0, geo_ambient_color=#d8d8d8, geo_ambient_colorR=null, geo_ambient_colorG=null, geo_ambient_colorB=null, geo_specular_color=#d8d8d8, geo_specular_colorR=null, geo_specular_colorG=null, geo_specular_colorB=null, geo_ssao_radius=0.15, geo_server_enable=false, geo_server_url=http://localhost:8081/geoserver/gaia3d/wms, geo_server_layers=gaia3d:backgroundForSHI, geo_server_parameters_service=WMS, geo_server_parameters_version=1.1.1, geo_server_parameters_request=GetMap, geo_server_parameters_transparent=true, geo_server_parameters_format=image/png, geo_server_add_url=null, geo_server_add_layers=null, geo_server_add_parameters_service=null, geo_server_add_parameters_version=null, geo_server_add_parameters_request=null, geo_server_add_parameters_transparent=null, geo_server_add_parameters_format=null, geo_callback_enable=true, geo_callback_apiresult=showApiResult, geo_callback_dataInfo=null, geo_callback_moveddata=null, geo_callback_selectedobject=showSelectedObject, geo_callback_insertissue=showInsertIssueLayer, geo_callback_listissue=null, geo_callback_clickposition=showClickPosition, notice_service_yn=Y, notice_service_send_type=0, notice_approval_request_yn=N, notice_approval_sign_yn=N, notice_password_update_yn=N, notice_approval_delay_yn=N, notice_risk_yn=N, notice_risk_send_type=0, notice_risk_grade=0, security_session_timeout_yn=N, security_session_timeout=30, security_user_ip_check_yn=N, security_session_hijacking=0, security_sso=0, security_sso_token_verify_time=3, security_log_save_type=0, security_log_save_term=2, security_dynamic_block_yn=N, security_api_result_secure_yn=N, security_masking_yn=Y, content_cache_version=1, content_main_widget_count=6, content_main_widget_interval=65, content_monitoring_interval=1, content_statistics_interval=0, content_load_balancing_interval=10, content_menu_group_root=Mago3D, content_user_group_root=Mago3D, content_server_group_root=Mago3D, content_data_group_root=Mago3D, os_timezone=null, os_ntp=null, os_ntp_day=null, os_ntp_hour=null, os_ntp_minute=null, os_radius_secret=null, site_name=Mago3D, site_admin_name=null, site_admin_mobile_phone=u1Cgl3H66Gx6ruL48dZzgw==, site_admin_email=88qb9Zh2qZAaxa0MR2LXJA==, uploadfile_top_value=null, uploadfile_bottom_value=null, site_product_log=null, site_company_log=null, backoffice_email_host=null, backoffice_email_port=null, backoffice_email_user=null, backoffice_email_password=null, backoffice_user_db_driver=null, backoffice_user_db_url=null, backoffice_user_db_user=null, backoffice_user_db_password=null, solution_name=null, solution_version=null, solution_company=null, solution_company_phone=null, solution_manager=null, solution_manager_phone=null, solution_manager_email=null, insert_date=2018-04-08 18:02:24.200139+08) 2018-04-08 20:40:25.808 INFO c.gaia3d.controller.LoginController[login:79] - @@ SESSION_TOKEN_AES_KEY = 1401624496769739 2018-04-08 20:40:25.826 INFO c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null 2018-04-08 20:40:25.827 INFO c.g.interceptor.SecurityInterceptor[preHandle:49] - ################################### exception uri 2018-04-08 20:40:25.828 INFO c.g.controller.CustomErrorController[error:32] - @@@@@@@@@@@@@@@@@@@@@@@ CustomErrorController attrs = {timestamp=Sun Apr 08 20:40:25 CST 2018, status=404, error=Not Found, message=/WEB-INF/views/login/login.jsp, path=/login/login.do}
The following line
c.g.interceptor.SecurityInterceptor[preHandle:36] - ## Requst URI = /error, Method = GET, Request Ip = 0:0:0:0:0:0:0:1, referer=null
may be the reason?So i dive into the code. The request URI becomes
/error
and it seems something goes wrong?================================================================== But when i started
mago3DAdminApplication.java
withEclipse
, I can accesshttp://localhost:9090/login/login.do
The problem may be that I use
Intellij IDEA 2018.1
and it conflict with program? So (1) Would you please test your code withIntellij IDEA 2018.1
and see if you can accesshttp://localhost:9090/login/login.do
successfully? (2) What the admin username and password forhttp://localhost:9090/login/login.do
login page? Thanks very much.
I hava the same problem, do you solve it?
I follow the steps and install all the necessary softwares and create databases. and then clone
mago3d
repository and import into Intellij IDEA. when i runMago3dAdminApplication.java
, a lot of errors occur:it says that a lot of methods are missing.
lots of similar errors also occur in other files.
I can not find the reasons. Please help, thanks very much.