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

    mySQL information

    Scheduled Pinned Locked Moved
    General Problems
    3
    7
    1.7k
    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.
    • H
      hancocza
      last edited by

      Hello,

      I’m looking to setup a FOG server for imaging purposes within a network. I have been in communication with the network guys at my company, and they have been opening ports for me to use the service. One they are hesitant to open for my use is the mySQL port because the transfer of data on that port isn’t very secure. What tasks is this port actually used for? I’ve been able to do hardware inventories without it open, but i haven’t been able to capture an image for deployment.

      Thanks

      1 Reply Last reply Reply Quote 0
      • george1421G
        george1421 Moderator
        last edited by

        You might want to explain how you have your FOG server setup and if you are using or planning on using remote storage nodes. Your fog server doesn’t need mysql access enabled externally as long as you have no fog storage nodes setup.

        Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

        1 Reply Last reply Reply Quote 0
        • H
          hancocza
          last edited by

          Sorry about that. It is a basic installation. The only storage is on the FOG server itself. It only needs the clients to be able to reach it, and deploy images and snapins. It uses the companies DNS/DHCP routers, and clients are pointed to the server using a bootable iPXE usb. I’ve made sure that NFS, FTP and portmap are all enabled through the routers, but it still hangs on the init scripts portion, before failing to mount the filesystem. So I was curious if not enabling mySQL access had anything to do with that.

          george1421G 1 Reply Last reply Reply Quote 0
          • george1421G
            george1421 Moderator @hancocza
            last edited by george1421

            @hancocza For fog the client does not directly interact with mysql. It only interacts with it via the FOG server. The client connects via http, https, tftp, ftp, and nfs to the fog server. If you are using dnsmasq on fog server then you need port 67, 68, 4011.

            still hangs on the init scripts portion

            Please provide a screen shot of this error. The init scripts bits use nfs to connect back to the fog server. If you have some linux skills I can tell you how to configure the FOS engine (the linux OS that runs on the target computer) for debugging.

            ref: FOG firewall requirements (from fog server perspective) https://forums.fogproject.org/topic/6162/firewall-configuration

            Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

            H 1 Reply Last reply Reply Quote 0
            • H
              hancocza @george1421
              last edited by hancocza

              I have all of those enabled and don’t use dnsmasq, so it looks to be more like a server config issue. Here are the screenshots of the process.
              0_1491920913210_IMG_20170411_101839.jpg
              .0_1491920923192_IMG_20170411_101939.jpg

              I have a little experience from messing with terminal in the past, so with some guidance I should be able to do it.

              Also forgot to mention, running 1.4.0 RC 3 on Ubuntu 14.04 LTS. Also the firewall is currently disabled, so that shouldn’t be an issue.

              george1421G 1 Reply Last reply Reply Quote 0
              • george1421G
                george1421 Moderator @hancocza
                last edited by

                @hancocza I’m going to say you have an nfs issue, where you might not have all of the ports open you need.

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!

                1 Reply Last reply Reply Quote 2
                • Wayne WorkmanW
                  Wayne Workman
                  last edited by Wayne Workman

                  I agree with George, this is a NFS Port problem.

                  Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG!
                  Daily Clean Installation Results:
                  https://fogtesting.fogproject.us/
                  FOG Reporting:
                  https://fog-external-reporting-results.fogproject.us/

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

                  184

                  Online

                  12.0k

                  Users

                  17.3k

                  Topics

                  155.2k

                  Posts
                  Copyright © 2012-2024 FOG Project