Go to advanced search

by DougieLawson
Tue Aug 14, 2018 12:28 pm
Forum: Python
Topic: pi to pi communication
Replies: 1
Views: 23

Re: pi to pi communication

python with mosquitto talking MQTT pub/sub is a simple well documented way to do that stuff.
by DougieLawson
Tue Aug 14, 2018 12:22 pm
Forum: Troubleshooting
Topic: Tutorial for MQTT on Raspbian Jessie?
Replies: 41
Views: 57585

Re: Tutorial for MQTT on Raspbian Jessie?

You can assign your 169.254.78.169 IP with sudo ifconfig eth0 169.254.78.169/16 Maybe not... This is an RPi Zero, hence no Ethernet port, and it has been set up as a standalone WiFi access point. (You have also advised the same user in this parallel thread: https://www.raspberrypi.org/forums/viewto...
by DougieLawson
Tue Aug 14, 2018 12:20 pm
Forum: Beginners
Topic: Move ssh key to other builds?
Replies: 4
Views: 62

Re: Move ssh key to other builds?

The simple answer is don't. You compromise your security doing that. Raspbian discovered that flaw and they regenerate SSH keys on first boot.

So you can steal borrow the code from Raspbian.
by DougieLawson
Tue Aug 14, 2018 12:20 pm
Forum: Beginners
Topic: Move ssh key to other builds?
Replies: 4
Views: 62

Re: Move ssh key to other builds?

The simple answer is don't. You compromise your security doing that. Raspbian discovered that flaw and they regenerate SSH keys on first boot.

So you can steal borrow the code from Raspbian.
by DougieLawson
Tue Aug 14, 2018 12:17 pm
Forum: Beginners
Topic: Syncing Current IP
Replies: 2
Views: 55

Re: Syncing Current IP

Anything that uses an IP address for any kind of security credential is never going to be secure.

There's dozens of ways to determine your public IP. The usual one is with the dyndns auto updater. That's a simple C program that's easy to hack for your own purpose.
by DougieLawson
Tue Aug 14, 2018 12:10 pm
Forum: Troubleshooting
Topic: I need help with connecting my Pi to a WPA2 Enterprise Wifi
Replies: 1
Views: 27

Re: I need help with connecting my Pi to a WPA2 Enterprise Wifi

Pay a visit or pick up the phone. Your uni/school help desk are paid to help you get connected. That's their day job.
by DougieLawson
Tue Aug 14, 2018 9:07 am
Forum: General discussion
Topic: MQTT installation on Stretch fixed?
Replies: 9
Views: 4432

Re: MQTT installation on Stretch fixed?

sudo apt install mosquitto mosquitto-client*
Works on latest Stretch.
by DougieLawson
Tue Aug 14, 2018 8:57 am
Forum: Beginners
Topic: mariadb connection
Replies: 2
Views: 52

Re: mariadb connection

As Dirk says error 111 has three possible causes.

1. Wrong IP, port may be right or wrong
2. Right IP, wrong port
3. Right IP, right port server not listening

You problem is clearly #3.
by DougieLawson
Tue Aug 14, 2018 8:50 am
Forum: AIY Projects
Topic: AIY Voice V1 - No luck with RPI 3 B+
Replies: 1
Views: 36

Re: AIY Voice V1 - No luck with RPI 3 B+

That's not true.

My AIY has been on my 3B+ since I got it.

I built it by copying /opt/aiy/* from the downloaded image then installing all of the aiy* packages over that with apt-get.
by DougieLawson
Tue Aug 14, 2018 8:42 am
Forum: Troubleshooting
Topic: Ethernet port has no lights turned on
Replies: 8
Views: 128

Re: Ethernet port has no lights turned on

... " CAT6 Flat Ethernet Cable " ... Just FYI you cannot have flat cat6 cable but the rest is interesting Who cares? If we assume the OP has tested whatever cable he/she is using means your meta-discussion is off-topic. Can we concentrate on offering solutions that might help ratherr than discussin...
by DougieLawson
Tue Aug 14, 2018 8:36 am
Forum: General discussion
Topic: Which operating system for Pi Zero W as access point, MQTT only
Replies: 25
Views: 445

Re: Which operating system for Pi Zero W as access point, MQTT only

MQTT is a layer 4 protocol. Layer 4 has an assigned PORT number.

IP addresses are assigned at layer 2.

What you mean is the IP address for the server running your MQTT broker (which is most likely Mosquitto at port 1883).
by DougieLawson
Tue Aug 14, 2018 8:31 am
Forum: Troubleshooting
Topic: My pi keeps getting frozen , sometimes screen pixel freeze, what should I do ,
Replies: 1
Views: 72

Re: My pi keeps getting frozen , sometimes screen pixel freeze, what should I do ,

Try building a new SDCard with Raspbian Stretch. You'll get a year's worth of fixes that way.
by DougieLawson
Tue Aug 14, 2018 8:28 am
Forum: Python
Topic: sending data from raspberry pi3 to ms sql server
Replies: 6
Views: 90

Re: sending data from raspberry pi3 to ms sql server

Search "raspberry mssql unixodbc site:raspberrypi.org" and you'll find the old posts. I'd do it for you but it's not easy on my phone in an airport.
by DougieLawson
Tue Aug 14, 2018 8:25 am
Forum: Troubleshooting
Topic: Tutorial for MQTT on Raspbian Jessie?
Replies: 41
Views: 57585

Re: Tutorial for MQTT on Raspbian Jessie?

You can assign your 169.254.78.169 IP with

sudo ifconfig eth0 169.254.78.169/16
by DougieLawson
Tue Aug 14, 2018 8:21 am
Forum: Troubleshooting
Topic: MotioneyeOS: Change default date after crash
Replies: 1
Views: 19

Re: MotioneyeOS: Change default date after crash

Add an external RTC like a ds1307 or ds3231.
by DougieLawson
Tue Aug 14, 2018 8:14 am
Forum: Python
Topic: sending data from raspberry pi3 to ms sql server
Replies: 6
Views: 90

Re: sending data from raspberry pi3 to ms sql server

Is your local Google broken?
by DougieLawson
Tue Aug 14, 2018 8:12 am
Forum: Python
Topic: sending data from raspberry pi3 to ms sql server
Replies: 6
Views: 90

Re: sending data from raspberry pi3 to ms sql server

You'll need unixodbc
by DougieLawson
Tue Aug 14, 2018 5:48 am
Forum: Troubleshooting
Topic: Ethernet port has no lights turned on
Replies: 8
Views: 128

Re: Ethernet port has no lights turned on

Do you have a power supply that's up to the job? The first things to stop working with a weedy supply are the ethernet & USB.

Also are you using the very latest Raspbian?
by DougieLawson
Mon Aug 13, 2018 4:13 am
Forum: For sale
Topic: Terrible service from an official Pi reseller. The Pi Shop
Replies: 4
Views: 180

Re: Terrible service from an official Pi reseller. The Pi Shop

As a value added reseller the PiShop is nothing to do with the RPF or RP(T) Ltd. so I wonder why you've published your rant here.
by DougieLawson
Sun Aug 12, 2018 8:15 pm
Forum: AIY Projects
Topic: New AIY *drastically* reduces recording volume [evidence]
Replies: 6
Views: 436

Re: New AIY *drastically* reduces recording volume [evidence]

Have you tried "OK Google, speak louder."?
by DougieLawson
Sat Aug 11, 2018 7:27 pm
Forum: C/C++
Topic: C and mysql query in a loop issue
Replies: 2
Views: 81

Re: C and mysql query in a loop issue

Sprinkle around some commit() calls. Add an explicit close() for your cursors.
by DougieLawson
Sat Aug 11, 2018 7:20 pm
Forum: Troubleshooting
Topic: One of my Pi:s cannot connect to internet, needs 192.168.x.x, gets 169.254.x.x.
Replies: 9
Views: 189

Re: One of my Pi:s cannot connect to internet, needs 192.168.x.x, gets 169.254.x.x.

Have you eliminated

1. Bad port on router/switch
2. Bad WiFi credentials
3. Bad Raspberry power supply (any sign of the on-screen lightning bolt)
by DougieLawson
Sat Aug 11, 2018 2:18 pm
Forum: Python
Topic: Database updates on runtime not detected
Replies: 6
Views: 98

Re: Database updates on runtime not detected

Make the updates atomic. Sprinkle some commit() calls in your code. Also close your cursor for a reader to release locks. You should also switch from MYISAM to INNODB or ARIADB as those both have better support for ACID (which you need for a data reader). Consider making ever SQL statement run as a ...
by DougieLawson
Sat Aug 11, 2018 2:03 pm
Forum: Add-ons
Topic: ETA for Official POE Hat for 3B+
Replies: 20
Views: 596

Re: ETA for Official POE Hat for 3B+

Farnell are being secretive, but RS aren't - https://uk.rs-online.com/web/p/power-management-development-kits/1735595/ "Available to back order for despatch 21/08/2018" Knowing RS that date doesn't mean anything. Too true. My first RPi1B was ordered in August 2012 and delivered in October. Never bu...

Go to advanced search