Can't connect to mariadb

[vicmosin]

Getting Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=localhost)(port=3306)(type=master) : Connection refused (Connection refused) all the time while starting from docker-compose. Other services can access mariadb without any issues but there I set connection string explicitely via spring.datasource.url=jdbc:mariadb://127.0.0.1

Can it be an issue or something else?

[codefromthecrypt]

recently the driver has been updated.. which version image are you using for mariadb/mysql?

[vicmosin]

@adriancole Thanks for reply. Right now we use the latest one which 10.3

[vicmosin]

it's 10.2, I am sorry

[codefromthecrypt]

just looked.. our test image isn't mariadb it is mysql. We use mariadb as the client for license reasons. Latest java client is 2.2.3 which is only a couple patches below latest.

http://search.maven.org/remotecontent?filepath=io/zipkin/java/parent/2.9.4/parent-2.9.4.pom http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22mariadb-java-client%22

you could probably look to see if something between 2.2.3 and 2.2.5 is an issue that relates to this. We haven't heard others complaining. Meanwhile we can bump to latest maria client for the next zipkin release.

[codefromthecrypt]

https://mariadb.com/kb/en/library/about-mariadb-connector-j/#choosing-a-version talks about compatibility...

[codefromthecrypt]

this will attempt to help https://github.com/openzipkin/zipkin/pull/2120

[vicmosin]

Apparently it was a network mode issue.. By default it's bridge so it was in isolated network. With host mode it works :) Thanks

[codefromthecrypt]

ok great: thanks for the tip. by the way 2.10.0 is out momentarily anyway

[jcchavezs]

@vicmosin what in documentation would prehent this issue to happen to you? Would you add something in docs related to this?

[vicmosin]

@jcchavezs I would just put some small notice that in case of using dockerized zipkin and host-based datasource it won't work because of docker's default network mode set to bridge. I.e. zipkin won't be able to connect to datasource since it's in the isolated network. Possible solutions are either use --link feature of docker or change network mode to host.

[jcchavezs]

Nice would you open a PR with that tweak?

Den lør. 7. jul. 2018, 13:47 skrev Victor Mosin notifications@github.com:

@jcchavezs https://github.com/jcchavezs I would just put some small notice that in case of using dockerized zipkin and host-based datasource it won't work because of docker's default network mode set to bridge. I.e. zipkin won't be able to connect to datasource since it's in the isolated network. Possible solutions are either use --link feature of docker or change network mode to host.

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/openzipkin/docker-zipkin/issues/181#issuecomment-403210149, or mute the thread https://github.com/notifications/unsubscribe-auth/AC7sAjYSVjww_LA0j2J1Uiy3MXPoORRCks5uEJ_RgaJpZM4U_L_q .

--

José Carlos

[hessam-shm]

I have the same problem with mariadb-java-client:2.3.0

[codefromthecrypt]

make sure you uncommented this

https://github.com/openzipkin/docker-zipkin/blob/master/docker-compose.yml#L17

please don't reply to old issues as it spams people with unrelated problems. if you need further support use gitter https://gitter.im/openzipkin/zipkin