Japp nu loggar jag med OWFS skriver både till RRD och MySQLjed skrev:Kul att det funkar nu
Kod: Markera allt
*/5 * * * * /usr/bin/php /var/www/homeautomation/read_temp_to_mysql.php
Kod: Markera allt
<?php
include_once ("/var/www/homeautomation/system/mysql_settings.php");
# Path to owfs
$owfs_path = "/mnt/1wire";
# Connect to the database and select a db
mysql_connect ($mysqlHost, $mysqlUsername, $mysqlPassword);
mysql_select_db ($mysqlDatabase);
# Get serial from the database
$sensor_q = "10.D0152A020800";
$sensor_r = @mysql_query ($sensor_q);
if (@mysql_num_rows ($sensor_r) > 0)
{
while ($_sensor = @mysql_fetch_object ($sensor_r))
{
$temp = exec ("/bin/cat /mnt/1wire/10.D0152A020800/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temps (sensor_serial, temp_c, date)";
$save_temp_q .= " VALUES ('10.D0152A020800', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
} else {
echo "No sensors found!<br />";
echo "Cowardly bailing out...<p>";
echo @mysql_error();
}
?>
Kod: Markera allt
<?php
$mysqlHost = "localhost";
$mysqlDatabase = "homeautomation";
$mysqlUsername = "root";
$mysqlPassword = **********;
?>
Kod: Markera allt
<?php
$mysqlHost = "192.168.0.88";
$mysqlDatabase = "owfs";
$mysqlUsername = "root";
$mysqlPassword = "password";
?>
Kod: Markera allt
<?php
include_once ("/1wire/mysql_settings.php");
# Connect to the database and select a db
mysql_connect ($mysqlHost, $mysqlUsername, $mysqlPassword);
mysql_select_db ($mysqlDatabase);
{
$temp = exec ("/bin/cat /mnt/1wire/uncached/28.68F02F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO Temp_Raspberry1 (sensor_serial, temp_c, date)";
$save_temp_q .= " VALUES ('28.68F02F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
} else {
echo "No sensors found!<br />";
echo "Cowardly bailing out...<p>";
echo @mysql_error();
}
?>
Kod: Markera allt
*/5 * * * * /usr/bin/php /1wire/read_temp_to_mysql.php
Kod: Markera allt
sudo apt-get install php5-cli
Kod: Markera allt
pi@raspberrypi /1wire $ php read_temp_to_mysql.php
PHP Parse error: syntax error, unexpected '}' in /1wire/read_temp_to_mysql.php on line 13
pi@raspberrypi /1wire $
Kod: Markera allt
pi@raspberrypi /1wire $ php read_temp_to_mysql.php
PHP Fatal error: Call to undefined function mysql_connect() in /1wire/read_temp_to_mysql.php on line 4
pi@raspberrypi /1wire $
Kod: Markera allt
sudo apt-get install php5-mysql
Kod: Markera allt
<?php
include_once ("/mnt/mysql_settings.php");
# Connect to the database and select a db
mysql_connect ($mysqlHost, $mysqlUsername, $mysqlPassword);
mysql_select_db ($mysqlDatabase);
{
$temp = exec ("/bin/cat /mnt/1-wire/28.DAC22F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Solfångare', '28.DAC22F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.22CB2F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Panna', '28.22CB2F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.FEDE2F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Nedre slavtank', '28.FEDE2F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.F4AC2F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Övre slavtank', '28.F4AC2F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.8BC32F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Vinkällare', '28.8BC32F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.51DB2F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Innetemp', '28.51DB2F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.86BD2F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Utetemp', '28.86BD2F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.41B42F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Retur', '28.41B42F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.80E92F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Framledning', '28.80E92F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.D2E82F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Övre tekniktank', '28.D2E82F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.770795040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Mitt tekniktank', '28.770795040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
$temp = exec ("/bin/cat /mnt/1-wire/28.84E92F040000/temperature");
$date = date ("Y-m-d H:i:s");
$save_temp_q = "INSERT INTO temperatur_system (Givare, serial, temp_c, date)";
$save_temp_q .= " VALUES ('Nedre tekniktank', '28.84E92F040000', '$temp', '$date')";
$save_temp_r = @mysql_query ($save_temp_q);
}
{
echo "No sensors found!<br />";
echo "Cowardly bailing out...<p>";
echo @mysql_error();
}
?>