본문 바로가기

atlassian_confluence_jira

confluence could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet confluence restore 하고 구동시켰는데 could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet 위와 같이 에러가 발생한다. 여러가지 방법을 다 써봤지만.. 실패.. mysql 백업에 문제가 있었다. mysql 데이터가 용량이 크다보니 max 값을 지정을 안해주면 백업 할때 에러가 발생한다. https://algo79.tistory.com/626 mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table ` m.. 더보기
Atlassian 제품 SSL 적용하기 comodo ssl 등록하기 우선 jks 파일을 생성 해야 한다. CSR 값 생성 # openssl req -new -newkey rsa:2048 -nodes -keyout test.key -out atlassian.csr You are about to be asked to enter information that will be incorporated into your certificate request. What you are about to enter is what is called a Distinguished Name or a DN. There are quite a few fields but you can leave some blank For some fields there will be a default value, If y.. 더보기
Crowd install Centos 7.x 기준 작성 JAVA 가 필요합니다. 이번엔 JDK 버전이 필요 합니다. https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Java SE Development Kit 8 - Downloads Java SE Development Kit 8 Downloads Thank you for downloading this release of the Java™ Platform, Standard Edition Development Kit (JDK™). The JDK is a development environment for building applications, applets, and componen.. 더보기
jira service desk install atlassian 제품들이 설치하는 방식이 다 비슷 하다. centos 7.x 환경기준 mysql 설치 # wget https://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm # yum install -y mysql57-community-release-el7-7.noarch.rpm # yum install -y mysql mysql-community-server mysql-server mysql-devel mysql-libs 설치 끝났으면 로그인하고 로그인 할때 안된다면 https://algo79.tistory.com/entry/mysql-57-%EC%9D%B4%EC%83%81-%EC%84%A4%EC%B9%98%EC%8B%9C-root-%E.. 더보기
BootstrapException: Unable to bootstrap application: The database driver (com.mysql.jdbc.Driver) was not found in the class path.<br/>This Confluence installation cannot be upgraded automatically. Please see Confluence documentation:<br/>https://conflue.. BootstrapException: Unable to bootstrap application: The database driver (com.mysql.jdbc.Driver) was not found in the class path. This Confluence installation cannot be upgraded automatically. Please see Confluence documentation: https://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL Database Setup For MySQL - Atlassian Documentation confluence.atlassian.com confluence 업그레이드를 했는데 .. 더보기
ERROR [UpmAsynchronousTaskManager:thread-4] [engine.jdbc.spi.SqlExceptionHelper] logExceptions The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size. ERROR [UpmAsynchronousTaskManager:thread-4] [engine.jdbc.spi.SqlExceptionHelper] logExceptions The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size. 위와 같이 에러가 발생을 하면 innodb_log_file_size 작아서 그렇다 올려주면 된다. innodb_log_file_size=512M or innodb_log_file_size=1G https://confluence.atlassian.com/confkb/unable-.. 더보기
jira Database: We've found a problem with your database connection URL jira update 하다가 위와 같이 에러가 발생 한다. mysql 5.6 이전버전과 이후 버전 차이에 문제가 생긴다. 아래와 같이 dbconfig.xml 파일을 수정 해주면 된다. 5.7 은 storage_engine=InnoDB5.6 이하는 default_storage_engine=InnoDBFor versions of MySQL below 5.7jdbc:mysql://dbserver:3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDBFor versions of MySQL of 5.7 and abovejdbc:mysql://dbserver:3306/jiradb?useUnicode=true&c.. 더보기
Administering Collaborative Editing maximum heap size 늘리기 confluence synchrony 메모리 늘리는 방법기본 default 값은 1G 이다. 2G로 늘려보자 vi setenv.shCATALINA_OPTS="-Dsynchrony.memory.max=2g ${CATALINA_OPTS}"추가 더보기

728x90
320x100