List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:October 4 2012 9:39pm
Subject:Re: user last activity and log in
View as plain text  

Am 04.10.2012 23:12, schrieb Johan De Meersman:
> ----- Original Message -----
>> From: "Reindl Harald" reindl@stripped>
>>
>> it does not matter what kind of users
> 
> I'm happy for you that you still have all the answers anyone could ever want,
> Harald.

not all but the one to the topic

IT IS IMPOSSIBLE
MYSQL CAN NOT DO WHAT THE OP WANT

> Regardless of having any background knowledge on the circumstance of the question,
> even.

mysql can not an dwill not log user-logins

> You truly are a gifted individual.

your opinion, but the answer to the question of the OP
is simply "NO you can't"

>> using the "general query log" can only be a bad joke
>> you will log EVERY query and not only log-ins
> 
> Yes, which is why I specified explicitly that it is very much discouraged for
> production use.

it is NOT the answer to the question damned
it doe NOT log the last login of a mysql user in a USEABLE form

> Now you may do things differently, and you may also reach a satisfactory solution; 
> but I am absolutely sick and tired of hearing how your way is the only valid way

i don't give a damn about what you are tired of

the answer to "I want to find the last time the given list of users
logged in. Is there any mysql table from where i can retrieve the data"
is SIMPLY NO and not a useless full query log

> casually implying that the rest of the world are all bloody idiots 

maybe in this case your conclusion i liked to call you
a bloody idiot for bringing full query log as answer
comes because you realized how useless the idea is

> that should just shut up and listen while you tell them every ridiculous 
> way in which they are wrong and inferior

maybe you should shut up yourself as long
you are hypersensible

> learn to accept that there are a lot of different ways to do things

again: your solution "full query log" is not one
if you can't face the truth this is your problem

> and that sometimes people pick their optimal solution on quite different 
> criteria than the ones you use. 

if someone does not like answers he should not ask questions

> There's More Than One Way To Do It.

full query og is none of them

if it takes SIX hours for your reply in the way you did here
my conclusion is that you recently came home drunken and should
go to bed


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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