• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login

    Cannot login to webui

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    3
    1.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      sampyla
      last edited by

      Hello

      FOG version 32
      I went through all the topics that were telling how to change my password form mysql etc. Tried to change the password from mysql database with:
      mysql -u root fog
      mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;

      after that I went through “/var/www/fog/commons/config.php” and “/opt/fog/service/etc/config.php” and changed all the instances of fog passwords to the one I changed into the mysql.
      After that I did “sudo passwd fog” and changed the system user password to the one I chose.

      And now… I cannot connect to the webui… but I can login to the local computer with the fog user.

      I tried changing all the passwords back to the default one, but now even that wont work.

      I also tried to change the password without the MD5 part but still no use…

      Edit:
      Should the uType and uCreatedDate contain some data? as it is, UcreatedDate is just zeros and dashes, and uType is empty.

      1 Reply Last reply Reply Quote 0
      • S
        sampyla
        last edited by

        Okay I found the problem. The password cannot contain% for some reason… And when I added the password directly through mysql, it borked the whole system. Setting the password back to default with MD5 works wonders.

        1 Reply Last reply Reply Quote 0
        • M
          maltobelli
          last edited by

          % is a wildcard(like * in bash, or Windows explorer) in MySQL when using some operators such as LIKE, it can be escaped and used as a literal % sign by placing a backslash sign in front of it. [CODE]%[/CODE]

          I don’t believe this to directly to be the reason, i assume that fog strips out/substitutes the % sign because it may be used in some sort of web based attack on the fog server. Just guessing though.

          1 Reply Last reply Reply Quote 0
          • 1 / 1
          • First post
            Last post

          165

          Online

          12.1k

          Users

          17.3k

          Topics

          155.3k

          Posts
          Copyright © 2012-2024 FOG Project