需要改善登录日志记录吗? [英] need to improve the Login logging ?

问题描述

亲爱的所有人
现在我在Mysql服务器上有一个数据库，并且我为局域网用户提供了一个使用C#的接口，现在每个用户使用该软件登录时，该软件都会在用户ID中插入日志(他们是与该软件相关的用户，而不是Mysql服务器用户)在某个表中，还插入登录时间/日期，当用户从软件中存在时，它会插入注销时间/日期
我使用此表来防止同时从两台PC使用同一用户登录，因此，如果用户未注销，则无法从另一台PC重新登录

问题是，如果软件或PC或电源中断发生了问题，该软件不会插入注销时间/日期，因此当用户尝试重新登录时，他将无法访问，因为该软件认为该用户已经登录

那么如何解决这样的问题呢?

谢谢
bye

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

推荐答案

您需要一种允许该操作的机制:类似断电的情况，用户需要具有重置自己的登录名的能力.如何为此设置规则取决于您的要求，但必须有一点信任，或者您需要一个中央管理员或服务台人员来访问应用程序的admin部分，从而允许他们为用户重置.

顺便说一句，这实际上不是数据库问题，而是编码问题，因此应该使用c#或您使用的任何语言(而不是MySql)标记(这与问题无关)

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)

这篇关于需要改善登录日志记录吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！