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

FOG Database View / Login Problem

Scheduled Pinned Locked Moved
FOG Problems
2
4
214
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.
  • M
    MotD
    last edited by Jun 9, 2022, 8:31 AM

    Hi,
    i want to import some PCs via CSV and for this I need the field “osid”. Now I want to look in the database in the table “supportedOS” for the corresponding OSID-Number for Windows10 as described in the documentation.

    But via PHPmyadmin I only get the databases “information_schema” and “phpmyadmin”. With another user I have no access to PHPmyadmin. I suspect that the username I logged in with does not have the necessary rights. But where do I get the correct username and if necessary the password?

    Can anyone help me or give me more information?

    Thanks

    G 1 Reply Last reply Jun 9, 2022, 11:40 AM Reply Quote 0
    • G
      george1421 Moderator @MotD
      last edited by Jun 9, 2022, 11:40 AM

      @motd Well I have a quick answer for you and a bit longer one to your second part.

      How do I find out the image ID number quickly? Look in the image management then create a new image definition. Select the Operating System field. In the drop down list it will list the OS and the OSID in parentheses.

      fod-osid2.png

      The bit longer issue is directly accessing the database. When you installed FOG the installer should have asked you for the root password for the mysql database. This password is not saved anywhere in FOG. So you need to know this password if you want to directly access the database. If you don’t know it you might be able to access the database by using sudo su - to switch to the root user (assuming your current user has sudo rights). Then access the database with mysql -u root and see if it lets you login.

      If that doesn’t work I’ll send you another hint using the FOG Forum chat.

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

      M 1 Reply Last reply Jun 9, 2022, 12:54 PM Reply Quote 0
      • M
        MotD @george1421
        last edited by Jun 9, 2022, 12:54 PM

        @george1421

        Thanks for the quick help.

        A login as root, as described by you, unfortunately does not work. I get the following error message:

        ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

        Regarding the password during the installation, I was also of the opinion to have saved this correctly, however, I can not log in.

        Is there any way to get the correct username and password?

        1 Reply Last reply Reply Quote 0
        • M
          MotD
          last edited by Jun 9, 2022, 12:59 PM

          the hint you sent me via chat has solved the problem great.

          thank you very much.

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

          272

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project