List:General Discussion« Previous MessageNext Message »
From:Singer Wang Date:October 5 2012 6:14am
Subject:Re: user last activity and log in
View as plain text  
Mellow greetings,

Enhance your calm. Lets get our facts straight and not go off our
rockers. MySQL 5.6 Enterprise edition will be able to do this natively (
https://blogs.oracle.com/MySQL/entry/new_in_mysql_enterprise_edition), but
otherwise you cannot do it natively. This does not mean
its impossible, though as there's a few easy work arounds.

1) Force all logins to use the PAM or AD authentication plugin -- if the
authentication is success then log it in AD or PAM
2) use a init-connect to log logins but that doesn't work for users with
super privileges as Keith mentioned below (thanks Keith for actually trying
to help!)
3) Write your own plugin using the MySQL Plugin APIs
4) use the McAfee Audit Plugin for MySQL (Free:
http://www.devshed.com/c/a/MySQL/McAfee-Releases-Audit-Plugin-for-MySQL-Users-86548/
)


Singer Wang
(yes, I just watched Demolition Man)



On Thu, Oct 4, 2012 at 11:29 PM, Keith Murphy <bmurphy@stripped>wrote:

> My friend Dave Holoboff wrote this up some time ago:
>
>
> http://mysqlhints.blogspot.com/2011/01/how-to-log-user-connections-in-mysql.html
>
> You know you people sound like children.
>
> Really  unprofessional.
>
> Go ahead --- call me names. i left middle school almost 30 years ago. It
> won't bother me.
>
> Can we knock off the name calling and actually offer advice and possible
> solutions? I thought that was what this list was for.
>
> For those of us out in the field doing things ... This might be your
> ticket. It requires a restart of MySQL (which may or may not be acceptable)
> bit it's a fairly clean solution.
>
> Minimal load, easy to query for your last connection time and how often
> connections are made by a user.
>
> Again, requires a restart to enable (and disable) . Oh, and users with
> "super" privileges won't be logged.
>
> Thanks,
>
> Keith
>
> --------------------------
>
> Keith Murphy
> Senior MySQL DBA
> Principal Trainer
> Paragon Consulting Services
> http://www.paragon-cs.com
> 850-637-3877
>
>
>
>
>
>
>
> --
>
> *
> *
> (c) 850-637-3877
>

Thread
user last activity and log inAastha4 Oct
  • Re: user last activity and log inList Man4 Oct
    • Re: user last activity and log inSinger Wang4 Oct
  • Re: user last activity and log inReindl Harald4 Oct
    • Re: user last activity and log inJohan De Meersman4 Oct
      • Re: user last activity and log inAastha4 Oct
        • Re: user last activity and log inReindl Harald4 Oct
          • Re: user last activity and log inJohan De Meersman4 Oct
            • Re: user last activity and log inReindl Harald4 Oct
    • Re: user last activity and log inClaudio Nanni4 Oct
      • RE: user last activity and log inRick James4 Oct
        • Re: user last activity and log inReindl Harald4 Oct
          • Re: user last activity and log inKeith Murphy5 Oct
            • Re: user last activity and log inKeith Murphy5 Oct
            • Re: user last activity and log inSinger Wang5 Oct
              • Re: user last activity and log inSinger Wang5 Oct
              • Re: user last activity and log inJohan De Meersman5 Oct