MySQL Forums :: Connector/Arduino :: Client disconnects from MySql server


Advanced Search

Client disconnects from MySql server
Posted by: ste z ()
Date: May 23, 2014 09:26AM

I'm facing a problem with the connection to my MySql server.
The connection is lost every 20-22 seconds and i have to connect again.
The connection to the WIFI network is not affected.
I would like to keep the connection alive even if there is no activity (INSERT statements), in order to reduce the delay. Note that the wait_timeout parameter in MySQL server is set to 28800 secs (default).


void setup()
{
Serial.begin(9600);
connectToWiFi();
connectToMySQL();
}

void checkMySQLConnection()
{
if (my_conn.is_connected() == 0)
{
Serial.println("Connection is lost");
connectToMySQL();
}

}


void loop()
{
checkWiFiConnection();
checkMySQLConnection();

//read pressure mat sensor
.
.
//INSERT data to db

delay(100);
}




Using Arduino Uno R3, Arduino WiFi shield R3 (firmware 1.0), and the latest MySql connector.

Any help would be greatly appreciated.

Options: ReplyQuote


Subject Views Written By Posted
Client disconnects from MySql server 2247 ste z 05/23/2014 09:26AM
Re: Client disconnects from MySql server 1105 ste z 06/01/2014 02:01AM


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.