• Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search
    • Register
    • Login
    1. Home
    2. darthanubis
    D
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 23
    • Best 0
    • Controversial 0
    • Groups 0

    darthanubis

    @darthanubis

    1
    Reputation
    364
    Profile views
    23
    Posts
    0
    Followers
    0
    Following
    Joined Last Online
    Age 53

    darthanubis Unfollow Follow

    Latest posts made by darthanubis

    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5420, member: 18”]If you make the other storage node master, it replicates the contents of its /images to all other storage nodes in the group, including the main FOG server. This is dangerous because if you do it wrong, you will overwrite all your images with nothing, basically wiping out the images.

      If you add another storage node, wait for the images to replicate to it, then change it to master. You will probably need to adjust the my.cnf file on the main FOG server to allow connections from remote hosts, and you have to provide the storage node with the proper password for connecting back to the MySQL database on the main FOG server.

      On the storage nodes, edit the /opt/fog/service/etc/config.php file. The username is almost always “fogstorage” and the password is almost always “fs####” where #### is some random number. The password is available in the FOG WebUI under Other Information, FOG Settings, FOG Storage Nodes.[/quote]

      Yeah, I got all of that from the wiki. I don’t remember the my.cnf editing though.

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5415, member: 18”]If you have a storage node in the same storage group, AND you have it configured properly, then the FOGImageReplicator service on the main server will push the image files to the storage nodes via ftp.

      there is a great storage nodes document on the wiki.[/quote]

      So,I don’t have to make the added storage node master for the main server to make the push? Because that is what I did, since the added storage node has more disk space.

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5413, member: 18”]no. only matters when you add storage nodes.[/quote]
      I’ve already added one storage node already.

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“darthanubis, post: 5407, member: 1659”][CODE] tail -10 /opt/fog/log/fogreplicator.log
      [08-02-12 4:35:11 pm] [08-02-12 4:35:11 pm] Failed to connect to database server, will try again in next iteration.
      [08-02-12 4:35:26 pm] * Starting FOG Image Replicator Service
      [08-02-12 4:35:31 pm] * [08-02-12 4:35:31 pm] Checking for new tasks every 600 seconds.
      [08-02-12 4:35:31 pm] * [08-02-12 4:35:31 pm] Starting service loop.
      [08-02-12 4:35:31 pm] [08-02-12 4:35:31 pm] Failed to connect to database server, will try again in next iteration.
      [08-02-12 4:37:57 pm] * Starting FOG Image Replicator Service
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Checking for new tasks every 600 seconds.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Starting service loop.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Checking if I am the group manager.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] I don’t appear to be the group manager, I will check back later.[/CODE]

      It worked!

      Just the contents of these files which contain usernames and passwords are starting to all look alike.[/quote]

      Am I to be worried about these group manager notices/errors?

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [CODE] tail -10 /opt/fog/log/fogreplicator.log
      [08-02-12 4:35:11 pm] [08-02-12 4:35:11 pm] Failed to connect to database server, will try again in next iteration.
      [08-02-12 4:35:26 pm] * Starting FOG Image Replicator Service
      [08-02-12 4:35:31 pm] * [08-02-12 4:35:31 pm] Checking for new tasks every 600 seconds.
      [08-02-12 4:35:31 pm] * [08-02-12 4:35:31 pm] Starting service loop.
      [08-02-12 4:35:31 pm] [08-02-12 4:35:31 pm] Failed to connect to database server, will try again in next iteration.
      [08-02-12 4:37:57 pm] * Starting FOG Image Replicator Service
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Checking for new tasks every 600 seconds.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Starting service loop.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] Checking if I am the group manager.
      [08-02-12 4:38:02 pm] * [08-02-12 4:38:02 pm] I don’t appear to be the group manager, I will check back later.[/CODE]

      It worked!

      Just the contents of these files which contain usernames and passwords are starting to all look alike.

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      In my excitement to get back into the UI, I forgot that the original problem is still present. Still getting the error in the replicator log.

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5333, member: 18”]ok. you show to only have user that can login to the fog web interface. The username is root.

      run this, as it will only update the root user that you use to login to the web interface and nothing else. You can change this after you get back into fog web ui if you want.

      run these commands from the “mysql>” prompt 😉 after connecting as root.
      [CODE]
      use fog;
      UPDATE users SET uPass = MD5(‘password’) where uName = ‘root’ limit 1;
      [/CODE]
      If you don’t get any errors then this should reset the password to “password” and let you login to the FOG web user interface with username “root” and password “password”.

      This DOES NOT change the root password for any other part of FOG or the operating system. This doesn’t even change the mysql root password, ONLY the username and password you put into the login box on the FOG server webpage.[/quote]

      😄 I’m IN! That fixed it! Thank you so much Chad. I really appreciate you having patience with me.

      Now I will start another thread about why I can’t upload a Windows 7 image without getting that darn multi partition error from the pxe boot screen.😕

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5330, member: 18”][CODE]mysql> mysql>[/CODE]

      I posted the command with the prompt in it so you’d know you need to run the script at the mysql> prompt.

      Remove “mysql>” from the query. Technically, I should have said. At the mysql> prompt, type “select uName from users;”[/quote]

      Jesus. :oops:

      [CODE]mysql> select uName from users;
      ±------+
      | uName |
      ±------+
      | root |
      ±------+
      1 row in set (0.00 sec)[/CODE]

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      See it??

      posted in FOG Problems
      D
      darthanubis
    • RE: Failed to connect to database server, will try again in next iteration.

      [quote=“chad-bisd, post: 5310, member: 18”]ok. query the users table in the fog database in mysql and post the contents.
      [CODE]
      mysql -u root -ppassword fog
      mysql>select uName from users;
      [/CODE]

      That should list all logins available to the web interfaces.[/quote]

      [CODE]mysql> mysql>select uName from users;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysql>select uName from users’ at line 1[/CODE]

      posted in FOG Problems
      D
      darthanubis