MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 00:56:03 2020 ---------------------------------------------------------------------------- 2020-09-11 00:56:03 notice : syslog logging is enabled. 2020-09-11 00:56:03 notice : maxlog logging is enabled. 2020-09-11 00:56:03 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 00:56:03 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 00:56:03 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 00:56:03 notice : Worker message queue size: 1MiB 2020-09-11 00:56:03 warning: The 'log_debug' option has no effect in release mode. 2020-09-11 00:56:03 notice : The logging of debug messages has been enabled. 2020-09-11 00:56:03 notice : The logging of informational messages has been enabled. 2020-09-11 00:56:03 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 00:56:03 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 00:56:03 notice : Total usable main memory: 3.45GiB. 2020-09-11 00:56:03 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 00:56:03 notice : MaxScale is running in process 17074 2020-09-11 00:56:03 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 00:56:03 notice : Log directory: /var/log/maxscale 2020-09-11 00:56:03 notice : Data directory: /var/lib/maxscale 2020-09-11 00:56:03 notice : Module directory: /usr/lib64/maxscale 2020-09-11 00:56:03 notice : Service cache: /var/cache/maxscale 2020-09-11 00:56:03 notice : Working directory: /var/log/maxscale 2020-09-11 00:56:03 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 00:56:03 info : qc_sqlite loaded. 2020-09-11 00:56:03 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 00:56:03 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 00:56:03 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 00:56:03 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 00:56:03 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846380484352. 2020-09-11 00:56:03 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846372091648. 2020-09-11 00:56:03 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 00:56:03 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846563106560. 2020-09-11 00:56:03 notice : Loading /etc/maxscale.cnf. 2020-09-11 00:56:03 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 00:56:03 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 00:56:03 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 00:56:03 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 00:56:03 notice : (Read-Write-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 00:56:03 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 00:56:03 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 00:56:03 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 00:56:03 notice : Server 'server1' charset: latin1 2020-09-11 00:56:03 notice : Server 'server2' charset: latin1 2020-09-11 00:56:03 notice : Server 'server3' charset: latin1 2020-09-11 00:56:03 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 00:56:03 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 00:56:03 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 00:56:03 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 00:56:03 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 00:56:03 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 00:56:03 notice : Starting a total of 1 services... 2020-09-11 00:56:03 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 00:56:03 notice : Service 'Read-Write-Service' started (1/1) 2020-09-11 00:56:04 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 00:57:01 info : Accept authentication from 'admin', using password. Request: /auth 2020-09-11 00:59:27 info : Accept authentication from 'admin', using password. Request: /auth 2020-09-11 01:00:11 info : Waiting for worker 0xb3cf20. 2020-09-11 01:00:11 info : Worker 0xb3cf20 received shutdown message. 2020-09-11 01:00:11 info : Worker 0xb3cf20 has shut down. 2020-09-11 01:00:11 info : Waited for worker 0xb3cf20. 2020-09-11 01:00:11 notice : Stopped MaxScale REST API 2020-09-11 01:00:11 info : Worker 0xb0f290 received shutdown message. 2020-09-11 01:00:11 info : Worker 0xb0f290 has shut down. 2020-09-11 01:00:11 info : Worker 0xb0ed20 received shutdown message. 2020-09-11 01:00:11 info : Worker 0xb0ed20 has shut down. 2020-09-11 01:00:11 info : Worker 0x7ffd3d1db5b0 received shutdown message. 2020-09-11 01:00:11 info : Worker 0x7ffd3d1db5b0 has shut down. 2020-09-11 01:00:11 notice : MaxScale is shutting down. 2020-09-11 01:00:11 info : Waiting for worker 0xb0ed20. 2020-09-11 01:00:11 info : Waited for worker 0xb0ed20. 2020-09-11 01:00:11 info : Waiting for worker 0xb0f290. 2020-09-11 01:00:11 info : Waited for worker 0xb0f290. 2020-09-11 01:00:11 notice : All workers have shut down. 2020-09-11 01:00:11 info : Destroying 'Read-Write-Service' 2020-09-11 01:00:11 info : Destroying 'Read-Write-Listener' 2020-09-11 01:00:11 notice : MaxScale shutdown completed. 2020-09-11 01:00:11 notice : MaxScale received signal SIGTERM. Exiting. 2020-09-11 01:00:11 MariaDB MaxScale is shut down. ---------------------------------------------------- MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:00:18 2020 ---------------------------------------------------------------------------- 2020-09-11 01:00:18 notice : syslog logging is enabled. 2020-09-11 01:00:18 notice : maxlog logging is enabled. 2020-09-11 01:00:18 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:00:18 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:00:18 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:00:18 notice : Worker message queue size: 1MiB 2020-09-11 01:00:18 notice : The logging of informational messages has been enabled. 2020-09-11 01:00:18 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:00:18 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:00:18 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:00:18 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:00:18 notice : MaxScale is running in process 17194 2020-09-11 01:00:18 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:00:18 notice : Log directory: /var/log/maxscale 2020-09-11 01:00:18 notice : Data directory: /var/lib/maxscale 2020-09-11 01:00:18 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:00:18 notice : Service cache: /var/cache/maxscale 2020-09-11 01:00:18 notice : Working directory: /var/log/maxscale 2020-09-11 01:00:18 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:00:18 info : qc_sqlite loaded. 2020-09-11 01:00:18 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:00:18 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:00:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:18 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783252932352. 2020-09-11 01:00:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783244539648. 2020-09-11 01:00:18 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:00:18 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783435554560. 2020-09-11 01:00:18 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:00:18 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:00:18 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:00:18 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:00:18 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:00:18 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:00:18 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:00:18 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:00:18 notice : Query classifier cache disabled. 2020-09-11 01:00:18 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:00:18 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:00:18 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:00:18 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:00:18 notice : Server 'server1' charset: latin1 2020-09-11 01:00:18 notice : Server 'server2' charset: latin1 2020-09-11 01:00:18 notice : Server 'server3' charset: latin1 2020-09-11 01:00:18 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:00:18 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:00:18 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:00:18 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:00:18 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:00:18 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:00:18 notice : Starting a total of 2 services... 2020-09-11 01:00:18 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:00:18 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:00:18 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:00:18 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:00:19 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:00:19 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:00:33 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:00:36 2020 ---------------------------------------------------------------------------- 2020-09-11 01:00:36 notice : syslog logging is enabled. 2020-09-11 01:00:36 notice : maxlog logging is enabled. 2020-09-11 01:00:36 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:00:36 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:00:36 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:00:36 notice : Worker message queue size: 1MiB 2020-09-11 01:00:36 notice : The logging of informational messages has been enabled. 2020-09-11 01:00:36 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:00:36 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:00:36 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:00:36 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:00:36 notice : MaxScale is running in process 17281 2020-09-11 01:00:36 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:00:36 notice : Log directory: /var/log/maxscale 2020-09-11 01:00:36 notice : Data directory: /var/lib/maxscale 2020-09-11 01:00:36 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:00:36 notice : Service cache: /var/cache/maxscale 2020-09-11 01:00:36 notice : Working directory: /var/log/maxscale 2020-09-11 01:00:36 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:00:36 info : qc_sqlite loaded. 2020-09-11 01:00:36 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:00:36 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:00:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:36 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140023985985280. 2020-09-11 01:00:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140023977592576. 2020-09-11 01:00:36 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:00:36 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140024168607488. 2020-09-11 01:00:36 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:00:36 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:00:36 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:00:36 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:00:36 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:00:36 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:00:36 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:00:36 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:00:36 notice : Query classifier cache disabled. 2020-09-11 01:00:36 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:00:36 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:00:36 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:00:36 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:00:36 notice : Server 'server1' charset: latin1 2020-09-11 01:00:36 notice : Server 'server2' charset: latin1 2020-09-11 01:00:36 notice : Server 'server3' charset: latin1 2020-09-11 01:00:36 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:00:36 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:00:36 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:00:36 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:00:36 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:00:36 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:00:36 notice : Starting a total of 2 services... 2020-09-11 01:00:36 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:00:36 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:00:36 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:00:36 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:00:37 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:00:37 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:00:51 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:00:53 2020 ---------------------------------------------------------------------------- 2020-09-11 01:00:53 notice : syslog logging is enabled. 2020-09-11 01:00:53 notice : maxlog logging is enabled. 2020-09-11 01:00:53 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:00:53 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:00:53 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:00:53 notice : Worker message queue size: 1MiB 2020-09-11 01:00:53 notice : The logging of informational messages has been enabled. 2020-09-11 01:00:53 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:00:53 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:00:53 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:00:53 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:00:53 notice : MaxScale is running in process 17366 2020-09-11 01:00:53 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:00:53 notice : Log directory: /var/log/maxscale 2020-09-11 01:00:53 notice : Data directory: /var/lib/maxscale 2020-09-11 01:00:53 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:00:53 notice : Service cache: /var/cache/maxscale 2020-09-11 01:00:53 notice : Working directory: /var/log/maxscale 2020-09-11 01:00:53 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:00:53 info : qc_sqlite loaded. 2020-09-11 01:00:53 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:00:53 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:00:53 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:53 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:00:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891042522880. 2020-09-11 01:00:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891034130176. 2020-09-11 01:00:53 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:00:53 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891225145088. 2020-09-11 01:00:53 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:00:53 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:00:54 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:00:54 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:00:54 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:00:54 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:00:54 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:00:54 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:00:54 notice : Query classifier cache disabled. 2020-09-11 01:00:54 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:00:54 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:00:54 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:00:54 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:00:54 notice : Server 'server1' charset: latin1 2020-09-11 01:00:54 notice : Server 'server2' charset: latin1 2020-09-11 01:00:54 notice : Server 'server3' charset: latin1 2020-09-11 01:00:54 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:00:54 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:00:54 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:00:54 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:00:54 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:00:54 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:00:54 notice : Starting a total of 2 services... 2020-09-11 01:00:54 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:00:54 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:00:54 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:00:54 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:00:55 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:00:55 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:10:54 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:10:54 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:10:54 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:13:52 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:13:56 2020 ---------------------------------------------------------------------------- 2020-09-11 01:13:56 notice : syslog logging is enabled. 2020-09-11 01:13:56 notice : maxlog logging is enabled. 2020-09-11 01:13:56 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:13:56 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:13:56 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:13:56 notice : Worker message queue size: 1MiB 2020-09-11 01:13:56 notice : The logging of informational messages has been enabled. 2020-09-11 01:13:56 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:13:56 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:13:56 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:13:56 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:13:56 notice : MaxScale is running in process 17644 2020-09-11 01:13:56 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:13:56 notice : Log directory: /var/log/maxscale 2020-09-11 01:13:56 notice : Data directory: /var/lib/maxscale 2020-09-11 01:13:56 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:13:56 notice : Service cache: /var/cache/maxscale 2020-09-11 01:13:56 notice : Working directory: /var/log/maxscale 2020-09-11 01:13:56 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:13:56 info : qc_sqlite loaded. 2020-09-11 01:13:56 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:13:56 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:13:56 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:13:56 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:13:56 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872107972352. 2020-09-11 01:13:56 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872099579648. 2020-09-11 01:13:56 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:13:56 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872290594560. 2020-09-11 01:13:56 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:13:56 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:13:56 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:13:56 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:13:56 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:13:56 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:13:56 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:13:56 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:13:56 notice : Query classifier cache disabled. 2020-09-11 01:13:56 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:13:56 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:13:56 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:13:56 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:13:56 notice : Server 'server1' charset: latin1 2020-09-11 01:13:56 notice : Server 'server2' charset: latin1 2020-09-11 01:13:56 notice : Server 'server3' charset: latin1 2020-09-11 01:13:56 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:13:56 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:13:56 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:13:56 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:13:56 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:13:56 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:13:56 notice : Starting a total of 2 services... 2020-09-11 01:13:56 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:13:56 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:13:56 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:13:56 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:13:57 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:13:57 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:14:49 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:14:52 2020 ---------------------------------------------------------------------------- 2020-09-11 01:14:52 notice : syslog logging is enabled. 2020-09-11 01:14:52 notice : maxlog logging is enabled. 2020-09-11 01:14:52 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:14:52 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:14:52 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:14:52 notice : Worker message queue size: 1MiB 2020-09-11 01:14:52 notice : The logging of informational messages has been enabled. 2020-09-11 01:14:52 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:14:52 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:14:52 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:14:52 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:14:52 notice : MaxScale is running in process 17741 2020-09-11 01:14:52 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:14:52 notice : Log directory: /var/log/maxscale 2020-09-11 01:14:52 notice : Data directory: /var/lib/maxscale 2020-09-11 01:14:52 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:14:52 notice : Service cache: /var/cache/maxscale 2020-09-11 01:14:52 notice : Working directory: /var/log/maxscale 2020-09-11 01:14:52 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:14:52 info : qc_sqlite loaded. 2020-09-11 01:14:52 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:14:52 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:14:52 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:14:52 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:14:52 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690518796032. 2020-09-11 01:14:52 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690510403328. 2020-09-11 01:14:52 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:14:52 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690701418240. 2020-09-11 01:14:52 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:14:52 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:14:52 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:14:52 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:14:52 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:14:52 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:14:52 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:14:52 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:14:52 notice : Query classifier cache disabled. 2020-09-11 01:14:52 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:14:52 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:14:52 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:14:52 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:14:52 notice : Server 'server1' charset: latin1 2020-09-11 01:14:52 notice : Server 'server2' charset: latin1 2020-09-11 01:14:52 notice : Server 'server3' charset: latin1 2020-09-11 01:14:52 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:14:52 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:14:52 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:14:52 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:14:52 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:14:52 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:14:52 notice : Starting a total of 2 services... 2020-09-11 01:14:52 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:14:52 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:14:52 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:14:52 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:14:53 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:14:53 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:15:04 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 01:15:07 2020 ---------------------------------------------------------------------------- 2020-09-11 01:15:07 notice : syslog logging is enabled. 2020-09-11 01:15:07 notice : maxlog logging is enabled. 2020-09-11 01:15:07 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 01:15:07 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 01:15:07 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 01:15:07 notice : Worker message queue size: 1MiB 2020-09-11 01:15:07 notice : The logging of informational messages has been enabled. 2020-09-11 01:15:07 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 01:15:07 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 01:15:07 notice : Total usable main memory: 3.45GiB. 2020-09-11 01:15:07 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 01:15:07 notice : MaxScale is running in process 17828 2020-09-11 01:15:07 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 01:15:07 notice : Log directory: /var/log/maxscale 2020-09-11 01:15:07 notice : Data directory: /var/lib/maxscale 2020-09-11 01:15:07 notice : Module directory: /usr/lib64/maxscale 2020-09-11 01:15:07 notice : Service cache: /var/cache/maxscale 2020-09-11 01:15:07 notice : Working directory: /var/log/maxscale 2020-09-11 01:15:07 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 01:15:07 info : qc_sqlite loaded. 2020-09-11 01:15:07 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 01:15:07 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 01:15:07 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:15:07 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 01:15:07 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017533486848. 2020-09-11 01:15:07 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017525094144. 2020-09-11 01:15:08 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 01:15:08 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017716109056. 2020-09-11 01:15:08 notice : Loading /etc/maxscale.cnf. 2020-09-11 01:15:08 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 01:15:08 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 01:15:08 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 01:15:08 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 01:15:08 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 01:15:08 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 01:15:08 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 01:15:08 notice : Query classifier cache disabled. 2020-09-11 01:15:08 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 01:15:08 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 01:15:08 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 01:15:08 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 01:15:08 notice : Server 'server2' charset: latin1 2020-09-11 01:15:08 notice : Server 'server3' charset: latin1 2020-09-11 01:15:08 notice : Server 'server1' charset: latin1 2020-09-11 01:15:08 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:15:08 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:15:08 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 01:15:08 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 01:15:08 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:15:08 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 01:15:08 notice : Starting a total of 2 services... 2020-09-11 01:15:08 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 01:15:08 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 01:15:08 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 01:15:08 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 01:15:09 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 01:15:09 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 01:20:39 info : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service 2020-09-11 01:20:58 info : Accept authentication from 'admin', using password. Request: /v1/maxscale/modules 2020-09-11 01:25:12 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:25:12 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:25:12 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:26:22 info : Accept authentication from 'admin', using password. Request: /v1/services 2020-09-11 01:26:35 info : Accept authentication from 'admin', using password. Request: /v1/listeners 2020-09-11 01:27:13 info : Accept authentication from 'admin', using password. Request: /v1/servers 2020-09-11 01:28:28 info : (1) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges. 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Target connection counts: 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in server1 Master, Running 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in server2 Slave, Running 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in server3 Slave, Running 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Connected to 'server1' 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Selected Master: server1 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Connected to 'server2' 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Selected Slave: server2 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Connected to 'server3' 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Selected Slave: server3 2020-09-11 01:28:28 info : (1) Started Read-Write-Service client session [1] for 'appuser' from ::ffff:10.0.2.180 2020-09-11 01:28:28 info : (1) Connected to 'server1' with thread id 158 2020-09-11 01:28:28 info : (1) Connected to 'server3' with thread id 939 2020-09-11 01:28:28 info : (1) Connected to 'server2' with thread id 34 2020-09-11 01:28:28 info : (1) (Read-Write-Service) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 37, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: select @@version_comment limit 1 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server2 < 2020-09-11 01:28:28 info : (1) Authentication to 'server1' succeeded. 2020-09-11 01:28:28 info : (1) Authentication to 'server3' succeeded. 2020-09-11 01:28:28 info : (1) Authentication to 'server2' succeeded. 2020-09-11 01:28:28 info : (1) [readwritesplit] (Read-Write-Service) Reply complete, last reply from server2 2020-09-11 01:28:46 info : (1) (Read-Write-Service) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt: 2020-09-11 01:28:46 info : (1) [readwritesplit] (Read-Write-Service) Session write, routing to all servers. 2020-09-11 01:28:46 info : (1) (Read-Write-Service) Execute sescmd 1 on 'server1': 2020-09-11 01:28:46 info : (1) [readwritesplit] (Read-Write-Service) Route query to master: server1 2020-09-11 01:28:46 info : (1) (Read-Write-Service) Execute sescmd 1 on 'server2': 2020-09-11 01:28:46 info : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server2 2020-09-11 01:28:46 info : (1) (Read-Write-Service) Execute sescmd 1 on 'server3': 2020-09-11 01:28:46 info : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server3 2020-09-11 01:28:46 info : Stopped Read-Write-Service client session [1] 2020-09-11 01:28:48 info : (2) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges. 2020-09-11 01:28:48 info : (2) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1 2020-09-11 01:28:48 info : (2) Started Database-Firewall-Service client session [2] for 'appuser' from ::ffff:10.0.2.180 2020-09-11 01:28:48 info : (2) Connected to 'server1' with thread id 159 2020-09-11 01:28:48 info : (2) Authentication to 'server1' succeeded. 2020-09-11 01:28:48 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' select @@version_comment limit 1 2020-09-11 01:28:51 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' SELECT DATABASE() 2020-09-11 01:28:51 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_INIT_DB] to 'server1' 2020-09-11 01:28:51 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' show databases 2020-09-11 01:28:51 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' show tables 2020-09-11 01:28:51 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_FIELD_LIST] to 'server1' 2020-09-11 01:29:07 notice : (2) [dbfwfilter] (Database-Firewall-Service) rule 'example_rule_1': regex matched on query 2020-09-11 01:33:53 info : Pinging 'server1', idle for 301 seconds 2020-09-11 01:33:53 info : (2) Response to COM_CHANGE_USER is OK, writing stored query 2020-09-11 01:35:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:35:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:35:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:38:54 info : Pinging 'server1', idle for 301 seconds 2020-09-11 01:38:54 info : (2) Response to COM_CHANGE_USER is OK, writing stored query 2020-09-11 01:43:55 info : Pinging 'server1', idle for 301 seconds 2020-09-11 01:43:55 info : (2) Response to COM_CHANGE_USER is OK, writing stored query 2020-09-11 01:45:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:45:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:45:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:48:57 info : Pinging 'server1', idle for 301 seconds 2020-09-11 01:48:57 info : (2) Response to COM_CHANGE_USER is OK, writing stored query 2020-09-11 01:53:58 info : Pinging 'server1', idle for 301 seconds 2020-09-11 01:53:58 info : (2) Response to COM_CHANGE_USER is OK, writing stored query 2020-09-11 01:55:14 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 01:55:14 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 01:55:14 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 01:56:11 info : (2) [qc_sqlite] (Database-Firewall-Service) Parsing the query failed, cannot report query type: exot exit 2020-09-11 01:56:11 warning: (2) [dbfwfilter] (Database-Firewall-Service) Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct: exot exit 2020-09-11 01:56:12 info : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1' 2020-09-11 01:56:12 info : Stopped Database-Firewall-Service client session [2] 2020-09-11 02:01:26 info : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. The data was identical to existing user data. 2020-09-11 02:01:26 warning: (3) [mariadbclient] Authentication failed for user 'injection_test'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Access denied for user 'injection_test'@'::ffff:10.0.2.180' (using password: YES)'. 2020-09-11 02:01:26 info : Stopped Database-Firewall-Service client session [3] 2020-09-11 02:05:15 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:05:15 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:05:15 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 02:07:58 info : (4) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'. 2020-09-11 02:07:58 info : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. The data was identical to existing user data. 2020-09-11 02:07:58 warning: (4) [mariadbclient] Authentication failed for user 'appuser'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Unknown database 'injection_test''. 2020-09-11 02:07:58 info : Stopped Database-Firewall-Service client session [4] 2020-09-11 02:11:06 info : (5) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges. 2020-09-11 02:11:06 info : (5) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1 2020-09-11 02:11:06 info : (5) Started Database-Firewall-Service client session [5] for 'appuser' from ::ffff:10.0.2.180 2020-09-11 02:11:06 info : (5) Connected to 'server1' with thread id 162 2020-09-11 02:11:06 info : (5) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' CREATE DATABASE sql_injection 2020-09-11 02:11:06 info : (5) Authentication to 'server1' succeeded. 2020-09-11 02:11:06 info : (5) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1' 2020-09-11 02:11:06 info : Stopped Database-Firewall-Service client session [5] 2020-09-11 02:11:19 info : (6) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges. 2020-09-11 02:11:19 info : (6) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1 2020-09-11 02:11:19 info : (6) Started Database-Firewall-Service client session [6] for 'appuser' from ::ffff:10.0.2.180 2020-09-11 02:11:19 info : (6) Connected to 'server1' with thread id 163 2020-09-11 02:11:19 info : (6) Authentication to 'server1' succeeded. 2020-09-11 02:11:19 info : (6) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' SHOW DATABASES 2020-09-11 02:11:19 info : (6) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1' 2020-09-11 02:11:19 info : Stopped Database-Firewall-Service client session [6] 2020-09-11 02:15:15 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:15:15 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:15:15 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 02:17:01 info : (7) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'. 2020-09-11 02:17:01 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 02:17:01 info : (7) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'. 2020-09-11 02:17:01 warning: (7) [mariadbclient] Authentication failed for user 'appuser'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Unknown database 'injection_test''. 2020-09-11 02:17:01 info : Stopped Database-Firewall-Service client session [7] 2020-09-11 02:17:14 info : (8) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges. 2020-09-11 02:17:14 info : (8) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1 2020-09-11 02:17:14 info : (8) Started Database-Firewall-Service client session [8] for 'appuser' from ::ffff:10.0.2.180 2020-09-11 02:17:14 info : (8) Connected to 'server1' with thread id 165 2020-09-11 02:17:14 info : (8) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' CREATE TABLE users1 AS SELECT * FROM users 2020-09-11 02:17:14 info : (8) Authentication to 'server1' succeeded. 2020-09-11 02:17:14 info : (8) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1' 2020-09-11 02:17:14 info : Stopped Database-Firewall-Service client session [8] 2020-09-11 02:20:17 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 02:20:20 2020 ---------------------------------------------------------------------------- 2020-09-11 02:20:20 notice : syslog logging is enabled. 2020-09-11 02:20:20 notice : maxlog logging is enabled. 2020-09-11 02:20:20 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 02:20:20 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 02:20:20 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 02:20:20 notice : Worker message queue size: 1MiB 2020-09-11 02:20:20 notice : The logging of informational messages has been enabled. 2020-09-11 02:20:20 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 02:20:20 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 02:20:20 notice : Total usable main memory: 3.45GiB. 2020-09-11 02:20:20 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 02:20:20 notice : MaxScale is running in process 18785 2020-09-11 02:20:20 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 02:20:20 notice : Log directory: /var/log/maxscale 2020-09-11 02:20:20 notice : Data directory: /var/lib/maxscale 2020-09-11 02:20:20 notice : Module directory: /usr/lib64/maxscale 2020-09-11 02:20:20 notice : Service cache: /var/cache/maxscale 2020-09-11 02:20:20 notice : Working directory: /var/log/maxscale 2020-09-11 02:20:20 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 02:20:20 info : qc_sqlite loaded. 2020-09-11 02:20:20 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 02:20:20 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 02:20:20 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 02:20:20 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 02:20:20 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989741901568. 2020-09-11 02:20:20 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989733508864. 2020-09-11 02:20:20 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 02:20:20 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989924523776. 2020-09-11 02:20:20 notice : Loading /etc/maxscale.cnf. 2020-09-11 02:20:20 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 02:20:20 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 02:20:20 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 02:20:20 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 02:20:20 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 02:20:20 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 02:20:20 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 02:20:20 notice : Query classifier cache disabled. 2020-09-11 02:20:20 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 02:20:20 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 02:20:20 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 02:20:20 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 02:20:20 notice : Server 'server1' charset: latin1 2020-09-11 02:20:20 notice : Server 'server2' charset: latin1 2020-09-11 02:20:20 notice : Server 'server3' charset: latin1 2020-09-11 02:20:20 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 02:20:20 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 02:20:20 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:20:20 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 02:20:20 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:20:20 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 02:20:20 notice : Starting a total of 2 services... 2020-09-11 02:20:20 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 02:20:20 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 02:20:20 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 02:20:20 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 02:20:21 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 02:20:21 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 02:30:21 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 02:30:21 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:30:21 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:40:21 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:40:21 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 02:40:21 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:50:26 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 02:50:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 02:50:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:00:26 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:00:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:00:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 03:10:27 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:10:27 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:10:27 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 03:20:28 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:20:28 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:20:28 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 03:30:28 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:30:28 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 03:30:28 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:40:28 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:40:28 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:40:28 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 03:50:28 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 03:50:28 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 03:50:28 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:00:29 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:00:29 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 04:00:29 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:10:29 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:10:29 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 04:10:29 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:20:30 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:20:30 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 04:20:30 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:30:31 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:30:31 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 04:30:31 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:40:31 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:40:31 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 04:40:31 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:50:36 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 04:50:36 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 04:50:36 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:00:36 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:00:36 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:00:36 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:10:37 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:10:37 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:10:37 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:20:38 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:20:38 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:20:38 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:30:42 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:30:42 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:30:42 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:40:47 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:40:47 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:40:47 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 05:50:52 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 05:50:52 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 05:50:52 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:00:52 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:00:52 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:00:52 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 06:10:57 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:10:57 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:10:57 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 06:20:58 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:20:58 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:20:58 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 06:30:58 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:30:58 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:30:58 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 06:40:59 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:40:59 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:40:59 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 06:50:59 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 06:50:59 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 06:50:59 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:01:04 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:01:04 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:01:04 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:11:04 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:11:04 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:11:04 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:21:05 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:21:05 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:21:05 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:31:05 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:31:05 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:31:05 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:41:05 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:41:05 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 07:41:05 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:51:06 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 07:51:06 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 07:51:06 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:01:11 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:01:11 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:01:11 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:11:11 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:11:11 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:11:11 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:21:12 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:21:12 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:21:12 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:31:12 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:31:12 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:31:12 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:41:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:41:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:41:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 08:51:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 08:51:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 08:51:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:01:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:01:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 09:01:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:11:13 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:11:13 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 09:11:13 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:21:14 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:21:14 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:21:14 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 09:31:19 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:31:19 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 09:31:19 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:41:19 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:41:19 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 09:41:19 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:51:20 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 09:51:20 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 09:51:20 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:01:21 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 10:01:21 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:01:21 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:11:21 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 10:11:21 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:11:21 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:21:22 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 10:21:22 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:21:22 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:31:22 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 10:31:22 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:31:22 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:41:23 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 10:41:23 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:41:23 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:51:23 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 10:51:23 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 10:51:23 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:01:23 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:01:23 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:01:23 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 11:11:24 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:11:24 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:11:24 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 11:21:24 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:21:24 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 11:21:24 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:31:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 11:31:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:31:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:41:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:41:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 11:41:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:51:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 11:51:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 11:51:26 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:01:26 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:01:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:01:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:11:27 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:11:27 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:11:27 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:16:19 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 12:16:22 2020 ---------------------------------------------------------------------------- 2020-09-11 12:16:22 notice : syslog logging is enabled. 2020-09-11 12:16:22 notice : maxlog logging is enabled. 2020-09-11 12:16:23 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 12:16:23 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 12:16:23 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 12:16:23 notice : Worker message queue size: 1MiB 2020-09-11 12:16:23 notice : The logging of informational messages has been enabled. 2020-09-11 12:16:23 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 12:16:23 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 12:16:23 notice : Total usable main memory: 3.45GiB. 2020-09-11 12:16:23 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 12:16:23 notice : MaxScale is running in process 26842 2020-09-11 12:16:23 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 12:16:23 notice : Log directory: /var/log/maxscale 2020-09-11 12:16:23 notice : Data directory: /var/lib/maxscale 2020-09-11 12:16:23 notice : Module directory: /usr/lib64/maxscale 2020-09-11 12:16:23 notice : Service cache: /var/cache/maxscale 2020-09-11 12:16:23 notice : Working directory: /var/log/maxscale 2020-09-11 12:16:23 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 12:16:23 info : qc_sqlite loaded. 2020-09-11 12:16:23 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 12:16:23 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 12:16:23 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 12:16:23 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 12:16:23 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088009389824. 2020-09-11 12:16:23 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088000997120. 2020-09-11 12:16:23 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 12:16:23 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088192012032. 2020-09-11 12:16:23 notice : Loading /etc/maxscale.cnf. 2020-09-11 12:16:23 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 12:16:23 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 12:16:23 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 12:16:23 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 12:16:23 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 12:16:23 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 12:16:23 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 12:16:23 notice : Query classifier cache disabled. 2020-09-11 12:16:23 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 12:16:23 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 12:16:23 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 12:16:23 notice : Journal file was created 35763 seconds ago. Maximum journal age is 28800 seconds. 2020-09-11 12:16:23 notice : Removing stale journal file for monitor 'MariaDB-Monitor'. 2020-09-11 12:16:23 notice : Server 'server2' charset: latin1 2020-09-11 12:16:23 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:16:23 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 12:16:23 notice : Server 'server1' charset: latin1 2020-09-11 12:16:23 notice : Server 'server3' charset: latin1 2020-09-11 12:16:23 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:16:23 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 12:16:23 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:16:23 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 12:16:23 notice : [mariadbmon] Selecting new master server. 2020-09-11 12:16:23 notice : [mariadbmon] Setting 'server1' as master. 2020-09-11 12:16:23 notice : Server changed state: server1[10.0.2.133:3306]: master_up. [Down] -> [Master, Running] 2020-09-11 12:16:23 notice : Server changed state: server2[10.0.2.47:3306]: slave_up. [Down] -> [Slave, Running] 2020-09-11 12:16:23 notice : Server changed state: server3[10.0.2.254:3306]: slave_up. [Down] -> [Slave, Running] 2020-09-11 12:16:23 notice : Starting a total of 2 services... 2020-09-11 12:16:23 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 12:16:23 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 12:16:23 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 12:16:23 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 12:16:24 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 12:16:24 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 12:26:24 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:26:24 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:26:24 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:36:24 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:36:24 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:36:24 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:46:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:46:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:46:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 12:56:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 12:56:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 12:56:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:06:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:06:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:06:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:16:25 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:16:25 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:16:25 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:26:26 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:26:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:26:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:36:26 info : Accept authentication from 'admin', using password. Request: /auth 2020-09-11 13:36:26 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:36:26 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:36:26 info : Server variables loaded from 'server2', next update in 600 seconds. MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 13:36:29 2020 ---------------------------------------------------------------------------- 2020-09-11 13:36:29 notice : syslog logging is enabled. 2020-09-11 13:36:29 notice : maxlog logging is enabled. 2020-09-11 13:36:29 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 13:36:29 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 13:36:29 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 13:36:29 notice : Worker message queue size: 1MiB 2020-09-11 13:36:29 notice : The logging of informational messages has been enabled. 2020-09-11 13:36:29 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 13:36:29 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 13:36:29 notice : Total usable main memory: 3.45GiB. 2020-09-11 13:36:29 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 13:36:29 notice : MaxScale is running in process 28043 2020-09-11 13:36:29 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 13:36:29 notice : Log directory: /var/log/maxscale 2020-09-11 13:36:29 notice : Data directory: /var/lib/maxscale 2020-09-11 13:36:29 notice : Module directory: /usr/lib64/maxscale 2020-09-11 13:36:29 notice : Service cache: /var/cache/maxscale 2020-09-11 13:36:29 notice : Working directory: /var/log/maxscale 2020-09-11 13:36:29 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 13:36:29 info : qc_sqlite loaded. 2020-09-11 13:36:29 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 13:36:29 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 13:36:29 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:36:29 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:36:29 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474302334720. 2020-09-11 13:36:29 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474220279552. 2020-09-11 13:36:29 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 13:36:29 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474484956928. 2020-09-11 13:36:29 notice : Loading /etc/maxscale.cnf. 2020-09-11 13:36:29 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 13:36:29 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 13:36:29 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 13:36:29 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 13:36:29 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 13:36:29 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 13:36:29 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 13:36:29 notice : Query classifier cache disabled. 2020-09-11 13:36:29 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 13:36:29 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 13:36:29 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 13:36:29 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 13:36:29 notice : Server 'server1' charset: latin1 2020-09-11 13:36:29 notice : Server 'server2' charset: latin1 2020-09-11 13:36:29 notice : Server 'server3' charset: latin1 2020-09-11 13:36:29 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:36:29 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 13:36:29 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:36:29 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 13:36:29 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:36:29 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 13:36:29 notice : Starting a total of 2 services... 2020-09-11 13:36:29 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 13:36:29 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 13:36:29 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 13:36:29 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 13:36:30 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 13:36:30 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 13:37:41 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 13:37:45 2020 ---------------------------------------------------------------------------- 2020-09-11 13:37:45 notice : syslog logging is enabled. 2020-09-11 13:37:45 notice : maxlog logging is enabled. 2020-09-11 13:37:45 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 13:37:45 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 13:37:45 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 13:37:45 notice : Worker message queue size: 1MiB 2020-09-11 13:37:45 notice : The logging of informational messages has been enabled. 2020-09-11 13:37:45 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 13:37:45 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 13:37:45 notice : Total usable main memory: 3.45GiB. 2020-09-11 13:37:45 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 13:37:45 notice : MaxScale is running in process 28147 2020-09-11 13:37:45 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 13:37:45 notice : Log directory: /var/log/maxscale 2020-09-11 13:37:45 notice : Data directory: /var/lib/maxscale 2020-09-11 13:37:45 notice : Module directory: /usr/lib64/maxscale 2020-09-11 13:37:45 notice : Service cache: /var/cache/maxscale 2020-09-11 13:37:45 notice : Working directory: /var/log/maxscale 2020-09-11 13:37:45 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 13:37:45 info : qc_sqlite loaded. 2020-09-11 13:37:45 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 13:37:45 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 13:37:45 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:37:45 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:37:45 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139996919445248. 2020-09-11 13:37:45 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139996911052544. 2020-09-11 13:37:45 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 13:37:45 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 139997102067456. 2020-09-11 13:37:45 notice : Loading /etc/maxscale.cnf. 2020-09-11 13:37:45 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 13:37:45 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 13:37:45 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 13:37:45 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 13:37:45 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 13:37:45 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 13:37:45 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 13:37:45 notice : Query classifier cache disabled. 2020-09-11 13:37:45 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 13:37:45 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 13:37:45 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 13:37:45 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 13:37:45 notice : Server 'server1' charset: latin1 2020-09-11 13:37:45 notice : Server 'server2' charset: latin1 2020-09-11 13:37:45 notice : Server 'server3' charset: latin1 2020-09-11 13:37:45 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:37:45 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 13:37:45 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:37:45 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 13:37:45 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:37:45 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 13:37:45 notice : Starting a total of 2 services... 2020-09-11 13:37:45 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 13:37:45 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 13:37:45 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 13:37:45 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 13:37:46 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 13:37:46 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 13:47:45 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:47:45 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:47:45 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:48:11 info : Accept authentication from 'admin', using password. Request: /auth MariaDB MaxScale /var/log/maxscale/maxscale.log Fri Sep 11 13:48:14 2020 ---------------------------------------------------------------------------- 2020-09-11 13:48:14 notice : syslog logging is enabled. 2020-09-11 13:48:14 notice : maxlog logging is enabled. 2020-09-11 13:48:14 notice : The collection of SQLite memory allocation statistics turned off. 2020-09-11 13:48:14 notice : Threading mode of SQLite set to Multi-thread. 2020-09-11 13:48:14 notice : The systemd watchdog is Enabled. Internal timeout = 30s 2020-09-11 13:48:14 notice : Worker message queue size: 1MiB 2020-09-11 13:48:14 notice : The logging of informational messages has been enabled. 2020-09-11 13:48:14 notice : Using up to 530.07MiB of memory for query classifier cache 2020-09-11 13:48:14 notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores. 2020-09-11 13:48:14 notice : Total usable main memory: 3.45GiB. 2020-09-11 13:48:14 notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664) 2020-09-11 13:48:14 notice : MaxScale is running in process 28469 2020-09-11 13:48:14 notice : Configuration file: /etc/maxscale.cnf 2020-09-11 13:48:14 notice : Log directory: /var/log/maxscale 2020-09-11 13:48:14 notice : Data directory: /var/lib/maxscale 2020-09-11 13:48:14 notice : Module directory: /usr/lib64/maxscale 2020-09-11 13:48:14 notice : Service cache: /var/cache/maxscale 2020-09-11 13:48:14 notice : Working directory: /var/log/maxscale 2020-09-11 13:48:14 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so 2020-09-11 13:48:14 info : qc_sqlite loaded. 2020-09-11 13:48:14 notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB 2020-09-11 13:48:14 notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext. 2020-09-11 13:48:14 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:48:14 info : Epoll instance for listening sockets added to worker epoll instance. 2020-09-11 13:48:14 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548302317312. 2020-09-11 13:48:14 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548293924608. 2020-09-11 13:48:14 notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes. 2020-09-11 13:48:14 info : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548484939520. 2020-09-11 13:48:14 notice : Loading /etc/maxscale.cnf. 2020-09-11 13:48:14 notice : /etc/maxscale.cnf.d does not exist, not reading. 2020-09-11 13:48:14 notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so 2020-09-11 13:48:14 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so 2020-09-11 13:48:14 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so 2020-09-11 13:48:14 notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so 2020-09-11 13:48:14 notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so 2020-09-11 13:48:14 notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache. 2020-09-11 13:48:14 notice : Query classifier cache disabled. 2020-09-11 13:48:14 notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so 2020-09-11 13:48:14 notice : The REST API will be encrypted, all requests must use HTTPS. 2020-09-11 13:48:14 notice : Started REST API on [0.0.0.0]:8989 2020-09-11 13:48:14 info : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat 2020-09-11 13:48:14 notice : Server 'server1' charset: latin1 2020-09-11 13:48:14 notice : Server 'server2' charset: latin1 2020-09-11 13:48:14 notice : Server 'server3' charset: latin1 2020-09-11 13:48:14 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:48:14 notice : Server 'server1' version: 10.4.14-MariaDB-log 2020-09-11 13:48:14 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:48:14 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 13:48:14 notice : Server 'server2' version: 10.4.14-MariaDB-log 2020-09-11 13:48:14 notice : Server 'server3' version: 10.4.14-MariaDB-log 2020-09-11 13:48:14 notice : Starting a total of 2 services... 2020-09-11 13:48:14 notice : (Read-Write-Listener) Listening for connections at [::]:4006 2020-09-11 13:48:14 notice : Service 'Read-Write-Service' started (1/2) 2020-09-11 13:48:14 notice : (Database-Firewall-Listener) Listening for connections at [::]:4004 2020-09-11 13:48:14 notice : Service 'Database-Firewall-Service' started (2/2) 2020-09-11 13:48:15 notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. 2020-09-11 13:48:15 notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'. 2020-09-11 13:58:14 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 13:58:14 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 13:58:14 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:08:15 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:08:15 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:08:15 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 14:18:15 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:18:15 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 14:18:15 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:28:15 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:28:15 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 14:28:15 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:38:16 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:38:16 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 14:38:16 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:48:16 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:48:16 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 14:48:16 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:58:17 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 14:58:17 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 14:58:17 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 15:08:17 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 15:08:17 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 15:08:17 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 15:18:18 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 15:18:18 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 15:18:18 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 15:28:18 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 15:28:18 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 15:28:18 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 15:38:19 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 15:38:19 info : Server variables loaded from 'server2', next update in 600 seconds. 2020-09-11 15:38:19 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 15:48:24 info : Server variables loaded from 'server1', next update in 600 seconds. 2020-09-11 15:48:24 info : Server variables loaded from 'server3', next update in 600 seconds. 2020-09-11 15:48:24 info : Server variables loaded from 'server2', next update in 600 seconds.