IT 한길

openssl s_client -connect url:port | openssl x509 -noout -dates

# audit list 조회 ========================
select
hex(a.goid) goid,
g.name node,
date_format(from_unixtime(a.time / 1000), '%Y-%m-%d %H:%i:%s.%f') time,
a.audit_level serverity,
a.name service,
a.message,
a.ip_address client_ip,
uncompress(b.request_zipxml) request, -- 옵션 사용중인 경우만
uncompress(b.response_zipxml) response -- 옵션 사용중인 경우만
from
  audit_main a
  left outer join audit_message b on a.goid = b.goid
  join cluster_info g on a.nodeid = g.nodeid
where
b.service_goid is not null -- 시스템,admin 로그 제외
and a.time > unix_timestamp('2022-02-17 11:38:57.274')*1000 -- 시작일시
and a.time < unix_timestamp('2022-02-17 11:48:57.274')*1000 -- 종료일시
-- and a.audit_level = 'WARNING'
-- and a.name like '%/openbanking/%' --api명
order by a.time desc;

 

# audit detail 조회 ========================
select
date_format(from_unixtime(a.time/1000),'%Y-%m-%d %H:%i:%s.%f') time,
a.message_id code,
case when b.position=1 then 'WARNING' else 'INFO' end Serverity,
b.value
from
  audit_detail a
  join audit_detail_params b on a.goid=b.audit_detail_goid
where hex(a.audit_goid)='85562EE4D72AA5EE2516C0D43F86EEFE' -- audit_main goid
order by a.time desc;

'IT > CA Gateway' 카테고리의 다른 글

[CA Gateway] Revision History 조회  (0) 2022.03.15

select a.name, b.version, date_format(from_unixtime(b.time/1000),'%Y-%m-%d %H:%i:%s.%f') time 
from policy a left outer join policy_version b
on a.goid = b.policy_goid
where a.name like '%API명'
order by b.version desc

'IT > CA Gateway' 카테고리의 다른 글

[CA Gateway] Audit 로그 조회  (0) 2022.03.15

- Access Token 요청 (graph.facebook.com/oauth/access_token)

- 사용자 게시물 피드 조회 : /{user-id}/feed (graph.facebook.com/v2.5/me/feed)

 

- keystore 생성

- pom.xml 파일 tomcat plugin 수정 (httpsPort, keystoreFile)

<build>
    <finalName>example</finalName> 
    <plugins>
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.5</version>
      </plugin>
      <plugin>
        <groupId>org.apache.tomcat.maven</groupId>
        <artifactId>tomcat7-maven-plugin</artifactId>
        <version>2.2</version>
        <configuration>
          <port>8080</port>
          <httpsPort>8443</httpsPort>
       	  <keystoreFile>c:/test.keystore</keystoreFile>
          <path>/</path>
          <contextReloadable>true</contextReloadable>
          <systemProperties>
            <JAVA_OPTS>-Xms512m -Xmx512m --XX:MaxPermSize=256m</JAVA_OPTS>
          </systemProperties>
        </configuration>
      </plugin>
    </plugins>
  </build>

 

 

'IT > Was' 카테고리의 다른 글

톰캣 불필요한웹메서드 제거  (0) 2020.07.14
[Tomcat]도커(Docker)에서 톰캣 설치  (0) 2020.06.11
Jboss AS 7 서버로깅설정  (0) 2014.03.24
JBoss AS 7 설치  (0) 2014.03.07
웹로직 64비트 설치  (0) 2014.02.10

리눅스 버전 확인

IT/Linux2020. 9. 22. 10:49

           grep . /etc/*-release       

           cat /etc/*-release | uniq  

           grep . /etc/issue*

           rpm -qa *-release           레드햇 계열

 

 

'IT > Linux' 카테고리의 다른 글

패스워드 변경 주기 삭제  (0) 2020.08.12
CentOS 8 다운로드  (0) 2020.06.08
yum : command not found (Redhat)  (0) 2020.06.08
/bin/sh^M: bad interpreter: No such file or directory 오류 발생 시  (0) 2020.06.03

1. Service Provider 생성

https://medium.com/disney-streaming/setup-a-single-sign-on-saml-test-environment-with-docker-and-nodejs-c53fc1a984c9

 

2. Service Provider 로그인

 - http://localhost:4300/login

 - IdP  로그인 화면으로 이동됨

IdP 로그인

 - 성공

- metadata 

1. docker 이미지 다운로드

 - docker pull kristophjunge/test-saml-idp (hub.docker.com/r/kristophjunge/test-saml-idp/)

[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                         COMMAND                  CREATED             STATUS              PORTS                                                      NAMES
3f1c9f57495f        kristophjunge/test-saml-idp   "docker-php-entrypoi   45 minutes ago      Up 45 minutes       80/tcp, 0.0.0.0:48080->8080/tcp, 0.0.0.0:48443->8443/tcp   testsamlidp_idp

2. docker 실행

[root@localhost ~]#docker run --name=testsamlidp_idp \
-p 48080:8080 \
-p 48443:8443 \
-e SIMPLESAMLPHP_SP_ENTITY_ID=http://app.example.com \
-e SIMPLESAMLPHP_SP_ASSERTION_CONSUMER_SERVICE=http://192.168.31.100:4300/login/callback \
-e SIMPLESAMLPHP_SP_SINGLE_LOGOUT_SERVICE=http://localhost/simplesaml/module.php/saml/sp/saml2-logout.php/test-sp \
-d kristophjunge/test-saml-idp
[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                         COMMAND                  CREATED             STATUS              PORTS                                                      NAMES
3f1c9f57495f        kristophjunge/test-saml-idp   "docker-php-entrypoi   45 minutes ago      Up 45 minutes       80/tcp, 0.0.0.0:48080->8080/tcp, 0.0.0.0:48443->8443/tcp   testsamlidp_idp

1. IdP 접속

 - http://localhost:포트/simplesaml

- Authentication 탭 클릭

- Test configured authentication sources 클릭

- example-userpass 클릭

- 아래 디폴트 계정으로 로그인

1 user1 user1pass group1 user1@example.com
2 user2 user2pass group2 user2@example.com
3 admin secret