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

Fog Storage Node "Failed to connect to database server" durring replication

Scheduled Pinned Locked Moved
FOG Problems
5
12
9.4k
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.
  • A
    ajcke
    last edited by Feb 8, 2012, 7:11 PM

    I’m trying to setup a fog storage node for the first time. Using fog .32. I have two ubuntu machines running. One is the main fog server the other is the storage node. I followed the [URL=‘http://youtu.be/X72WthDGwsw’]this youtube video[/URL]. When I run [I]“watch tail fogreplicator.log”[/I] from the MAIN FOG server I see the following over and over:[I] “Failed to connect to database server, will try again in next iteration.”[/I]

    1 Reply Last reply Reply Quote 0
    • A
      ajcke
      last edited by Feb 9, 2012, 4:13 PM

      [ATTACH=full]39[/ATTACH]
      I setup a new Ubuntu machine today and installed FOG as a storage node and got the same result. Is there an issue with my database? Is there a file somewhere that needs edited/checked? Screen shot attached.

      [url=“/_imported_xf_attachments/0/39_storagenode replication error.jpg?:”]storagenode replication error.jpg[/url]

      1 Reply Last reply Reply Quote 0
      • A
        ajcke
        last edited by Feb 9, 2012, 7:10 PM

        All right. I got it to work. I had to edit the opt/fog/service/FOGImageReplicator file. There were no database credentials in this file. This file doesn’t want the fog database credentials it wants FOG_STORAGENODE_MYSQLUSER and password. Entering these credentials works!

        1 Reply Last reply Reply Quote 0
        • I
          ID10Tea
          last edited by May 18, 2012, 3:25 PM

          I have the same problem when I try to open FOGImageReplicator I get an error. " The folder contents could not be displayed. You do not have the permissions necessary to view the contents of “FOGImageReplicator”"

          1 Reply Last reply Reply Quote 0
          • A
            ajcke
            last edited by May 18, 2012, 3:29 PM

            Did you try editing the file as in post #3? When I was setting all this up I was trying to with Ubuntu Hyper-V VMs which did not work very well. I only had one stand alone box available so I do not have any storagenodes setup currently.

            1 Reply Last reply Reply Quote 0
            • I
              ID10Tea
              last edited by May 18, 2012, 3:33 PM

              [quote=“ajcke, post: 3549, member: 97”]Did you try editing the file as in post #3? When I was setting all this up I was trying to with Ubuntu Hyper-V VMs which did not work very well. I only had one stand alone box available so I do not have any storagenodes setup currently.[/quote]
              I can’t get to it to edit. When I try to open it I get the error above. I am running servers wirth Ubuntu 10.4 no VMs.

              1 Reply Last reply Reply Quote 0
              • A
                ajcke
                last edited by May 18, 2012, 4:22 PM

                Even if you open it as the root user?

                1 Reply Last reply Reply Quote 0
                • I
                  ID10Tea
                  last edited by May 18, 2012, 5:24 PM

                  I’m a Ubuntu noob… How do I open it as the root user?

                  1 Reply Last reply Reply Quote 0
                  • A
                    ajcke
                    last edited by May 18, 2012, 5:31 PM

                    Same here. You are probably about where I was about 1yr ago. Open up terminal and place sudo in front of the file name.
                    sudo [I]filelocation/filename[/I]

                    Alternatively you can enable the root account which is not recommended, but I do anyways.
                    Open up terminal and type:
                    [I]sudo passwd root[/I]

                    You can disable it after getting everything configured.[I]
                    sudo passwd -l root[/I]

                    1 Reply Last reply Reply Quote 0
                    • D
                      darthanubis
                      last edited by Jul 30, 2012, 8:11 PM

                      I see and can edit the file, but no one mentions where in the file the text is located or what it looks like to be edited?

                      1 Reply Last reply Reply Quote 0
                      • C
                        chad-bisd Moderator
                        last edited by Jul 31, 2012, 4:21 AM

                        [quote=“darthanubis, post: 5212, member: 1659”]I see and can edit the file, but no one mentions where in the file the text is located or what it looks like to be edited?[/quote]

                        FOG version 0.32, edit the /opt/fog/service/etc/config.php on the [B]STORAGE[/B] node. The mysql username and password will be the ones displayed in the WebUI of the [B]NORMAL/MAIN[/B] fog server under Other Information, Fog Settings, Fog Storage Nodes. Usually “fogstorage” and “fs####” where #### is a random number between 0000 and 9999.

                        Once you update the /opt/fog/service/etc/config.php on the storage node, restart the scheduler service:
                        [CODE]sudo /etc/init.d/FOGScheduler restart[/CODE]

                        tail the log file and see if the error is resolved.


                        If you would like to make a donation to the Fog project, please do so [U][COLOR=#0000ff][URL='http://sourceforge.net/dona…

                        1 Reply Last reply Reply Quote 0
                        • B
                          bossbarnes07
                          last edited by Sep 23, 2013, 12:24 AM

                          [quote=“ID10Tea, post: 3548, member: 1040”]I have the same problem when I try to open FOGImageReplicator I get an error. " The folder contents could not be displayed. You do not have the permissions necessary to view the contents of “FOGImageReplicator”"[/quote]
                          Where in the file should I put this information?
                          Thanks

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

                          162

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project