• View
• Edit
• History
• Print

Encoders

To read the status of the baldors, you should issue these commands on fourier

mysql -u root -p\\ [Enter the root password for fourier] use mt_pleasant_26
select * from drives_2013_Feb order by id desc limit 1 ;

The returned output will be something like this:

±------±---------±-----------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------+ | id | time_utc | date_utc | drive1_name | drive1_rpm | drive1_hz | drive1_amps | drive1_runtime | drive1_lastfault | drive1_lastfault_timeago | drive2_name | drive2_rpm | drive2_hz | drive2_amps | drive2_runtime | drive2_lastfault | drive2_lastfault_timeago | drive3_name | drive3_rpm | drive3_hz | drive3_amps | drive3_runtime | drive3_lastfault | drive3_lastfault_timeago | drive4_name | drive4_rpm | drive4_hz | drive4_amps | drive4_runtime | drive4_lastfault | drive4_lastfault_timeago | ±------±---------±-----------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------+ | 48933 | 04:50:48 | 2013–02–26 | X1 | NULL | NULL | NULL | NULL | NULL | 0:00:00 | X2 | NULL | NULL | NULL | NULL | NULL | 0:00:00 | Y1 | NULL | NULL | NULL | NULL | NULL | 0:00:00 | Y2 | NULL | NULL | NULL | NULL | NULL | 0:00:00 | ±------±---------±-----------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------±------------±-----------±----------±------------±---------------±-----------------±-------------------------+ 1 row in set (0.00 sec)

where the first section is the column header and the section contains the corresponding values. N.B - the drives need to be on for the returned information to be useful.

To finish, enter exit in the mysql terminal.