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

    Invalid user after schema creation

    Scheduled Pinned Locked Moved
    FOG Problems
    2
    4
    1.6k
    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.
    • R
      RobertDupont
      last edited by

      Hi,

      I’m setting up FOG on a debian squeeze (6.0) but I ran into issues.
      I arrived to the point I can open the web interface to set up the schema on the database.
      When I click on the button to create the schema, it throws me an error:

      Database error: (ID# 15-18)
      Database Error:
      Access denied for user ‘focuser’@‘localhost’ to database ‘fog’

      What is weird is when I log in on the DB using ‘foguser’ as user (using mysql command line) is that I can see a bunch of tables created so the credentials must be right. If I try to run it again, it gives me another error about an existing column.

      I searched in the wiki and I tried to debug with a user in the IRC channel but we couldn’t figure out what was wrong in the configuration.

      Would you have any idea where I should look to fix the issue? Or maybe is there a flag to force it to think the DB schema is done somewhere in a file or in the DB?
      Is there any way I can debug this problem? Is there any flag to enable debug?

      1 Reply Last reply Reply Quote 0
      • C
        chad-bisd Moderator
        last edited by

        Focuser or foguser?

        Do you have a password in MySQL for the fog user? If so, did you update the config file?


        If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

        1 Reply Last reply Reply Quote 0
        • R
          RobertDupont
          last edited by

          Sorry, mistyped, it’s ‘foguser’.

          Yes. It wouldn’t have created the database (partially) if it wasn’t there.

          By the way, here is a list of the tables it created. I don’t know if it’s complete or not:

          [FONT=courier new]mysql> show tables;[/FONT]
          [FONT=courier new]±-----------------------+[/FONT]
          [FONT=courier new]| Tables_in_fog |[/FONT]
          [FONT=courier new]±-----------------------+[/FONT]
          [FONT=courier new]| aloLog |[/FONT]
          [FONT=courier new]| clientUpdates |[/FONT]
          [FONT=courier new]| dirCleaner |[/FONT]
          [FONT=courier new]| globalSettings |[/FONT]
          [FONT=courier new]| greenFog |[/FONT]
          [FONT=courier new]| groupMembers |[/FONT]
          [FONT=courier new]| groups |[/FONT]
          [FONT=courier new]| history |[/FONT]
          [FONT=courier new]| hostAutoLogOut |[/FONT]
          [FONT=courier new]| hostScreenSettings |[/FONT]
          [FONT=courier new]| hosts |[/FONT]
          [FONT=courier new]| images |[/FONT]
          [FONT=courier new]| imagingLog |[/FONT]
          [FONT=courier new]| inventory |[/FONT]
          [FONT=courier new]| moduleStatusByHost |[/FONT]
          [FONT=courier new]| multicastSessions |[/FONT]
          [FONT=courier new]| multicastSessionsAssoc |[/FONT]
          [FONT=courier new]| nfsFailures |[/FONT]
          [FONT=courier new]| nfsGroupMembers |[/FONT]
          [FONT=courier new]| nfsGroups |[/FONT]
          [FONT=courier new]| plugins |[/FONT]
          [FONT=courier new]| printerAssoc |[/FONT]
          [FONT=courier new]| printers |[/FONT]
          [FONT=courier new]| schemaVersion |[/FONT]
          [FONT=courier new]| snapinAssoc |[/FONT]
          [FONT=courier new]| snapinJobs |[/FONT]
          [FONT=courier new]| snapinTasks |[/FONT]
          [FONT=courier new]| snapins |[/FONT]
          [FONT=courier new]| supportedOS |[/FONT]
          [FONT=courier new]| tasks |[/FONT]
          [FONT=courier new]| userCleanup |[/FONT]
          [FONT=courier new]| userTracking |[/FONT]
          [FONT=courier new]| users |[/FONT]
          [FONT=courier new]| virus |[/FONT]
          [FONT=courier new]±-----------------------+[/FONT]
          [FONT=courier new]34 rows in set (0.00 sec)[/FONT]

          1 Reply Last reply Reply Quote 0
          • R
            RobertDupont
            last edited by

            I blew the installation and set up Ubuntu 10.4 and it worked fine.

            The only difference with the Debian is that I set up a password for the root user for MySQL on Debian (and created a user that was granted all rights to the whole DB; and provided that information in the fog config file as explained).

            Thanks anyway 🙂

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

            144

            Online

            12.0k

            Users

            17.3k

            Topics

            155.2k

            Posts
            Copyright © 2012-2024 FOG Project