그룹웨어 점검

CHANGHO KIM·2022년 7월 7일
0

그룹웨어 원격지원

log 접속

[root@gw ~]# cd /opt/TerraceTims/log/notif
notifier/ notify/
[root@gw ~]# cd /opt/TerraceTims/log/notifier/
[root@gw notifier]# ls
debug.log    error.log.3        gc_2017-04-03.log  gc_2018-10-18.log            gc_2020-09-07.log.0.current  gc_2021-01-12.log.0.current  info.log    info.log.4  warn.log    warn.log.4
error.log    error.log.4        gc_2017-04-28.log  gc_2018-10-30.log            gc_2020-10-07.log.0.current  gc_2022-02-03.log.0.current  info.log.1  info.log.5  warn.log.1  warn.log.5
error.log.1  gc_2016-11-16.log  gc_2017-11-24.log  gc_2019-11-14.log.0.current  gc_2020-10-25.log.0.current  gc_2022-02-17.log.0.current  info.log.2  info.log.6  warn.log.2  warn.log.6
error.log.2  gc_2017-04-02.log  gc_2017-11-26.log  gc_2020-01-30.log.0.current  gc_2020-10-26.log.0.current  gc_2022-06-08.log.0.current  info.log.3  info.log.7  warn.log.3  warn.log.7
[root@gw notifier]# less error.log
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# tail -f error.log
2022.07.06 10:28:35 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='540-229298' type='result'></iq>
java.lang.NullPointerException
2022.07.06 10:29:14 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='659-229305' type='result'></iq>
java.lang.NullPointerException
2022.07.06 13:29:00 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='897-230308' type='result'></iq>
java.lang.NullPointerException
2022.07.07 09:31:23 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='337-236824' type='result'></iq>
java.lang.NullPointerException
2022.07.07 14:22:39 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='830-238148' type='result'></iq>
java.lang.NullPointerException



^C
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# cd /opt/TerraceTims/log/catalina/webmail/
[root@gw webmail]# less 20220707.log
[root@gw webmail]#
[root@gw webmail]#
[root@gw webmail]# ps -ef | grep dbdata
root        989 168085  0 15:46 pts/1    00:00:00 grep dbdata
mailadm  189053      1  0 Jun08 ?        00:29:56 /data/TerraceTims/3rd/edb/9.4AS/bin/edb-postgres -D /opt/TerraceTims/3rd/edb/dbdata
[root@gw webmail]# /data/TerraceTims/3rd/edb/9.4AS/bin/psql -U mailadm -p 5432 tims
psql.bin (9.4.1.4)
Type "help" for help.

tims=# select * from go_users where name='오지연';
 id  |       created_at       |       updated_at       | deleted_at | employee_number | locale |    last_logined_at     | login_count | login_fail_count | login_id | login_locked_at | mai    l_group |  name  | name_hurigana |  noti  | open_type |                       password                       |  password_changed_at   | search_name | status | time_zone  | company_id | co    nfig_id | mail_user_seq | user_profile_id | user_push_setting_id | use_cert | user_integration_id | force_to_change_password | user_web_noti_setting_id | user_mobile_noti_setting_id | use    r_mail_noti_setting_id | user_noti_setting_id | fixed_ip | delayed_pw_change_checked_at
-----+------------------------+------------------------+------------+-----------------+--------+------------------------+-------------+------------------+----------+-----------------+----    --------+--------+---------------+--------+-----------+------------------------------------------------------+------------------------+-------------+--------+------------+------------+---    --------+---------------+-----------------+----------------------+----------+---------------------+--------------------------+--------------------------+-----------------------------+----    -----------------------+----------------------+----------+------------------------------
 393 | 29-MAY-20 15:08:07.803 | 28-JUN-22 08:57:06.877 |            | 20200601        | ko     | 07-JUL-22 13:50:20.421 |        1557 |                0 | ojy      |                 |                | 오지연 |               | ENABLE | OPEN      | {SHA256}dGERob7sI2m5nTIfu/w8RVR9Dg6Je9CdkzM3L/qV/G0= | 18-NOV-21 08:55:35.417 | 오지연      | ONLINE | Asia/Seoul |         10 |       tims=#  |           413 | --More--
tims=#
tims=#
tims=# \q
[root@gw webmail]#
[root@gw webmail]#
[root@gw webmail]#
[root@gw webmail]# less 20220707.log
[root@gw webmail]#
[root@gw webmail]#
[root@gw webmail]# cd /opt/TerraceTims/log/notifier/
[root@gw notifier]# ls
debug.log          gc_2017-04-03.log            gc_2020-09-07.log.0.current  info.log    warn.log
error.log          gc_2017-04-28.log            gc_2020-10-07.log.0.current  info.log.1  warn.log.1
error.log.1        gc_2017-11-24.log            gc_2020-10-25.log.0.current  info.log.2  warn.log.2
error.log.2        gc_2017-11-26.log            gc_2020-10-26.log.0.current  info.log.3  warn.log.3
error.log.3        gc_2018-10-18.log            gc_2021-01-12.log.0.current  info.log.4  warn.log.4
error.log.4        gc_2018-10-30.log            gc_2022-02-03.log.0.current  info.log.5  warn.log.5
gc_2016-11-16.log  gc_2019-11-14.log.0.current  gc_2022-02-17.log.0.current  info.log.6  warn.log.6
gc_2017-04-02.log  gc_2020-01-30.log.0.current  gc_2022-06-08.log.0.current  info.log.7  warn.log.7
[root@gw notifier]# less info.log
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# /data/TerraceTims/3rd/edb/9.4AS/bin/psql -U mailadm -p 5432 tims
psql.bin (9.4.1.4)
Type "help" for help.

tims=#
tims=#
tims=# select * from go_users where name='김창호';
 id  |      created_at       |       updated_at       | deleted_at | employee_number | locale |    last_logined_                                                                               at     | login_count | login_fail_count | login_id | login_locked_at | mail_group |  name  | name_hurigana |  no                                                                               ti  | open_type |                       password                       |  password_changed_at   | search_name |                                                                                status | time_zone  | company_id | config_id | mail_user_seq | user_profile_id | user_push_setting_id | use_cert                                                                                | user_integration_id | force_to_change_password | user_web_noti_setting_id | user_mobile_noti_setting_id | use                                                                               r_mail_noti_setting_id | user_noti_setting_id | fixed_ip | delayed_pw_change_checked_at
-----+-----------------------+------------------------+------------+-----------------+--------+-----------------                                                                               -------+-------------+------------------+----------+-----------------+------------+--------+---------------+----                                                                               ----+-----------+------------------------------------------------------+------------------------+-------------+-                                                                               -------+------------+------------+-----------+---------------+-----------------+----------------------+---------                                                                               -+---------------------+--------------------------+--------------------------+-----------------------------+----                                                                               -----------------------+----------------------+----------+------------------------------
 446 | 15-JUN-21 16:58:04.07 | 01-JUL-22 09:20:18.555 |            | 20210604        | ko     | 07-JUL-22 10:46:                                                                               50.235 |        1220 |                0 | kch      |                 |            | 김창호 |               | ENA                                                                               BLE | OPEN      | {SHA256}LZCwNUuBftU/XGD2s3aRs0FdCOdheiKx98+SoWRo8VA= | 03-FEB-22 12:19:33.537 | 김창호      |                                                                                                   389 |                  389 |          |             389 |    --More--
(1 row)
tims=#
tims=#
tims=#
tims=# \q
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# less info.log
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# less info.log
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# date
2022. 07. 07. () 16:02:17 KST
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]#
[root@gw notifier]# less info.log
[root@gw notifier]# less error.log

log 확인

[root@gw notifier]# less error.log
2V0PSJ1dGYtOCI=</response>
java.lang.NumberFormatException: For input string: "undefined"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:580)
        at java.lang.Integer.<init>(Integer.java:867)
        at org.jivesoftware.openfire.auth.GoAuthProvider.getPassword(GoAuthProvider.java:91)
        at org.jivesoftware.openfire.auth.AuthFactory.getPassword(AuthFactory.java:156)
        at org.jivesoftware.openfire.net.XMPPCallbackHandler.handle(XMPPCallbackHandler.java:85)
        at com.sun.security.sasl.digest.DigestMD5Server.validateClientResponse(DigestMD5Server.java:589)
        at com.sun.security.sasl.digest.DigestMD5Server.evaluateResponse(DigestMD5Server.java:244)
        at org.jivesoftware.openfire.net.SASLAuthentication.handle(SASLAuthentication.java:325)
        at org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:183)
        at org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandler.java:181)
        at org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimpleProtocolDecoderOutput.java:58)
        at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:185)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
        at org.jivesoftware.openfire.plugin.RawPrintFilter.messageReceived(RawPrintFilter.java:66)
        at org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
        at org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
        at org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
        at org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java:239)
        at org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(ExecutorFilter.java:283)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
        at java.lang.Thread.run(Thread.java:748)
2022.07.01 15:45:03 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='557-198819' type='result'></iq>
java.lang.NullPointerException
2022.07.02 00:11:58 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='31-201575' type='result'></iq>
java.lang.NullPointerException
2022.07.02 00:12:05 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='625-201577' type='result'></iq>
java.lang.NullPointerException
2022.07.02 00:16:00 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='239-201597' type='result'></iq>
java.lang.NullPointerException
2022.07.05 14:20:32 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='790-223629' type='result'></iq>
java.lang.NullPointerException
2022.07.06 10:27:54 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='411-229308' type='result'></iq>
java.lang.NullPointerException
2022.07.06 10:28:31 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='717-229301' type='result'></iq>
java.lang.NullPointerException
2022.07.06 10:28:35 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='540-229298' type='result'></iq>
java.lang.NullPointerException
2022.07.06 10:29:14 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='659-229305' type='result'></iq>
java.lang.NullPointerException
2022.07.06 13:29:00 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='897-230308' type='result'></iq>
java.lang.NullPointerException
2022.07.07 09:31:23 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='337-236824' type='result'></iq>
java.lang.NullPointerException
2022.07.07 14:22:39 org.jivesoftware.openfire.nio.ConnectionHandler - Closing connection due to error while processing message: <iq to='xmppdaou.com' id='830-238148' type='result'></iq>
java.lang.NullPointerException

openfire

profile
전산담당자

0개의 댓글