MySQL Forums :: Connector/Arduino :: MySQL and Arduino Chapter 7


Advanced Search

Re: MySQL and Arduino Chapter 7
Posted by: Richard Mason ()
Date: April 07, 2014 01:11AM

Well, following my recent frustrations I've proceeded to the next problem
First to note that that in the /etc/mysql/my.cnf file under the [mysqld] section it said:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1

which explains why I couldn't connect using the pi's assigned ip address
Now that's fixed the the sketch on page 234 of the book runs - sort of.

I added a disconnect() and, starting with an empty arduino.hello table, opening of the Serial Monitor results in:
Connecting
Connecting to server version 5.5.35-0+wheezy1
Query Success!
Disconnected

Good, except there is not one entry into the database but three!
The first shouldn't be there at all as its time stamp preceeds the actual opening of the Serial Monitor. The second entry is the expected one. The third entry is triggered by closing the Serial Moniter

Options: ReplyQuote


Subject Views Written By Posted
MySQL and Arduino Chapter 7 2380 Richard Mason 03/31/2014 01:35AM
Re: MySQL and Arduino Chapter 7 1330 Richard Mason 04/07/2014 01:11AM
Re: MySQL and Arduino Chapter 7 1227 Charles Bell 04/08/2014 11:31AM
Re: MySQL and Arduino Chapter 7 1306 Richard Mason 04/10/2014 07:22PM
Re: MySQL and Arduino Chapter 7 1524 Charles Bell 04/08/2014 11:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.