{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["DBMS 설정 테스트","고객사 아이디_IP체크"],"read":"whole","date_system":"1900"}

{"sheet":"DBMS 설정 테스트","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"merged":[[1,4,7,4],[1,5,7,5],[1,6,7,6],[1,7,7,7],[1,8,7,8]]}
["\bDBMS","DBMS 설정값 적용","연결정보","설정 정보","테스트 케이스","확인로그","로그출력","테스트 케이스","확인로그","로그 출력","비고"]
["\b큐브리드","DB.DBMS=CUBRID","CUBRID.DRIVER=cubrid.jdbc.driver.CUBRIDDriver\nCUBRID.URL=jdbc:cubrid:119.193.215.98:30000:mjon_agent:::\nCUBRID.USER=mjonAgentUr\nCUBRID.PASSWORD=mjonAgentUr!@#$","1. CUBRID.DRIVER : 드라이버 설정\n2. CUBRID.URL : DBMS URL 설정\n   - 예) 119.193.215.98 : 서버IP 설정\n   - 예) 30000 : DBMS Port 설정\n   - 예) mjon_agent : 데이터베이스명\n3. CUBRID.USER : DBMS 사용자 ID 설정\n4. CUBRID.PASSWORD : DBMS 사용자 비밀번호 설정","1. DRIVER 정보를 잘못 입력한 경우\n2. URL 정보중 잘못 입력한 경우\n3. USER 정보를 잘못 입력한 경우\n4. PASSWORD 정보를 잘못 입력한 경우","logs/agent/munjaonClient.log","### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC \nConnection\n### The error may exist in class path resource [sqlmap/mariadb/mariadb_sql.xml]\n### The error may involve com.munjaon.client.mariadb.mapper.MariaDBMapper.checkTableForMessage\n### The error occurred while executing a query\n### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection\n        at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:156)\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75)\n        at jdk.internal.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)\n        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n        at java.base/java.lang.reflect.Method.invoke(Method.java:568)\n        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)\n        ... 16 common frames omitted\nCaused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection\n        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:84)\n        at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)\n        at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)\n        at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:348)\n        at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:89)\n        at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:64)\n        at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)\n        at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)\n        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)\n        at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90)\n        at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)\n        ... 23 common frames omitted\n        Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.\n        at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)\n        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)\n        at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)\n        at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)\n        at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:160)\n        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:118)\n        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)\n        ... 33 common frames omitted\nCaused by: java.sql.SQLNonTransientConnectionException: Socket fail to connect to host:address=(host=192.168.0.60)(port=3303)(type=primary). 연결이 거부됨\n        at org.mariadb.jdbc.client.impl.ConnectionHelper.connectSocket(ConnectionHelper.java:137)\n        at org.mariadb.jdbc.client.impl.StandardClient.<init>(StandardClient.java:99)\n        at org.mariadb.jdbc.Driver.connect(Driver.java:70)\n        at org.mariadb.jdbc.Driver.connect(Driver.java:101)\n        at org.mariadb.jdbc.Driver.connect(Driver.java:27)\n        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)\n        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)\n        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)\n        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)\n        at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)\n        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)\n        at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)\n        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)\n        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)\n        at java.base/java.lang.Thread.run(Thread.java:833)\nCaused by: java.net.ConnectException: 연결이 거부됨","발송테이블이 생성되지 않은 경우","logs/SMS/SMS_Log_YYYYMMDD.log\nlogs/LMS/LMS_Log_YYYYMMDD.log\nlogs/MMS/MMS_Log_YYYYMMDD.log\nlogs/KAT/KAT_Log_YYYYMMDD.log\nlogs/KFT/KFT_Log_YYYYMMDD.log\nlogs/LOG_MOVE/LOG_MOVE_Log_YYYYMMDD.log\nlogs/REPORT/REPORT_Log_YYYYMMDD.log","[checkReady][DBMS : CUBRID is ready]"]
["MariaDB","DB.DBMS=MARIADB","MARIADB.DRIVER=org.mariadb.jdbc.Driver\nMARIADB.URL=jdbc:mariadb://localhost:3306/mjon\nMARIADB.USER=root\nMARIADB.PASSWORD=1234","1. MARIADB.DRIVER : 드라이버 설정\n2. MARIADB.URL : DBMS URL 설정\n   - 예) localhost : 서버IP 설정\n   - 예) 3306 : DBMS Port 설정\n   - 예) mjon : 데이터베이스명\n3. MARIADB.USER : DBMS 사용자 ID 설정\n4. MARIADB.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : MARIADB is ready]"]
["Mssql","DB.DBMS=MSSQL","MSSQL.DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver\nMSSQL.URL=jdbc:sqlserver://119.193.215.98:1433;databaseName=mjon_agent;encrypt=true;trustServerCertificate=true\nMSSQL.USER=mjonAgentUr\nMSSQL.PASSWORD=mjonAgentUr!@#$","1. MSSQL.DRIVER : 드라이버 설정\n2. MSSQL.URL : DBMS URL 설정\n   - 예) 119.193.215.98: 서버IP 설정\n   - 예) 1433 : DBMS Port 설정\n   - 예) databaseName=mjon_agent : 데이터베이스명\n3. MSSQL.USER : DBMS 사용자 ID 설정\n4. MSSQL.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : MSSQL is ready]"]
["Mysql","DB.DBMS=MYSQL","MYSQL.DRIVER=com.mysql.cj.jdbc.Driver\nMYSQL.URL=jdbc:mysql://localhost:3306/mjon\nMYSQL.USER=root\nMYSQL.PASSWORD=1234","1. MYSQL.DRIVER : 드라이버 설정\n2. MYSQL.URL : DBMS URL 설정\n   - 예) localhost : 서버IP 설정\n   - 예) 3306 : DBMS Port 설정\n   - 예) mjon : 데이터베이스명\n3. MYSQL.USER : DBMS 사용자 ID 설정\n4. MYSQL.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : MYSQL is ready]"]
["Oracle","DB.DBMS=ORACLE","ORACLE.DRIVER=oracle.jdbc.driver.OracleDriver\nORACLE.URL=jdbc:oracle:thin:@119.193.215.98:1524:XE\nORACLE.USER=mjonAgentUr\nORACLE.PASSWORD=mjonAgentUr!@#$","1. ORACLE.DRIVER : 드라이버 설정\n2. ORACLE.URL : DBMS URL 설정\n   - 예) 119.193.215.98: 서버IP 설정\n   - 예) 1524 : DBMS Port 설정\n   - 예) XE : \bSID\n3. ORACLE.USER : DBMS 사용자 ID 설정\n4. ORACLE.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : ORACLE is ready]"]
["Postresql","DB.DBMS=POSTGRESQL","POSTGRESQL.DRIVER=org.postgresql.Driver\nPOSTGRESQL.URL=jdbc:postgresql://119.193.215.98:5432/mjon_agent\nPOSTGRESQL.USER=mjonagentur\nPOSTGRESQL.PASSWORD=mjonAgentUr!@#$","1. POSTGRESQL.DRIVER : 드라이버 설정\n2. POSTGRESQL.URL : DBMS URL 설정\n   - 예) 119.193.215.98: 서버IP 설정\n   - 예) 5432 : DBMS Port 설정\n   - 예) mjon_agent : 데이터베이스명\n3. POSTGRESQL.USER : DBMS 사용자 ID 설정\n4. POSTGRESQL.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : POSTGRESQL is ready]"]
["티베로","DB.DBMS=TIBERO","TIBERO.DRIVER=com.tmax.tibero.jdbc.TbDriver\nTIBERO.URL=jdbc:tibero:thin:@119.193.215.98:8633:tibero\nTIBERO.USER=mjonAgentUr\nTIBERO.PASSWORD=mjonAgentUr!@#$","1. TIBERO.DRIVER : 드라이버 설정\n2. TIBERO.URL : DBMS URL 설정\n   - 예) 119.193.215.98: 서버IP 설정\n   - 예) 8633 : DBMS Port 설정\n   - 예) tibero : 데이터베이스명\n3. TIBERO.USER : DBMS 사용자 ID 설정\n4. TIBERO.PASSWORD : DBMS 사용자 비밀번호 설정",{"$nulls":5},"[checkReady][DBMS : TIBERO is ready]"]

{"sheet":"고객사 아이디_IP체크","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,0,0,9],[3,0,3,1],[8,0,8,6],[10,4,15,4]]}
["설정 대상 테이블 : mj_agent_mber_config"]
[]
[]
["설정 컬럼"]
["IP_LIMIT_YN","접속 IP 제한 여부"]
["ALLOW_IP_BASIC","기본 접속 IP"]
["ALLOW_IP_EXTEND","확장 접속 IP"]
[]
["기타 다른 설정은 정상이고 IP 설정에 대한 케이스만 적용"]
["IP_LIMIT_YN\n(IP 제한 설정 값)","ALLOW_IP_BASIC\n(기본 접속 IP)","ALLOW_IP_EXTEND\n(확장 접속 IP)","고객접속 IP(가정)","로그확인","로그출력","비고"]
["\bN","Null 또는 공인 IP","Null 또는 공인 IP","119.193.215.98","logs/SMS/SMS_Log_YYYYMMDD.log\nlogs/LMS/LMS_Log_YYYYMMDD.log\nlogs/MMS/MMS_Log_YYYYMMDD.log\nlogs/KAT/KAT_Log_YYYYMMDD.log\nlogs/KFT/KFT_Log_YYYYMMDD.log","[BIND FAIL] [RESULT CODE : 00]"]
["Y","Null","Null","119.193.215.98",null,"[BIND FAIL] [RESULT CODE : 40]"]
["Y","공인IP\n   - 허용되지 않은 공인 IP\n   - 예) 119.193.215.97","공인IP\n   - 허용되지 않은 공인 IP\n   - 예) 119.193.215.99","119.193.215.98",null,"[BIND FAIL] [RESULT CODE : 40]"]
["\bY","공인IP\n   - 허용 공인 IP\n   - 예) 119.193.215.98","공인IP\n   - 허용되지 않은 공인 IP\n   - 예) 119.193.215.99","119.193.215.98",null,"[BIND FAIL] [RESULT CODE : 00]"]
["Y","공인IP\n   - 허용되지 않은 공인 IP\n   - 예) 119.193.215.97","공인IP\n   - 허용 공인 IP\n   - 예) 119.193.215.98","119.193.215.98",null,"[BIND FAIL] [RESULT CODE : 00]"]
["Y","공인IP\n   - 허용 공인 IP\n   - 예) 119.193.215.98","공인IP\n   - 허용 공인 IP\n   - 예) 119.193.215.98","119.193.215.98",null,"[BIND FAIL] [RESULT CODE : 00]"]