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

    Changing Name works, Joining AD is not but was prior to upgrade

    Scheduled Pinned Locked Moved
    FOG Problems
    5
    26
    12.1k
    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.
    • R
      Raff
      last edited by

      Bill,

      Looking through the posts again, you have probably changed the global AD settings to use [B]Domain Username: Administrator[/B] but you have not done it for that individual host in Host Management. Its is still probably using Domain\Administrator.

      1 Reply Last reply Reply Quote 0
      • Bill RiceB
        Bill Rice Testers
        last edited by

        Let me Say!!! Thank you to the community! I now have AD joining functional again… the simple aspect of removing the roxborough\ in the host setting was the KEY!!! ty…

        Key Factor:
        “you have not done it for that individual host in Host Management. Its is still probably using Domain\Administrator.”

        Ok so recap- After updating to 1.0.1 from .032
        AD joining may break the fix for me was to verify the following settings :

        FOG_AD_DEFAULT_DOMAINNAME [COLOR=#ff6600]My Domain.com[COLOR=#3366ff] This setting never changes[/COLOR][/COLOR]
        FOG_AD_DEFAULT_OU ([COLOR=#ff6600]Blank[/COLOR]) Using default OU Computers1 [COLOR=#3366ff]This setting never changes[/COLOR]
        FOG_AD_DEFAULT_USER [U][U][COLOR=#ff6600][SIZE=5]Administrator[/SIZE][/COLOR][/U][/U] (as per updated version only User name required) [B][U][U][SIZE=5][COLOR=#999999]REMOVE the DOMAIN\ Just leave the User name ONLY[/COLOR][/SIZE][/U][/U][/B]
        FOG_AD_DEFAULT_PASSWORD ([COLOR=#ff6600]Encrypted with fogcrypt[/COLOR]) [COLOR=#3366ff]This setting never changes[/COLOR]

        [COLOR=#ff6600]Under HOST options check the AD setting and make sure it does not have “[U][B]Domain\USER”[/B][/U] It Must match as above (User Name only)[/COLOR]

        [COLOR=#ff6600]after this I was able to have the PC join the Domain with the Fog service[/COLOR]

        1 Reply Last reply Reply Quote 0
        • R
          Raff
          last edited by

          Your welcome Bill, If you have hundreds of hosts in your database with that setting, create a temporary group and mass change the AD setting.

          1 Reply Last reply Reply Quote 0
          • Bill RiceB
            Bill Rice Testers
            last edited by

            [quote=“Raff, post: 28068, member: 298”]Your welcome Bill, If you have hundreds of hosts in your database with that setting, create a temporary group and mass change the AD setting.[/quote]

            Small issue with that I have over 500 deployed systems. some images are not allowed access to the domain CEO’s, CFO’s and so on. so I must go through all of my hosts and check each one individually… but I have no issue doing this… as long as I know it works.!

            1 Reply Last reply Reply Quote 0
            • R
              Raff
              last edited by

              You could do an SQL query to the database directly and change only the ones that have the setting roxborough\Administrator

              1 Reply Last reply Reply Quote 0
              • Bill RiceB
                Bill Rice Testers
                last edited by

                [quote=“Raff, post: 28071, member: 298”]You could do an SQL query to the database directly and change only the ones that have the setting roxborough\Administrator[/quote]

                RAFF,
                Im not that familiar with SQL modification is there a simple way to either use a GUI to search it or a step by step command to edit the SQL database… I have always wanted to reset the numbering as well for images we have deleted and the newest images just keep adding on increasing in number.

                1 Reply Last reply Reply Quote 0
                • R
                  Raff
                  last edited by

                  I use SQLyog community edition to make a connection to the database.

                  Recommend you make a backup first.

                  The SQL query you need to execute is:
                  update hosts set hostADUser=‘Administrator’ where hostADUser=‘roxborough\Administrator’;

                  1 Reply Last reply Reply Quote 0
                  • Bill RiceB
                    Bill Rice Testers
                    last edited by

                    Ok so I am attempting to do this two ways… Directly from the FOG server Via Command Line and from a windows PC here is the error i see from the Fog Server:
                    roxborough@roxmintfog:~$ mysql -u root -p fog
                    Enter password:
                    Reading table information for completion of table and column names
                    You can turn off this feature to get a quicker startup with -A

                    Welcome to the MySQL monitor. Commands end with ; or \g.
                    Your MySQL connection id is 9275
                    Server version: 5.5.37-0ubuntu0.12.04.1 (Ubuntu)

                    Copyright © 2000, 2014, Oracle and/or its affiliates. All rights reserved.

                    Oracle is a registered trademark of Oracle Corporation and/or its
                    affiliates. Other names may be trademarks of their respective
                    owners.

                    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

                    mysql> update hosts set hostADUser=‘Administrator’ where hostADUser=‘roxborough\Administrator’;
                    Query OK, 0 rows affected (0.00 sec)
                    Rows matched: 0 Changed: 0 Warnings: 0

                    mysql> update hosts set hostADUser=‘Administrator’ where hostADUser=‘roxborough\Administrator’;
                    Query OK, 0 rows affected (0.00 sec)
                    Rows matched: 0 Changed: 0 Warnings: 0

                    mysql>
                    and in Windows I tried using SQLyog for win and it keeps adding my domain ID to the end of the logon users credentials so it denies access to the fog server/DB.

                    1 Reply Last reply Reply Quote 0
                    • R
                      Raff
                      last edited by

                      it’s probably case sensitive, modify the query with the correct case, check an existing host for the case your using

                      1 Reply Last reply Reply Quote 0
                      • Bill RiceB
                        Bill Rice Testers
                        last edited by

                        [quote=“Raff, post: 28080, member: 298”]it’s probably case sensitive, modify the query with the correct case, check an existing host for the case your using[/quote]

                        Is there any older config files I can look at that would house this information as I think I have already modified the current configuration so the previous case sensitivity is lost. Im trying to reference what it used to be but cant find the FOG configuration file that had this information from any backup’s

                        1 Reply Last reply Reply Quote 0
                        • Tom ElliottT
                          Tom Elliott
                          last edited by

                          What about this:
                          [code]update hosts set hostADUser=‘Administrator’ where hostADUser like ‘%roxborough%Administrator%’;[/code]

                          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! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • JunkhackerJ
                            Junkhacker Developer
                            last edited by

                            i recommend that you install phpmyadmin, which will allow you to edit the database from a webgui, if you want to edit the database and are unfamiliar with editing mysql databases from command line

                            signature:
                            Junkhacker
                            We are here to help you. If you are unresponsive to our questions, don't expect us to be responsive to yours.

                            1 Reply Last reply Reply Quote 0
                            • Bill RiceB
                              Bill Rice Testers
                              last edited by

                              [quote=“Tom Elliott, post: 28119, member: 7271”]What about this:
                              [code]update hosts set hostADUser=‘Administrator’ where hostADUser like ‘%roxborough%Administrator%’;[/code][/quote]

                              BINGO!
                              mysql> update hosts set hostADUser=‘Administrator’ where hostADUser like ‘%roxborough%Administrator%’;
                              Query OK, 179 rows affected (0.01 sec)
                              Rows matched: 179 Changed: 179 Warnings: 0

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

                              116

                              Online

                              12.1k

                              Users

                              17.3k

                              Topics

                              155.3k

                              Posts
                              Copyright © 2012-2024 FOG Project