Storage Node Not working since i upgraded the storage node to 1.3.4

[royg706]

My storage node now displays this message “A valid database connection could not be made”

[george1421]

What version did you upgrade from?

The error basically says the storage node can not connect to the fog server’s database.

So I have to ask the questions

1. What version of fog did you upgrade from?
2. Is both the fog server and storage node on the same FOG release?
3. When you setup the storage node did you give it the proper fog (linux) account password?

[Tom Elliott]

Assuming you’re running Ubuntu as the OS, would you be willing to install 1.3.5-RC-7?

I’m aware of some issues, though I don’t know exactly what they are/were, that seem to be corrected for under the 1.3.5 series. RC 7 was just released today which also comes with a new FOG Client and should work properly for your needs here.

[royg706]

ubuntu version 14.04.5 LTS
I cannot recall the version that it was on previously it was a trunk version i got back in november of 2016. There was connection between the server and storage node. However when i upgraded the storage node to 1.3.4 the connection broke.
yes it has the proper password.

I am unable to upgrade to the newest trunk now. I get the following error.

SVN: E000111: Unable to connect to a respository at URL ‘https://svn.code.sf.net/p/freeghost/code/trunk’

SVN: E0000111: Error running context: connection refused

[Tom Elliott]

@royg706 Updating any version of svn is not going to put you on the RC’s as requested.

Open terminal and become root.

From there run:

apt-get update
apt-get install git
cd /root
git clone https://github.com/fogproject/fogproject.git
cd fogproject
git checkout dev-branch
git pull
cd bin
./installfog.sh -y

Fixed.

[royg706]

I have done a completely new installation of both the server and the storage node with version 1.3.5.
So far the server seems to be working fine. However, the storage node is still giving me the same error.
A valid database connection could not be made"1.3.5

I have checked the credentials and they all appear to be correct. Any new ideas would help.

Thanks.

[royg706]

[04-03-17 7:54:40 pm] * Started sync for Image 600WIN10TEST
[04-03-17 8:04:40 pm] * Starting Image Replication.
[04-03-17 8:04:40 pm] * We are group ID: 1. We are group name: default
[04-03-17 8:04:40 pm] * We are node ID: 1. We are node name: MAIN
[04-03-17 8:04:40 pm] * Attempting to perform Group -> Group image replication.
[04-03-17 8:04:40 pm] * Not syncing Image between groups
[04-03-17 8:04:40 pm] | Image Name: 600WIN10TEST
[04-03-17 8:04:40 pm] | There are no other members to sync to.
[04-03-17 8:04:40 pm] * Attempting to perform Group -> Nodes image replication.
[04-03-17 8:04:40 pm] * Found Image to transfer to 1 node
[04-03-17 8:04:40 pm] | Image Name: 600WIN10TEST
[04-03-17 8:04:40 pm] | Replication already running with PID: 2521
[04-03-17 8:14:40 pm] * Starting Image Replication.
[04-03-17 8:14:40 pm] * We are group ID: 1. We are group name: default
[04-03-17 8:14:40 pm] * We are node ID: 1. We are node name: MAIN
[04-03-17 8:14:40 pm] * Attempting to perform Group -> Group image replication.
[04-03-17 8:14:40 pm] * Not syncing Image between groups
[04-03-17 8:14:40 pm] | Image Name: 600WIN10TEST
[04-03-17 8:14:40 pm] | There are no other members to sync to.
[04-03-17 8:14:40 pm] * Attempting to perform Group -> Nodes image replication.
[04-03-17 8:14:40 pm] * Found Image to transfer to 1 node
[04-03-17 8:14:40 pm] | Image Name: 600WIN10TEST
[04-03-17 8:14:41 pm] | Files do not match.
[04-03-17 8:14:41 pm] * Deleting remote file: /images/600WIN10TEST/d1.mbr
[04-03-17 8:14:41 pm] | Files do not match.
[04-03-17 8:14:41 pm] * Deleting remote file: /images/600WIN10TEST/d1.original.uuids
[04-03-17 8:14:41 pm] | Files do not match.
[04-03-17 8:14:41 pm] * Deleting remote file: /images/600WIN10TEST/d1.partitions
[04-03-17 8:14:42 pm] | Files do not match.
[04-03-17 8:14:42 pm] * Deleting remote file: /images/600WIN10TEST/d1p1.img
[04-03-17 8:14:42 pm] | Files do not match.
[04-03-17 8:14:42 pm] * Deleting remote file: /images/600WIN10TEST/d1p2.img
[04-03-17 8:14:42 pm] | Files do not match.
[04-03-17 8:14:42 pm] * Deleting remote file: /images/600WIN10TEST/d1p3.img
[04-03-17 8:14:42 pm] | Files do not match.
[04-03-17 8:14:42 pm] * Deleting remote file: /images/600WIN10TEST/d1p4.img
[04-03-17 8:14:43 pm] * Starting Sync Actions
[04-03-17 8:14:43 pm] | CMD:
lftp -e ‘set xfer:log 1; set xfer:log-file “/opt/fog/log/fogreplicator.600WIN10TEST.transfer.RHINO.log”;set ftp:list-options -a;set net:max-retries 10;set net:timeout 30; mirror -c -r -R --ignore-time -vvv --exclude “.srvprivate” --delete-first “/images/600WIN10TEST” “/images/600WIN10TEST”; exit’ -u rogelio,[Protected] 168.30.166.27
[04-03-17 8:14:43 pm] * Started sync for Image 600WIN10TEST

[george1421]

@royg706 said in Storage Node Not working since i upgraded the storage node to 1.3.4:

lftp -e ‘set xfer:log 1; set xfer:log-file “/opt/fog/log/fogreplicator.600WIN10TEST.transfer.RHINO.log”;set ftp:list-options -a;set net:max-retries 10;set net:timeout 30; mirror -c -r -R --ignore-time -vvv --exclude “.srvprivate” --delete-first “/images/600WIN10TEST” “/images/600WIN10TEST”; exit’ -u rogelio,[Protected] 168.30.166.27

From here, now you should focus on the /opt/fog/log/fogreplicator.600WIN10TEST.transfer.RHINO.log The log you posted has launch the replication process and now this new log tells us what is going on during that replication session in details.

The other issue about database. Are you still running on lts 14.04 or did you deploy it on 16.04 now?

[royg706]

It is on 14.04

[Wayne Workman]

@royg706 I would verify the credentials - them seeming to appear correct isn’t good enough, they need tested. Here are two articles that explain how to test the FTP credentials and remote MySQL credentials properly - if there are problems with any of this, you’ll find them during testing.
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_FTP
https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL