List:General Discussion« Previous MessageNext Message »
From:Singer Wang Date:October 5 2012 7:17am
Subject:Re: user last activity and log in
View as plain text  
My bad actually, the MySQL Enterprise Audit is available in MySQL 5.5

S

On Fri, Oct 5, 2012 at 2:14 AM, Singer Wang <wang@stripped> wrote:

> 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