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

stuck on ubuntu 10.04 LTS Database

Scheduled Pinned Locked Moved Solved
Linux Problems
3
12
2.8k
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.
  • D
    dat
    last edited by Mar 29, 2016, 10:37 PM

    When I click on Install/Upgrade Now, I get this message. 0_1459290827190_fog.jpg .
    I tried doing this but it didn’t work.

    sudo nano /opt/fog/.fogsettings
    Fill in the following portions
    snmysqluser=“{root}”
    snmysqlpass=“{password if you have one}”
    snmysqlhost=“{localhost}”
    Reset the mySQL database password to be what is in the config files
    run
    sudo dpkg-reconfigure mysql-server-5.5
    replace the last two numbers if using a different version of mySQL
    enter in the new password
    From that point on it should stay working after rebooting.

    Any ideas?

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Mar 29, 2016, 10:39 PM

      Based on the footer, it appears this is FOG 1.2.0?

      Did you set a mysql root password?

      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

      D 1 Reply Last reply Mar 30, 2016, 4:21 PM Reply Quote 0
      • D
        dat
        last edited by Mar 29, 2016, 10:57 PM

        It is the FOG 1.2.0.

        I changed the snmysqlpass=“{my password}”

        and then entered it into the

        sudo dpkg-reconfigure mysql-server-5.5

        I get this and it kind of just pauses before bringing me back to #

        160329 16:51:27 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
        160329 16:51:27 [Note] /usr/sbin/mysqld (mysqld 5.5.47-0ubuntu0.14.04.1) starting as process 3755 …
        mysql start/running, process 3887

        Thanks for the help!

        1 Reply Last reply Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Mar 30, 2016, 3:34 PM

          @dat Usually when it’s a credentials issue you will see “access denied” or something like this. But I cannot see this on the sceenshot. Something wrong with the DB? Try on the command line? mysql --user=root -p…

          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

          D 1 Reply Last reply Mar 30, 2016, 4:45 PM Reply Quote 0
          • D
            dat @Tom Elliott
            last edited by Mar 30, 2016, 4:21 PM

            @Tom-Elliott I did.

            T 1 Reply Last reply Mar 30, 2016, 4:22 PM Reply Quote 0
            • T
              Tom Elliott @dat
              last edited by Mar 30, 2016, 4:22 PM

              @dat When you set this up in the /opt/fog/.fogsettings file, did you re-run the fog installer?

              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

              D 1 Reply Last reply Mar 30, 2016, 10:07 PM Reply Quote 0
              • D
                dat @Sebastian Roth
                last edited by Mar 30, 2016, 4:45 PM

                @Sebastian-Roth It looks like I am able to get into MySQL

                **Welcome to the MySQL monitor. Commands end with ; or \g.
                Your MySQL connection id is 37
                Server version: 5.5.47-0ubuntu0.14.04.1 (Ubuntu)

                Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved.

                Oracle is a registered trademark of Oracle Corporation and/or its
                affiliates. Other names may be trademarks of their respective
                owners.

                Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

                mysql> **

                But I still can’t get the Database Schema Installer / Updater to work. Any thoughts?

                Thanks for the help!!

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Mar 30, 2016, 6:10 PM

                  @dat In the mysql command line client try the same things as you see from the schema updater:

                  mysql> CREATE DATABASE fog;
                  ...
                  ...
                  

                  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
                  • D
                    dat @Tom Elliott
                    last edited by Mar 30, 2016, 10:07 PM

                    So I have the bad habit of doing tab to finish a line and removed udpcast-20120424.tar.gz and not udpcast-20071228.tar.gz . After I corrected the issue everything worked. Thanks @Sebastian-Roth and @Tom-Elliott for your help.

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by Mar 30, 2016, 10:20 PM

                      @dat How did you solve the issue?! I am lost with what you are saying about udpcast… not related to mysql issue!?

                      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 D 2 Replies Last reply Mar 30, 2016, 10:57 PM Reply Quote 1
                      • T
                        Tom Elliott @Sebastian Roth
                        last edited by Mar 30, 2016, 10:57 PM

                        @Sebastian-Roth just a guess but when it asks for password it set the db password with a tab.

                        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 1
                        • D
                          dat @Sebastian Roth
                          last edited by Mar 31, 2016, 5:02 PM

                          @Sebastian-Roth under the Update and Install Packages on https://wiki.fogproject.org/wiki/index.php?title=Ubuntu_14.04 it ask that you run this

                          cd Desktop/
                          cd fog_0.32/
                          cd packages
                          wget https://svn.code.sf.net/p/freeghost/code/trunk/packages/udpcast-20120424.tar.gz
                          rm -f udpcast-20071228.tar.gz
                          sed -i ‘s:udpcastout=“udpcast-20071228”:udpcastout=“udpcast-20120424”:’ …/lib/common/config.sh
                          sed -i ‘s:udpcastsrc=“…/packages/udpcast-20071228.tar.gz”:udpcastsrc=“…/packages/udpcast-20120424.tar.gz”:’ …/lib/common/config.sh
                          cd …/bin/
                          sudo ./installfog.sh

                          during the “rm -f udpcast-20071228.tar.gz” I hit tab and it did this “rm -f udpcast-udpcast-20120424.tar.gz”.

                          So I erased the tar.gz that I just downloaded. So it couldn’t find the package which I assume caused the errors.

                          I hope that clarifies things.

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

                          206

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project