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

Change Image ID Number

Scheduled Pinned Locked Moved Solved
FOG Problems
3
44
12.5k
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.
  • T
    Tom Elliott @Wayne Workman
    last edited by Oct 14, 2016, 3:49 PM

    @Wayne-Workman You might be better doing this:

    SET @count = 0;
    UPDATE `images` SET `images`.`imageID` = @count:= @count + 1;
    ALTER TABLE `images` AUTO_INCREMENT = 1;
    

    This will reorder without trying to guess numeric values.

    The last statement will reset the auto_increment value to the next highest in the list (essentially it will put it at whatever the max id is + 1).

    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
    • T
      Tom Elliott
      last edited by Oct 14, 2016, 3:50 PM

      Additionally, this could use some refinement to auto adjust the image group assosiacations and host ids, but for quick and dirty reordering this will work.

      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

      W 1 Reply Last reply Oct 14, 2016, 3:52 PM Reply Quote 0
      • W
        Wayne Workman @Tom Elliott
        last edited by Oct 14, 2016, 3:52 PM

        @Tom-Elliott That’s nice, but there are other areas that need re-ordering. imageGroupAssoc and hostImage

        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/

        T 1 Reply Last reply Oct 14, 2016, 3:52 PM Reply Quote 0
        • T
          Tom Elliott @Wayne Workman
          last edited by Oct 14, 2016, 3:52 PM

          @Wayne-Workman right but you can follow the same procedure to reorder the items on image group association.

          For Host image id associations it may be a bit rougher.

          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

          T W 2 Replies Last reply Oct 14, 2016, 3:54 PM Reply Quote 0
          • T
            Tom Elliott @Tom Elliott
            last edited by Oct 14, 2016, 3:54 PM

            @Tom-Elliott I’ll try to come up with a more intuitive approach that isn’t relying on a mathematical scale to increment things. Of course testing will be needed.

            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

            W 1 Reply Last reply Oct 14, 2016, 3:55 PM Reply Quote 0
            • W
              Wayne Workman @Tom Elliott
              last edited by Oct 14, 2016, 3:54 PM

              @Tom-Elliott Right because there are duplicate image IDs in the hosts table, you can’t use a count whatsoever there. I’m not liking this method at all because of imageGroupAssoc and hostImage not being taken care of in this answer.

              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/

              T 1 Reply Last reply Oct 15, 2016, 1:41 AM Reply Quote 0
              • W
                Wayne Workman @Tom Elliott
                last edited by Oct 14, 2016, 3:55 PM

                @Tom-Elliott Of course BASH could handle this easily.

                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
                • W
                  Wayne Workman @RobTitian16
                  last edited by Wayne Workman Oct 14, 2016, 10:11 AM Oct 14, 2016, 4:10 PM

                  @RobTitian16 said in Change Image ID Number:

                  @Wayne-Workman Sorry, it was a typo when I was writing it up on here. Here’s the screenshot to confirm what I’ve typed in:

                  0_1476458331910_Capture.PNG

                  The query for the hosts table probably succeeded for you in the above attempt. If you’ve not tried anything else since that, It can be undone with
                  UPDATE hosts SET hostImage = hostImage + 4;
                  But if you’ve started doing other stuff, you shouldn’t do this. Communicate with us, tell us what’s going on.

                  Also, I’m working on a BASH script to re-order Image IDs.

                  Good thing you have snapshots - you might just want to revert to the snapshot and sit tight for an hour or so.

                  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
                  • W
                    Wayne Workman @RobTitian16
                    last edited by Oct 14, 2016, 4:47 PM

                    @RobTitian16 @Tom-Elliott I wrote a BASH script that is working. I’ll make a github project for it soon but here it is:

                    #!/bin/bash
                    
                    #----- MySQL Credentials -----#
                    snmysqluser=""
                    snmysqlpass=""
                    snmysqlhost=""
                    # If user and pass is blank, leave just a set of double quotes like ""
                    # if the db is local, set the host to just double quotes "" or "127.0.0.1" or "localhost"
                    
                    
                    #----- Begin Program -----#
                    
                    selectAllImageIDs="SELECT imageID FROM images ORDER BY imageID"
                    selectLowestImageID="SELECT imageID FROM images ORDER BY imageID LIMIT 1"
                    
                    options="-sN"
                    if [[ $snmysqlhost != "" ]]; then
                    	options="$options -h$snmysqlhost"
                    fi
                    if [[ $snmysqluser != "" ]]; then
                            options="$options -u$snmysqluser"
                    fi
                    if [[ $snmysqlpass != "" ]]; then
                            options="$options -p$snmysqlpass"
                    fi
                    options="$options -D fog -e"
                    
                    lowestID=$(mysql $options "$selectLowestImageID")
                    
                    #If the lowest image ID is greater than 1, we can renumber all images sequentially.
                    if [[ "$lowestID" -gt "1" ]]; then
                        count=1
                        mysql $options "$selectAllImageIDs" | while read imageID; do
                    
                            echo "-------------------"
                            echo "Attempting to change Image ID $imageID to $count"
                            mysql $options "UPDATE images SET imageID = $count WHERE imageID = $imageID"
                            mysql $options "UPDATE imageGroupAssoc SET igaImageID = $count WHERE igaImageID = $imageID"
                            mysql $options "UPDATE hosts SET hostImage = $count WHERE hostImage = $imageID"
                            echo "Attempt completed"
                            count=$((count + 1))
                    
                        done
                    fi
                    

                    Sample output:

                    [root@fog-server ~]# ./renumberFogImages.sh 
                    -------------------
                    Attempting to change Image ID 2 to 1
                    Attempt completed
                    -------------------
                    Attempting to change Image ID 3 to 2
                    Attempt completed
                    -------------------
                    Attempting to change Image ID 4 to 3
                    Attempt completed
                    -------------------
                    Attempting to change Image ID 5 to 4
                    Attempt completed
                    [root@fog-server ~]#
                    

                    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/

                    T 1 Reply Last reply Oct 17, 2016, 3:06 PM Reply Quote 1
                    • T
                      Tom Elliott @Wayne Workman
                      last edited by Oct 15, 2016, 1:41 AM

                      @Wayne-Workman you most certainly could use a count so long as the iteration of the count matches the new item. You adjust the statement to update all items matching a particular I’d. For example if I’d is 4 and is now set to 1. You would do an update like:
                      update imageGroupAssoc set igaImageID=1 where igaImageID=4

                      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

                      W 1 Reply Last reply Oct 15, 2016, 2:33 AM Reply Quote 0
                      • W
                        Wayne Workman @Tom Elliott
                        last edited by Oct 15, 2016, 2:33 AM

                        @Tom-Elliott That’s what I did in the bash script below.

                        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/

                        R 1 Reply Last reply Oct 17, 2016, 2:14 PM Reply Quote 0
                        • R
                          RobTitian16 @Wayne Workman
                          last edited by Oct 17, 2016, 2:14 PM

                          @Wayne-Workman Thanks for this, although when running the script I receive the following errors:

                          0_1476713516864_Capture.PNG

                          The blanked out part of line 23 is the password. Yet when running:

                          mysql -h localhost -u root -p"password" -D fog
                          

                          I’m able to log-in perfectly fine.

                          W 1 Reply Last reply Oct 17, 2016, 2:20 PM Reply Quote 0
                          • W
                            Wayne Workman @RobTitian16
                            last edited by Oct 17, 2016, 2:20 PM

                            @RobTitian16 Edit the script, at the top is username and password and host. Set those to what is needed. If root works, use root and “password” and set the host to “localhost”

                            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/

                            R 2 Replies Last reply Oct 17, 2016, 2:48 PM Reply Quote 0
                            • R
                              RobTitian16 @Wayne Workman
                              last edited by Oct 17, 2016, 2:48 PM

                              @Wayne-Workman Indeed, I set those as root and “password” with the host being “localhost”. It gave me those errors in the previous screenshot.

                              1 Reply Last reply Reply Quote 0
                              • R
                                RobTitian16 @Wayne Workman
                                last edited by Oct 17, 2016, 2:50 PM

                                @Wayne-Workman 0_1476715852117_Capture.PNG

                                W T 3 Replies Last reply Oct 17, 2016, 2:53 PM Reply Quote 0
                                • W
                                  Wayne Workman @RobTitian16
                                  last edited by Wayne Workman Oct 17, 2016, 8:54 AM Oct 17, 2016, 2:53 PM

                                  @RobTitian16 line 17 is actually the if argument. Try to put a space between the [[ and ]] brackets and the inner line between them. Like:
                                  if [[ $snmysqlhost != "" ]]; then

                                  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
                                  • T
                                    Tom Elliott @RobTitian16
                                    last edited by Oct 17, 2016, 2:55 PM

                                    @RobTitian16 Looks to my like your snmysqlpass and snmysqlhost fields are using missmatching quotes.

                                    The snmysqlpass looks to start with a single quote but end with a double quote.

                                    THe snmysqlhost field looks like it’s much the same.

                                    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

                                    W 1 Reply Last reply Oct 17, 2016, 3:00 PM Reply Quote 1
                                    • W
                                      Wayne Workman @Tom Elliott
                                      last edited by Oct 17, 2016, 3:00 PM

                                      @Tom-Elliott Yup. I didn’t look close enough at it lol.

                                      Looks like a simple typo. In the original script I posted, it’s good.

                                      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/

                                      R 1 Reply Last reply Oct 17, 2016, 3:03 PM Reply Quote 0
                                      • R
                                        RobTitian16 @Wayne Workman
                                        last edited by Oct 17, 2016, 3:03 PM

                                        @Wayne-Workman Thanks, although that’s actually a result of me blocking out the password. I can confirm there are double quotes on all 3 lines. I copied and pasted the code below, so it’s all the same as far as I can tell.
                                        I can also confirm there is a space between the [[ and ]] brackets and the inner line between them, as suggested.

                                        W 1 Reply Last reply Oct 17, 2016, 3:15 PM Reply Quote 0
                                        • T
                                          Tom Elliott @RobTitian16
                                          last edited by Oct 17, 2016, 3:06 PM

                                          @RobTitian16, @Wayne-Workman is correct.

                                          On all the of the “if lines” you must have a space after [[ and before ]]

                                          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

                                          W 1 Reply Last reply Oct 17, 2016, 3:52 PM Reply Quote 1
                                          • 1
                                          • 2
                                          • 3
                                          • 1 / 3
                                          1 / 3
                                          • First post
                                            19/44
                                            Last post

                                          149

                                          Online

                                          12.0k

                                          Users

                                          17.3k

                                          Topics

                                          155.2k

                                          Posts
                                          Copyright © 2012-2024 FOG Project