SingleStore DB

Log Entry Schema for LOGINS-ONLY Level

If your node is configured to use the LOGINS-ONLY logging mode, the log entry uses the following schema:

<log-entry-id>,<timestamp>,<time-zone>,<hostname>:<port>,<node-type>,USER_LOGIN,<thread-id>,<username>,<remote-host>,<user-grant>,<auth-type>,<success or failure>:<reason>

Note: Login data and the database activity can coexist in one file.

The following log entry uses the schema specified above, and it represents a user pac with a successful login attempt:

3,2020-08-11 18:53:18.150,UTC,c770dd909a9c:3306,agg,USER_LOGIN,100000,pac,192.168.0.1,pac@%,mysql_native_password,SUCCESS

The following table describes the fields in the schema, and identifies each of the values in the example above:

Entry

Description

Example Value

log-entry-id

Represents the log entry’s unique identifier.

3

timestamp

The node’s local system time when an operation was executed.

2020-08-11 18:53:18.150

time-zone

Specifies the local time zone when an operation was executed.

UTC

hostname:port

Specifies the node’s hostname and port.

c770dd909a9c:3306

node-type

Specifies whether the node is an agg (aggregator) or a leaf node.

agg

USER LOGIN

A constant which indicates that the record format represents a user login.

USER_LOGIN

thread-id

Id of the thread executing the statement.

100000

user-name

Specifies the username that is trying to log in.

pac

remote-host

Hostname/address from which the client is connecting. This value is detected by the server and not reported by the client.

192.168.0.1

user-grant

The username@hostname specification from the GRANT that defines the user for whom authentication is being attempted.

pac@%

auth-type

Indicates the authentication method which is active (for example native password, pam, Kerberos, etc.), as specified by the GRANT ... IDENTIFIED VIA statement.

mysql_native_password

Success/Failure: <reason>

Indicates the success or failure of the login attempt. The <reason> is populated only for a failed login attempt, it specifies why the login attempt failed.

SUCCESS

For more information on common log entries, see the General Log Entry Schema section above.