My forum

pumo wrote:How homeautomation uses 1wire ?
will it work with owfs ?
I have installed owfs to debian and use it allready with my own tempgraphing withs sql.
or maybe even possible to read other table from same mysql server temperature data ?

pumo wrote:it just my own made owfs to mysql with php
I made php script which reads owfs once in minute and stores it to mysql, and another script makes graph every 15mins with jpgraph.

table structure is this (output from phpmyadmin):

Code: Select all

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mittailut`
--

-- --------------------------------------------------------

--
-- Table structure for table `temps`
--

CREATE TABLE IF NOT EXISTS `temps` (
  `id` int(11) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ulko` float(4,2) NOT NULL default '0.00',
  `olohuone` float(4,2) NOT NULL default '0.00',
  `ilpin` float(4,2) NOT NULL default '0.00',
  `ilpout` float(4,2) NOT NULL default '0.00',
  `pannuh` float(4,2) NOT NULL default '0.00',
  `pannuhk` float(4,2) NOT NULL default '0.00',
  `sauna` float(4,2) NOT NULL default '0.00',
  `autotalli` float(4,2) NOT NULL default '0.00',
  `takavarasto` float(4,2) NOT NULL default '0.00',
  `alaskuri` decimal(10,0) NOT NULL,
  `blaskuri` decimal(10,0) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=343417 ;

--
-- Dumping data for table `temps`
--

INSERT INTO `temps` (`id`, `date`, `ulko`, `olohuone`, `ilpin`, `ilpout`, `pannuh`, `pannuhk`, `sauna`, `autotalli`, `takavarasto`) VALUES
(1, '2010-03-31 08:53:21', 0.12, 22.81, 24.69, 37.31, 24.31, 27.00, 0.00, 0.00, 0.00);

CREATE TABLE `temps` (                                                                  
          `id` int(10) unsigned NOT NULL AUTO_INCREMENT,                                        
          `sensor_serial` char(24) COLLATE latin1_general_ci DEFAULT NULL,                      
          `temp_c` float DEFAULT NULL,                                                          
          `date` datetime DEFAULT NULL,                                                         
          PRIMARY KEY (`id`),                                                                   
          KEY `date` (`date`)                                                                   
        )

Pal wrote:Hello!

I installed HomeAutomation 2.2 on a Hyper-V virtual Windows 2008 R2 Server with IIS 7 and PHP 5.3.3, connecting to MySQL 5.1.53 on another Hyper-V virtual Windows 2008 R2 Server on the same physical host. The Tellstick is connected to the physical host and shared to the virtual machine using the Fabulatech USB over Network solution.

The Tellstick works fine, and the HomeAutomation setup process works fine all the way to the "Delete install directory". When clicking the button, it said it couldn't delete the install directory (all permissions were fine though). So, I deleted it manually. The button still replied the same thing. So, I enabled the "Finish installation" button by editing the DOM.

After that (when I assume it is supposed to go to the actual page for the first time?), I got this error:

Code: Select all

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' false, true) AS active, e.ipaddress, u.username, d.description FROM even' at line 1
SELECT e.status, IF(dt.type = 'absdimmer', e.dimlevel, 0) AS dimlevel, e.timestamp, IF(TIMESTAMPDIFF(HOUR, e.timestamp, now()) >= , false, true) AS active, e.ipaddress, u.username, d.description FROM events e LEFT JOIN users u ON e.userid = u.id INNER JOIN devices d ON d.id = e.device_id INNER JOIN devicetypes dt ON dt.id = d.type ORDER BY e.id DESC LIMIT 5

I found the query on line 533 in dbfunction.php. The line looks like this:

Code: Select all

		$query = "	SELECT e.status, IF(dt.type = 'absdimmer', e.dimlevel, 0) AS dimlevel, e.timestamp, IF(TIMESTAMPDIFF(HOUR, e.timestamp, now()) >= ".$_SESSION[CFG_SESSION_KEY]["settings"]["hoursstatusactive"].", false, true) AS active, e.ipaddress, u.username, d.description 
					FROM events e 
					LEFT JOIN users u ON e.userid = u.id 
					INNER JOIN devices d ON d.id = e.device_id 
					INNER JOIN devicetypes dt ON dt.id = d.type";

Apparently, the session variable $_SESSION[CFG_SESSION_KEY]["settings"]["hoursstatusactive"] returned nothing.

I added this after the session_start(); line in index.php:

Code: Select all

$_SESSION['favcolor'] = 'green';
echo($_SESSION["favcolor"]);

and it output "green" before the error messages. So, PHP_SESSION was working. php_info() also said that session is loaded.

I checked the settings table in the database, and there was no hoursstatusactive row. I added this:

Code: Select all

INSERT INTO `homeautomation`.`settings` (`id`,`name`,`grouping`,`label`,`value`,`type`,`sort`) VALUES (NULL,'hoursstatusactive','infobox','hoursstatusactive','3','text','126');

And then it started to work.

Just thought I'd let you know. I guess an easy and nice way to solve it is to give the hoursstatusactive a reasonable default, and maybe also add it in the database if it's not there.

The setup process asks for the JT.EXE path, but doesn't say that it should be the directory path, and not a path including the JT.EXE file itself. It will let you know this when you open the page at the first time after setup, but then you need to find the row in the database to fix it. A comment in the setup would be a good thing (or make it recognize both ways).

And at last, my actual question: I see no devices. Am I supposed to do something more to get the device into HomeAutomation? The Telldus stuff is already configured to share the devices to all users (to get it to work nicely with the Fabulatech service).

Regards
/P

Pal wrote:I know it should be there (I checked the files), but it wasn't. A bunch of other settings were there though.

jtbinpath was there, but I set it to C:\Program Files (x86)\jt.exe in stead of just C:\Program Files (x86). The setup didn't warn me about this, and there was no comment telling me which variant it wanted. When going to the site after setup, it did warn me however, and I could change it in the database.

Pal wrote: I couldn't change it on the settings page, since I didn't have any Configuration - Settings page yesterday. Under Configuration I only had devices, house plan and scenarios. Today I have user and settings links as well. Don't know why that changed, but today I had to login and yesterday I didn't. Could that be why user and settings wasn't there? Yesterday I was on the local network, and now I am at work. Could that be why I didn't have to login yesterday? Or did the setup process log me in? Yesterday the interface was in English, today it is in Swedish. Could that make any difference?

Pal wrote: And I know I could always just reinstall the whole thing, but then I wouldn't be able to give you the feedback. And I don't want things just to work, I'm nerd enough to want to know why they don't work.

The tdtoolpath is set to C:\Program Files (x86)\Telldus. Looks right to me? There was no devices mentioned during the setup process. But the Telldus Center is working fine, so the device is there allright.

Pal wrote:Thanks, then I got answers to all my questions.

Which leads me to ask new ones.

I changed the tdtoolpath to C:\Progra~2\Telldus and updated from Tellstick, but still no devices. I can't find anything about debug on the settings page, but if you give me what to put in the settings table in the database, I can turn it on that way.

How do I access the log file from web (if it's possible)? http://host.com/homeautomation/logs/logs.txt gives me a 404. But it might not be there while debug is not on?

/P

insert  into `settings`(`name`,`grouping`,`label`,`value`,`type`,`sort`) values ('debug','userinterface','debugmode','1','radio',118);

Pal wrote:I tried something similar, but set grouping to system...

Anyway, the debug setting is there, the debug data is there (in black text on black background but viewable by selecting it) and the debug file is there. And the device is there:

Code: Select all

2010-12-01	12:45	Pal	137.61.234.225	Locking dongle
2010-12-01	12:45	Pal	137.61.234.225	Command: C:\Progra~2\Telldus/tdtool.exe --list
Output:
Number of devices: 1
3	Vardagsrumsfönstret	ON
2010-12-01	12:45	Pal	137.61.234.225	Unlocking dongle

But still no devices on the web page, nor in the database.

function ImportTelldusDevices()
{
	foreach($devices as $device)
	...

function ImportTelldusDevices()
{
	echo "<pre>Devices:";
	print_r($devices);
	echo "<pre>";

	foreach($devices as $device)
	...

// error_reporting(E_ALL);
error_reporting(E_ALL ^ E_NOTICE);

error_reporting(E_ALL);
//error_reporting(E_ALL ^ E_NOTICE);