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

MySQL troubleshooting

Scheduled Pinned Locked Moved
FOG Problems
6
14
2.9k
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
    moses
    last edited by May 26, 2016, 6:56 PM

    I’m trying to troubleshoot what appears to be a password mismatch between FOG/MySQL.

    The MySQL password is blank, and I’m trying to check what FOG has.

    According to the wiki, the password should be in:

    /var/www/[html]/fog/commons/config.php
    /opt/fog/service/etc/config.php

    The first file doesn’t exist:

    [admin@localhost bin]$ ls /var/www/html/fog/commons/
    base.inc.php  index.php  init.php  schema.php  text.php
    

    and the second file has only one line:

    <?php define('WEBROOT','/var/www/html/fog/');
    

    Am I missing something or does the wiki need to be updated?

    1 Reply Last reply Reply Quote 0
    • S
      Sebastian Roth Moderator
      last edited by Sebastian Roth May 26, 2016, 1:22 PM May 26, 2016, 7:21 PM

      @moses The paths are different for different FOG versions. If I remember correctly you are using FOG trunk. So please take a look at /var/www/{html/,}fog/lib/fog/config.class.php

      Guess we should update the #wiki!

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      T 1 Reply Last reply May 27, 2016, 1:08 PM Reply Quote 2
      • W
        Wayne Workman
        last edited by May 27, 2016, 12:48 AM

        wow that page is super old…

        I’ll see what I can do.

        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!
        Daily Clean Installation Results:
        https://fogtesting.fogproject.us/
        FOG Reporting:
        https://fog-external-reporting-results.fogproject.us/

        1 Reply Last reply Reply Quote 0
        • W
          Wayne Workman
          last edited by Wayne Workman May 26, 2016, 8:29 PM May 27, 2016, 2:26 AM

          @Moderators @Developers @Testers Check it out? https://wiki.fogproject.org/wiki/index.php?title=Password_Central

          I totally re-wrote it.

          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!
          Daily Clean Installation Results:
          https://fogtesting.fogproject.us/
          FOG Reporting:
          https://fog-external-reporting-results.fogproject.us/

          G 1 Reply Last reply May 27, 2016, 3:19 AM Reply Quote 2
          • G
            george1421 Moderator @Wayne Workman
            last edited by May 27, 2016, 3:19 AM

            @Wayne-Workman Looks great.

            The only comment that I would make is to place a disclaimer at the top and somewhere in the middle about soon to be released version 1.3.0 since it has not been officially released yet. One might get the impression that 1.3.0 has been release already. I know its knit picking but we have quite a bit of confusion already with the trunk revisions.

            And this is just a general comment, I wish we could either change the default web admin account from fog or change the linux fog account to something other than fog. I’ve seen admins get this mixed up and think they are changing the password for the web gui and end up changing the linux fog password and breaking image capture.

            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!

            W 1 Reply Last reply May 27, 2016, 3:22 AM Reply Quote 0
            • W
              Wayne Workman @george1421
              last edited by May 27, 2016, 3:22 AM

              @george1421 about the “pending release”… you have no idea how many articles reference FOG 1.3.0 lol. I’m writing for the release, and when that happens, boom, all documentation becomes correct.

              I’m all for changing the default local user and default interface user.

              Make it admin or something. having it as fog just gets the Ubuntu folks locked out of their servers.

              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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              G 1 Reply Last reply May 27, 2016, 3:26 AM Reply Quote 0
              • G
                george1421 Moderator @Wayne Workman
                last edited by May 27, 2016, 3:26 AM

                @Wayne-Workman said in MySQL troubleshooting:

                I’m all for changing the default local user and default interface user.
                Make it admin or something. having it as fog just gets the Ubuntu folks locked out of their servers.

                admin seems to be a consistent default across most open source projects. What ever it is, it should just be different than what the back end service uses (could change the back end service account also). That way there IS a distinction for both the IT admin as well as when we discuss issues in the forum.

                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!

                W 1 Reply Last reply May 27, 2016, 3:31 AM Reply Quote 0
                • W
                  Wayne Workman @george1421
                  last edited by Wayne Workman May 26, 2016, 9:31 PM May 27, 2016, 3:31 AM

                  @george1421 webfog and localfog maybe… or webadmin and localadmin

                  Because, thinking now, probably a lot of Ubuntu people create an account on installation called admin

                  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!
                  Daily Clean Installation Results:
                  https://fogtesting.fogproject.us/
                  FOG Reporting:
                  https://fog-external-reporting-results.fogproject.us/

                  T 1 Reply Last reply May 27, 2016, 10:05 AM Reply Quote 0
                  • Q
                    Quazz Moderator
                    last edited by May 27, 2016, 9:29 AM

                    Are you using Ubuntu 16.04 per chance?

                    M 1 Reply Last reply May 27, 2016, 1:04 PM Reply Quote 0
                    • T
                      Tom Elliott @Wayne Workman
                      last edited by May 27, 2016, 10:05 AM

                      @Wayne-Workman Most people use admin, like @george1421 said.

                      To all,

                      While I understand wanting a change, (which is very simple) I worry about the extent to which people seem to be “worried”.

                      No project, regardless of free, paid, or otherwise, will ever be able to appease everybody. The same thing goes that they can’t be expected to make adjustments for all use cases either.

                      Changing the username makes sense, but since it’s inception, it’s used fog as the main username. As I said, this is not normal, and adds to the confusion of since FTP uses this same methodology.

                      I don’t know if I “should” make the change for the username now though as I’m pretty confident FOG, as it currently stands, is very close to a release compared to even 3 months ago. Making this adjust is simple enough, but when a release is this close, and so many others are already (more or less) used to the GUI as it stands, making just a menial change seems rather moot to me.

                      What worries me (and I suppose this could go for many things) is the idea that people think we should make a full adjustment simple because one or two others ran into an issue once.

                      While I’m all for trying to make things simpler, making a “project” do this for you seems a bit out of order, at least in my eyes. For example:

                      This one time my system failed to upload. To fix this I had to check the disk. Please add disk checking to EVERYTHING because this happened once.

                      At what point should it be expected that the user actually make sure things are okay rather than rely on “source code” to make assumptions and fix things for you? (Then the reverse that we make those changes, and the admin didn’t want them?)

                      One of the things I dislike more than anything is people complaining about text as it’s read. I do understand trying to make things more readable, but to expect that a change “MUST” happen to something as pointless as text, because one person didn’t understand, is a waste of time.

                      I don’t know why I feel like adding this information here but do feel this needs to be stated.

                      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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                      1 Reply Last reply Reply Quote 0
                      • M
                        moses @Quazz
                        last edited by May 27, 2016, 1:04 PM

                        @Quazz Centos 7

                        T 1 Reply Last reply May 27, 2016, 1:07 PM Reply Quote 0
                        • T
                          Tom Elliott @moses
                          last edited by May 27, 2016, 1:07 PM

                          @moses are you still looking for the config file?

                          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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          M 1 Reply Last reply May 27, 2016, 1:32 PM Reply Quote 0
                          • T
                            Tom Elliott @Sebastian Roth
                            last edited by May 27, 2016, 1:08 PM

                            @Sebastian-Roth said in MySQL troubleshooting:

                            @moses The paths are different for different FOG versions. If I remember correctly you are using FOG trunk. So please take a look at /var/www/{html/,}fog/lib/fog/config.class.php

                            Guess we should update the #wiki!

                            If you are here’s the info again.

                            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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                            Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                            Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                            1 Reply Last reply Reply Quote 0
                            • M
                              moses @Tom Elliott
                              last edited by May 27, 2016, 1:32 PM

                              @Tom-Elliott No, I found it. Discovered underlying issues with Centos, not FOG, so I’m taking backups of config and images, and reinstalling.

                              Long story short, systemd got corrupted due to me being an idiot.

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

                              152

                              Online

                              12.0k

                              Users

                              17.3k

                              Topics

                              155.2k

                              Posts
                              Copyright © 2012-2024 FOG Project