search

dico / mysmarthome

Other
1 stars 0 forks source link

Question about telldus live connection #1

Open norpan opened 8 years ago

norpan commented 8 years ago

How do I set up a connection to Telldus Live? In fuTelldus there was a setting on the profile page, but I can't find anything in MSH.

dico commented 8 years ago

Under your user in upper right corner, and settings->bindings->telldus from there.

norpan commented 8 years ago

Yes, I saw that one. It says: "No installed bindings found... Install some bindings to get started with your smarthome!" And a button with "Upload binding", but I'm not sure what file to upload.

dico commented 8 years ago

Oh, looks like the bindings wasn't added with the commit. I would probably add these as own repositories though.

But in the meantime, here is the telldus binding: https://www.dropbox.com/sh/xq8tz8uj2128raw/AADCJPvapYbIV3ws4-iC7AVPa?dl=0

If you upload this .zip files under /bindings (you probably need to create the bindings-folder in the root). You should be able to install it from the MSH-GUI (not tested enough and depends on read/write to the bindings-folder).

If you can't install it, just unzip the files to /bindings/telldus.live. You have to add the db-table from the db.sql in the telldus.live binding.

Other bindings i have or I'm working on: Netatmo - Finish Carwings Nissan Leaf - In progress Intesishome - Planned Heatmiser - Planned

norpan commented 8 years ago

Ok! That explains that. Next hurdle. There seem to be a mismatch in the DB, the telldus binding referers to a column type in the table msh_devices which is not there.

dico commented 8 years ago

I see that the column device_alias is missing from the db.sql in MSH. I have updated this now, but it looks like the telldus binding is still trying to write data to columns that should be deprecated.

Quick fix:

/binding/telldus.live/sync.php Lines:

206-217

238-248

335

631

...or...

The deprecated columns should have no impact on the web-application, other that I just haven't cleaned up the code in the telldus binding.

Here is an direct export of mine:

CREATE TABLE IF NOT EXISTS msh_devices ( device_int_id int(11) NOT NULL, user_id int(11) NOT NULL, module varchar(64) NOT NULL COMMENT 'DEPRECATED', binding varchar(64) NOT NULL, device_ext_id varchar(256) NOT NULL, device_name varchar(128) NOT NULL, device_alias varchar(128) NOT NULL, type varchar(64) NOT NULL COMMENT 'DEPRECATED', type_desc varchar(32) NOT NULL COMMENT 'DEPRECATED', category varchar(64) NOT NULL COMMENT 'DEPRECATED', description varchar(256) NOT NULL, description2 varchar(256) NOT NULL COMMENT 'DEPRECATED', icon varchar(128) NOT NULL, url varchar(256) NOT NULL, latitude double NOT NULL, longitude double NOT NULL, value_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED', value2_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED', value3_unit tinyint(4) NOT NULL COMMENT 'DEPRECATED', battery double NOT NULL, state float NOT NULL COMMENT 'Device current state. Use when not log.', dashboard tinyint(4) NOT NULL COMMENT 'view on dashboard', dashboard_size varchar(32) NOT NULL COMMENT 'small, wide, big', monitor tinyint(4) NOT NULL, public tinyint(4) NOT NULL, deactive tinyint(4) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=736 DEFAULT CHARSET=latin1;

ALTER TABLE msh_devices ADD PRIMARY KEY (device_int_id), ADD KEY device_ext_id (device_ext_id);

ALTER TABLE msh_devices MODIFY device_int_id int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=736;