ATS: Difference between revisions
(8 intermediate revisions by the same user not shown) | |||
Line 54: | Line 54: | ||
== Wipe out filesystem == | == Wipe out filesystem == | ||
Using the Din-to-serial cable (usually found hanging in cab6) connect to the left DIN port (adjacent to the NIC port) and the other end to your PC's serial port. | Using the Din-to-serial cable (usually found hanging in cab6) connect to the left DIN port (adjacent to the NIC port) and the other end to your PC's serial port. Set speed to 9600 baud | ||
Try hitting the carriage return a couple times to see if the card is alive (probably not). To reboot the card, pull it out of the housing, wait a few seconds, then replug it. You have about 30 sec to get back to the serial screen where you will see: | Try hitting the carriage return a couple times to see if the card is alive (probably not). To reboot the card, pull it out of the housing, wait a few seconds, then replug it. You have about 30 sec to get back to the serial screen where you will see: | ||
Line 89: | Line 89: | ||
(our default root password) | (our default root password) | ||
Reset configuration to default values (Y/N)? | Reset configuration to default values (Y/N)? | ||
enter 'n' | enter 'n' | ||
Line 190: | Line 190: | ||
</pre> | </pre> | ||
Ftp to the real (private) | Ftp to the real (private) IP for the ATS, login with admin user (pass is our std root pass): | ||
<pre>[root@backup3 ~/047_files]# ftp 10.1.2.78 | <pre>[root@backup3 ~/047_files]# ftp 10.1.2.78 | ||
Connected to 10.1.2.78. | Connected to 10.1.2.78. | ||
Line 198: | Line 198: | ||
Password: | Password: | ||
230 Password OK. | 230 Password OK. | ||
Remote system type is NET+ARM.</pre> | Remote system type is NET+ARM. | ||
ftp> </pre> | |||
Prepare for binary upload and issue 2 put commands to upload <tt>pwralert.dat</tt> and <tt>rom.bin</tt>: | Prepare for binary upload and issue 2 put commands to upload <tt>pwralert.dat</tt> and <tt>rom.bin</tt>: | ||
Line 229: | Line 230: | ||
[root@backup3 ~/047_files]#</pre> | [root@backup3 ~/047_files]#</pre> | ||
Quick note on command you entered above: the command you run to upload the config for ATS8 is: | |||
put ats8.paconfig.ini paconfig.ini | put ats8.paconfig.ini paconfig.ini | ||
the command for ATS9 would be: | whereas the command for ATS9 would be: | ||
put ats9.paconfig.ini paconfig.ini | put ats9.paconfig.ini paconfig.ini | ||
Line 334: | Line 335: | ||
= Configure new ATS card = | = Configure new ATS card = | ||
PLATFORM: TrippLite | These are the steps to load a brand new ATS card. The steps below are for an old-style card, a new style card will ask more questions about disabling telnet (yes) and http (yes) and so on. | ||
default root pass is: TrippLite<br> | |||
default admin pass is: admin | |||
Connect to the ATS via serial and plug in the card (or ATS) and you'll see: | |||
<pre>PLATFORM: TrippLite | |||
APPLICATION: PowerAlert 12 | APPLICATION: PowerAlert 12 | ||
----------------------------------------------------------------------------- | ----------------------------------------------------------------------------- | ||
Line 349: | Line 355: | ||
Default duplex setting for Ethernet connection: Auto-negotiate | Default duplex setting for Ethernet connection: Auto-negotiate | ||
----------------------------------------------------------------------------- | ----------------------------------------------------------------------------- | ||
Press any key in 10 seconds to change these settings. | Press any key in 10 seconds to change these settings.</pre> | ||
hit enter | |||
Press A to Accept the settings, or M to Modify?m | Press A to Accept the settings, or M to Modify? | ||
enter 'm' | |||
Enter the root password: ********* | Enter the root password: ********* | ||
Reset configuration to default values (Y/N)? | Reset configuration to default values (Y/N)? | ||
enter 'n' | |||
For each of the following questions, you can press <Return> to select the value shown in braces, or you can enter a new value. | <pre>For each of the following questions, you can press <Return> to select the value shown in braces, or you can enter a new value. | ||
NETWORK INTERFACE PARAMETERS: | NETWORK INTERFACE PARAMETERS: | ||
Should this target obtain IP settings from the network?[N] n | Should this target obtain IP settings from the network?[N]</pre> | ||
Static IP address [192.168.1.19]? 10.1.2.78 | enter 'n' | ||
Subnet Mask IP address [255.255.255.0]? | Static IP address [192.168.1.19]? | ||
Gateway address IP address [192.168.1.1]? 10.1.2.1 | Since this is ATS8, we use '10.1.2.78'. If it were ATS10 we'd use '10.1.2.80' | ||
Host Name []? ats8.johncompanies.com | Subnet Mask IP address [255.255.255.0]? | ||
Hit enter, it's correct | |||
Gateway address IP address [192.168.1.1]? | |||
enter '10.1.2.1' | |||
Host Name []? | |||
enter 'ats8.johncompanies.com' | |||
<pre>SECURITY PARAMETERS: | |||
Would you like to update the Root Password?[N]</pre> | |||
enter 'y' | |||
<pre>Enter the new Root Password: ******** | |||
Enter the new Root Password: ******** | Re-enter the new Root Password: ********</pre> | ||
Re-enter the new Root Password: ******** | use the default root password | ||
HARDWARE PARAMETERS: | <pre>HARDWARE PARAMETERS: | ||
Would you like to update the RTC date/time?[N] y | Would you like to update the RTC date/time?[N] y | ||
Line 383: | Line 402: | ||
hour: 15 | hour: 15 | ||
minute: 13 | minute: 13 | ||
second: 13 | second: 13</pre> | ||
go ahead and update the time | |||
Do you want to configure advanced settings? y | Do you want to configure advanced settings? | ||
enter 'y' | |||
Each development board must have a unique Ethernet MAC address. | Each development board must have a unique Ethernet MAC address. | ||
Set the board's Ethernet MAC Address[00:06:67:22:69:95]? | Set the board's Ethernet MAC Address[00:06:67:22:69:95]? | ||
enter to accept | |||
Do you want to completely erase the file system? n | Do you want to completely erase the file system? | ||
enter 'n' | |||
How long (in seconds) should CPU delay before starting up[10]? | |||
enter to accept | |||
Default Ethernet setting (0=Auto, 1=10 Half, 2=10 Full, 3=100 Half, 4=100 Full) [Auto]? | |||
enter '4' to force 100 Full | |||
Now, it will reboot itself: | |||
Saving the changes in NV memory...Done. | <pre>Saving the changes in NV memory...Done. | ||
Line 415: | Line 442: | ||
Default duplex setting for Ethernet connection: 100 Full Duplex | Default duplex setting for Ethernet connection: 100 Full Duplex | ||
----------------------------------------------------------------------------- | ----------------------------------------------------------------------------- | ||
Press any key in 10 seconds to change these settings. | Press any key in 10 seconds to change these settings.</pre> | ||
As soon as you see the ftp server has started, follow the instructions for [[#Upload_driver_.26_config]] to upload the driver and config. | |||
To set the admin pass, browse to ats webpage using an standard (not lynx) browser. You may need to do this from the office since the firewall setup will prevent you from accessing the ATS webpage from most places. Alternately, you can browse to it by getting on the private network locally. Note, you must browse to it via https:// after the paconfig.ini has been uploaded as it will specify https access only. | |||
Login as: admin/admin<br> | |||
Browse to: settings -> system<br> | |||
change guest and admin pass (standard root pass)<br> | |||
Then click the button to reboot | |||
== Assigning a server to an ATS port in mgmt == | |||
A customer may simply be assigned to an ATS port via their system/customer screen in mgmt. If another customer is using that port (cancelled) you will need to clear out the old customer - set ATS port to none - before you can assign the same port to another customer. | |||
To assign a port to a JC machine, you need to do this manually in the database. | |||
Here are the assigned ports at the time of writing: | |||
<pre>mysql> select sysid, hostname, atsport from systems where cid='col00001' and atsport is not null; | |||
+-------+-------------------------+---------+ | |||
| sysid | hostname | atsport | | |||
+-------+-------------------------+---------+ | |||
| 1492 | jail3.johncompanies.com | 0614 | | |||
| 4751 | firewall2 | 0607 | | |||
| 4752 | isys | 0611 | | |||
| 4753 | nat2 | 0606 | | |||
| 4754 | bwdb2 | 0605 | | |||
| 4755 | backup3 | 0604 | | |||
| 4756 | switch-p20 | 0609 | | |||
| 4757 | digi3 | 0610 | | |||
| 4758 | switch-p21 | 0509 | | |||
| 4759 | switch-p22 | 0409 | | |||
| 4760 | switch-p23 | 0309 | | |||
| 4761 | switch-p24 | 0209 | | |||
| 4762 | switch-p25 | 0109 | | |||
| 4763 | switch-p26 | 0709 | | |||
| 4764 | switch-p27 | 0809 | | |||
| 4765 | magrathea | 0602 | | |||
+-------+-------------------------+---------+ | |||
16 rows in set (0.02 sec) | |||
mysql> | |||
</pre> | |||
So to move isys to port 3 in cab 6: | |||
mysql> update systems set atsport='0603' where sysid=4752; | |||
If the system you want to add is not in the database, you will need to add it first. Refer to a jail/virt setup doc for hints. | |||
Latest revision as of 17:45, 29 November 2012
Rebooting and Recovering[edit]
- confirm the ATS is actually offline. https://secure.johncompanies.com/mgmt/ats.html
- you should see 16 ports listed with green or red icons for each indicating status (green=up, red=down) and the customer # who's on that port. If you see no info, the ATS is down.
- try to browse to the ATS: https://ats1.johncompanies.com If you get a response:
- Navigate to Settings -> Network and click 'Save Settings'. This will trigger the ATS to reboot
- If you get no response via browser:
- Go to backup3 (a8p3). ping the ATS (see https://secure.johncompanies.com/mgmt/cabinetmap.html for the private IP). If it responds, re-upload the driver and config. On backup3, go to /root/055_files OR /root/047_files , find the dir which contains the config for the ATS in question and ftp 2 driver files and config to ATS:
[root@backup3 ~/047_files]# ftp 10.1.2.71 Connected to 10.1.2.71. 220 NET+ARM FTP Server 1.0 ready. Name (10.1.2.71:root): admin 331 User admin OK, send password. Password: 230 Password OK. Remote system type is NET+ARM. ftp> bin 200 Type set to I. ftp> put pwralert.dat local: pwralert.dat remote: pwralert.dat 200 PORT command Ok. 150 About to open data connection. 226 Transfer complete 679080 bytes sent in 0.92 secs (717.1 kB/s) ftp> put rom.bin local: rom.bin remote: rom.bin 200 PORT command Ok. 150 About to open data connection. put ats1paconfig.ini paconfig.ini 226 Transfer complete 2109474 bytes sent in 2.63 secs (782.0 kB/s) ftp> ascii 200 Type set to I. ftp> put ats1.paconfig.ini paconfig.ini local: ats1.paconfig.ini remote: paconfig.ini 200 PORT command Ok. 150 About to open data connection. 226 Transfer complete 4174 bytes sent in 0.02 secs (213.9 kB/s) ftp> bye 221 Goodbye.
after which the ATS will auto-reboot upon ftp disconnect and should come back up ok.
- No response to ping: have DC pull and reseat the ATS card
- No response to pull:
- Reupload driver and config. See #Reload_or_Update_ATS
- No response to pull:
Reload or Update ATS[edit]
The TrippLite ATS webcard is prone to lockups/crashes/failure. With only 1 exception, historically we've been able to rescue them by reloading the cards. This is an easy process, but it must be done in person.
Wipe out filesystem[edit]
Using the Din-to-serial cable (usually found hanging in cab6) connect to the left DIN port (adjacent to the NIC port) and the other end to your PC's serial port. Set speed to 9600 baud
Try hitting the carriage return a couple times to see if the card is alive (probably not). To reboot the card, pull it out of the housing, wait a few seconds, then replug it. You have about 30 sec to get back to the serial screen where you will see:
BSP Version 012.004.047.001.0001 Built on Fri Apr 3 13:25:45 2009 by cspengler Copyright TrippLite 2007, all rights reserved PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: IP address on LAN is 10.1.2.78 LAN interface's subnet mask is 255.255.255.0 IP address of default gateway to other networks is 10.1.2.1 HARDWARE PARAMETERS: The date/time from RTC hardware: 11/13/2012 12:26:36 This board's serial number is 9836AY0AC735100483 This board's MAC Address is 00:06:67:21:EB:D6 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: 100 Full Duplex ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings.
At this point press a key where you will be prompted:
Press A to Accept the settings, or M to Modify?
hit 'm' to modify.
It will then ask a series of questions:
Enter the root password: ********
(our default root password)
Reset configuration to default values (Y/N)?
enter 'n'
For the next several questions we hit enter to accept the existing/current settings:
For each of the following questions, you can press <Return> to select the value shown in braces, or you can enter a new value. NETWORK INTERFACE PARAMETERS: Should this target obtain IP settings from the network?[N] Static IP address [10.1.2.78]? Subnet Mask IP address [255.255.255.0]? Gateway address IP address [10.1.2.1]? Host Name [ats8.johncompanies.com]? SECURITY PARAMETERS: Would you like to update the Root Password?[N] HARDWARE PARAMETERS: Would you like to update the RTC date/time?[N]
Do you want to configure advanced settings?
here we enter 'y' to get to advanced settings.
Each development board must have a unique Ethernet MAC address. Set the board's Ethernet MAC Address[00:06:67:21:EB:D6]?
hit enter
Do you want to completely erase the file system?
enter 'y'
Erasing the file system will wipe out any and all driver and data files stored on the board. Doing this, however, will initialize PowerAlert to a default configuration. When PowerAlert starts you will need to use FTP to put a new 'pwralert.dat' file onto the board. Are you sure you want to completely erase the file system?
enter 'y'
Hit enter to accept default/current for the next 2 questions:
The file system will be erased during initialization. How long (in seconds) should CPU delay before starting up[10]? Default Ethernet setting (0=Auto, 1=10 Half, 2=10 Full, 3=100 Half, 4=100 Full) [100 Full]? Saving the changes in NV memory...Done.
Now the ATS will reboot itself:
PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: IP address on LAN is 10.1.2.78 LAN interface's subnet mask is 255.255.255.0 IP address of default gateway to other networks is 10.1.2.1 HARDWARE PARAMETERS: The date/time from RTC hardware: 11/13/2012 12:28:06 This board's serial number is 9836AY0AC735100483 This board's MAC Address is 00:06:67:21:EB:D6 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: 100 Full Duplex ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings.
Don't press anything, let it boot.
At this point it will start to boot, and as soon as you see:
ftpd started
on screen, you can proceed with the next step:
Upload driver & config[edit]
Login to backup3 at i2b as root and go to :
[root@backup3 ~]# cd /root [root@backup3 ~]# ls 047_files disk-image1 disk-image5 driver_win-9.5.4_.zip fs3 fs7 052_FWfiles disk-image2 disk-image6 fs fs4 fs8 055_files disk-image3 disk-image7 fs1 fs5 verify.sh disk-image disk-image4 disk-image8 fs2 fs6 [root@backup3 ~]#
The drivers and configs are in directories 047_files (old-style cards, in ATS1,2,3,7,8,9) and 055_files (new-style cards, in ATS4,5,6)
Depending on which ATS you're updating, cd to that directory (this example assumes ATS8, an old-style card):
[root@backup3 ~]# cd 047_files/ [root@backup3 ~/047_files]# ls ats1.paconfig.ini ats3.paconfig.ini ats7.paconfig.ini ats9.paconfig.ini rom.bin ats2.paconfig.ini ats4.paconfig.ini ats8.paconfig.ini pwralert.dat [root@backup3 ~/047_files]#
Ftp to the real (private) IP for the ATS, login with admin user (pass is our std root pass):
[root@backup3 ~/047_files]# ftp 10.1.2.78 Connected to 10.1.2.78. 220 NET+ARM FTP Server 1.0 ready. Name (10.1.2.78:root): admin 331 User admin OK, send password. Password: 230 Password OK. Remote system type is NET+ARM. ftp>
Prepare for binary upload and issue 2 put commands to upload pwralert.dat and rom.bin:
ftp> bin 200 Type set to I. ftp> put rom.bin local: rom.bin remote: rom.bin 200 PORT command Ok. 150 About to open data connection. 226 Transfer complete 2109474 bytes sent in 2.40 secs (856.8 kB/s) ftp> put pwralert.dat local: pwralert.dat remote: pwralert.dat 200 PORT command Ok. 150 About to open data connection. 226 Transfer complete 679080 bytes sent in 0.80 secs (823.9 kB/s)
Set the mode to ascii to upload the correct config file:
ftp> ascii 200 Type set to I. ftp> put ats8.paconfig.ini paconfig.ini local: ats8.paconfig.ini remote: paconfig.ini 200 PORT command Ok. 150 About to open data connection. 226 Transfer complete 4014 bytes sent in 0.00 secs (8322.6 kB/s) ftp> exit 221 Goodbye. [root@backup3 ~/047_files]#
Quick note on command you entered above: the command you run to upload the config for ATS8 is:
put ats8.paconfig.ini paconfig.ini
whereas the command for ATS9 would be:
put ats9.paconfig.ini paconfig.ini
At this point, after you disconnect, the ATS card will automatically reboot (2x) and load up the new config:
PowerAlert 12 is initialized. verifying length and md5 Flash write complete, returned code: 0 File write worked File write worked Ftp session closed, rebooting in ten seconds System rebooting now BSP Version 012.004.047.001.0001 Built on Fri Apr 3 13:25:45 2009 by cspengler Copyright TrippLite 2007, all rights reserved PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: IP address on LAN is 10.1.2.78 LAN interface's subnet mask is 255.255.255.0 IP address of default gateway to other networks is 10.1.2.1 HARDWARE PARAMETERS: The date/time from RTC hardware: 11/13/2012 12:32:22 This board's serial number is 9836AY0AC735100483 This board's MAC Address is 00:06:67:21:EB:D6 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: 100 Full Duplex ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings. Timeout, no key was pressed. Application Version 012.004.047.001.0001 Built on Mon Jun 8 11:26:04 2009 by cspengler Current IP Address: 10.1.2.78 Snmp Access set ftpd started System DAT files were deleted. paconfig.ini has changed settings that require a reboot Add of syslog 0 server ignored as blank Add of syslog 1 server ignored as blank Add of syslog 2 server ignored as blank Add of syslog 3 server ignored as blank PowerAlert 12 is initialized. (auto reboots again) BSP Version 012.004.047.001.0001 Built on Fri Apr 3 13:25:45 2009 by cspengler Copyright TrippLite 2007, all rights reserved PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: IP address on LAN is 10.1.2.78 LAN interface's subnet mask is 255.255.255.0 IP address of default gateway to other networks is 10.1.2.1 HARDWARE PARAMETERS: The date/time from RTC hardware: 11/13/2012 12:35:15 This board's serial number is 9836AY0AC735100483 This board's MAC Address is 00:06:67:21:EB:D6 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: 100 Full Duplex ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings. Timeout, no key was pressed. Application Version 012.004.047.001.0001 Built on Mon Jun 8 11:26:04 2009 by cspengler Current IP Address: 10.1.2.78 Snmp Access set ftpd started Add of syslog 0 server ignored as blank Add of syslog 1 server ignored as blank Add of syslog 2 server ignored as blank Add of syslog 3 server ignored as blank Auto discovery done, starting web server. httpServ: Task running PowerAlert 12 is now initializing... PowerAlert 12 is initialized.
And once you see that last line: PowerAlert 12 is initialized you know that the ATS is loaded/up.
Configure new ATS card[edit]
These are the steps to load a brand new ATS card. The steps below are for an old-style card, a new style card will ask more questions about disabling telnet (yes) and http (yes) and so on.
default root pass is: TrippLite
default admin pass is: admin
Connect to the ATS via serial and plug in the card (or ATS) and you'll see:
PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: The board will obtain IP configuration parameters from the network. HARDWARE PARAMETERS: The date/time from RTC hardware: 11/13/2012 08:44:06 This board's serial number is 9932BY0AC735100180 This board's MAC Address is 00:06:67:22:69:95 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: Auto-negotiate ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings.
hit enter
Press A to Accept the settings, or M to Modify?
enter 'm'
Enter the root password: ********* Reset configuration to default values (Y/N)?
enter 'n'
For each of the following questions, you can press <Return> to select the value shown in braces, or you can enter a new value. NETWORK INTERFACE PARAMETERS: Should this target obtain IP settings from the network?[N]
enter 'n'
Static IP address [192.168.1.19]?
Since this is ATS8, we use '10.1.2.78'. If it were ATS10 we'd use '10.1.2.80'
Subnet Mask IP address [255.255.255.0]?
Hit enter, it's correct
Gateway address IP address [192.168.1.1]?
enter '10.1.2.1'
Host Name []?
enter 'ats8.johncompanies.com'
SECURITY PARAMETERS: Would you like to update the Root Password?[N]
enter 'y'
Enter the new Root Password: ******** Re-enter the new Root Password: ********
use the default root password
HARDWARE PARAMETERS: Would you like to update the RTC date/time?[N] y Current date/time is 11/13/2012 08:45:15 month: 11 day: 12 year: 2012 hour: 15 minute: 13 second: 13
go ahead and update the time
Do you want to configure advanced settings?
enter 'y'
Each development board must have a unique Ethernet MAC address. Set the board's Ethernet MAC Address[00:06:67:22:69:95]?
enter to accept
Do you want to completely erase the file system?
enter 'n'
How long (in seconds) should CPU delay before starting up[10]?
enter to accept
Default Ethernet setting (0=Auto, 1=10 Half, 2=10 Full, 3=100 Half, 4=100 Full) [Auto]?
enter '4' to force 100 Full
Now, it will reboot itself:
Saving the changes in NV memory...Done. PLATFORM: TrippLite APPLICATION: PowerAlert 12 ----------------------------------------------------------------------------- NETWORK INTERFACE PARAMETERS: IP address on LAN is 10.1.2.78 LAN interface's subnet mask is 255.255.255.0 IP address of default gateway to other networks is 10.1.2.1 HARDWARE PARAMETERS: The date/time from RTC hardware: 11/12/2012 15:13:32 This board's serial number is 9932BY0AC735100180 This board's MAC Address is 00:06:67:22:69:95 After board is reset, start-up code will wait 10 seconds Default duplex setting for Ethernet connection: 100 Full Duplex ----------------------------------------------------------------------------- Press any key in 10 seconds to change these settings.
As soon as you see the ftp server has started, follow the instructions for #Upload_driver_.26_config to upload the driver and config.
To set the admin pass, browse to ats webpage using an standard (not lynx) browser. You may need to do this from the office since the firewall setup will prevent you from accessing the ATS webpage from most places. Alternately, you can browse to it by getting on the private network locally. Note, you must browse to it via https:// after the paconfig.ini has been uploaded as it will specify https access only.
Login as: admin/admin
Browse to: settings -> system
change guest and admin pass (standard root pass)
Then click the button to reboot
Assigning a server to an ATS port in mgmt[edit]
A customer may simply be assigned to an ATS port via their system/customer screen in mgmt. If another customer is using that port (cancelled) you will need to clear out the old customer - set ATS port to none - before you can assign the same port to another customer.
To assign a port to a JC machine, you need to do this manually in the database.
Here are the assigned ports at the time of writing:
mysql> select sysid, hostname, atsport from systems where cid='col00001' and atsport is not null; +-------+-------------------------+---------+ | sysid | hostname | atsport | +-------+-------------------------+---------+ | 1492 | jail3.johncompanies.com | 0614 | | 4751 | firewall2 | 0607 | | 4752 | isys | 0611 | | 4753 | nat2 | 0606 | | 4754 | bwdb2 | 0605 | | 4755 | backup3 | 0604 | | 4756 | switch-p20 | 0609 | | 4757 | digi3 | 0610 | | 4758 | switch-p21 | 0509 | | 4759 | switch-p22 | 0409 | | 4760 | switch-p23 | 0309 | | 4761 | switch-p24 | 0209 | | 4762 | switch-p25 | 0109 | | 4763 | switch-p26 | 0709 | | 4764 | switch-p27 | 0809 | | 4765 | magrathea | 0602 | +-------+-------------------------+---------+ 16 rows in set (0.02 sec) mysql>
So to move isys to port 3 in cab 6:
mysql> update systems set atsport='0603' where sysid=4752;
If the system you want to add is not in the database, you will need to add it first. Refer to a jail/virt setup doc for hints.