tag:blogger.com,1999:blog-2959317805805542041.post6239630463319462266..comments2024-03-17T22:27:12.515-07:00Comments on Chuck's Blog: Introducing MySQL Connector/ArduinoChuckhttp://www.blogger.com/profile/02410977284521913938noreply@blogger.comBlogger396125tag:blogger.com,1999:blog-2959317805805542041.post-47559856781255159352015-12-01T10:59:55.072-08:002015-12-01T10:59:55.072-08:00This post is now closed for comments. See my lates...This post is now closed for comments. See my latest blog on Connector/Arduino for comments at http://drcharlesbell.blogspot.com/2015/07/new-mysql-connectorarduino-release-104.html or check out the Connector/Arduino forum at http://forums.mysql.com/list.php?175.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-73661731704213725452015-12-01T10:58:06.711-08:002015-12-01T10:58:06.711-08:00I am not sure what you're asking, but the conn...I am not sure what you're asking, but the connector as I've written it is _very_ specific to the Arduino and its supporting libraries; the Ethernet library in particular.<br /><br />So I doubt you will be able to use it on other hardware. <br /><br />That said, the source code is available on launchpad as described above. <br /><br />However, if you are compiling C code, you should check the Oracle website and use the C connector (called Connector/C or libmysqlc), which is part of the server install and thus available to anyone on the platforms supported. Even if your platform is not supported, if it is Linux-based, you may be able to compile it. I cannot offer more help than that on Connector/C. I suggest checking the Oracle MySQL forums for more information.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-34021220554422184112015-12-01T08:25:32.084-08:002015-12-01T08:25:32.084-08:00Hi Chuck,
I am using different hardware for home a...Hi Chuck,<br />I am using different hardware for home automation.<br />I am using RTOS,lwip as a part of SDK.<br />do you have C code for this so that I can try it on my hardware.Anonymoushttps://www.blogger.com/profile/03377826298125543437noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-13545029805682665822015-12-01T05:26:27.567-08:002015-12-01T05:26:27.567-08:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/04009872340858570928noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-55077905188240174822015-11-30T07:23:09.565-08:002015-11-30T07:23:09.565-08:00Hello Snottlebocket,
Your project interests me a l...Hello Snottlebocket,<br />Your project interests me a lot ! Did you update your code ? Would it be possible to have a look at it ?<br />Thanks a lotAnonymoushttps://www.blogger.com/profile/16039930910707502655noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-17718387861892204242015-11-30T07:22:16.990-08:002015-11-30T07:22:16.990-08:00Hello Snottlebocket,
Your project interests me a l...Hello Snottlebocket,<br />Your project interests me a lot, did you update your code and does it work ?<br />Thanks a lotAnonymoushttps://www.blogger.com/profile/16039930910707502655noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-72292109244178043532015-11-30T07:21:56.196-08:002015-11-30T07:21:56.196-08:00Hello Snottlebocket,
Your project interests me a l...Hello Snottlebocket,<br />Your project interests me a lot, did you update your code and does it work ?<br />Thanks a lotAnonymoushttps://www.blogger.com/profile/16039930910707502655noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-34338422167382023292015-11-06T05:17:51.466-08:002015-11-06T05:17:51.466-08:00Hello. There are many reasons your sketch is not c...Hello. There are many reasons your sketch is not connecting. See the reference manual at https://launchpad.net/mysql-arduino (see the .pdf file) for a detailed explanation of the most common events. Since you are on Windows, be sure that you are not running the Windows firewall and if you are port 3306 is open. Finally, make sure you are using the latest 1.0.4GA code as it does not require you to patch the sha1 code.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-76890485275366386202015-11-05T23:24:05.124-08:002015-11-05T23:24:05.124-08:00I am using an Arduino Uno and I am using a windows... I am using an Arduino Uno and I am using a windows.I'm following this tutoriel .I don't have a problem with the compilation or the upload, but in the monitor I receive the message: Connecting... <br />then I will receive nothing: no connection failed no query success.<br />I didn't apply a-diff-patch. because the compilation success. Can you help me please.Anonymoushttps://www.blogger.com/profile/00497570858700246712noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-73849322344726770822015-08-20T12:05:56.739-07:002015-08-20T12:05:56.739-07:00Hi. There should be no issues with using it with M...Hi. There should be no issues with using it with MAMP. Please see the new reference manual at https://launchpad.net/mysql-arduino/release-1.0.4-ga/release-1.0.4-ga/+download/MySQL_Connector_Arduino_Reference_Manual-1.0.4ga.pdf. There is a troubleshooting section in there that should help you configure and test your setup and connection issue.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-14450693967626129852015-08-20T11:00:43.440-07:002015-08-20T11:00:43.440-07:00Hello sir, congratulations. This connector is awes...Hello sir, congratulations. This connector is awesome. Do you know if it works with MAMP in Mac OSX? I`m trying to using it with my mac as a server, but it is not connecting. I`m not sure if it is because of MAMP. Can you help me?<br /><br />ThanksToka do La-Roccahttps://www.blogger.com/profile/07875024665986072203noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-91231054878855467372015-04-11T08:42:52.947-07:002015-04-11T08:42:52.947-07:00I can not connect to my database from arduino too....I can not connect to my database from arduino too. I will try your way. Hope every will be fine.Tnd Solutionshttps://www.blogger.com/profile/02394830792590017679noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-5340823157606767862015-04-10T10:39:19.614-07:002015-04-10T10:39:19.614-07:00There is some help in the source code. Look for ex...There is some help in the source code. Look for examples and readme.txt.<br /><br />Also, check my later blogs, particularly ones where I announced new versions.<br /><br />You can also see the book, "Beginning Sensor Networks with Raspberry Pi and Arduino".Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-26062305327657854972015-04-09T20:26:11.947-07:002015-04-09T20:26:11.947-07:00i am very new to this. do you have any tutorial?i am very new to this. do you have any tutorial?Anonymoushttps://www.blogger.com/profile/03589578809969718293noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-14263245930759388182015-03-23T17:51:09.628-07:002015-03-23T17:51:09.628-07:00You need to uncomment WITH_SELECT in mysql.h.You need to uncomment WITH_SELECT in mysql.h.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-62706263795497990782015-03-13T01:56:48.208-07:002015-03-13T01:56:48.208-07:00Hello Mr Chuck..
event i run example program, i ha...Hello Mr Chuck..<br />event i run example program, i have problem<br /><br />mysql_connector.ino: In function 'void do_query(const char*)':<br />mysql_connector.ino:69:3: error: 'column_names' was not declared in this scope<br />mysql_connector.ino:69:17: error: 'c' was not declared in this scope<br />mysql_connector.ino:70:3: error: 'row_values' was not declared in this scope<br />mysql_connector.ino:70:15: error: 'r' was not declared in this scope<br />mysql_connector.ino:85:15: error: 'class Connector' has no member named 'get_columns'<br />mysql_connector.ino:100:17: error: 'class Connector' has no member named 'get_next_row'<br />mysql_connector.ino:114:15: error: 'class Connector' has no member named 'free_row_buffer'<br />mysql_connector.ino:122:11: error: 'class Connector' has no member named 'free_columns_buffer'<br />Error compiling.<br /><br />i use arduino 1.6.0 in windows 8.0MALIKhttps://www.blogger.com/profile/06764347417511038703noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-51452877459233988492015-03-02T08:40:50.111-08:002015-03-02T08:40:50.111-08:00You are using a newer version of the IDE that requ...You are using a newer version of the IDE that require const before the declaration. Just put const before it and it will compile. A future release of the connector will fix this. There are at least 2 places where you have to do this. See my other posts on this subject.Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-86408087627360649852015-03-01T00:51:51.244-08:002015-03-01T00:51:51.244-08:00Hy sir
I have some trouble with arduino sketch, t...Hy sir<br /><br />I have some trouble with arduino sketch, the error is "Arduino\libraries\MYSQL\sha1.cpp:11:25: error: variable 'sha1InitState' must be const in order to be put into read-only section by means of '__attribute__((progmem))'<br />uint8_t sha1InitState[] PROGMEM = {"<br /><br />I have beed downloaded the library in https://launchpad.net/mysql-arduino, but it still got that error?<br />what should i do sir?FMYhttps://www.blogger.com/profile/03793489821783888213noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-66333489241675282222015-02-26T10:40:25.857-08:002015-02-26T10:40:25.857-08:00Hi. Thanks.
I would need to see your sketch to di...Hi. Thanks.<br /><br />I would need to see your sketch to diagnose the problem. Also, what Arduino, IDE version, and shield are you using?Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-90057194196845742802015-02-25T18:40:07.429-08:002015-02-25T18:40:07.429-08:00Hi Chuck, congrats for the blog! great work!
I am...Hi Chuck, congrats for the blog! great work!<br /><br />I am using your libraries, and I am facing problems with connecting to the server, the first time I run the code, it was able to connect properly to the MySql in the server. However, after one or two other connections, it started not to connect anymore. The UserID and Password is right and with all the granted permissions, the Ethernet shield works perfectly wth other libraries and codes, but I still got the problem during connection. I am wondering if there is another MySQL configuration that I should do for Client connections that may solve the problem. Can you provide me some clues that may help me? ThanksAnonymoushttps://www.blogger.com/profile/06274714374609709653noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-79528436586397162602015-02-16T10:45:10.397-08:002015-02-16T10:45:10.397-08:00The answers you seek are throughout this blog and ...The answers you seek are throughout this blog and several of my other blogs.<br /><br />The condensed version is as follows:<br /><br />1. Check network connectivity with a second PC. Ensure you can connect to your server with the mysql client using the IP, username, and password in your sketch. If you cannot, solve that problem first.<br /><br />2. Ensure your sketch has the correct credentials (IP, username, password, and port) from (1). <br /><br />3. If (1) succeeds and (2) does not, test the Ethernet shield to ensure it is working properly using one of the Ethernet example sketches.<br /><br />4. In rare cases, you may have a firewall or port access issue on the server that you will need to resolve. <br /><br />5. You may also have security issues on the server. Remember, a user on MySQL is defined by the username and hostname. Hint:<br /><br />GRANT ... ON ... TO 'user'@'%'<br />Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-67051423355307111262015-02-16T03:50:23.820-08:002015-02-16T03:50:23.820-08:00Thank you chuck.
That is success. No Error and I ...Thank you chuck. <br />That is success. No Error and I can upload it to arduino uno.<br />But when I run in serial monitor, eth cannot conect to mysql.<br />error message is :<br />connecting....<br />conection failed.<br /><br />why the process happen like this..?<br /><br />In my PC, I have to install mysql server, php5 and apache2 to localhost.<br /><br />Pleasa help me.oohttps://www.blogger.com/profile/04875786585204462852noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-9446717427525233252015-02-12T18:24:01.977-08:002015-02-12T18:24:01.977-08:00Three things to try; 1) make sure you have only on...Three things to try; 1) make sure you have only one copy of the SHA folder and it must reside in your Arduino libraries folder, 2) make sure you are using the SHA1 folder included in the .zip download from launchpad, and 3) if you are using a newer release of the Arduino IDE, simply add 'const' (no quotes) before each of the lines that appear as an error.<br /><br />For example:<br /><br />Change:<br /><br />uint8_t sha1InitState[] PROGMEM = {<br /><br />to:<br /><br />const uint8_t sha1InitState[] PROGMEM = {<br /><br />Chuckhttps://www.blogger.com/profile/02410977284521913938noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-48815443727602875982015-02-07T22:25:56.450-08:002015-02-07T22:25:56.450-08:00Hii chuck... I need you help.
I already follow all...Hii chuck... I need you help.<br />I already follow all the step about connecting arduino ethernet to mysql use mysql connector.<br />I make it to linux ubuntu. But when I running the arduino program, I look the error like this :<br />In file included from /usr/share/arduino/libraries/sha1/sha1.cpp:3:0:<br />/usr/share/arduino/libraries/sha1/sha1.cpp:9:25: error: variable ‘sha1InitState’ must be const in order to be put into read-only section by means of ‘__attribute__((progmem))’<br />uint8_t sha1InitState[] PROGMEM = {<br />^<br /><br />I dont know what happen with connector sha. could you help me solve it ?? If I forget another step, please send me the right code and step to my mail : folkeslaumal76@gmail.com<br /><br />I hope you help. Thank You<br />oohttps://www.blogger.com/profile/04875786585204462852noreply@blogger.comtag:blogger.com,1999:blog-2959317805805542041.post-87393063073360667132015-02-07T22:22:18.512-08:002015-02-07T22:22:18.512-08:00This comment has been removed by the author.oohttps://www.blogger.com/profile/04875786585204462852noreply@blogger.com