Playbook #1756
/home/ssh-gateway/ansible/kuly/check-if-mariadb.yaml
Execution
Date 11 Sep 2024 15:12:23 +0100
Duration 00:01:01.73
Controller ssh-gw-4.layershift.com
User root
Versions
Ansible 2.16.4
ara 1.7.1 / 1.7.1
Python 3.10.10
Summary
138 Hosts
3 Tasks
414 Results
1 Plays
6 Files
0 Records
remote_user:root check:False tags:all

Task result details


Field Value
changed 
False
cmd 
set -o pipefail
systemctl status mariadb.service
delta 
0:00:00.019521
end 
2024-09-11 15:13:08.175473
invocation 
{
    "module_args": {
        "_raw_params": "set -o pipefail\nsystemctl status mariadb.service\n",
        "_uses_shell": true,
        "argv": null,
        "chdir": null,
        "creates": null,
        "executable": "/bin/bash",
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
rc 
0
start 
2024-09-11 15:13:08.155952
stderr
stderr_lines 
[]
stdout 
● mariadb.service - MariaDB 10.6.18 database server
   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─override.conf
   Active: active (running) since Tue 2024-08-20 22:25:38 BST; 3 weeks 0 days ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 258569 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 22 (limit: 4152359)
   Memory: 1.6G
   CGroup: /system.slice/mariadb.service
           └─258569 /usr/sbin/mariadbd

Sep 11 14:44:29 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:44:29 667409 [Warning] Aborted connection 667409 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:49:32 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:49:32 667450 [Warning] Aborted connection 667450 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:54:34 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:54:34 667475 [Warning] Aborted connection 667475 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 14:59:36 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:59:36 667496 [Warning] Aborted connection 667496 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:04:38 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:04:38 667535 [Warning] Aborted connection 667535 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:09:40 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:09:40 667561 [Warning] Aborted connection 667561 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Sep 11 15:10:18 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:18 667564 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'
Sep 11 15:10:18 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:18 667565 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'
Sep 11 15:10:19 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:19 667567 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'
Sep 11 15:10:19 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:19 667568 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'
stdout_lines 
[
    "\u25cf mariadb.service - MariaDB 10.6.18 database server",
    "   Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; enabled; vendor preset: disabled)",
    "  Drop-In: /etc/systemd/system/mariadb.service.d",
    "           \u2514\u2500override.conf",
    "   Active: active (running) since Tue 2024-08-20 22:25:38 BST; 3 weeks 0 days ago",
    "     Docs: man:mariadbd(8)",
    "           https://mariadb.com/kb/en/library/systemd/",
    " Main PID: 258569 (mariadbd)",
    "   Status: \"Taking your SQL requests now...\"",
    "    Tasks: 22 (limit: 4152359)",
    "   Memory: 1.6G",
    "   CGroup: /system.slice/mariadb.service",
    "           \u2514\u2500258569 /usr/sbin/mariadbd",
    "",
    "Sep 11 14:44:29 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:44:29 667409 [Warning] Aborted connection 667409 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:49:32 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:49:32 667450 [Warning] Aborted connection 667450 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:54:34 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:54:34 667475 [Warning] Aborted connection 667475 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 14:59:36 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 14:59:36 667496 [Warning] Aborted connection 667496 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:04:38 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:04:38 667535 [Warning] Aborted connection 667535 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:09:40 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:09:40 667561 [Warning] Aborted connection 667561 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)",
    "Sep 11 15:10:18 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:18 667564 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'",
    "Sep 11 15:10:18 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:18 667565 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'",
    "Sep 11 15:10:19 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:19 667567 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'",
    "Sep 11 15:10:19 clever-coral.man-1.vm.plesk-server.com mariadbd[258569]: 2024-09-11 15:10:19 667568 [Warning] Access denied for user 'clients.dev'@'%' to database 'achisomoch_demo'"
]