New Version (3.0.0 ->3.0.2) crashes with MySQL connect

[Falkenstone]

Hi,
since the new Board Version ESP8266 3.0..0 the connect to MySQL (Library MySQL_Connector_Arduino) crashes every time. I am not the professional to find out what is different to version 2.7.3. That was my last attempt with which version the "connect" function worked. Could you inspect this issue and modify the library? You could use one of the example from the library and you see what happened.

thx
Falke

[d-a-v]

The template that you deliberately removed while opening your issue does deserve you,
because we don't have any input on what the issue is, or any way to reproduce it.

Particularly detailed error messages with debug option enabled,
and an MCVE for us to reproduce the issue are requested.

The author of the library who did his own tests is blaming the core, but could help with what he saw.

[mcspr]

...also a duplicate of #8250

notice that the current version of the library can't be built successfully with the Core 3.0.2 anyway, only 3.0.0. and I'd suggest to look at the piece of code it stops compiling at and fix the issue

building `.pio\build\nodemcuv2\lib3d7\MySQL_Connector_Arduino\MySQL_Encrypt_Sha1.cpp.o' because it doesn't exist
Compiling .pio\build\nodemcuv2\lib3d7\MySQL_Connector_Arduino\MySQL_Encrypt_Sha1.cpp.o
lib\MySQL_Connector_Arduino\src\MySQL_Encrypt_Sha1.cpp: In member function 'virtual size_t Encrypt_SHA1::write(uint8_t)':
lib\MySQL_Connector_Arduino\src\MySQL_Encrypt_Sha1.cpp:89:1: error: no return statement in function returning non-void [-Werror=return-type]
   89 | }
      | ^
lib\MySQL_Connector_Arduino\src\MySQL_Encrypt_Sha1.cpp: In member function 'virtual size_t Encrypt_SHA1::write(uint8_t*, int)':
lib\MySQL_Connector_Arduino\src\MySQL_Encrypt_Sha1.cpp:95:1: error: no return statement in function returning non-void [-Werror=return-type]
   95 | }
      |

it is literally saying what is wrong :) both Encrypt_SHA1::write() result is never used, so just add return 0;

[Falkenstone]

Ok,
i've added 'return 1' in both functions and now it works. The statement 'return 0 does not cause a crash, but you cannot log into MySQL. (Access denied for user 'XXX'@'YYYYYY' (using password: YES).

[d-a-v]

@Falkenstone
Do you plan to make a pull request on MySQL_Connector_Arduino repository ?

[Pablo2048]

I did it few minutes before...

[d-a-v]

You may edit the first post in your PR and add "fixes # 171 # 173 # 176 and maybe # 145"
(without spaces)

[Pablo2048]

Done, thanks for the guidance...