Storage node added - But it's not in the list of nodes
-
@kafluke Please run the following commands to see if there is something strange in the database:
shell> mysql -u root -p Password: ... mysql> use fog; ... mysql> SELECT * FROM nfsGroupMembers; ... mysql> SELECT * FROM nfsGroups; ...
Post results here.
-
MariaDB [fog]> SELECT * FROM nfsGroupMembers; +-------+------------------------+-------------------------------------+-----------------+------------+-------------+----------------------+------------+---------------+------------------+--------------+--------------+---------------+-------------------+---------+----------------------------------------------+--------+--------------+-----------------+------------+ | ngmID | ngmMemberName | ngmMemberDescription | ngmIsMasterNode | ngmGroupID | ngmRootPath | ngmSSLPath | ngmFTPPath | ngmMaxBitrate | ngmSnapinPath | ngmIsEnabled | ngmHostname | ngmMaxClients | ngmBandwidthLimit | ngmUser | ngmPass | ngmKey | ngmInterface | ngmGraphEnabled | ngmWebroot | +-------+------------------------+-------------------------------------+-----------------+------------+-------------+----------------------+------------+---------------+------------------+--------------+--------------+---------------+-------------------+---------+----------------------------------------------+--------+--------------+-----------------+------------+ | 1 | Park City Fog Server | Auto generated fog nfs group member | 1 | 1 | /images | /opt/fog/snapins/ssl | /images | | /opt/fog/snapins | 1 | 192.168.2.75 | 10 | 0 | fog | 8o0qgd/YwBipfLd5zr8wOKOpJZ09wn4oyljNGMdjZ/Q= | | em1 | 1 | /fog | | 17 | Park City Storage Node | | 0 | 1 | /images | /opt/fog/snapins/ssl | /images | | /opt/fog/snapins | 1 | 192.168.2.76 | 10 | 10000 | fog | 8eYU5hbZj1P63WmOCmU3sPGISCT6oZW8YkhU02LRbw4= | | ens160 | 1 | /fog | | 18 | Buffalo Storage Node | | 0 | 1 | /images | /opt/fog/snapins/ssl | /images | | /opt/fog/snapins | 1 | 192.168.0.75 | 10 | 0 | fog | GJ8ru+eIpsMzyuTPWx38DtdWYPO7Aan7oC3yYAWCjvs= | | ens160 | 1 | /fog | +-------+------------------------+-------------------------------------+-----------------+------------+-------------+----------------------+------------+---------------+------------------+--------------+--------------+---------------+-------------------+---------+----------------------------------------------+--------+--------------+-----------------+------------+ 3 rows in set (0.00 sec) MariaDB [fog]> SELECT * FROM nfsGroups; +------+----------------------+------------------------------+ | ngID | ngName | ngDesc | +------+----------------------+------------------------------+ | 1 | Park City Fog Server | Auto generated fog nfs group | +------+----------------------+------------------------------+ 1 row in set (0.00 sec) MariaDB [fog]>
-
@kafluke So do you still see the deleted node in the mysql/mariadb output??
Please help us with some more context. Which node (name) did you delete?
-
@Sebastian-Roth The name of the deleted node was “Dallas Storage Node”. I don’t see it below.
-
@kafluke See if you can add the new storage node definition into the DB manually. I know this is ugly but we ought to see if this is working.
shell> mysql -u root -p Password: ... mysql> use fog; ... mysql> INSERT INTO nfsGroupMembers VALUES ('', 'Dallas Storage Node', '', 0, 1, '/images', '/opt/fog/snapins/ssl', '/images', '', '/opt/fog/snapins', 1, '192.168.X.Y', 10, 0, 'fog', 'password', '', 'ens160', 1, '/fog'); ...
Make sure you use the correct IP address. Do not just copy & paste the command you see above. Most values are fine but definitely take a look at IP and maybe name…
-
@Sebastian-Roth Thanks I’ll try that if my VM import doesn’t work. We had a backup of the FOG Node that I moved. It won’t be done until tomorrow. Thanks for the responses.
-
@Sebastian-Roth Manually added it using your commands and now it shows up in the Fog Node list, however, I cannot make any changes to the node. Nothing I select sticks after I click on update. I go back and the change I made is back to what it was before.
Also, I have nothing in my dropdown list for the log viewer. Something got really messed up here.
-
Yeah, something’s definitely jacked. No snapins work any longer. That’s okay, we’ve been meaning to build a new FOG server on one of our ESXi hosts anyway. Now I just hope I can figure out how to migrate all the settings.
-
@kafluke Sounds really strange like if the table is read only. Don’t think I have seen this before.
@george1421 ???
-
@Sebastian-Roth Okay so I just did a complete fresh install on a brand new server. Dev version 1.5.5.3. Absolutely no logs for me to look at inside the log viewer. Weird.