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

    MYSQL & TFTP Stops randomly after update from 0.32 to 1.0.1 and 12.04 to 14.04

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    9
    2.7k
    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.
    • J
      jahilton2002
      last edited by

      Hi guys hope you can help…i’ll go through what i did to get these issues…

      i was running 12.04 with 0.32 no problems… on my lunch break checked to see if fog 0.33 had been released…

      1.0.1! woohoo!

      So i updated to 1.0.1 no probs…it was running like this for 4hrs approx…

      i decided to update ubuntu 12.04 to 14.04 and everything seemed to go fine…

      after an hour or so after updating ubuntu… i started getting “unable to connect to database” error in the web gui…

      however TFTP still worked…after a restart, tftp stopped working as well as the webgui.

      i did

      “sudo stop tftpd-hpa”
      “sudo start tftpd-hpa”
      “sudo service mysql stop”
      “sudo service mysql start”

      this fixes both issues…until i restart or it randomly stops working again… if i run the above in terminal it starts working again straight away.

      i thought i was asking too much updating fog as well as ubuntu…

      so i made a fresh server for testing…installed 14.04 from the off… and then 1.0.1.

      the above problems appeared within 20mins!

      is this a 14.04 issue? i didn’t have 1.0.1 installed on 12.04 long enough to see if the issue was there…

      anyhelp would be great!

      thanks

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

        Too my knowledge, this seems to be an issue with 14.04, not 1.0.1. I don’t know why, it just seems to cut programs at random intervals, though after the first fail, performing service <servicename> restart or the upstart equivalent seems to work until next load up.

        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
        • J
          jahilton2002
          last edited by

          Thats all makes sense then…thanks for the reply

          1 Reply Last reply Reply Quote 0
          • W
            Wolfbane8653 Developer
            last edited by

            [url]http://fogproject.org/forum/threads/tftpd-hpa-not-starting-on-reboot.10560/[/url]

            1 Reply Last reply Reply Quote 0
            • J
              jahilton2002
              last edited by

              Thanks for the link, but the service randomly stops also.

              1 Reply Last reply Reply Quote 0
              • C
                cadre
                last edited by

                I just did a clean installation of 13.10 (after a clean install of 14.04 gave me this trouble too) and I’m having the exact same issue. Restarting MySQL fixes it temporarily, but in my case mysql is stopping while I’m actively logged into and using the web interface.

                I’ll try to do a clean install of 12.04 but really people, what could be the problem?

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

                  This post is deleted!
                  1 Reply Last reply Reply Quote 0
                  • R
                    rhythmtone
                    last edited by

                    This has been plaguing me as well, especially because it is difficult to replicate the problem consistently.

                    Running the permission modification below does seem to stabilize SQL on Ubuntu 14.04 x64. Although it did still crash once, it certainly seems “better” after this modification:

                    sudo chmod 775 /var/lib/mysql

                    Your mileage may vary, but try that to start. I understand that the whole “it’s better but it still occasionally crashes” is not a scientific or conclusive answer at all, but that is all that I’ve been able to come up with so far…

                    Thanks,
                    D.L.

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

                      To add, actually it seems almost 100% stable with this modification, no crashes today…

                      Maybe the one crash after I made this change was a fluke and/or I had not rebooted yet, I cannot remember with all the different testing that I’ve been doing…

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

                      207

                      Online

                      12.0k

                      Users

                      17.3k

                      Topics

                      155.2k

                      Posts
                      Copyright © 2012-2024 FOG Project