Unable to connect to MySQL in app from Servlet

Question

Unable to connect to MySQL in app from Servlet

和江相馬 1

I cannot connect to the DB created by MySQL in app from the Servlet.

The following is a partial excerpt of the error display in the log stream.
This error means that there was a problem while processing the request. The request was received by the Web server, but during processing a fatal error occurred, causing the 500 error.

The following is a partial excerpt of the error display in the MySQL process.log.
2022-07-25T00: 54: 37.811653Z 0 [ERROR] Cannot open Windows EventLog; check privileges, or start server with --log_syslog = 0

Until last year, I was able to connect without any problems, but when I ran it last week, I couldn't connect and asked a question.
By the way, when I used Tomcat and MySQL of Xampp created locally, I was able to connect.

Finally, the development environment is as follows.
After creating a resource from Web Apps, turn on MySQL in app and create a DB from MySQL.
・ Windows 10
・ Eclipse Version: 2022
* The version when you could connect last year is Version: 2020
· Azure Toolkit for Eclipse
・ Java11
* Java 8 was used last year
・ Connector / J 8.0

Anurag Sharma 17,631 Reputation points

2022-07-25T06:38:57.963+00:00

Hi @和江相馬 , welcome to Microsoft Q&A forum.

Can you please confirm if you are using Azure MySQL Server or on-premise MySQL Server?
和江相馬 1 Reputation point

2022-08-02T09:16:34.74+00:00

An Azure MySQL server.
I created it with MySQL in app on my web app instance.
Anurag Sharma 17,631 Reputation points

2022-08-03T06:23:59.027+00:00

Thanks for replying back.

From the error message it seems your server might not be running while trying to connect with the web app. Can you please verify it as highlighted in below screenshot:

If this is working, just restart the server once and try. If this still does not work, we can check further things.
和江相馬 1 Reputation point

2022-08-04T01:57:38.86+00:00

Thank you for your reply.
I'm using "My SQL in APP" as shown in the screenshot, and I've rebooted and burned it many times, but it doesn't work.
Until last year, it was working fine.
By the way, create with "Azure DataBase for MySQL" and set the connection string (String url ="jdbc:mysql://servletdb.mysql.database.azure.com:3306/{MySQLindatabase-name}?useSSL=true&requireSSL=false ";
I put users = DriverManager.getConnection(url, "{user-name@{database-name}", "{password}");) and connected, but it was NG even if I reconnected.

Your answer

Anurag Sharma 17,631 Reputation points

2022-07-25T06:38:57.963+00:00

Hi @和江相馬 , welcome to Microsoft Q&A forum.

Can you please confirm if you are using Azure MySQL Server or on-premise MySQL Server?
和江相馬 1 Reputation point

2022-08-02T09:16:34.74+00:00

An Azure MySQL server.
I created it with MySQL in app on my web app instance.
Anurag Sharma 17,631 Reputation points

2022-08-03T06:23:59.027+00:00

Thanks for replying back.

From the error message it seems your server might not be running while trying to connect with the web app. Can you please verify it as highlighted in below screenshot:

If this is working, just restart the server once and try. If this still does not work, we can check further things.
和江相馬 1 Reputation point

2022-08-04T01:57:38.86+00:00

Thank you for your reply.
I'm using "My SQL in APP" as shown in the screenshot, and I've rebooted and burned it many times, but it doesn't work.
Until last year, it was working fine.
By the way, create with "Azure DataBase for MySQL" and set the connection string (String url ="jdbc:mysql://servletdb.mysql.database.azure.com:3306/{MySQLindatabase-name}?useSSL=true&requireSSL=false ";
I put users = DriverManager.getConnection(url, "{user-name@{database-name}", "{password}");) and connected, but it was NG even if I reconnected.

Share via

Unable to connect to MySQL in app from Servlet

Your answer