Go to advanced search

by DougieLawson
Tue Aug 14, 2018 8:14 am
Forum: Python
Topic: sending data from raspberry pi3 to ms sql server
Replies: 6
Views: 101

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: 101

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: 11
Views: 188

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: 197

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: 441

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: 6
Views: 137

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: 190

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: 101

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: 609

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...
by DougieLawson
Sat Aug 11, 2018 1:56 pm
Forum: Interfacing (DSI, CSI, I2C, etc.)
Topic: Switch bipolar relais with MCP23107
Replies: 12
Views: 229

Re: Switch bipolar relais with MCP23107

Have you set register 0x00 & 0x01 the iodira/iodirb registers default to all input.
by DougieLawson
Sat Aug 11, 2018 1:53 pm
Forum: Networking and servers
Topic: Unknown port open on Raspberry Pi
Replies: 2
Views: 130

Re: Unknown port open on Raspberry Pi

You don't have an open port. That's clearly an ephemeral connection to some external service.

You may find some ephemeral ports are the RPi talking to itself.
by DougieLawson
Sat Aug 11, 2018 1:42 pm
Forum: Beginners
Topic: How to detect an old style wired doorbell only - nothing else
Replies: 20
Views: 375

Re: How to detect an old style wired doorbell only - nothing else

Thanks for all the info As a future project, I wonder if its worth removing the chime box altogether... Wire the doorbell button to the PI Let the PI talk to something like an ECHO DOT to produce a chime? A bell push with resistor wired to a GPIO can give you a signal when the caller rings. Another...
by DougieLawson
Sat Aug 11, 2018 5:58 am
Forum: Beginners
Topic: Raspbian Desktop mode
Replies: 3
Views: 175

Re: Raspbian Desktop mode

You need a minimal desktop to run RealVNC

sudo apt install raspberrypi-ui-mods
should pull in what you need on a Raspbian Lite system.
by DougieLawson
Sat Aug 11, 2018 5:54 am
Forum: Troubleshooting
Topic: Dhcp kill all network even Xwindows failed to restart
Replies: 6
Views: 118

Re: Dhcp kill all network even Xwindows failed to restart

If you're never planning to take your Raspberry Pi roaming round the world
sudo apt purge rfkill
will solve your pain.

That change isn't approved by the RPF folks as it's part of their WiFi compliance stuff.
by DougieLawson
Sat Aug 11, 2018 5:30 am
Forum: Beginners
Topic: Problems with maria db
Replies: 3
Views: 90

Re: Problems with maria db

Here's an example of using string substitution in python. #!/usr/bin/env python import mysql.connector as sql import time import datetime sensorData = sql.connect(user='dougie', password='secretpassword', host='192.168.3.14', database='sensordata') bmp_data = sensorData.cursor() endTime = datetime.d...
by DougieLawson
Fri Aug 10, 2018 10:00 pm
Forum: General discussion
Topic: I have the [Insert ressurected son of deity of choice here] of micro SD cards??
Replies: 20
Views: 513

Re: I have the [flying spaghetti monster] of micro SD cards??

RubyRiley wrote:
Fri Aug 10, 2018 7:44 am
DougieLawson wrote:
Fri Aug 10, 2018 7:06 am
The OP hasn't told us which models of Raspberry she is using.
I'm using Raspberry Pi 3 Model B+
Is the SDCard NOOBS 2.8.2 or Raspbian 2018-06-27 or something earlier?
by DougieLawson
Fri Aug 10, 2018 7:17 am
Forum: Beginners
Topic: No IP address via DHCP
Replies: 15
Views: 26942

Re: No IP address via DHCP

Do you have MAC address filtering on your router?

How many addresses are assigned to the router's DHCP pool?

Start by giving the router a reboot.
by DougieLawson
Fri Aug 10, 2018 7:14 am
Forum: Beginners
Topic: Raspberry Pi Not booting - Bricked PI?
Replies: 25
Views: 573

Re: Raspberry Pi Not booting - Bricked PI?

If you're in Europe and can convince your vendor that it's a faulty board rather than your fault then there is a two year warranty.
by DougieLawson
Fri Aug 10, 2018 7:12 am
Forum: Beginners
Topic: Html/php or permission problems?
Replies: 2
Views: 78

Re: Html/php or permission problems?

sudo usermod -a - G gpio www-data
by DougieLawson
Fri Aug 10, 2018 7:06 am
Forum: General discussion
Topic: I have the [Insert ressurected son of deity of choice here] of micro SD cards??
Replies: 20
Views: 513

Re: I have the [flying spaghetti monster] of micro SD cards??

The OP hasn't told us which models of Raspberry she is using.
by DougieLawson
Fri Aug 10, 2018 7:01 am
Forum: General discussion
Topic: Flight Monitoring
Replies: 9
Views: 843

Re: Flight Monitoring

PiAware installs a bunch of lighttpd pieces. The data (with MLAT) is fed to Flightaware.
by DougieLawson
Fri Aug 10, 2018 6:51 am
Forum: Other programming languages
Topic: PHP & Serial comm with RPi?
Replies: 3
Views: 115

Re: PHP & Serial comm with RPi?

Open an LXTerminal window and enter these two commands
sudo usermod -a -G dialout www-data
sudo reboot
by DougieLawson
Thu Aug 09, 2018 5:24 pm
Forum: General discussion
Topic: Pi MAC-address uniqueness
Replies: 7
Views: 1273

Re: Pi MAC-address uniqueness

Is it really related the birthday paradox as that has a much more limited number of possible values from a set of 365 with one edge case?
by DougieLawson
Thu Aug 09, 2018 4:49 pm
Forum: General discussion
Topic: Flight Monitoring
Replies: 9
Views: 843

Re: Flight Monitoring

I'm running PiAware. one day I'm hoping to catch a H47 Chinook from RAF Odiham (EGVO) flying too low over my house. I've already caught a couple of daft callsigns (AIRWOLF1 & AIRWOLF2) out of Odiham. Best aircraft yet was PA474 (BBMF Lancaster) flying over. Might try taking it abroad next time I get...

Go to advanced search