[MDEV-18387] 2019-01-27 15:50:07 140300589381376 [Warning] Aborted connection 555 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets) Created: 2019-01-27  Updated: 2019-01-29  Resolved: 2019-01-29

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Reindl Harald Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

can you PLEASE disbale that annoying logging flooding machines running nss_mysql for every local or ssh session started?

besides it's annyoing you can easily write the whole disk full by intention which makes it a DOS attack

2019-01-27 15:50:07 140300589381376 [Warning] Aborted connection 555 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:50:15 140300589995776 [Warning] Aborted connection 557 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:50:16 140300584158976 [Warning] Aborted connection 556 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:55:03 140300589995776 [Warning] Aborted connection 565 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:55:05 140300588766976 [Warning] Aborted connection 567 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:55:05 140300588152576 [Warning] Aborted connection 568 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 15:55:09 140300584466176 [Warning] Aborted connection 566 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300586309376 [Warning] Aborted connection 577 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300589381376 [Warning] Aborted connection 579 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300589995776 [Warning] Aborted connection 581 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300584466176 [Warning] Aborted connection 582 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300584158976 [Warning] Aborted connection 580 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300588152576 [Warning] Aborted connection 584 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300588766976 [Warning] Aborted connection 583 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:01 140300586309376 [Warning] Aborted connection 585 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:02 140300588152576 [Warning] Aborted connection 576 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:13 140300586002176 [Warning] Aborted connection 578 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:00:58 140300588766976 [Warning] Aborted connection 575 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:01:02 140300586309376 [Warning] Aborted connection 593 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:01:02 140300586002176 [Warning] Aborted connection 594 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:01:08 140300588152576 [Warning] Aborted connection 592 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:02:03 140300588766976 [Warning] Aborted connection 599 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:02:06 140300584466176 [Warning] Aborted connection 598 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:03:01 140300586002176 [Warning] Aborted connection 602 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:05:01 140300587230976 [Warning] Aborted connection 605 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:05:01 140300584466176 [Warning] Aborted connection 606 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:05:01 140300588152576 [Warning] Aborted connection 608 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:05:01 140300588766976 [Warning] Aborted connection 607 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:10:01 140300589688576 [Warning] Aborted connection 617 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:10:01 140300588766976 [Warning] Aborted connection 615 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:10:01 140300588152576 [Warning] Aborted connection 616 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:10:01 140300589381376 [Warning] Aborted connection 619 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:10:01 140300586002176 [Warning] Aborted connection 618 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:15:01 140300589381376 [Warning] Aborted connection 627 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:15:02 140300586616576 [Warning] Aborted connection 628 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:15:02 140300584466176 [Warning] Aborted connection 630 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:15:02 140300588766976 [Warning] Aborted connection 631 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)
2019-01-27 16:15:02 140300587230976 [Warning] Aborted connection 629 to db: 'pam_mysql' user: 'pam_mysql' host: 'localhost' (Got an error reading communication packets)

 Comments   
Comment by Elena Stepanova [ 2019-01-28 ]

You can turn the warnings off by setting log_warnings=1 either temporary at runtime or permanently in the config file.

Comment by Reindl Harald [ 2019-01-28 ]

well, that is a global setting while that crap wasn't logged for many years and started with 10.1 or 10.2

Comment by Elena Stepanova [ 2019-01-28 ]

log_warnings was 1 by default up to and including 10.1, and has become 2 by default in 10.2, which is why you've started seeing the extra warnings. If you don't need the extra warnings, just set it back to 1.

Comment by Reindl Harald [ 2019-01-29 ]

switch such debug stuff to on by defualt is pretty dumb given the amount of log messages it creates in case of a bad c,client by intention

Generated at Thu Feb 08 08:43:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.