Gabe-Soares
commented
5 years ago include
include
include
include
include
include "calcDist.h"
include
include
byte mac_address[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED }; byte ip_address[] = { 192, 168, 0, 20 }; byte dns_address[] = { 192, 168, 0, 1 }; byte gateway_address[] = { 192, 168, 0, 1 }; byte netmask[] = { 255, 255, 255, 0 };
IPAddress server_ip(, , , ); //Did hide the actual database server IP. EthernetClient client; MySQL_Connection conn((Client *)&client);
char user[] = "", password[] = "", use_bd[] = "USE bd_ic"; //Same to the user and password. bool aux_conn = false;
void setup() { coord c_atual; c_atual.lat = -23.515884; c_atual.lon = -47.756303; Serial.begin(57600); while(!Serial); Serial.print("Serial initialized.\n"); Ethernet.begin(mac_address, ip_address, dns_address, gateway_address, netmask); delay(3000); Serial.print("Connecting to internet.\n"); Serial.println(Ethernet.localIP());
//This is where the code stops. Sometimes it runs on a looping from the begining of setup() till this line, sometimes it just stops.if (conn.connect(server_ip, 3306, user, password)){
//This code isn't executed.
Serial.print("Connection stablished.\n");
//This is the query I'm concatenating.
char select[251] = "SELECT coord_lat_cli,coord_long_cli FROM cliente_tb, atividade_tb WHERE coord_lat_cli!=\"\" AND coord_long_cli!=\"\" AND fk_id_cli=id_cli AND data_ativ='"; //String base do SELECT.
char data[31], hora_ini[31], hora_fin[10]; //Strings de apoio para a montagem do SELECT.
Serial.print("Definindo variáveis de data e hora.\n");
strcpy(data, "20180220' AND hora_ini_ativ<='");
strcpy(hora_ini, "11:30:00' AND hora_fin_ativ>='");
strcpy(hora_fin, "12:30:00'");
Serial.print("Montando SELECT.\n");
strcat(select, data);
strcat(select, hora_ini);
strcat(select, hora_fin);
//Exibindo select montado.
Serial.println(select);
MySQL_Cursor *cursor_mem = new MySQL_Cursor(&conn);
cursor_mem->execute(use_bd); //Executa o comando de "USE" do sql.
delete cursor_mem; //Deletar o cursor criado, recomendação do desenvolvedor da biblioteca, pelo uso de memória.
aux_conn = true;} else{ Serial.println("!- Conexão falhou."); conn.close(); Serial.println("!- Tentativa de conexão finalizada."); }
if(aux_conn){ Serial.println("Executando a consulta."); MySQL_Cursor *cursor_mem = new MySQL_Cursor(&conn); cursor_mem->execute(select); //Executa o comando de "SELECT" do sql.
//There's more code after this, but i don't think it's necessary , so if it's needed, I could copy it later.} }
I did try to think where could the bug be, i tought about:
- Memory overload.
- Problem generating or executing the query.
- Some type of multithread problem with any proccess of cann.çconnect()
Once again, anticipated thanks for the atention!
ChuckBell
chakthy
Hey! I'm working on a arduino UNO project with a Ethernet shield w5100. My project should be able to connect to a online database and return some coordinates under some where clauses (the day and time the code is running, solving the bug I'm dealing with right now, I'm probably going for TimeStamp or something like that). So, I'm using strcat() to concatenate the strings and generate the Select query. It's also good to tell that both datas I'm selecting are doubles, and the fields I'm comparing in the where clauses are date and time type (I don't have idea if the bugs there). The weird thing is that I've made a LOT of tests with slightly different codes to try to catch the bug, but i couldn't, and the results on the tests somehow did vary. (Most of my code runs on the setup function) Some of the tests simply stopped on the following line:
if (conn.connect(server_ip, 3306, user, password))Other tests I don't know why run the code until this line, and then begin a looping, restarting the setup till this if, and doing it again, and again.... Some codes I did write on the begining of the project (with less code after the connection, but the same code before it) are still working, so I'm suspecting of memory overload maybe [?]. That's it... I don't have any idea what's causing this, but it can connect to the internet, but not to the database server. Thanks for the atention! I hope you can help me solve this, I'm stuck on this for too long!I'll post some of my code soon.