[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

MySQL / htaccess authentication with login timestamping

Currently our site runs MySQL autentication to get in. This is via htaccess/MySQL auth. (LAMP based system).

I'm trying to think of a way to timestamp a successful login onto the site. Mainly via logging the successful authentication time into the login Table.

Any ideas on how to approach this would be appreciated.
2 Solutions
You could modify mod_auth_mysql to log anything you need.
Ray PaseurCommented:
You might be able to adapt this design.

The adaptation would write the client identity and the DATETIME values into a log table.  This would happen in the registration script near line 33 and in the login script near line 26.

HTH, ~Ray
kiwistagAuthor Commented:
Thanks, I'll look at these & see how I go :)

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now