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

    Problems with fog homepage

    Scheduled Pinned Locked Moved Solved
    FOG Problems
    4
    21
    5.0k
    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.
    • Z
      zln1996
      last edited by

      Hi,

      I was experiencing an issue with our fog server not loading the homepage, so I updated to the current stable build. The problem persisted so I went ahead and updated to the most current release. The issue is when I try to go to http://<server-ip>/fog/management I get an error in firefox that it would keep redirecting forever. I know after you update fog, you need to update the schema, and I have experienced database connection issues in the past could this be what the problem is? Fog is running on a 16.04 Ubuntu machine. Any help with this would be greatly appreciated!

      Thanks

      1 Reply Last reply Reply Quote 0
      • Z
        zln1996 @KnightRaven
        last edited by

        @KnightRaven There are no words to describe how happy I am right now. I finally got it working and I’m in fog again and everything looks okay! Knight I want to thank you so much for your help you had me on the right path all along, however, I did have to do a few extra steps. I’m going to explain so if anyone has this issue later on and they stumble upon this post hopefully it will help them out.

        First thing is the reason I could never get mysqld to start is during the installation of mySQL it never created the directory /var/run/mysqld so that’s why it would never start a mysql instance. So using these commands you can accomplish that.

        mkdir -p /var/run/mysqld
        chown mysql:mysql /var/run/mysqld
        

        Once that was done, make sure all instances of regular mysql is gone. I used killall mysql and then to verify killall -9 mysql Then I ran the following command

        mysqld_safe --skip-grant-tables --skip-networking &
        

        Once that is done you’ll need to open a different terminal. And do the following:

        mysql -u root
        

        If all is well you should now be in the database once more, here I checked for the user account like you mentioned Knight, but mine seemed to still be in there. So if the user is there use the following commands (this is what I had to do in my case, since my root user still existed)

        use mysql;
        update user set authentication_string=PASSWORD('<YOURPASSWORDHERE>') where user='root';
        flush privileges;
        \q
        

        So now your password should be updated, so now to verify kill all of the mysqld instances and start the regular mysql ones. This can be accomplished by the following.

        killall mysqld
        service mysql start
        #now you can check your new password...
        mysql -u root -p
        #Enter your password and you should be brought to the following prompt...
        mysql>
        

        After that I was able to get to the fog homepage and update my schema, and now I’m back in with everything in tact. After this was done I followed Tom’s advice and disabled automatic updates because I’m really tired of Ubuntu breaking everything lol.

        I hope this helps any future readers, so you don’t have to go through this madness like I did. Turn off automatic updates as soon as you can, because from my experience it only causes issues, and if you have to update your Ubuntu fog machine prepare for problems.

        I also want’s to extend one last thanks to @KnightRaven @Tom-Elliott and @george1421 for their help on this, you guys rock!

        Along with everyone else’s references here is the one I used: https://askubuntu.com/questions/489098/unable-to-reset-root-password-of-mysql

        KnightRavenK 1 Reply Last reply Reply Quote 1
        • george1421G
          george1421 Moderator
          last edited by george1421

          Did you happen to have a redirection in place where if you keyed in http://<fog_IP> it would redirect you to the fog login page?

          It sounds similar to this issue: https://forums.fogproject.org/topic/10093/updated-to-fog-1-4-0-getting-blank-white-page/6

          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!

          1 Reply Last reply Reply Quote 0
          • Z
            zln1996
            last edited by

            I never set up a redirect for fog, I would always key in the whole server address. In the location Tom specified in his first post in the article you shared i don’t have an index.php I do have an index.html. I attempted to do what Wanderson posted but the issue is still occuring. I don’t necessarily believe it’s an issue with the update itself as this was a problem before I upgraded fog.

            george1421G 1 Reply Last reply Reply Quote 0
            • george1421G
              george1421 Moderator @zln1996
              last edited by

              @zln1996 does the apache error log provide any insight?

              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!

              Z 1 Reply Last reply Reply Quote 0
              • Z
                zln1996 @george1421
                last edited by zln1996

                @george1421 I do see a re-direct occuring no matter what i put in for example: http://<server-ip>/asdfasdf it adds “?node=schema” don’t know if that helps any. As for the error logs see below, I have omitted the server ip intentionally. The error there may be because I was messing around with the settings in that article, so after you told me to check the log out I restarted the apache2 service and tried to pull the page up, but the error never showed up again in the error log.

                [Wed May 17 17:19:29.081733 2017] [php7:error] [pid 29225] [client x.x.x.x:37264] PHP Fatal error: Uncaught Error: Call to a member function lastInsertId() on boolean in /var/www/fog/lib/db/pdodb.class.php:443\nStack trace:\n#0 /var/www/fog/lib/fog/fogcontroller.class.php(527): PDODB->insertId()\n#1 /var/www/fog/lib/fog/hookmanager.class.php(176): FOGController->save()\n#2 /var/www/fog/lib/fog/fogpagemanager.class.php(82): HookManager->processEvent(‘SEARCH_PAGES’, Array)\n#3 [internal function]: FOGPageManager->__construct()\n#4 /var/www/fog/lib/fog/fogbase.class.php(457): ReflectionClass->newInstanceArgs(Array)\n#5 /var/www/fog/management/index.php(23): FOGBase::getClass(‘FOGPageManager’)\n#6 {main}\n thrown in /var/www/fog/lib/db/pdodb.class.php on line 443
                [Wed May 17 17:35:14.867060 2017] [mpm_prefork:notice] [pid 29220] AH00169: caught SIGTERM, shutting down
                [Wed May 17 17:35:14.959750 2017] [mpm_prefork:notice] [pid 29342] AH00163: Apache/2.4.25 (Ubuntu) OpenSSL/1.0.2k configured – resuming normal operations
                [Wed May 17 17:35:14.959797 2017] [core:notice] [pid 29342] AH00094: Command line: ‘/usr/sbin/apache2’

                Edit: After about 18 mins the above error populated to the apache error log.

                george1421G 1 Reply Last reply Reply Quote 0
                • george1421G
                  george1421 Moderator @zln1996
                  last edited by

                  @zln1996 Well it looks like we are going to need one of the @Developers look at this error. Its not ringing any bells for me.

                  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!

                  Z 1 Reply Last reply Reply Quote 0
                  • Z
                    zln1996 @george1421
                    last edited by

                    @george1421 Okay thanks for your help man, I really appreciate you looking at this with me!

                    Tom ElliottT 1 Reply Last reply Reply Quote 0
                    • Tom ElliottT
                      Tom Elliott @zln1996
                      last edited by

                      @zln1996 please try the manual instructions here: https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

                      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

                      Z 1 Reply Last reply Reply Quote 0
                      • Z
                        zln1996 @Tom Elliott
                        last edited by

                        @Tom-Elliott I did the steps you provided, the second command worked on that post, but now it’s still a blank screen and I can’t get into the mySQL database.

                        Tom ElliottT 1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott @zln1996
                          last edited by

                          @zln1996 What do you mean the second command worked? What second command?

                          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

                          Z 1 Reply Last reply Reply Quote 0
                          • Z
                            zln1996 @Tom Elliott
                            last edited by

                            @Tom-Elliott ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ''; that one actually executed the first failed, but like I said after this command I still was unable to get to the homepage of fog, and now I can’t seem to login to my sql database.

                            KnightRavenK 1 Reply Last reply Reply Quote 0
                            • KnightRavenK
                              KnightRaven @zln1996
                              last edited by

                              @zln1996
                              I had troubles this past week after updating as well. My issues I’m sure was due to my own clumsyness. We had a fire drill and in my haste I kicked the power to the station during fog update. The DB was not in good shape after and had similar problems. I am by no means a MySQL/DB pro so please use caution with my assistance.

                              So what I found was to stop mysql service and use this command to get into the DB…

                              sudo mysqld --skip-grant-tables
                              

                              Then in another terminal run:

                              mysql
                              use mysql
                              

                              After trying a bunch of other things(table repairs and such) I realized the root account was missing(as were others).
                              You can use this to check existance and should show rights assigned.

                              select * from user where User='root';
                              
                              

                              I can’t find the page that helped me most but I think next is:

                              FLUSH PRIVILEGES
                              #if root doesnt exist...
                              insert into user (Host, User, Password) values ('localhost','root','');
                              
                              #IF/after root exists...
                              update user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',Reload_priv='Y',Shutdown_priv='Y',Process_priv='Y',File_priv='Y',Grant_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Show_db_priv='Y',Super_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Repl_slave_priv='Y',Repl_client_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y',Create_user_priv='Y' where user='root';
                              
                              #
                              grant all privileges on *.* to 'root'@'%' with grant option;
                              grant all privileges on *.* to 'root'@'localhost' with grant option;
                              

                              while I didnt use this site:http://www.helpfromfriend.com/featured/how-to-recreate-root-account-in-mysql/ initially ,
                              it does layout basically what i had to do.

                              you may need to add: IDENTIFIED WITH mysql_native_password BY ‘’ to the end of the GRANT statements. I think I had to.

                              If you want to check/repair tablesyou can check this site on how to:
                              http://www.thegeekstuff.com/2011/12/mysqlcheck

                              The experts here may over rule me but it helped me.

                              hopefully this helps you. Or at least someone.

                              Jason

                              A wise man knows he can always grow wiser.

                              99 little bugs in the code, 99 little bugs
                              Fix one bug, save it again…
                              101 little bugs in the code

                              Z 1 Reply Last reply Reply Quote 2
                              • Z
                                zln1996 @KnightRaven
                                last edited by

                                @KnightRaven Thanks for the help man! I am definitely not in anyway a SQL pro lol, so I tried what you did. I used the command sudo service mysql stop and then ran the first command. When I attempted to run the second command I receive this error: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) I then checked the status of the mysql service and it was still stopped. I also attempted the command in the article you provided /etc/init.d/mysql stop mysqld_safe --skip-grant-tables but that was also to no avail. I even attempted to replace “stop” with “start” in that command but that didn’t work either. :L

                                KnightRavenK 1 Reply Last reply Reply Quote 0
                                • KnightRavenK
                                  KnightRaven @zln1996
                                  last edited by

                                  @zln1996
                                  hmmm… Maybe the server isn’t stopping all the way. I think you can try:

                                  killall mysqld
                                  

                                  Mine gave me this error as well but don’t rem. what all I did now.

                                  You may also need to check your mysql config file “my.cnf”.
                                  should be located in /etc/mysql/my.cnf
                                  while I didn’t find them here, you can also check:
                                  /etc/my.cnf
                                  /var/lib/mysql/my.cnf

                                  Make sure any IPs match your server and check where it says the .sock file is supposed to be. There is also a bind statement listed, but from what I read(and as was in my file) it should be commented out.
                                  As I checked mine just now I don’t see any IPs or names other than at the bind-address which is commented out.

                                  You could also try just making the .sock file:

                                  touch /var/run/mysqld/myssqld.sock
                                  

                                  keep in mind when making these changes you will need to use sudo or run as root(sudo -i).

                                  Check your error.log file in /var/log/mysql/error.log
                                  It may have some more info.
                                  also: /var/log/mysql.err and /var/log/mysql.log
                                  although for me the last two were empty.

                                  Now I will tell you that I eventually re-installed mysql but I would use that as a last resort. My DB data stayed intact(as far as fog info goes anyway) but I may have been lucky.

                                  after re-installing I used the steps provided previously to re-add the root user and it’s rights. I didn’t realize the root user was gone til after the re-install so I figure I may not have had to do that.

                                  A wise man knows he can always grow wiser.

                                  99 little bugs in the code, 99 little bugs
                                  Fix one bug, save it again…
                                  101 little bugs in the code

                                  Z 1 Reply Last reply Reply Quote 1
                                  • Z
                                    zln1996 @KnightRaven
                                    last edited by

                                    @KnightRaven Okay thanks man, I’m about to try those things and see if it works for me. If it doesn’t I may resort to uninstalling mySQL.

                                    Maybe @Tom-Elliott could answer, whether or not, my fog database should stay intact if I uninstall and then re-install mySQL?

                                    Also Knight, what commands did you run to uninstall mySQL and re-install it? The ones I found seem to get rid of anything SQL related.

                                    KnightRavenK 2 Replies Last reply Reply Quote 0
                                    • KnightRavenK
                                      KnightRaven @zln1996
                                      last edited by

                                      @zln1996
                                      I forgot to mention you can use

                                      ps -ef | grep mysql
                                      

                                      to find other potential instances of mysql running.

                                      as far as removal goes…

                                      sudo apt-get remove --purge mysql-server mysql-client mysql-common
                                      sudo apt-get autoremove
                                      sudo apt-get autoclean
                                      

                                      then to re-install…

                                      sudo apt-get update
                                      sudo apt-get install mysql-server mysql-client mysql-common
                                      

                                      If you don’t have a .sql backup you can try backing up these folders:
                                      /etc/mysql and /var/lib/mysql
                                      it looks like, at least on mine, that the data is in /var/lib/mysql. It has matching info for my databases anyway.

                                      Using --purge will certainly get rid of config files. Maybe it leaves the data though?

                                      If this is a full blown live production server I might wait til i hear back from one of the Fog pros. While I use mine regularly it is not mission critical so to speak. I also had backups I could use. I was also prepared that I would have to just manually re-enter the image info as the files would still be there.
                                      My killer would have been losing my advanced pxe scripts lol.

                                      A wise man knows he can always grow wiser.

                                      99 little bugs in the code, 99 little bugs
                                      Fix one bug, save it again…
                                      101 little bugs in the code

                                      1 Reply Last reply Reply Quote 1
                                      • KnightRavenK
                                        KnightRaven @zln1996
                                        last edited by

                                        @zln1996
                                        Also you are quite welcome. I just hope its useful info. These guys on here have helped me quite a bit to keep things running and setup stuff. So I try to help or add my $.02 worth.

                                        I dunno they might would like for me to stop. 😏

                                        A wise man knows he can always grow wiser.

                                        99 little bugs in the code, 99 little bugs
                                        Fix one bug, save it again…
                                        101 little bugs in the code

                                        Z 1 Reply Last reply Reply Quote 1
                                        • Z
                                          zln1996 @KnightRaven
                                          last edited by

                                          @KnightRaven This is driving me insane lol, Ubuntu absolutely hates me. I completely removed sql and reinstalled it, and it still denies access to everything. The only other thing I can think of doing is saving my images then installing Ubuntu and fog again.

                                          Any ideas? Or does this seem like the only other option?

                                          KnightRavenK 1 Reply Last reply Reply Quote 0
                                          • KnightRavenK
                                            KnightRaven @zln1996
                                            last edited by

                                            @zln1996
                                            Wow. I’m not really sure. I would hate to think you’d have to go that extreme. Maybe someone else knows better than I.

                                            However…
                                            Did it ask you for a password during re-install? I will say that mine did but the login still didn’t work. Root was still missing I still had to use the --skip-grant-tables to get in. There is also a network related switch/option but I don’t know for sure what that does. Maybe skips issues if it denies login from localhost?
                                            I think its --skip-networking. You can try that. I may have used both now that I think about it. I’ve slept a couple of times since then though. LOL

                                            The only other thing I could think(if you didn’t) is to verify that the config files are gone from /etc/mysql when re-installing.

                                            The next thing would be purely experimental… But there is a mariadb that is supposed to be a drop in replacement for mysql. You could try installing that and see if that fixes it. But I have not tried this.

                                            I’m sorry I can’t be of more help.

                                            A wise man knows he can always grow wiser.

                                            99 little bugs in the code, 99 little bugs
                                            Fix one bug, save it again…
                                            101 little bugs in the code

                                            Z 1 Reply Last reply Reply Quote 1
                                            • Z
                                              zln1996 @KnightRaven
                                              last edited by

                                              @KnightRaven There are no words to describe how happy I am right now. I finally got it working and I’m in fog again and everything looks okay! Knight I want to thank you so much for your help you had me on the right path all along, however, I did have to do a few extra steps. I’m going to explain so if anyone has this issue later on and they stumble upon this post hopefully it will help them out.

                                              First thing is the reason I could never get mysqld to start is during the installation of mySQL it never created the directory /var/run/mysqld so that’s why it would never start a mysql instance. So using these commands you can accomplish that.

                                              mkdir -p /var/run/mysqld
                                              chown mysql:mysql /var/run/mysqld
                                              

                                              Once that was done, make sure all instances of regular mysql is gone. I used killall mysql and then to verify killall -9 mysql Then I ran the following command

                                              mysqld_safe --skip-grant-tables --skip-networking &
                                              

                                              Once that is done you’ll need to open a different terminal. And do the following:

                                              mysql -u root
                                              

                                              If all is well you should now be in the database once more, here I checked for the user account like you mentioned Knight, but mine seemed to still be in there. So if the user is there use the following commands (this is what I had to do in my case, since my root user still existed)

                                              use mysql;
                                              update user set authentication_string=PASSWORD('<YOURPASSWORDHERE>') where user='root';
                                              flush privileges;
                                              \q
                                              

                                              So now your password should be updated, so now to verify kill all of the mysqld instances and start the regular mysql ones. This can be accomplished by the following.

                                              killall mysqld
                                              service mysql start
                                              #now you can check your new password...
                                              mysql -u root -p
                                              #Enter your password and you should be brought to the following prompt...
                                              mysql>
                                              

                                              After that I was able to get to the fog homepage and update my schema, and now I’m back in with everything in tact. After this was done I followed Tom’s advice and disabled automatic updates because I’m really tired of Ubuntu breaking everything lol.

                                              I hope this helps any future readers, so you don’t have to go through this madness like I did. Turn off automatic updates as soon as you can, because from my experience it only causes issues, and if you have to update your Ubuntu fog machine prepare for problems.

                                              I also want’s to extend one last thanks to @KnightRaven @Tom-Elliott and @george1421 for their help on this, you guys rock!

                                              Along with everyone else’s references here is the one I used: https://askubuntu.com/questions/489098/unable-to-reset-root-password-of-mysql

                                              KnightRavenK 1 Reply Last reply Reply Quote 1
                                              • 1
                                              • 2
                                              • 1 / 2
                                              • First post
                                                Last post

                                              212

                                              Online

                                              12.0k

                                              Users

                                              17.3k

                                              Topics

                                              155.2k

                                              Posts
                                              Copyright © 2012-2024 FOG Project