need to improve the Login logging ?

Question

0.00/5 (No votes)

See more:

Dear ALL
now i have a DB on Mysql server and i have an interface using C# for lan users ,now when each user log in using the software , the software insert the log in userID (they are users related to the software not the Mysql servers users) in a certain table and insert also login time/date and when the user exist from the software , it inserts the logout time/date
i use this table to prevent login using the same USER from two PC at the same time , so if a user is not logout ,it can't login again from another pc

the problem that if a problem happened with the software or the PC or electricity cutoff , the software doesn't insert logout time/date so when the user try relogin , he can't access since the software thinks that the user is already logged on

so how to solve such problem??

thanks
bye

Posted 30-May-11 21:39pm

AhmedOsamaMoh

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**R. Giskard Reventlov** · Accepted Answer · 2011-05-30T21:53:00

You need to have a mechanism that allows for this: something like if the power cuts off a user needs to have the ability to reset their own log in. How you set the rules for this is down to your requirements but there has to be a little trust or you need to have a central administrator or help desk person that has access to an admin part of the application that allows them to reset for a user.

By they way, this isn't really a database issue, it's a coding issue so should have been tagged with c# or whatever language you are using rather than MySql (which is not really relevant to the problem)