Changes between Version 11 and Version 12 of Installation/DatabaseSetup

Timestamp:

Apr 15, 2013 7:24:57 PM (11 years ago)

Author:

jhickey

Comment:

--

Installation/DatabaseSetup

@@ -252 +252 @@
 mysql> insert into tipservers set server='capture2digi';
 }}}
+
+== Setting up IPMI ==
+
+=== IPMI Nodes ===
+
+Each IPMI controller is treated as special node in the database.
+
+It must exist in the nodes table, the interfaces table, and the wires table.  
+
+{{{
+insert into nodes set node_id='cpc5-ipmi', phys_nodeid='cpc5-ipmi', type='IPMI', role='powerctrl';
+insert into interfaces set node_id='cpc5-ipmi', IP='192.168.254.5', mask='255.255.240.0', mac='002590761bf0',interface_type='fxp', iface='eth0', role='ctrl';
+insert into wires set node_id1='cpc5-ipmi', card1=0, port1=1, node_id2='hp1', card2=1, port2=12, type='Control';
+}}}
+
+
+The node type IPMI will have to be added to /usr/local/etc/dhcpd.conf.template and then 'dhcpd_makeconf -ir' should be run.
+
+{{{
+#
+# IPMI Network
+#
+subnet 192.168.254.0 netmask 255.255.255.0 {
+        option subnet-mask              255.255.255.0;
+        option domain-name-servers      192.168.252.1;
+        option domain-name              "isi.deterlab.net";
+
+        group {
+                %%nodetype=IPMI
+        }
+}
+}}}
+
+
+=== IPMI Power Control ===
+
+In the outlets table, simply use the IPMI node for the associated testbed node.
+
+{{{
+mysql> select * from outlets where node_id='cpc5'; 
++---------+-----------+--------+---------------------+
+| node_id | power_id  | outlet | last_power          |
++---------+-----------+--------+---------------------+
+| cpc5    | cpc5-ipmi |      1 | 2013-01-22 06:01:04 | 
++---------+-----------+--------+---------------------+
+1 row in set (0.00 sec)
+}}}
+
+
+=== IPMI Serial Console ===
+
+TBD.