Drizzle MySQL Connection Error

davidbsecrist · 2017-05-25T05:33:09+00:00

Thanks, I will open it on GithubOn Wednesday, May 24, 2017 at 5:31:40 PM UTC+3, rpaprocki wrote:I maintain this project. :)Go ahead and open an issue on GitH...

Drizzle MySQL Connection Error

davidbsecrist

Hi,

I have a web server and a database server. I'm using the Nginx Drizzle Module to try to connect the two. On my web server, I have the following in my nginx.conf file:

upstream backend {
drizzle_server <DATABASE_SERVER_IP> dbname=mydbname
user=myuser password=mypass protocol=mysql;
}

I also have this pasted in my server block for testing: https://github.com/openresty/drizzle-nginx-module#last-insert-id

In my browser when I go to <WEB_SERVER_IP>/test, I get a 502 error. When I check the error.log file, I see:

Access denied for user 'myuser'@'<WEB_SERVER_IP>' (using password: YES) while connecting to drizzle upstream, client: <MY_LOCAL_IP>, server: localhost, request: "GET /test HTTP/1.1", subrequest: "/mysql", upstream: "drizzle://<DATABASE_SERVER_IP>:3306", host: "<WEB_SERVER_IP>"

So even though I'm defining the drizzle_server with <DATABASE_SERVER_IP>, the host is being set to <WEB_SERVER_IP>.

What am I missing?

Thanks

davidbsecrist

I tracked it down to SSL. I was requiring an SSL connection when connecting from the web server to the database server. Disabling that allows the connection to go through and the #last-insert-id code to properly execute.

It looks like SSL support was added to drizzle 7.2 via https://code.launchpad.net/~linuxjedi/drizzle/drizzle-libdrizzle-ssl

But I guess the drizzle-nginx-module would need updating to add it.. :(

Thanks