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

database connection not available

Scheduled Pinned Locked Moved Solved
FOG Problems
2
4
1.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.
  • M
    matijn
    last edited by matijn Sep 3, 2018, 12:33 AM Sep 3, 2018, 6:27 AM

    After setting up FOG with no root password on mysql within 2-3 weeks I get the message:
    ‘database connection not available’.

    Then I revert the virtual machine, before that error. To continue production.
    This is a dirty workaround for our problem.

    I have tried to setup phpmyadmin and reset the mysql password within.
    User accounts > root > Edit Privileges > Change password > {newpassword}

    hashing choice:

    • native MySql authentication.
      and tried also: unix socket based authentication.

    after that I replaced the fog settings
    sudo nano /opt/fog/.fogsettings
    snmysqlpass: ‘’{newpassword}" without the brackets…
    sudo reboot

    This didn’t fix the message ‘database connection not available’.
    Any solution?

    Ubuntu 18.04.1LTS

    1 Reply Last reply Reply Quote 0
    • T
      tian
      last edited by tian Sep 4, 2018, 5:18 AM Sep 4, 2018, 7:51 AM

      Hi matijn,

      did you already try this?:
      https://forums.fogproject.org/topic/10006/ubuntu-is-fog-s-enemy

      We’re not on Ubuntu 18.04 yet and still running 16.04. But every time we update the OS by apt-get (doesn’t matter if upgrade or dist-upgrade) and it contains a SQL update the things described in the link above needs to be done.

      If that solves your problem and you have some sort of automatic updates turned on you could think about to deactivate them and run them regularly by yourself.

      If that doesn’t solve your problem maybe someone else has another idea.

      1 Reply Last reply Reply Quote 1
      • M
        matijn
        last edited by Sep 7, 2018, 9:10 AM

        I’ve now applied the mysql lines out of topic 10006.
        Within 2-3 weeks we know of this helps. I will post an update.

        1 Reply Last reply Reply Quote 0
        • M
          matijn
          last edited by matijn Sep 19, 2018, 1:46 AM Sep 19, 2018, 7:22 AM

          Ok.
          It seems i decided to enter no root password for mysql while running the installation, after I tried to configure a less secure root password.

          After setting a very very strong password on mysql root account (phpmyadmin).
          You have to manually edit:

          sudo nano /var/www/fog/lib/fog/Config.class.php

          In my case, for Ubuntu 18.04.1 LTS
          sudo nano /var/www/html/fog/lib/fog/Config.class.php

          private static function _dbSettings()
          enter credentials.

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

          170

          Online

          12.0k

          Users

          17.3k

          Topics

          155.2k

          Posts
          Copyright © 2012-2024 FOG Project