External ports (in section ports) you need only for external word communication. You need to change it to 3306.Īll of the applications into cluster use internal ports (3306 in mysql case). Variable SQL_INTERNAL_PORT probably has 3307 value. Hackernews_1 | at .run(FutureTask.java:266)ĭocker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMESĪb721996469d mysql:5.7 "docker-entrypoint.s…" 42 minutes ago Up 55 seconds 3306/tcp, 0.0.0.0:3307->3307/tcp two_mysql_1ħaab98e2b8d7 prismagraphql/prisma:1.8 "/bin/sh -c /app/sta…" 2 hours ago Restarting (1) Less than a second ago two_hackernews_1 Hackernews_1 | at .HikariPool$PoolEntr圜reator.call(HikariPool.java:563) Hackernews_1 | at .HikariPool$PoolEntr圜reator.call(HikariPool.java:570) Hackernews_1 | at .HikariPool.access$500(HikariPool.java:64) Hackernews_1 | at .HikariPool.createPoolEntry(HikariPool.java:430) Hackernews_1 | at .PoolBase.newPoolEntry(PoolBase.java:193) You need your mysql service to be of Type NodePort instead of ClusterIP to access it outside Kubernetes. Hackernews_1 | at .PoolBase.newConnection(PoolBase.java:341) Hackernews_1 | at .connect(Driver.java:90) Hackernews_1 | at .newConnection(MariaDbConnection.java:144) Hackernews_1 | at .(AbstractConnectProtocol.java:1040) Hackernews_1 | at .(ExceptionMapper.java:79) Hackernews_1 | at .(ExceptionMapper.java:161) Hackernews_1 | Caused by: : Could not connect to address=(host=mysql)(port=3307)(type=master) : Connection refused (Connection refused) Hackernews_1 | at $n(ThreadPoolExecutor.java:624) Hackernews_1 | at .runWorker(ThreadPoolExecutor.java:1149) sudo firewall-cmd -zonepublic -add-port3306/tcp -permanent antoniomerlin at 7:32 Add a comment 3 Answers Sorted by: 3 The default port for MySQL is 3306. Hackernews_1 | at $DatabaseDef$$anon$2.run(BasicBackend.scala:239) 121 1 1 4 firewall-cmd -zoneMyZone -add-servicemysql Michael Hampton at 6:48 i have already did it. Hackernews_1 | at $DatabaseDef.acquireSession(JdbcBackend.scala:38) Hackernews_1 | at $DatabaseDef.acquireSession$(BasicBackend.scala:217) Hackernews_1 | at $DatabaseDef.acquireSession(BasicBackend.scala:218) Hackernews_1 | at $DatabaseDef.createSession(JdbcBackend.scala:38) Hackernews_1 | at $DatabaseDef.createSession(JdbcBackend.scala:47) Hackernews_1 | at $BaseSession.(JdbcBackend.scala:439) Hackernews_1 | at .createConnection(HikariCPJdbcDataSource.scala:18) Either do a remote forward (Set localport: 3306, remotehost: yourmysqlservernameorip, remoteport: 3306 ) or a. This userid value might not be the same as the user name of your MySQL account. Hackernews_1 | at .getConnection(HikariDataSource.java:83) Set userid youruserid to log in to your server. Hackernews_1 | at .HikariPool.getConnection(HikariPool.java:145) Hackernews_1 | at .HikariPool.getConnection(HikariPool.java:186) Hackernews_1 | at .HikariPool.createTimeoutException(HikariPool.java:548) "$"Įrror: hackernews_1 | Exception in thread "main" : database - Connection is not available, request timed out after 5008ms. ManagementApiSecret: $PRISMA_MANAGEMENT_API_SECRET I have been unable to create a MySQL database on a port other than 3306 using Docker Compose. I am trying to create multiple Prisma database services on a single machine.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |