-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathevidence_mysql_logs.txt
More file actions
169 lines (164 loc) · 14.5 KB
/
evidence_mysql_logs.txt
File metadata and controls
169 lines (164 loc) · 14.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
2025-11-04 16:21:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
2025-11-04 16:21:06+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-11-04 16:21:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.44-1.el7 started.
2025-11-04 16:21:06+00:00 [Note] [Entrypoint]: Initializing database files
2025-11-04T16:21:06.860071Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-11-04T16:21:07.215805Z 0 [Warning] InnoDB: New log files created, LSN=45790
2025-11-04T16:21:07.289326Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2025-11-04T16:21:07.303785Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4473f5da-b99a-11f0-815c-b6a4311530ee.
2025-11-04T16:21:07.307431Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-11-04T16:21:07.511890Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:07.511926Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:07.512400Z 0 [Warning] CA certificate ca.pem is self signed.
2025-11-04T16:21:07.565238Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2025-11-04 16:21:10+00:00 [Note] [Entrypoint]: Database files initialized
2025-11-04 16:21:10+00:00 [Note] [Entrypoint]: Starting temporary server
2025-11-04 16:21:10+00:00 [Note] [Entrypoint]: Waiting for server startup
2025-11-04T16:21:11.255433Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-11-04T16:21:11.261358Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 125 ...
2025-11-04T16:21:11.268290Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-11-04T16:21:11.268361Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-11-04T16:21:11.268367Z 0 [Note] InnoDB: Uses event mutexes
2025-11-04T16:21:11.268370Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-11-04T16:21:11.268373Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-11-04T16:21:11.268376Z 0 [Note] InnoDB: Using Linux native AIO
2025-11-04T16:21:11.269103Z 0 [Note] InnoDB: Number of pools: 1
2025-11-04T16:21:11.269408Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-11-04T16:21:11.273868Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2025-11-04T16:21:11.291670Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-11-04T16:21:11.298921Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-11-04T16:21:11.314402Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-11-04T16:21:11.331505Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-11-04T16:21:11.331670Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-11-04T16:21:11.372804Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-11-04T16:21:11.374635Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-11-04T16:21:11.374675Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-11-04T16:21:11.376031Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 2768291
2025-11-04T16:21:11.376393Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-11-04T16:21:11.377633Z 0 [Note] Plugin 'FEDERATED' is disabled.
2025-11-04T16:21:11.380022Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251104 16:21:11
2025-11-04T16:21:11.391476Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-11-04T16:21:11.391529Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-11-04T16:21:11.391536Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:11.391538Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:11.392063Z 0 [Warning] CA certificate ca.pem is self signed.
2025-11-04T16:21:11.392134Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-11-04T16:21:11.397224Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2025-11-04T16:21:11.406189Z 0 [Note] Event Scheduler: Loaded 0 events
2025-11-04T16:21:11.406755Z 0 [Note] mysqld: ready for connections.
Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
2025-11-04 16:21:11+00:00 [Note] [Entrypoint]: Temporary server started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-11-04T16:21:12.039648Z 3 [Note] InnoDB: Stopping purge
2025-11-04T16:21:12.047398Z 3 [Note] InnoDB: Resuming purge
2025-11-04T16:21:12.051513Z 3 [Note] InnoDB: Stopping purge
2025-11-04T16:21:12.058367Z 3 [Note] InnoDB: Resuming purge
2025-11-04T16:21:12.063498Z 3 [Note] InnoDB: Stopping purge
2025-11-04T16:21:12.070766Z 3 [Note] InnoDB: Resuming purge
2025-11-04T16:21:12.074498Z 3 [Note] InnoDB: Stopping purge
2025-11-04T16:21:12.081640Z 3 [Note] InnoDB: Resuming purge
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
2025-11-04 16:21:15+00:00 [Note] [Entrypoint]: Creating database dvwa
2025-11-04 16:21:15+00:00 [Note] [Entrypoint]: Creating user dvwa
2025-11-04 16:21:15+00:00 [Note] [Entrypoint]: Giving user dvwa access to schema dvwa
2025-11-04 16:21:15+00:00 [Note] [Entrypoint]: Stopping temporary server
2025-11-04T16:21:15.408413Z 0 [Note] Giving 0 client threads a chance to die gracefully
2025-11-04T16:21:15.408476Z 0 [Note] Shutting down slave threads
2025-11-04T16:21:15.408483Z 0 [Note] Forcefully disconnecting 0 remaining clients
2025-11-04T16:21:15.408490Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2025-11-04T16:21:15.408590Z 0 [Note] Binlog end
2025-11-04T16:21:15.409141Z 0 [Note] Shutting down plugin 'ngram'
2025-11-04T16:21:15.409182Z 0 [Note] Shutting down plugin 'partition'
2025-11-04T16:21:15.409189Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2025-11-04T16:21:15.409192Z 0 [Note] Shutting down plugin 'ARCHIVE'
2025-11-04T16:21:15.409194Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-11-04T16:21:15.409222Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2025-11-04T16:21:15.409225Z 0 [Note] Shutting down plugin 'MyISAM'
2025-11-04T16:21:15.409234Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2025-11-04T16:21:15.409237Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2025-11-04T16:21:15.409239Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2025-11-04T16:21:15.409241Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2025-11-04T16:21:15.409243Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2025-11-04T16:21:15.409245Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2025-11-04T16:21:15.409246Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2025-11-04T16:21:15.409248Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2025-11-04T16:21:15.409250Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2025-11-04T16:21:15.409252Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2025-11-04T16:21:15.409253Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-11-04T16:21:15.409255Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-11-04T16:21:15.409257Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2025-11-04T16:21:15.409259Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-11-04T16:21:15.409261Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2025-11-04T16:21:15.409263Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-11-04T16:21:15.409264Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2025-11-04T16:21:15.409266Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-11-04T16:21:15.409268Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-11-04T16:21:15.409270Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-11-04T16:21:15.409272Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-11-04T16:21:15.409274Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-11-04T16:21:15.409276Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-11-04T16:21:15.409278Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-11-04T16:21:15.409281Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2025-11-04T16:21:15.409283Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2025-11-04T16:21:15.409285Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2025-11-04T16:21:15.409287Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2025-11-04T16:21:15.409289Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2025-11-04T16:21:15.409292Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2025-11-04T16:21:15.409294Z 0 [Note] Shutting down plugin 'InnoDB'
2025-11-04T16:21:15.409449Z 0 [Note] InnoDB: FTS optimize thread exiting.
2025-11-04T16:21:15.409695Z 0 [Note] InnoDB: Starting shutdown...
2025-11-04T16:21:15.510265Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2025-11-04T16:21:15.510812Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 251104 16:21:15
2025-11-04T16:21:17.151136Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12219419
2025-11-04T16:21:17.156830Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2025-11-04T16:21:17.156892Z 0 [Note] Shutting down plugin 'MEMORY'
2025-11-04T16:21:17.156899Z 0 [Note] Shutting down plugin 'CSV'
2025-11-04T16:21:17.156903Z 0 [Note] Shutting down plugin 'sha256_password'
2025-11-04T16:21:17.156906Z 0 [Note] Shutting down plugin 'mysql_native_password'
2025-11-04T16:21:17.157003Z 0 [Note] Shutting down plugin 'binlog'
2025-11-04T16:21:17.160995Z 0 [Note] mysqld: Shutdown complete
2025-11-04 16:21:17+00:00 [Note] [Entrypoint]: Temporary server stopped
2025-11-04 16:21:17+00:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.
2025-11-04T16:21:17.657122Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2025-11-04T16:21:17.659589Z 0 [Note] mysqld (mysqld 5.7.44) starting as process 1 ...
2025-11-04T16:21:17.664182Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-11-04T16:21:17.664238Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-11-04T16:21:17.664244Z 0 [Note] InnoDB: Uses event mutexes
2025-11-04T16:21:17.664247Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-11-04T16:21:17.664255Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-11-04T16:21:17.664257Z 0 [Note] InnoDB: Using Linux native AIO
2025-11-04T16:21:17.664567Z 0 [Note] InnoDB: Number of pools: 1
2025-11-04T16:21:17.664745Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-11-04T16:21:17.667205Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2025-11-04T16:21:17.677258Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-11-04T16:21:17.681408Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-11-04T16:21:17.694697Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-11-04T16:21:17.707638Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-11-04T16:21:17.707768Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-11-04T16:21:17.736620Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2025-11-04T16:21:17.737375Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-11-04T16:21:17.737412Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-11-04T16:21:17.738484Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 12219419
2025-11-04T16:21:17.738768Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2025-11-04T16:21:17.739131Z 0 [Note] Plugin 'FEDERATED' is disabled.
2025-11-04T16:21:17.742995Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251104 16:21:17
2025-11-04T16:21:17.746649Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-11-04T16:21:17.746700Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-11-04T16:21:17.746707Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:17.746709Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-11-04T16:21:17.747200Z 0 [Warning] CA certificate ca.pem is self signed.
2025-11-04T16:21:17.747277Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-11-04T16:21:17.747617Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2025-11-04T16:21:17.747716Z 0 [Note] IPv6 is available.
2025-11-04T16:21:17.747737Z 0 [Note] - '::' resolves to '::';
2025-11-04T16:21:17.747759Z 0 [Note] Server socket created on IP: '::'.
2025-11-04T16:21:17.751585Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2025-11-04T16:21:17.758763Z 0 [Note] Event Scheduler: Loaded 0 events
2025-11-04T16:21:17.759442Z 0 [Note] mysqld: ready for connections.
Version: '5.7.44' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2025-11-04T18:18:58.012735Z 4 [Note] Got an error reading communication packets
2025-11-04T18:39:12.798730Z 29 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'dvwa'@'%'