Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • harald 7 posts 27 karma points
    Nov 07, 2011 @ 11:56
    harald
    0

    can not login to the system

    Umbraco 4.7 has been installed at a virtual server 2008 R2 with asp.NET 4.0 MS SQL database 2008 R2.

    The following problem occurred:
    During the installation process one user has been created with administrative rights. Later, there have been created further user some with and others some without administrative rights.
    I have been using this program for some weeks and there have not been any problems everybody was able to log on with their access codes.
    However, since yesterday nobody is able to log on to the system any more neither user with nor without administrative rights. Although I did not changed any user settings.
    In the table umbracoUser are still all users registered with accurate logins and passwords.

    1st question:
    How is that possible?

    In the table umbracoUserLogins is the column timeout from type BIGINT
    2nd question
    Which time function is hereby used and how can I convert it back into a readable date-time format?

    Who is able to help me as this project is very important to me and I am grateful for every hint!!!


    harald

  • Rodion Novoselov 694 posts 859 karma points
    Nov 07, 2011 @ 12:08
    Rodion Novoselov
    0

    Hi. I've already seen several times that failed user log-in was actually caused just by a failed connection to a database server. So, it's the first thing that I would recommend to check.

  • Tim 1193 posts 2675 karma points MVP 5x c-trib
    Nov 07, 2011 @ 12:27
    Tim
    0

    Hi Harald,

    +1 to what @Rodion said about the database connection

    Also, check the umbracoLog table and see if there's anything being logged in there to do with the failed logins as well, that might provide some more information.

    IIf you have any part of your site that talks directly to the database, test those pages, if they're failing it's definiftely the database connection. If the login page can't reach the database, you just get a login error, as the CMS can't talk to the DB to check the user, and treats it as a failed login!

  • harald 7 posts 27 karma points
    Nov 07, 2011 @ 13:35
    harald
    0

    Hi,

    I have the reason found.

    What theirs say, a failed connection to the database. The password of the umbraco user of the database had expired.

    now, everybody can again  to log on to the system.

    thanks for your rapid response.


    harald

     

     

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies