• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.4k
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.
  • B
    Bill Rice Testers
    last edited by May 23, 2014, 2:54 PM

    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 May 23, 2014, 3:18 PM

      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
      • B
        Bill Rice Testers
        last edited by May 23, 2014, 5:23 PM

        [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
        • T
          Tom Elliott
          last edited by May 23, 2014, 5:26 PM

          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
          • J
            Junkhacker Developer
            last edited by May 23, 2014, 5:27 PM

            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
            • B
              Bill Rice Testers
              last edited by May 23, 2014, 5:28 PM

              [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
              2 / 2
              • First post
                22/26
                Last post

              226

              Online

              12.1k

              Users

              17.3k

              Topics

              155.4k

              Posts
              Copyright © 2012-2024 FOG Project