Go to advanced search

by harvy
Tue Sep 10, 2019 7:40 pm
Forum: Raspberry Pi Desktop for PC and Mac
Topic: docker on raspberry pi desktop for PC
Replies: 1
Views: 80

docker on raspberry pi desktop for PC

Hi all, Im testing/playing with setting up PI Hole, which i want to run in a docker container to allow it to be restarted automatically etc in case of any problems, plus be able to rebuild quickly if i break it. I have an ESXI Host where i have rasbpian for pc installed, but am having problems insta...
by harvy
Wed Jan 10, 2018 9:18 pm
Forum: Troubleshooting
Topic: Raspberry password is change automatically
Replies: 15
Views: 3018

Re: Raspberry password is change automatically

I've just had the same on one of my four pi's today - some time around mid day GMT... The pi is NOT internet facing - its behind my router, and only openvpn port to another device... nothing in bash_history for pi user. default ssh port is not 22, and pi user is not default. but meanwhile pi is runn...
by harvy
Wed Jan 10, 2018 9:03 pm
Forum: Troubleshooting
Topic: Password changed and new rsh key?
Replies: 0
Views: 167

Password changed and new rsh key?

So i have a pi setup to control my heating, runs come custom python code for reading DS1820b sensors, and writes to a mysql db (on a seperate server). It also runs some code to host a python based web page, to display room temp, and ability to adjust the temp. Been using it for best part of 5 months...
by harvy
Thu Jan 04, 2018 7:55 pm
Forum: General programming discussion
Topic: some SQL help
Replies: 4
Views: 894

Re: some SQL help

I cant do mysqldmp as its not installed (im running the db on a synology nas box - its installed via phpmyadmin rather then directly). I've done a create like to get the sql: -- Table structure for table `temp_log` -- CREATE TABLE IF NOT EXISTS `temp_log` ( `measurement_id` int(11) NOT NULL AUTO_INC...
by harvy
Fri Dec 29, 2017 7:31 pm
Forum: General programming discussion
Topic: some SQL help
Replies: 4
Views: 894

Re: some SQL help

bit of headscratching later: set @sensor='28-00000595cc2a'; set @log=2100; select (hour(TIMEDIFF(b.time,a.time))*60)+minute(TIMEDIFF(b.time,a.time)) as Seconds_on, b.current-a.current as temp_increase from heating_log AS a, heating_log AS b where a.log_id = @log and b.log_id = (select min(log_id) fr...
by harvy
Fri Dec 29, 2017 4:49 pm
Forum: General programming discussion
Topic: some SQL help
Replies: 4
Views: 894

some SQL help

Having a bit of a dense moment - I have a log table for heating, everytime the heating comes on, i get an entry for what the current temp is, the target temp, time, and on or off. example entrys are: log_id sensor_id time Ascending current target on_off(1 signifies on, 0 is off) 2137 28-00000595cc2a...
by harvy
Mon Apr 03, 2017 9:02 pm
Forum: Automation, sensing and robotics
Topic: Sensing when Garage Door is Open
Replies: 25
Views: 15410

Re: Sensing when Garage Door is Open

Evening all, Apologies for bringing this one back up, just wandered if someone can help me with this? I'm doing the same, but without the LED's. I want to know when the sensor is open/closed and use that in a program. I've connected a 270 ohm between 3.3 and pin 17, from pin 17 to the relay, which t...
by harvy
Thu Feb 16, 2017 6:20 pm
Forum: Troubleshooting
Topic: how many DS1820b's on a single Pi
Replies: 5
Views: 938

Re: how many DS1820b's on a single Pi

Just to update, changed to 2k2, and all sensors are working ok apart from one, which is only reporting 85.... Which I think is not initialized...

One day I'll get round to checking
by harvy
Mon Jan 23, 2017 3:42 pm
Forum: Troubleshooting
Topic: how many DS1820b's on a single Pi
Replies: 5
Views: 938

Re: how many DS1820b's on a single Pi

I've done a star topology, in hindsight prob should have done it differently, but wiring is done now... I will change the resistor to 2K2 and see if its any better. Is there a way to measure and calculate the value the resistance should be? I have a basic multi meter which can measure resistance, vo...
by harvy
Mon Jan 23, 2017 1:51 pm
Forum: Troubleshooting
Topic: how many DS1820b's on a single Pi
Replies: 5
Views: 938

how many DS1820b's on a single Pi

Good Afternoon, I have a number of sensors wired up around the house for floor and room tempratures. All individually work and give me correct readings (except 1 which consistantly gives me a reading of 85), however they all drop off the pi if being used together. Setup is as follows: 1 sensor is bu...
by harvy
Tue Dec 27, 2016 12:49 am
Forum: Advanced users
Topic: pin sizes
Replies: 14
Views: 4809

Re: pin sizes

0.1" equals 0.54mm. The thickness of a pinheader pin is very stricktly defined, but almost nowhere documented, I guess only producers really know. :( Could try to find out, but iT woud be easier to assume its 1mm, and just try Your ferrule. Your Google fu is not strong: http://docs-europe.electroco...
by harvy
Mon Dec 26, 2016 9:54 pm
Forum: Advanced users
Topic: pin sizes
Replies: 14
Views: 4809

pin sizes

I'm looking to purchase some bootlace ferrules, but not sure on size. What i want to do is connect a number of cat5 strands together on a board which then connects to the raspberry pi's. Cleanest way i can think of (and to allow future changes as needed) is to put a bootlace on the end and plug onto...
by harvy
Mon Nov 07, 2016 8:19 pm
Forum: Beginners
Topic: github gui application for pi
Replies: 4
Views: 3117

Re: github gui application for pi

cheers DougieLawson,

its the branches that i am getting confused with, more syntax rather then anything but the magpi issues 27-29 clear up some things!

Will make a cheat sheet to help me tomorrow!
by harvy
Mon Nov 07, 2016 7:27 pm
Forum: Beginners
Topic: github gui application for pi
Replies: 4
Views: 3117

github gui application for pi

Good afternoon, Is there any programs available to assist in marking files to upload, and manage branches etc for repos from github? I'm developing some software and am putting it on github to a) backup, b) make it available if anyone else wants to use it, but i'm finding myself spending more time t...
by harvy
Thu Sep 08, 2016 11:45 am
Forum: Beginners
Topic: Booting my raspberry Pi for the first time
Replies: 8
Views: 1509

Re: Booting my raspberry Pi for the first time

On a recent new install i did with Jessie on a Pi2 B, so long as it was connected to the network and i could find its ip address, i could ssh into it using my laptop over the network and configure all i wanted. Easiest way to get the IP for me was to check my router for connected devices... I don't ...
by harvy
Wed Aug 17, 2016 11:08 am
Forum: Automation, sensing and robotics
Topic: send data sensor to hosting server
Replies: 3
Views: 2575

Re: send data sensor to hosting server

I've used mysqldb. import MySQLdb as mdb Setup a new connection as such: first for a select statement , then an insert def select_sql(command): """Will execute a select command onto the pi schema on remote database and return the value""" try: ## host, userid, password, database instance con = mdb.c...
by harvy
Thu Aug 04, 2016 11:18 am
Forum: Python
Topic: FOR loop and DS18B20 sensors
Replies: 2
Views: 712

Re: FOR loop and DS18B20 sensors

I've used this: def main(): #clear_sensors() Main_sensor_list=get_current_sensors() for i in range(0,len(Main_sensor_list)): update_value(Main_sensor_list[i]) if __name__ == "__main__": main() get_current_sensors() will bring back a list of all sensors it finds in the location ef get_current_sensors...
by harvy
Thu Aug 04, 2016 8:01 am
Forum: Python
Topic: MySQL refuses to commit
Replies: 4
Views: 1039

Re: MySQL refuses to commit

thanks for the response DougieLawson,

the rest of my code does to it that way,

I had some casting issues which i never got round to resolving - and as a work around i ended up doing this!

one day i'l get round to sorting it!
by harvy
Wed Aug 03, 2016 3:05 pm
Forum: Python
Topic: MySQL refuses to commit
Replies: 4
Views: 1039

Re: MySQL refuses to commit

My code is as follows: def insert_sql(command): """Will execute an insert or delete command onto the pi schema and commit changes""" logging.debug("Running insert sql "+str(command)) try: ## host, userid, password, database instance con = mdb.connect('host', 'user', 'pass', 'schema'); cursor = con.c...
by harvy
Thu Jun 16, 2016 10:07 am
Forum: Beginners
Topic: Best way to synchronize two Raspberry Pi3
Replies: 7
Views: 3997

Re: Best way to synchronize two Raspberry Pi3

If there is connectivity for a few seconds, could you not sync the time in those few seconds then issue to sensor to get its reading?
by harvy
Mon May 23, 2016 5:51 pm
Forum: Beginners
Topic: Sign of a decent psu?
Replies: 2
Views: 521

Sign of a decent psu?

So I'm looking for a few PSUs to power pos around the house, what kind of components should I expect to see in my power supply to see of its of a decent quality?(physically see rather then measure with specialist tools). For my use, the supply will be removed from its case and mains will be connecte...
by harvy
Thu Apr 14, 2016 12:02 pm
Forum: Interfacing (DSI, CSI, I2C, etc.)
Topic: how to identify pins on DS1820b
Replies: 4
Views: 841

Re: how to identify pins on DS1820b

Thanks rattus, though the sensor is wired and now under tile so i can't see them!

Jogl, I'll give it a go tonight, was wandering if there was any other way in case there is no difference!
by harvy
Thu Apr 14, 2016 10:48 am
Forum: Interfacing (DSI, CSI, I2C, etc.)
Topic: how to identify pins on DS1820b
Replies: 4
Views: 841

Re: how to identify pins on DS1820b

Doing some more thinking, if i just use ground and data (ie "1 wire" install, and get the wires wrong, that shouldn't burn out the sensor should it? I can connect up two of the three wires to ground and data on a pi and see if it gives a reading, If not swap over, until i get readings... then the re...
by harvy
Thu Apr 14, 2016 10:35 am
Forum: Interfacing (DSI, CSI, I2C, etc.)
Topic: how to identify pins on DS1820b
Replies: 4
Views: 841

how to identify pins on DS1820b

So i've done a bit of a silly mistake, I've soldered some leads to three ds1820b's confined they are working and then buried the sensors under tiles. Fast forward a couple of days and with a memory of a goldfish, i now can not remember which colored wire goes to which pin. Is there a way i can ident...

Go to advanced search