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

[Bill Rice]

[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.!

[Raff]

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

[Bill Rice]

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

[Raff]

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’;

[Bill Rice]

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.

[Raff]

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

[Bill Rice]

[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

[Tom Elliott]

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

[Junkhacker]

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

[Bill Rice]

[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