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



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


  • Moderator

    @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



  • It is on 14.04


  • Moderator

    @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?



  • [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



  • 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.


  • Senior Developer

    @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.



  • 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


  • Senior Developer

    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.


  • Moderator

    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?

Log in to reply
 

437
Online

39000
Users

10717
Topics

101757
Posts

Looks like your connection to FOG Project was lost, please wait while we try to reconnect.