Hi,
Thanks in advance for your kind support.
I am not an expert but have little understanding of concepts and trying to integrate various things to get some useful projects for my purpose. I want to update the database (MySQL) on shared hosting using the SIM900A module and Arduino nano board. With help of examples shared on this platform and my understanding, I achieved a significant part of the same. The following is the approach I have adopted and the current status:
I have put a PHP code on the server (shared hosting) to update the database once it received the GET request
I have also uploaded the code in the Arduino with proper connections for sending requests to the server.
Problems I am facing:
I am not able to update the data on my specific database, through the Arduino sent request. the same code is working with Thingspeak, My code is also working otherwise, as I have tested through web form request and URL request. I am not sure where is the problem. I am also not getting any errors. The response to the AT request is "OK" only
Though I can update the Thingspeak channel, only till the command lesser than 61characters, which are sent after the AT+CIPSEND command. There is no error, even if the request size increases, but data updated only till 61 characters (including \x1A character)
"I am wondering, is this the limit, that cannot be increased or there is some possibility to increase it."
I understand that the problem appears to be in approach and not in code, as the code is working in itself. However, please let me know, which code I need to share, as it is a multifile code on the web-editor
Thanks for your response. Where and how I can get the server log. It is a Linux server (inmotion hosting). There is one directory with name "logs". However, it has no file/folder with the time matching with my latest session. putting down some last lines, which may be corresponding to my yesterday's session:
However, I don't think it is related to my issue. I also found one session file that may be linked with my issue, but I am not able to decode it. as there is no timestamp in lines, I am putting the whole content of the file.
PMA_token |s:32:"6645432e267d3270532a427a65283e64"; HMAC_secret |s:16:"zla^%JWEF2T7l)6c";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1617159173;}encryption_key|s:32:"!|aЭ ]ь@ГКїика9jkееp НГz";relation|a:1:{i:1;a:22:{s:11:"PMA_VERSION";s:5:"4.9.4";s:7:"relwork";b:0;s:11:"displaywork";b:0;s:12:"bookmarkwork";b:0;s:7:"pdfwork";b:0;s:8:"commwork";b:0;s:8:"mimework";b:0;s:11:"historywork";b:0;s:10:"recentwork";b:0;s:12:"favoritework";b:0;s:11:"uiprefswork";b:0;s:12:"trackingwork";b:0;s:14:"userconfigwork";b:0;s:9:"menuswork";b:0;s:7:"navwork";b:0;s:17:"savedsearcheswork";b:0;s:18:"centralcolumnswork";b:0;s:20:"designersettingswork";b:0;s:19:"exporttemplateswork";b:0;s:8:"allworks";b:0;s:4:"user";N;s:2:"db";N;}}cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1617159159;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1615875976;s:9:"userprefs";a:1:{s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:25:"server_1_cpses_ruv98pgz0o";a:5:{s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}}}userconfig|a:2:{s:2:"db";a:1:{s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1617159159;}two_factor_check|b:1;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}tmpval|a:14:{s:13:"table_uiprefs";a:1:{i:1;a:1:{s:14:"user_MyDB";a:1:{s:3:"MyTbl";a:0:{}}}}s:5:"query";a:1:{s:32:"c89a67cd3a3eaef49ebefa05108025f6";a:8:{s:3:"sql";s:19:"SELECT * FROM MyTbl";s:12:"repeat_cells";i:100;s:8:"max_rows";i:50;s:3:"pos";s:1:"0";s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:3:"WKT";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";s:1:"0";s:8:"max_rows";i:50;s:12:"repeat_cells";i:100;s:20:"possible_as_geometry";b:0;s:13:"recent_tables";a:1:{i:1;a:1:{i:0;a:2:{s:2:"db";s:14:"user_MyDB";s:5:"table";s:3:"MyTbl";}}}s:15:"favorite_tables";a:1:{i:1;a:0:{}}}is_multi_query|b:0;sql_history|a:2:{i:0;a:3:{s:2:"db";s:14:"user_MyDB";s:5:"table";s:3:"MyTbl";s:8:"sqlquery";s:19:"SELECT * FROM MyTbl";}i:1;a:3:{s:2:"db";s:14:"user_MyDB";s:5:"table";s:3:"MyTbl";s:8:"sqlquery";s:19:"SELECT * FROM MyTbl";}}debug|a:0:{}errors|a:0:{}
This time I tried using PuTTY and AT command to avoid coding error if there is any. The sequence of AT command is being given below:
AT+CIPSHUT
SHUT OK
AT+CIPMODE=0
OK
AT+CIPMUX=0
OK
AT+CGATT=1
OK
AT+CSTT="www","",""
OK
AT+CIICR
OK
AT+CIFSR
100.69.36.85
AT
OK
AT+CIPSTART="TCP","mywebsite.com","80"
OK
CONNECT OK
AT+CIPSEND
> GET /bf?K=MyTbl&a=12&b=23&c=34&d=45&e=56&f=GGH&g=1
SEND OK