Не сбить нас с верного пути, нам по фигу куда идти
https://forum.lissyara.su/
Код: Выделить всё
cat /home/rrdtool/script/update_temperature
#!/bin/sh
. /home/rrdtool/script/config
MONITOR="/usr/local/bin/digitemp_DS9097 -a -c /usr/local/etc/digitemp.conf"
temp_room=`$MONITOR | grep "Sensor_0" | awk '{print $2}'`
temp_street=`$MONITOR | grep "Sensor_1" | awk '{print $2}'`
temp_gazebo=`$MONITOR | grep "Sensor_2" | awk '{print $2}'`
${mysql_preffix} --execute="CREATE TABLE \`${year}\` (\`id\` INT(16) NOT NULL AUTO_INCREMENT, \`data\` INT(16) NOT NULL, \`temp_street\` FLOAT, \`temp_gazebo\` FLOAT, \`temp_room\` FLOAT, PRIMARY KEY (\`id\`), KEY \`data\`(\`data\`)) TYPE=MyISAM" 2>/dev/null
${mysql_preffix} --execute="INSERT INTO \`${year}\` (\`data\`, \`temp_street\`, \`temp_gazebo\`, \`temp_room\`) VALUES ('${data}', '${temp_street}', '${temp_gazebo}', '${temp_room}')"
`/usr/local/bin/rrdtool update $RRDPREFIX/temperature.rrd N:$temp_street:$temp_gazebo:$temp_room`Код: Выделить всё
#!/bin/sh
. /home/rrdtool/script/config
MONITOR="/usr/local/bin/digitemp_DS9097 -a -c /usr/local/etc/digitemp.conf"
temp_room=`$MONITOR | grep "Sensor_0" | awk '{print $2}'`
temp_street=`$MONITOR | grep "Sensor_1" | awk '{print $2}'`
temp_gazebo=`$MONITOR | grep "Sensor_2" | awk '{print $2}'`
`/usr/local/bin/rrdtool update $RRDPREFIX/temperature.rrd N:$temp_street:$temp_gazebo:$temp_room`Код: Выделить всё
# Данные для подключения к MySQL
mysql="/usr/local/bin/mysql"
mysql_serv="localhost"
mysql_user="name"
mysql_pass="pass"
mysql_base="temperature"
# Конектимся
mysql_preffix="${mysql} --host=${mysql_serv} --user=${mysql_user} --password=${mysql_pass} --database=${mysql_base}"
year="`date +%Y`"
data="`date +%s`"
# Создаем таблицу
${mysql_preffix} --execute="CREATE TABLE \`${year}\` (\`id\` INT(16) NOT NULL AUTO_INCREMENT, \`data\` INT(16) NOT NULL, \`temp_street\` FLOAT, \`temp_gazebo\` FLOAT, \`temp_room\` FLOAT, PRIMARY KEY (\`id\`), KEY \`data\`(\`data\`)) TYPE=MyISAM" 2>/dev/null
# Пишем туда данные (полученные скриптом выше)
${mysql_preffix} --execute="INSERT INTO \`${year}\` (\`data\`, \`temp_street\`, \`temp_gazebo\`, \`temp_room\`) VALUES ('${data}', '${temp_street}', '${temp_gazebo}', '${temp_room}')"
Код: Выделить всё
ERROR 1146 (42S02) at line 1: Table 'temperature.2011' doesn't exist
Код: Выделить всё
[blacking ~]$ /usr/local/bin/digitemp_DS9097 -i -s /dev/cuau0
DigiTemp v3.6.0 Copyright 1996-2007 by Brian C. Lane
GNU Public License v2.0 - http://www.digitemp.com
Turning off all DS2409 Couplers
...
Searching the 1-Wire LAN
28B5A41903000091 : DS18B20 Temperature Sensor
28DDD4CF0200003D : DS18B20 Temperature Sensor
28CBD9CF02000038 : DS18B20 Temperature Sensor
ROM #0 : 28B5A41903000091
ROM #1 : 28DDD4CF0200003D
ROM #2 : 28CBD9CF02000038
Wrote .digitemprcКод: Выделить всё
MONITOR="/usr/local/bin/digitemp_DS9097 -a -c /usr/local/etc/digitemp.conf"
temp_room=`$MONITOR | grep "Sensor_0" | awk '{print $2}'`
temp_street=`$MONITOR | grep "Sensor_1" | awk '{print $2}'`
temp_gazebo=`$MONITOR | grep "Sensor_2" | awk '{print $2}'`Код: Выделить всё
DigiTemp v3.6.0 Copyright 1996-2007 by Brian C. Lane
GNU Public License v2.0 - http://www.digitemp.com
Sensor_0: 24.3
Sensor_1: -10.9
Sensor_2: 20.3
за окном?