AuditWiki

You've loaded an old revision of the document! If you save it, you will create a new version with this data.

==== 1. 디렉토리명 및 기능 ====

== 1-1. smurelay ==

==== 2. 각 파일별 로그 내용 ====
== 아이디_SEND.log 로그내용 (agent와 통신 시) ==
<code>
21:32:37-321 RECV: DELIVER2 - 아이디 0212345678 01012345678  5
21:32:37-321 PUTQ: 아이디 01012345678 0212345678  5 (queue_normal.que:0-1)
</code>

^로그내용 구분값^설명^
|아이디|agent ID|
|01012345678|수신자 전화번호|
|0212345678|회신번호|
|0-1|queue_tran.que의 CURRENT INDEX 와 LAST_INDEX|

== 아이디_SEND.log 로그내용 (대기중) ==
※설명 : agent측 송신 라인과 통신이 없을 때 대기 상태의 로그내용.
<code>
23:59:01-761 SEND: LINK_CONFIRM to Client [아이디_SEND]
</code>

== 아이디_SEND.log 로그내용  ==
※설명 : agent측 송신 라인과 통신 시 Result= 4:Not Bound 발생하여  재송신 하는 로그내용.
<code>
10:16:01-395 SEND: DELIVER_ACK [sn = 158333290] [Result = 4:Not Bound]
10:16:01-395 RECV: DELIVER2 - smspia_sr_smsd1 025524568 01049177301 smspia.com 158333289
</code>
^Result 번호 종류^Result 메시지^설명^
|4|Not Bound| |
|19|Flow Control| |
|17|NO-URL User| |
|0| |

== 아이디_SEND.log 로그내용 (소켓 연결 에러) ==

※설명 : agent측 송신 라인과 통신 시 소켓 연결 에러 시 저장되는 로그내용.
<code>
23:29:58-580 Err: Read Socket Error [rc = -1] [Connection reset by peer]
23:29:58-581 Close Client socket ...
23:29:58-581 Notice: smCLIENT-아이디_SEND shutdown !!!
23:29:58-608 nCnts DupSequence = 6
23:30:03-537 Exit smCLIENT ...
23:30:33-174 _shm_cInfo size = 616
23:30:33-174 --------------------------------------------------
</code>

== 아이디_SEND.log 로그내용 (소켓 연결) ==

※설명 : agent측 송신 라인과 통신 시 정상적으로 저장되는 로그내용.
<code>
23:39:28-380 Starting smCLIENT - 아이디_SEND Daemon ..
23:39:28-380 Client [Socket = 10]  [pid cur = 13516 - 13516]
23:39:28-380 SEND: BIND_ACK [result = 0]
23:39:28-381 Success: Write BIND_ACK ...
23:39:28-381 Checking DupSequence = 6
</code>

== 아이디_RECV.log 로그내용 (agent와 통신 시) ==

※설명 : 전송결과를 agent측 수신 라인과 통신 시 정상적으로 저장되는 로그내용.
<code>
21:32:54-121 GETQ: REPORT2 아이디 01012345678 011 6 5 아이디_RECV.que(0-0)
21:32:54-124 RECV: REPORT-ACK2 ....
</code>

== 아이디_RECV.log 로그내용 ==

※설명 : 전송결과를 agent측 수신 라인과 통신 시 TimeOut 발생 후 제시도 할 경우 저장되는 로그내용.
<code>
15:09:46-925 Err: REPORT_ACK Wait TimeOut.. [sn = 0]
15:09:46-925 GETQ: REPORT2 b2pharm 01199516386 016 6 53884 b2pharm_RECV.que(0-0)
</code>

== 아이디_RECV.log 로그내용 (새션정보 기입 실패 시) ==
<code>
00:01:35-711 01|2|smu2_SDBPROC_2|INSERT SM_SESSION FAIL [MySQL server has gone away]
</code>

== 아이디_RECV.log 로그내용 (대기중) ==
<code>
23:59:54-877 SEND: LINK_CONFIRM to Client [아이디_RECV]
</code>

== 아이디_RECV.log 로그내용 (소켓 연결 에러) ==
<code>
23:29:58-580 Err: Read Socket Error [rc = -1] [Connection reset by peer]
23:29:58-581 Close Client socket ...
23:29:58-581 Notice: smCLIENT-아이디_SEND shutdown !!!
23:29:58-608 nCnts DupSequence = 6
23:30:03-537 Exit smCLIENT ...
23:30:33-174 _shm_cInfo size = 616
23:30:33-174 --------------------------------------------------
</code>

== 아이디_RECV.log 로그내용 (소켓 연결) ==
<code>
23:39:28-380 Starting smCLIENT - 아이디_RECV Daemon ..
23:39:28-380 Client [Socket = 11]  [pid cur = 13517 - 13517]
23:39:28-380 SEND: BIND_ACK [result = 0]
23:39:28-380 Success: Write BIND_ACK ...
</code>

== smu_LISTENER.log 로그 내용 ==
<code>
00:00:26-720 RECV: BIND2 [smspia_sr_smsd1-sr_smsd1! : S version = ua-2.1.5;Linux;mysql]
00:00:26-720 Check for remote_ip = 121.254.175.26
00:00:26-720 ip1 [121.254.175.26:121.254.175]
00:00:26-720 Close Socket = 10
00:00:26-720 Wait Bind client = 0
00:00:26-720 fork Child: Pid = 3890 sock = 10
</code>

== smu_LISTENER.log 로그 내용 (사용정지 시) ==
<code>
00:00:03-027 Close Socket = 10
00:00:03-027 Err: ID [gyeongju] 사용 정지 !!!
00:00:03-027 RECV: BIND2 [gyeongju-1234 : R version = WIN2000_MSSQL_20080222_DP_MT_E_M]
00:00:03-027 SEND: BIND_ACK [result = 2]
00:00:03-027 Wait Bind client = 1
</code>

== smu_LISTENER.log 로그 내용 (사용정지 시) ==
<code>
03:24:42-309 Close Socket = 10
03:24:42-309 Wait Bind client = 1
03:24:42-310 Err: Read Socket Error [rc = 0] [Connection reset by peer]
03:24:42-310 Close Socket = 11
03:24:42-310 Wait Bind client = 0
03:24:42-325 Accept New Client Company Socket [49.143.97.133] [10]
03:24:42-325 Err: Read Socket Error [Invalid Length = 1392574464]
03:24:42-325 Close Socket = 10
03:24:42-325 Wait Bind client = 0
03:24:42-332 Accept New Client Company Socket [49.143.97.133] [10]
03:24:42-334 Err: Read Socket Error [Invalid Length = -12]
Dump [length = 11]
11: 00 00 00 71 6A 81 6E 30 81 6B A1                              ...qj.n0.k.
</code>

== smu_LISTENER.log 로그 내용 (클라이언트 아이디 미 존재 시) ==
<code>
00:02:36-144 Close Socket = 10
00:02:36-144 Err: client id [timeelc] 가 없습니다 !!!
00:02:36-144 RECV: BIND2 [timeelc-timeelc : S version = WIN2003_MSSQL_20080222_DP_MT_E_M]
00:02:36-144 SEND: BIND_ACK [result = 2]
</code>

== smu_LISTENER.log 로그 내용 ==
<code>
Close Temp 0 Socket = 10
</code>

== smu_LISTENER.log 로그 내용 ==
<code>
23:10:25-996 Accept New Client Company Socket [121.254.175.26] [10]
23:10:25-996 RECV: BIND2 [smspia_sr_smsd2-sr_smsd2! : R version = ua-2.1.5;Linux;mysql]
23:10:25-996 Check for remote_ip = 121.254.175.26
23:10:25-996 ip1 [121.254.175.26:121.254.175]
23:10:25-996 Err: [smspia_sr_smsd2_RECV] Already Connected ...
23:10:25-996 SEND: BIND_ACK [result = 2]
23:10:25-996 Close Socket = 10
23:10:25-996 Wait Bind client = 0
</code>

== smu_LISTENER.log 로그 내용 (agent -> smurelay 송신 시) ==
<code>
23:30:32-881 RECV: BIND2 [아이디-비밀번호 : S version = ua-2.1.5;Windows NT (unknown);Mssql????????P]
23:30:32-881 Check for remote_ip = IP주소
23:30:32-881 ip1 [IP주소:IP주소]
23:30:32-881 Close Socket = 10
23:30:32-881 Wait Bind client = 0
</code>
^로그내용 구분 값^설명^
|아이디|agent 아이디|
|비밀번호|agent 비밀번호|
|S 또는 R|S:송신, R:수신|
|version|agent의 접속환경|

== smu_LISTENER.log 로그 내용 (MMS smrelay 세션 끊김) ==
<code>
00:26:38-045 ALARM_LEVEL(2): SESSION [아이디 MMSCLI] Session Closed...
</code>

== smu_LISTENER.log 로그 내용 (소켓 연결 시도 후 연결 실패 시) ==
<code>
23:59:55-379 Accept New Client Company Socket [IP주소] [10]
23:59:55-379 Err: Read Socket Error [rc = -1] [Connection reset by peer]
23:59:55-379 Close Socket = 10
23:59:55-379 Wait Bind client = 0
</code>

== smu_LISTENER.log 로그 내용 (SM_SESSION 테이블에 접속정보를 저장) == 
<code>
14:57:30-090 INSERT force into SM_SESSION [smspia_smsd3-S]
14:57:30-090 INSERT force into SM_SESSION [smspia_smsd3-R]
</code>
^로그내용 구분 값^설명^
|smspia_smsd3|agent 아이디|
|S 또는 R|S:송신, R:수신|

== smu_LISTENER.log 로그 내용 (DB QUERY 관련 에러) ==
<code>
15:28:59-404 Err : mysql_real_query in OpenSql() - MySQL server has gone away
</code>

== smu_SDBPROC_1.log 로그 내용 (DB접속 성공 시) ==
<code>
00:01:37-987 MySQL Connect OK!!
</code>

== smu_SDBPROC_1.log 로그 내용 (상태 로그) ==
<code>
23:59:43-631 SEND_STAT : 201405 아이디
</code>

== smu_SDBPROC_1.log 로그 내용 ==
<code>
08:06:13-506 Starting DBQ-ERROR Proc ...
08:06:13-506 SMS_UPDATE: 0003222187 smspia_spam 01062402263 20140511080613 06 7 019 (0-1)
</code>

== smu_SDBPROC_1.log 로그 내용 ==
<code>
20:10:09-986 SESSION_DELETE: aselcni S 19117 (1-28)
20:10:09-986 DBLOG: DELETE SM_SESSION FAIL ID = aselcni PID = 19117 LINETYPE = S
20:10:09-986 DBErr: [2006 : MySQL server has gone away]
</code>

== smu_SDBPROC_1.log 로그 내용 ==
<code>
10:04:46-950 SMS_UPDATE: 0003081561 ohmysmsWeb 01077704889 20140506100446 08 1 019 (0-0)
10:04:46-950 Err : updateSQL [2006-MySQL server has gone away]
10:04:46-950 Err : mysql_real_query in OpenSql() - MySQL server has gone away
10:04:46-950 Err: UPDATE SM_TRAN Fail [2006 : MySQL server has gone away]
10:04:46-950 PUT_ERRQ: 0003081561 ohmysmsWeb 01077704889 (0-1)
</code>

== smu_SDBPROC_1.log 로그 내용 ==
<code>
10:07:25-076 SMS_UPDATE: 0039836733 smspia_sr_smsd1 01052197327 20140506100723 06 3 016 (0-0)
10:07:25-076 Err : mysql_affected_rows() in OpenSql() -
10:07:25-076 Err: UPDATE SM_TRAN Fail [0 : ]
10:07:25-076 PUT_ERRQ: 0039836733 smspia_sr_smsd1 01052197327 (0-3)
</code>

== smu_SDBPROC_1.log 로그 내용 ==

※설명: 세션정보 삭제 시 기록되는 내용입니다.
<code>
SESSION_DELETE: smspia_sr_smsd1 S 19349 (1-2)
</code>

== smu_SDBPROC_1.log 로그 내용 ==

※설명: DB에서 세션정보 삭제 시 기록되는 내용입니다.
<code>
14:39:07-195 SESSION_INSERT: aselcni S 16824 ua-2.1.1;Windows Server 2008 ;sqlse 20140511143906 114.207.244.75-52509 (1-2)
14:39:07-195 Err: INSERT SM_SESSION [2006 : MySQL server has gone away]
14:39:07-195 DBLOG: ID = aselcni PID = 16824 LINETYPE = S
</code>

== smu_SDBPROC_1.log 로그 내용 ==
<code>
PUT_ERRQ: 0037440423 smspia_sr_smsd1 01066484248 (0-2)
PUT_ERRQ: 0037440243 smspia_sr_smsd1 01020700804 0166010328 20140501221633 0 3 (0-1)
</code>

== smu_SDBPROC_1.log 로그 내용 (각 세션의 접속정보를 저장 시) ==
<code>
23:59:52-864 SESSION_INSERT: 아이디 S(송신) 17724 ua-2.1.5;Linux;mysql 20140512235951 121.254.175.26-37117 (1-2)
23:59:52-864 SESSION_INSERT: 아이디 R(수신) 17725 ua-2.1.5;Linux;mysql 20140512235951 121.254.175.26-37117 (0-0)
</code>
^로그내용 구분 값^설명^
|아이디|agent 아이디|
|S 또는 R|S:송신, R:수신|
|17724, 17725|PID|

== smu_SDBPROC_1.log 로그 내용 (각 세션의 접속정보를 저장 실패 시) ==
<code>
00:00:51-374 Err: INSERT SM_SESSION [2006 : MySQL server has gone away]
00:00:51-374 DBLOG: ID = ohmysmsWeb PID = 4242 LINETYPE = S
</code>

== smu_SDBPROC_1.log 로그내용 (SMS 데이터를 INSERT 시) ==
<code>
23:36:36-184 SMS_INSERT: SM_TRAN.TR_NUM값 smspia_sr_smsd1(smspia.com)
 01012345678 01000008520 20140520233636 0 사용자 전송라인(ex. 3)  (97-99)
</code>
^로그내용 구분 값^설명^
|SM_TRAN.TR_NUM값|SM_TRAN.TR_NUM값|
|smspia_sr_smsd1|agent 아이디|
|97-99|DB큐의 CURRENT INDEX 와 LAST INDEX|

== smu_SDBPROC_1.log 로그내용 (SMS 데이터를 UPDATE시) ==
<code>
23:59:12-442 Starting DBQ-ERROR Proc ...
23:59:12-442 SMS_UPDATE: SM_TRAN.TR_NUM값 smspia_sr_smsd1 01012341234 
20140520235912 결과코드 값(ex. 19) 사용자 전송라인(ex. 3)  (0-0) 
</code>
^로그내용 구분 값^설명^
|SM_TRAN.TR_NUM값|SM_TRAN.TR_NUM값|
|smspia_sr_smsd1|agent 아이디|
|0-0|DB큐의 CURRENT INDEX 와 LAST INDEX|

== smu_SDBPROC_1.log 로그내용  ==
<code>
17:52:45-352 Ending DBQ-ERROR Proc ...
17:52:45-352 Err Empty Queue Unlink [/home/ohmysms/binary/smrelay/QUEUE/queue_dberr.que]
</code>

== smu_SDBPROC_1.log 로그내용  ==
<code>
12:06:54-012 Starting DBQ-ERROR Proc ...
12:06:54-012 ERR_INSERT: 0037727633 smspia_sr_smsd1  01071693167 20140502120545 0 3 (0-2)
</code>

== SMS_1.log 로그내용 (대기 시 로그내용)==
<code>
00:09:57-862 SEND: LINK to Dacom-Relay
00:09:57-863 RECV: LINK_CHECK from DACOM
</code>

== SMS_1.log 로그내용 (전송 시 로그내용)==
<code>
15:44:19-850 GETQ: DELIVER - agent 아이디 01012345678 0212345678 3017845 (queue_normal.que:0-0)
15:44:19-850 SEND: DELIVER - 전송아이디 01012345678 0212345678 cpsn=3017845 sn=376575
15:44:19-852 RECV: DELIVER_ACK [sn = 376575] [result: 0]
15:44:43-847 RECV: REPORT - SM137423_004 01058035080 mobile=019 sn=373588 result=8(8)
15:44:43-847 PUTQ: REPORT2 agent 아이디 01058035080 mobile=019 result=8 sn=3015100 (ohmysmsWeb_RECV.que: 0-1)
15:44:50-854 Store Session File = [/home/ohmysms/binary/smrelay/QUEUE/SMS_1.ssf]
15:44:50-854 Write Session .... [gnSerial = 376575] [gnSessCnts = 61]
</code>
^로그내용 구분 값^설명^
|agent 아이디|agent 아이디|
|전송 아이디|sms발송 회원 아이디|
|3017845|사용자가 전송한 TR_NUM값|
|queue_normal.que|queue_normal.que 에서 전송할 메시지 1개를 읽어옴|
|0-1|queue_tran.que의 CURRENT INDEX 와 LAST_INDEX|
|376575|서버의 키값으로 서버키와 dacom.cfg의 index값이 조합되어 SM_TRAN 테이블의 TR_NUM 값|
|gnSerial|현재 서버키 값 (고유 값)|
|gnSessCnts|파일에 저장된 메시지 개수 (REPORT 수신을 대기하고 있는 개수)|

== SMS_1.log 로그내용 (세션 관련 장애 시)==
<code>
23:59:49-041 RECV: REPORT - SM137423 01047826480 mobile=011 sn=5374872 result=6(6)
23:59:49-041 Notice: Not Found Deliver-Ack Session [sn = 5374872] !!!
</code>

== SMS_1.log 로그내용 (전송결과 상태 관련 로그)==
<code>
01:31:38-857 RECV: LINK_CHECK from DACOM
01:32:02-857 RECV: REPORT - SM137423_004 01025860079 mobile=016 sn=323943 result=8(8)
01:32:02-857 PUTQ: REPORT2 ohmysmsWeb 01025860079 mobile=016 result=8 sn=2966322 (ohmysmsWeb_RECV.que: 0-1)
01:32:02-857 STAT: ohmysmsWeb ymd=201405 send=0 succ=0 fail=0 wait=0 dwait=-176
</code>

== SMS_1.log 로그내용 (전송결과 상태 관련 로그)==
<code>
18:03:05-768 TIMEOUT: REPORT - smspia_spam 01090876551 346263 21525309 11
</code>

== SMS_1.log 로그내용 (전송결과 상태 관련 로그)==
<code>
09:02:35-700 GETQ: DELIVER - ireal1 01030027854 01071470497 1 (queue_normal.que:0-0)
09:02:35-700 SEND: DELIVER -  01030027854 01071470497 cpsn=1 sn=355220
09:02:35-700 New STAT id(7)=ireal1 ymd=20140519 nStATs=8
</code>

== smu_MOVER.log 로그내용 (SM_TRAN 테이블의 데이터를 SM_LOG_20140512테이블로 이동) ==
<code>
23:58:06-912 Selected: date=20140512 count=6
23:58:06-917 6 rows insert INTO SM_LOG_20140512
23:58:06-921 6 rows deleted from SM_TRAN
23:59:07-923 MySQL Connect OK!!
</code>

== smu_MOVER.log 로그내용 (agent 담당자에게 문자 발송 시 SC_TRAN 테이블에 알람 추가) ==
<code>
23:56:56-341 ALARM: phone=010-1234-5678 cb=15446815 message=[아이디 MMSCLI 접속이종료되었습니다]
23:56:56-342 MySQL Connect OK!!
</code>

== mmu_MOVER.log 로그내용 (로그테이블 생성) ==
<code>
00:01:37-502 Create IDX [IDX_SM_MMSMST_LOG_201405_1] OK!! 
</code>

== mmu_MOVER.log 로그내용 (월별 겁색관련) ==
<code>
00:03:07-233 Selected: date=201405 count=6
</code>

== mmu_MOVER.log 로그내용 (검색 실패 시) ==
<code>
00:01:37-253 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_mmurelay.SM_MMSLST_LOG_201405' doesn't exist
00:01:37-253 Fail.. SELECT MR_ID FROM SM_MMSMST_LOG_201405 WHERE 1=2
00:01:37-253 No Table...[SM_MMSMST_LOG_201405]
</code>

== mmu_MOVER.log 로그내용 (검색 실패 시) ==
<code>
00:01:37-515 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_mmurelay.SM_LOG_20140501' doesn't exist
00:01:37-253 Fail.. SELECT TR_ID FROM SM_LOG_20140501 WHERE 1=2
00:01:37-253 No Table...[SM_LOG_20140501]
</code>

== smu_RELAY.log 로그내용 ==
<code>
04:00:01-959 [smu_STAT]를 실행합니다..
04:00:01-959 smu_STAT forked ..
</code>

== smu_RELAY.log 로그내용 ==
<code>
06:06:01-934 Err : mysql_real_query in OpenSql() - MySQL server has gone away
06:06:01-934 DB Open Cursor fail !!!
06:06:01-934 MySQL Connect OK!!
</code>

== smu_RELAY.log 로그내용 (회원 정보 설정값 변경 시) ==
<code>
06:07:01-942 Change Client: ireal1 [ipcheck_yn: Y->N]
06:07:01-942 Change Client: smspia_sr_smsd2 [ipcheck_yn: Y->N]
</code>

== smu_RELAY.log 로그내용 (SM_CLIENT 정보 변경 시도 실패) ==
<code>
00:48:59-851 MySQL Connect OK!!
00:49:53-857 Client 통신상태변경 : [id: smspia_sr_smsd1] [sentCnt: 1093116 -> 1093117] [stdCnt: 5039651 -> 5039651] [Month: 201405 -> 201405]
00:49:53-858 Client 통신상태변경: [id: test112] [sentCnt: 0 -> 0] [stdCnt: 0 -> 0] [Month:  -> 201404]
00:49:53-858 Err : mysql_affected_rows() in OpenSql() -
00:49:53-858 Err: UPDATE SM_CLIENT Fail [0 : ][UPDATE SM_CLIENT set CLI_CURMONTH='201404', CLI_SENTCNT=0 WHERE CLI_ID='test112']
</code>

== smu_RELAY.log 로그내용 (mmu_STAT 실행 관련 시) ==
<code>
04:00:00-157 [mmu_STAT]를 실행합니다..
04:00:00-157 mmu_STAT forked ..
</code>

== smu_SPAM.log 로그내용 (쿼리문 에러 시) ==
<code>
18:13:08-755 Err : mysql_real_query in OpenSql() - MySQL server has gone away
</code>

== smu_STAT.log로그내용 (시작 시) ==
<code>
04:00:01-977 Starting - [smu_STAT] !!!!
04:00:01-977 db.start_time = 0400
04:00:01-977 db.min_day = 1
04:00:01-977 db.max_day = 2
04:00:01-977 MySQL Connect OK!!
</code>

== smu_STAT.log로그내용 (쿼리문 에러 관련) ==
<code>
04:00:01-098 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay_test.SM_LOG_20140129' doesn't exist
04:00:01-098 Fail.. SELECT TR_ID FROM SM_LOG_20140129 WHERE 1=2
04:00:01-098 SKIP stat process since [SM_LOG_20140129] table does not exist
04:00:01-098 SM_MMS_LST [20140129] log_table = [SM_MMSLST_LOG_20140129] 데이터를 처리합니다.
04:00:01-098 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay_test.SM_MMSLST_LOG_20140129' doesn't exist
04:00:01-098 Fail.. SELECT MM_ID FROM SM_MMSLST_LOG_20140129 WHERE 1=2
04:00:01-098 SKIP stat process since [SM_MMSLST_LOG_20140129] table does not exist
04:00:01-098 =====================================================
04:00:01-098 SM120MT [20140129] 데이터를 처리합니다.
04:00:01-098 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay_test.SM_LOG_20140129' doesn't exist
04:00:01-098 ERR: SQL=[select  TR_ID, TR_MSGTYPE, IFNULL(TR_NET, '000') TR_NET, sum(if(TR_RSLTSTAT='06',1,0)) SUCC_CNT, count(*) TOT_CNT    from (select TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_SENDSTAT            from SM_TRAN where (TR_SENDDATE between '20140129000000' and '20140129235959') and TR_SENDSTAT in ('1','2')           union all           select  TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_SENDSTAT           from SM_LOG_20140129 where (TR_SENDDATE between '20140129000000' and '20140129235959') and TR_SENDSTAT in ('1','2')) A group by TR_ID, TR_MSGTYPE, IFNULL(TR_NET, '000')]
04:00:01-098 =====================================================
04:00:01-098 SM120MT_MMS [20140129] 데이터를 처리합니다.
04:00:01-098 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay_test.SM_MMSLST_LOG_20140129' doesn't exist
04:01:41-098 [smu_STAT] Program shutdown...
</code>

== smu_STAT.log로그내용 (통계작업 관련) ==
<code>
[SM_LOG_201404] 테이블이 존재합니다. [SM_LOG_201404] 통계작업을 시작합니다.
[SM_MMSLST_LOG_201404] 테이블이 존재하지 않습니다. [SM_MMSLST_LOG_201404] 통계작업은 건너 뜁니다.
</code>

== smu_STAT.log로그내용 (중지 시) ==
<code>
[smu_STAT] Program shutdown...
</code>

== smu_STAT.log로그내용 (백업유형 존재여부 검사 관련)==
<code>
Table [SM_LOG_201404] 존재여부 검사 !!! 백업유형[M]
Table [SM_MMSLST_LOG_201404] 존재여부 검사 !!! 백업유형[M]
</code>

== smu_STAT.log로그내용 (SM_MMSLST_LOG_일자별 테이블 미전재 시)==
<code>
SKIP stat process since [SM_MMSLST_LOG_20140519] table does not exist
</code>

== smu_STAT.log로그내용 (새로운 계정 추가 시)==
<code>
ADD_NEW: id=hrc1978 date=20140430 net=011 type=0 succ=4 tot=4
</code>

== smu_STAT.log로그내용 (에러시: 로그 테이블이 존재하지 않을때 발생) ==
<code>
04:00:02-034 SM_TRAN [20140522] 데이터 처리를 성공
04:00:02-034 =====================================================
04:00:02-034 SM_MMS_LST [20140522] log_table = [SM_MMSLST_LOG_20140522] 데이터를 처리합니다.
04:00:02-034 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay.SM_MMSLST_LOG_20140522' doesn't exist
</code>

== smu_STAT.log로그내용 (SMS 전송 통계 테이블에 데이터 추가 시) ==
<code>
04:00:02-120 SM120MT [20140429] 데이터를 처리합니다
04:00:02-354 ADD: id=아이디 date=20140429 net=011 type=0 succ=21 tot=21
04:00:02-354 ADD: id=아이디 date=20140429 net=016 type=0 succ=18 tot=18
04:00:02-354 ADD: id=아이디 date=20140429 net=019 type=0 succ=14 tot=14
</code>

== smu_STAT.log로그내용 (MMS 전송 통계 테이블에 데이터 추가 시) ==
<code>
04:00:02-120 SM120MT_MMS [20140518] 데이터를 처리합니다.
</code>

== smu_STAT.log로그내용 ==
<code>
04:00:01-746 db.start_time = 0400
04:00:01-746 db.min_day = 1
04:00:01-746 db.max_day = 2
04:00:01-746 MySQL Connect OK!!
04:00:01-748 =====================================================
04:00:01-748 SM_TRAN [20140522] 데이터를 처리합니다.
04:00:01-748 SQL: [replace into SM_STAT select TR_ID, '20140522', '0', TR_MSGTYPE, IFNULL(TR_NET, '000'), sum(if(TR_RSLTSTAT='06',1,0)), 0, sum(if(
TR_RSLTSTAT='05' || TR_RSLTSTAT='07',1,0)), sum(if(TR_RSLTSTAT='00' || TR_RSLTSTAT='05' || TR_RSLTSTAT='06' || TR_RSLTSTAT='07', 0, 1)), sum(if(TR_
RSLTSTAT='00',1, 0 )), count(*) from (select TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_SENDSTAT        from SM_TRAN where TR_SENDDATE >= '20140522
000000' and TR_SENDDATE <= '20140522235959'     and TR_SENDSTAT in ('1','2')    union all       select  TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_
SENDSTAT        from SM_LOG_20140522 where TR_SENDDATE >= '20140522000000' and TR_SENDDATE <= '20140522235959'  and TR_SENDSTAT in ('1','2')) A gro
up by TR_ID, TR_MSGTYPE, IFNULL(TR_NET, '000')]
</code>

== smu_ALARM.log 로그내용 ==
<code>
13:49:01-718 --------------------------------------------------
13:49:01-718 Starting smalert Daemon ..
13:49:01-718 shmSize = 1243016
13:49:01-718 normal_queue_limit = 20000
13:49:01-718 real_queue_limit = 2000
13:49:01-718 batch_queue_limit = 20000
13:49:01-718 db_queue_limit = 100000
13:49:01-718 open queue [queue_alarm.que]
</code>

== smu_ALARM.log 로그내용 ==
<code>
ALARM: dest=01068209315 cb=15446815 QUEUE_ALARM: queue_real.que 임계치 초과 건수: 4146
</code>

== EH_MMS_1.log 로그내용 ==
<code>
00:00:02-340 SEND: LINK_CONFIRM to Client [ctradmin_RECV]
</code>

== EH_MMS_1.log 로그내용 ==
<code>
00:00:05-847 Store Session File = [/home/smspia/binary/smrelay/QUEUE/EH_MMS_1.ssf]
00:00:05-847 Write Session .... [gnSerial = 0] [gnSessCnts = 0]
</code>

== EH_MMS_1.log 로그내용 ==
<code>
Send BIND to DACOM 1 [SM109881-ehan6123]
</code>

== EH_MMS_1.log 로그내용 (소켓 접속 성공 시)==
<code>
Success: Socket Connect Dacom-MMSGW DELIVER [211.233.82.229 - 8100(포트번호)]
</code>

== EH_MMS_1.log 로그내용 ==
<code>
03:24:44-600 Err: Read Socket Error [rc = 0] [No such file or directory]
03:24:44-600 Err: Dacom-MMSGW REPORT socket Closed ...
03:25:00-633 Err: Init_Socket_For_Client : Connect Error [8100][211.233.82.229][Connection refused]
03:25:00-633 Err: Dacom-MMSGW REPORT Socket [211.233.82.229-8100] connect fail !!! [Connection refused]
03:25:00-634 Err: Read Socket Error [rc = 0] [No such file or directory]
03:25:00-634 Err: Dacom-MMSGW DELIVER socket Closed ...
03:25:00-634 Err: Init_Socket_For_Client : Connect Error [8100][211.233.82.229][Connection refused]
03:25:00-634 Err: Dacom-MMSGW DELIVER Socket [211.233.82.229-8100] connect fail !!! [Connection refused]
</code>

== EH_MMS_1.log 로그내용 ==
<code>
00:00:15-769 RECV: PONG from DACOM
</code>

== MMS_2.log 로그내용 (전송 현황 로그 UTQ 부분) ==
<code>
00:00:23-334 PUTQ: MREPORT id=smspia_mms phone=01062283245 netid=KTF result=1000 sn=19343311 (smspia_mms_MRECV.que: 0-1)
00:00:23-334 RECV: REPORT phone=01062283245 net=KTF sn=2319048 result=1000
00:00:23-334 SEND: REPORT_ACK sn=2319048 result=0
00:00:23-334 STAT: smspia_mms ymd=201404 send=0 succ=1 fail=0 wait=1262 dwait=357
</code>

== MMS_2.log 로그내용 (전송 현황 로그 GETQ 부분) ==
<code>
00:00:28-340 GETQ: MT_REQ id=smspia_mms dest=01090760773 cb=01026751719 csn=19348623 (queue_mms_real.que:1-8)
00:00:28-340 SEND: MMS_FILE size=2431
00:00:28-340 SEND: MT_REQ id=smspia_mms sid= cpsn=19348623 sn=2321117
00:00:28-340 Store Session File = [/home/ohmysms/binary/mmrelay/QUEUE/MMS_2.ssf]
00:00:28-340 Write Session .... [gnSerial = 2321116] [gnSessCnts = 1261]
</code>

== MMS_2.log 로그내용 (전송시간 초과) ==
<code>
08:15:08-009 TIMEOUT: MREPORT - smspia_mms 01030553834 sn=20073364 3002
</code>

== MMS_2.log 로그내용 ==
<code>
00:00:28-342 DEL_MMSFILE : /home/ohmysms/binary/mmrelay/MMSFILE/smspia_mms_20140501_19348623.dat
00:00:28-342 GETQ: MT_REQ id=smspia_mms dest=01093531332 cb=01026751719 csn=19348624 (queue_mms_real.que:2-8)
00:00:28-342 ISRT: SESSION phone=01090760773 csn=19348623 sn=2321117 ss=1261
00:00:28-342 PUTQ: MMS_LIST phone=01090760773 tsn=2321117 csn=19348623 (queue_mmsdb.que:0-2)
00:00:28-342 PUTQ: MMS_MASTER  cnts_type=TXT cb=01026751719 nphone=1 ncnts=0 tsn=2321117 csn=19348623 (queue_mmsdb.que:0-1)
00:00:28-342 RECV: MT_RES sn=2321117 result=1000
00:00:28-342 SEND: MMS_FILE size=2431
00:00:28-342 SEND: MT_REQ id=smspia_mms sid= cpsn=19348624 sn=2321118
</code>

== smspia_mms_MSEND.log 로그내용 ==
<code>
00:00:00-456 RECV: PING from Client [smspia_mms_MSEND]
</code>

== smspia_mms_MSEND.log 로그내용 ==
<code>
00:00:27-530 PUTQ: MMS file_size=2431 Bytes queue_mms_real.que:0-1
</code>

== smspia_mms_MSEND.log 로그내용 ==
<code>
00:00:27-530 RECV: MT_REQ dest=01033887279 cb=01026751719 ctype=TXT ipcnt=1 ccnt=0 sn=19348625
</code>

== smspia_mms_MSEND.log 로그내용 ==
<code>
00:00:27-530 SEND: MT_RES sn=19348623 result=1000
</code>

== smspia_mms_MSEND.log 로그내용 ==
<code>
00:00:27-532 PUTQ: MMS file_size=2431 Bytes queue_mms_real.que:0-6
00:00:27-532 PUTQ: MMS file_size=2431 Bytes queue_mms_real.que:0-7
00:00:27-532 PUTQ: MMS file_size=2431 Bytes queue_mms_real.que:0-8
00:00:27-532 RECV: MT_REQ dest=01026889620 cb=01026751719 ctype=TXT ipcnt=1 ccnt=0 sn=19348630
00:00:27-532 RECV: MT_REQ dest=01027270200 cb=01026751719 ctype=TXT ipcnt=1 ccnt=0 sn=19348628
00:00:27-532 RECV: MT_REQ dest=01085949498 cb=01026751719 ctype=TXT ipcnt=1 ccnt=0 sn=19348629
00:00:27-532 RECV: MT_REQ HEADER sn=19348628 text=p ctype=TXT
00:00:27-532 RECV: MT_REQ HEADER sn=19348629 text=p ctype=TXT
00:00:27-532 RECV: MT_REQ HEADER sn=19348630 text=p ctype=TXT
</code>

== smspia_mms_MRECV.log ==
<code>
23:59:58-891 RECV: PING from Client [smspia_mms_MRECV]
</code>

== smspia_mms_MRECV.log ==
<code>
00:00:23-534 GETQ: MREPORT sn=19343311 phone=01062283245 net=KTF result=1000
00:00:23-534 RECV: MREPORT-ACK ....
</code>

== mmu_SDBPROC_1.log ==
<code>
06:57:29-704 Err: SM130MT INSERT Fail [2006:MySQL server has gone away]
</code>

== smu_SDBPROC_1.log ==
<code>
06:57:29-704 Err: SM130MT INSERT Fail [2006:MySQL server has gone away]
</code>

== mmu_MOVER.log 로그내용 (SM_TRAN 테이블의 데이터를 SM_LOG_20140512테이블로 이동) ==
<code>
23:58:06-912 Selected: date=20140512 count=6
23:58:06-917 6 rows insert INTO SM_MMS_20140512
23:58:06-921 6 rows deleted from SM_MMS_LST
23:59:07-923 MySQL Connect OK!!
</code>

== mmu_SDBPROC_2.log ==
<code>
00:02:52-918 CLEAR_STAT : 201404 smspia_mms
</code>

== smu_MDBPROC_1.log 로그 내용 (DB UPDATE 실패시) ==
<code>
10:13:29-440 MMS_LIST_UPDT: id=smspia_mms phone=01095559045 trkey=1382165 cpsn=18481630 (1-3)
10:13:29-440 ERR: MMS_LIST Update fail [UPDATE SM_MMS_LST set MM_SENDSTAT='2', MM_RSLTSTAT='3002', MM_NET='000', MM_RSLTDATE='20140402101328', MM_MODIDATE=now() where MM_NUM=1382165 AND MM_CPNUM=18481630 AND MM_ID='smspia_mms' AND MM_PHONE='01095559045']
10:13:29-440 Err : mysql_real_query in OpenSql() - MySQL server has gone away
10:13:29-440 Err: SM_MMS_MST Read Fail [2006:MySQL server has gone away]
10:13:29-440 SQL: SELECT MR_PHONE_CNT, MR_REPORT_CNT FROM SM_MMS_MST where MR_NUM=1382165 AND MR_CPNUM=18481630 AND MR_ID='smspia_mms'
10:13:29-440 PUT_ERRQ: MMS_LST_UPDATE 1382165 smspia_mms 01095559045 000 3002 (0-1)
</code>

== mmu_MDBPROC_2.log 로그 내용 ==
<code>
10:11:32-175 MMS_MASTER: id=smspia_mms sid= type=TXT cb=0263224277 trkey=1422633 cpsn=18520408 (1-2)
10:11:32-175 MMS_LIST: id=smspia_mms phone=01092241539 cb=0263224277 trkey=1422633 cpsn=18520408 (0-0) 
</code>

== mmu_MDBPROC_2.log 로그 내용 ==
<code>
11:09:19-551 MMS_MASTER: id=smspia_mms sid= type=TXT cb=0230140116 trkey=1425426 cpsn=18522549 (1-2)
11:09:19-551 PUT_ERRQ: MMS_MST_INSERT 1425426 smspia_mms 01033470304 0230140116 2014-04-02 11:09:17 TXT (0-1)
</code>

== mmu_STAT.log 로그 내용 ==
<code>
04:00:00-609 SM_TRAN [20140509] 데이터를 처리를 성공
04:00:00-609 =====================================================
04:00:00-609 SM_MMS_LST [20140509] log_table = [SM_MMSLST_LOG_20140509] 데이터를 처리합니다.
04:00:00-609 Err : mysql_real_query in OpenSql() - Table 'smsrelay_hansoft_smurelay.SM_MMSLST_LOG_20140509' doesn't exist
04:00:00-609 Fail.. SELECT MM_ID FROM SM_MMSLST_LOG_20140509 WHERE 1=2
04:00:00-609 SKIP stat process since [SM_MMSLST_LOG_20140509] table does not exist
04:00:00-609 =====================================================
04:00:00-609 SM_TRAN [20140508] 데이터를 처리합니다.
04:00:00-609 SQL: [replace into SM_STAT select TR_ID, '20140508', '0', TR_MSGTYPE, IFNULL(TR_NET, '000'), sum(if(TR_RSLTSTAT='06',1,0)), 0, sum(if(TR_RSLTSTAT='05' || TR_RSLTSTAT='07',1,0)), sum(if(TR_RSLTSTAT='00' || TR_RSLTSTAT='05' || TR_RSLTSTAT='06' || TR_RSLTSTAT='07', 0, 1)), sum(if(TR_RSLTSTAT='00',1, 0 )), count(*) from (select TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_SENDSTAT  from SM_TRAN where TR_SENDDATE >= '20140508000000' and TR_SENDDATE <= '20140508235959'  and TR_SENDSTAT in ('1','2')    union all   select  TR_ID, TR_MSGTYPE, TR_NET, TR_RSLTSTAT, TR_SENDSTAT     from SM_LOG_20140508 where TR_SENDDATE >= '20140508000000' and TR_SENDDATE <= '20140508235959'  and TR_SENDSTAT in ('1','2')) A group by TR_ID, TR_MSGTYPE, IFNULL(TR_NET, '000')]
</code>

== SEND_RECV.log 로그 내용 ==
<code>
00:13:22-517 smspia_mms PUTQ: MT_REQ sid= pcnt=1 01093297353 01082984242 sn=18884418 (queue_mms_real.que:0-1)
</code>

== SEND_RECV.log 로그 내용 (특정 agent id RECV 다운)==
<code>
아이디_RECV SHUTDOWN !!!
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_sr_smsd1 SEND-3: DELIVERT - 3833352-157287784 (ss=8500) 01194049435 9577 S smspia.com
</code>

== SEND_RECV.log 로그 내용 ==
<code>
mspia_sr_smsd1_RECV SESSION START !! 
</code>

== SEND_RECV.log 로그 내용 ==
<code>
01|1|ireal1_SEND|10분동안 Client 입력이 없어서 자동 종료합니다.
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_sr_smsd1_SEND Client와의 연결 종료되었습니다.
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_sr_smsd1_SEND SHUTDOWN !!!
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_sr_smsd2 RECV-3: REPORT2 - 1788112 01036429225 06 011
smspia_spam RECV-7: REPORT2 - 21469338 01066532228 06 011
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_mms RECV: MREPORT - 19318143 01099646899 4002 KTF  
</code>

== SEND_RECV.log 로그 내용 ==
<code>
smspia_mms SEND: MT_REQ pcnt=1 cpsn=19345131 sn=2333891
</code>

Edit summary

Note: By editing this page you agree to license your content under the following license: CC Attribution-Share Alike 4.0 International

AuditWiki

User Tools

Site Tools

Page Tools