gaia3d/mago3d-cms

mago3D Project

mago3d-cms's Issues

日本語　修正

Issueは問題じゃなくてIssueに。。。。。。
問題は誤解するかも

web server HTTPS configuration

https://www.youtube.com/watch?v=7LotrjTLqRA

cache

ehcache를 적용할까 하는데.... 그대로 쓰기에는 뭔가 맞지 않다.
추후 고려 하자.

http://jojoldu.tistory.com/57

Apache + Tomcat 설정값 튜닝 사례

https://tmondev.blog.me/220731906490?fbclid=IwAR2uc-T5sAngcs4cIezaaNVbi4G8zl-P0pEq8_ladJYI07h0xL8_wNKJ_jA

Nginx를 활용한 무중단 배포

http://jojoldu.tistory.com/267

Open JDK 적용

https://engineering.linecorp.com/ko/blog/line-open-jdk/?fbclid=IwAR3e5YtpkTdUD9jshFlKDb5nUupHk-LDwE_J88dQlePASC9wcPpG4xvqx4U

위치 정보 관련 colum을 varchar -> numeric 으로 변경

varchar type을 numeric으로 변경
latitude 의 경우 총 13자리, 정수3자리, 소수점 이하가 10자리.

ALTER TABLE project
ALTER COLUMN "latitude" TYPE NUMERIC(13, 10)
USING ("latitude"::NUMERIC(13,10)),
ALTER COLUMN "longitude" TYPE NUMERIC(13, 10)
USING ("longitude"::NUMERIC(13,10)),
ALTER COLUMN "height" TYPE NUMERIC(7, 3)
USING ("height"::NUMERIC(7,3));

web server authentication with database

http://www.opengee.org/geedocs/answer/2848305.html

https://gist.github.com/fanda/b4544e3bf0901db6cca4

HazelCast(Local Cache)

[ 손권남 페이스북에서 퍼옴 ]

나는 Java에서 "캐시 목적으로" Redis나 Memcached를 되도록 사용하지 않길 권한다.

• 일단 서버 추가로 인한 운영부담
• Network 대역폭 차지, Network 전송에 의한 Latency 증가
• 캐시 대상 객체 필드가 변경되었을 때직렬화 문제 발생 - 배포하는 도중에 예를들면 꼭 필요한 필드가 존재하지 않는 상황등 발생. 이게 제일 골치아픔.

이에 대한 해결책으로 Java 에는 다양한 Local Cache 솔루션들이 있다. 당연히 In Memory Local Cache이므로 성능은 엄청좋고, 직렬화 과정이 없으므로 객체 변경으로 인한 문제도 발생하지 않는다.

그중에서도 Local Cache를 하되, Update/Delete 시에 다른 Java instance들에게 해당 데이터를 evict 시키라고 신호를 주는 방식으로 정합성을 맞춰줄 수 있다. 물론 다른 서버들은 새로운 객체를 DB에서 다시 읽어야 한다. 하지만 이로인한 손실은 매우 작다. 매번 원격 캐시 Network 호출하는 것에 비하면 새발의 피.
(Infinispan 문서에서는 이런것을 Replication-Invalidation 모드라고 부르는 듯)

아래 글은 바로 HazelCast를 이용해 Update/Delete 동기화된 Local Cache를 구현하는 방법인데 나도 해봐야지~
안그래도 Infinispan으로 해보려고 맘먹고 있었는데.

https://pkgonan.github.io/2018/10/hazelcast-hibernate-second-level-cache?fbclid=IwAR38_W2BETzmg5eZIBZRxvIz_Cgai7_PfM-WdibmzWvVunbJMtAzw7YfimQ

Generate and deploy war

How do I deploy war of admin in tomcat? I tried to do so and have been failing.

I guess there might be something we need to do with artifactId or something I am not sure. But I can access the login page via localhost:9090/mago3d-admin/login/login.do. But once I enter the correct credentials and hit enter, it gets redirected to localhost:9090/login/process-login.do. I should be redirected to localhost:9090/mago3d-admin/main/index.do but it is just not working.

I am new to spring boot and have no clue what to do.

Change oracle java to openjdk

openjdk9 has a springboot error, so java9 application is suspended

In the case of openjdk8, the license check is not clear and needs confirmation.
http://hg.openjdk.java.net/jdk8u/jdk8u/rev/866ed739fa56

local pc zulu?
https://www.azul.com/downloads/zulu/zulu-windows/

참고 사이트

헬싱키
https://kartta.hel.fi/3d/

3drepo
http://3drepo.org

springboot jwt

https://www.devglan.com/spring-security/spring-boot-jwt-auth

cloud version user ui

우린 공짜 버전
https://github.com/puikinsh/sufee-admin-dashboard
이걸 했습니다.

http://eliteadmin.themedesigner.in/demos/bt4/inverse/index.html
이건 유료라....

S3 권한관리

서명된 URL
http://docs.aws.amazon.com/ko_kr/AmazonCloudFront/latest/DeveloperGuide/private-content-signed-urls.html

그런데 이 방법으로 안될거 같다.

Scheduler

http://www.cronmaker.com/?fbclid=IwAR1TRD2MKxfeyYEjcnwDS-jQ7KtuRQGzBV8Vj0aK78AR2-4ST5oinuFJvvo

data group 수정

ancestor를 가지게 수정해야 함

cache가 로딩 될때
1 ancestor로 groupby
1을 child를 전부 select 한후 depth, view_order 로 order by
data_group_id로 select data_info 테이블 select 해서 캐싱에....
ancestor key로 저장?

Available after login

when i access http://localhost/homepage/demo.do .It remind me “Available after login”.So how can i login?

Webix - Tree

https://webix.com

demo.do locale

            log.info("@@ viewLibrary = {}", viewLibrary);
	String viewName = "demo";
	String lang = (String)request.getParameter("lang");
	if(lang == null || "".equals(lang)) {
		lang = (String)request.getSession().getAttribute(SessionKey.LANG.name());
		if(lang == null || "".equals(lang)) {
			Locale myLocale = request.getLocale();
			lang = myLocale.getLanguage();
		}
	}
	
	log.info("@@ lang = {}", lang);
	if(lang != null && !"".equals(lang)) {
		request.getSession().setAttribute(SessionKey.LANG.name(), lang);
		Locale locale = new Locale(lang);

// LocaleResolver localeResolver = RequestContextUtils.getLocaleResolver(request);
localeResolver.setLocale(request, response, locale);
}

Java source code error, lots of methods are missing. Please help, thanks.

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 run Mago3dAdminApplication.java, a lot of errors occur:

it says that a lot of methods are missing.

C:\git\repository\mago3d-git\mago3d-core\src\main\java\com\gaia3d\domain\DataInfoLog.java
Error:(127, 39) java: can not find symbol
  symbol:   method getCode_name()
 location: type  com.gaia3d.domain.CommonCode variable commonCode

C:\git\repository\mago3d-git\mago3d-core\src\main\java\com\gaia3d\parser\impl\DataFileJsonParser.java
Error:(29, 54) java: can not find symbol
   symbol:   method getFile_info_id()
   location: type com.gaia3d.domain.FileInfo variable fileInfo
Error:(30, 29) java: can not find symbol
  symbol:    setLog_type(java.lang.String)
   location: type com.gaia3d.domain.FileParseLog variable fileParseLog
Error:(33, 80) java: 找不到符号
  符号:   方法 getFile_path()
  位置: 类型为com.gaia3d.domain.FileInfo的变量 fileInfo
Error:(33, 106) java: 找不到符号
  符号:   方法 getFile_real_name()
  位置: 类型为com.gaia3d.domain.FileInfo的变量 fileInfo
Error:(51, 33) java: 找不到符号
  符号:   方法 setProject_id(java.lang.Long)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(52, 33) java: 找不到符号
  符号:   方法 setData_name(java.lang.String)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(53, 33) java: 找不到符号
  符号:   方法 setData_key(java.lang.String)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(54, 78) java: 找不到符号
  符号:   方法 setLatitude(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(55, 80) java: 找不到符号
  符号:   方法 setLongitude(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(56, 74) java: 找不到符号
  符号:   方法 setHeight(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(57, 76) java: 找不到符号
  符号:   方法 setHeading(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(58, 72) java: 找不到符号
  符号:   方法 setPitch(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo
Error:(59, 70) java: 找不到符号
  符号:   方法 setRoll(java.math.BigDecimal)
  位置: 类型为com.gaia3d.domain.DataInfo的变量 dataInfo

lots of similar errors also occur in other files.

I can not find the reasons. Please help, thanks very much.

Safari Technology Preview

이 브라우저가 크롬 보다 빠르다고 하는데....
시연할때 이용할 수 있는지 테스트가 필요.

Drag & Drop File Upload

보안에 취약하지 않고
다중 업로딩이 가능한걸 사용해야 겠지?

https://gitlab.com/meno/dropzone/wikis/home
http://www.dropzonejs.com/

http://eliteadmin.themedesigner.in/demos/eliteadmin-dark/form-upload.html
http://eliteadmin.themedesigner.in/demos/eliteadmin-dark/form-dropzone.html
https://codepen.io/collection/XLPxWz/
https://fineuploader.com/

CSS Camelcase

http://findawayer.tistory.com/entry/CSS%EC%97%90%EC%84%9C-%EC%BA%90%EB%A9%80%EC%BC%80%EC%9D%B4%EC%8A%A4camelCase%EB%8A%94-%EC%A2%8B%EC%A7%80-%EC%95%8A%EB%8B%A4

UI 참고 할 사이트

Autodek forge demo site
http://www.ogicim.com/
http://adndevblog.typepad.com/technology_perspective/2016/01/autodesk-forge-platfotrm.html

https://www.techsoft3d.com/products/

HA using DRBD

LifeKeeper/DataKeeper

ci & deploy

aws 에서의 ci, deploy 참고
http://jojoldu.tistory.com/265

구글 OTP 연동

https://github.com/ihoneymon/spring-security-2step-verification

구글 오픈 소스 Jib

Dockerfile 안 만들고 docker 이미지 빌드하기

클라우드 환경에서 F4D 웹 서비스 할때 보안, Akamai 조사해 보자.

akamai

As execution mago3d-admin?

Hi, I already downloaded mago3d from the git repository and ran gradle build and the process went well.

Now what I want is to know how to run mago3d-admin. In the documentation it says:

Run mago3d-admin project spring boot
/mago3d-admin/src/main/java/com/gaia3d/Mago3dAdminApplication.java

But I have no idea what it means or if I need to install anything.
Please could you give me a hint of how I should run it and what I need.

Thanks

Missing css

Some css files do not exist.
At "mago3d-admin\src\main\webapp\WEB-INF\views\config\list-db-backup-log.jsp"

<link type="text/css" rel="stylesheet" href="/css/ko/layout.css" />
<link type="text/css" rel="stylesheet" href="/css/ko/common.css" />
<link type="text/css" rel="stylesheet" href="/css/ko/admin.css" />

Setting error when using IntelliJ IDEA

After intellij idea starts spring boot.
When connected to the
http: // localhost: 9090 / login / login.do
404 error occurs.

/WEB-INF/views/login/login.jsp
I can not find it.
It uses the same source, and works fine in eclipse.

    @Bean
@ConditionalOnMissingBean(InternalResourceViewResolver.class)
public InternalResourceViewResolver viewResolver() {
	InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
	viewResolver.setPrefix("/WEB-INF/views");
	viewResolver.setSuffix(".jsp");
	viewResolver.setOrder(3);
	return viewResolver;
}

I can not find any reason.

HA Proxy

https://github.com/benelog/h2demo

chart site

https://okky.kr/article/470566

varnish cache

성능을 높이기 위해서 적용해야 할 듯

동적 캐시
https://varnish-cache.org/

/config/modify-policy.do has null-pointer error, if default project is removed

About config/modify-policy.do

When "시작시 로딩 프로젝트" is set to some project(s), and if its project is deleted.
Opening "/config/modify-policy.do" result in NullPointer error in Java, and browser get error.

To recover, erase "geo_data_default_projects" from policy table.

Maybe, delete "geo_data_default_projects" from "modify-policy.do" screen first, then remove project cause no error.

클라우드 개발 관련 정보

s3 파일 업로더
https://beomi.github.io/2017/12/15/Direct-upload-to-S3-with-Lambda/

How to prevent objects from changing position?

Hello, I attach two test videos in Mago3D, one using the mago3d test site and the other using the mago3D API implementation.
https://peertube.video/videos/watch/eb668e7e-a9ce-4000-91b3-342bef372170
https://peertube.video/videos/watch/3b2427e5-7398-4a2c-989c-600ad0753112

In both sites, when I click on an object to get information and then start writing something for a notification, the object starts to change its position. I would like to know if it is possible to disable that behavior and how to do it.

This behavior happens with AWDS keys. I would like to prevent the object from changing position.

Thanks

DataSource HikariCp 로 교체

https://github.com/brettwooldridge/HikariCP

mago3d.properties Directory 修正

DirectoryがDefault値が
D:
になっておりますが、D:がない人がいます。
C:に変更するべき

Http2 세팅시 확인 할 점

http://d2.naver.com/helloworld/8842776

대용량 excel download

잘 정리해 두었네
교육용

https://m.blog.naver.com/PostView.nhn?blogId=tmondev&logNo=221388780914&proxyReferer=&proxyReferer=