Hi - New to Flink and FlinkSQL I'm looking to just...
# troubleshooting
b
Hi - New to Flink and FlinkSQL I'm looking to just play with some queries and came across https://github.com/ververica/flink-sql-cookbook . If I'm not using the Ververica Platform is there a packaged docker-compose that would let me play around with the cookbooks here?
b
Thanks! The cookbokos that mention kafka (i.e. https://github.com/ververica/flink-sql-cookbook/blob/main/joins/03_kafka_join/03_kafka_join.md ) for those i'd just have to include kafka in that docker-compose ?
m
Yes. You can also check https://github.com/MartijnVisser/flink-only-sql if you’re interested in a setup with Kafka
🙌 1
b
This is great. Thanks!
j
@Bhaarat Ververica Platform has a community edition that is free to use.
👍 1
x
Hello @Martijn Visser, when I clone your repo and start the containers, nginx gets 404 not found when I access from my laptop, if I access from inside the container, it is good. Can you please help ?
m
Are you sure you're accessing http://localhost/flink/flink-docs-master/ ?
I've just pulled the repo and tried it locally on a new machine, it works out of the box for me
x
Yes @Martijn Visser
Copy code
docker-compose ps
NAME                           COMMAND                   SERVICE             STATUS              PORTS
broker                         "/etc/confluent/dock…"    broker              running             0.0.0.0:9092->9092/tcp, 0.0.0.0:9101->9101/tcp, :::9092->9092/tcp, :::9101->9101/tcp
elasticsearch                  "/bin/tini -- /usr/l…"    elasticsearch       running             0.0.0.0:9200->9200/tcp, 0.0.0.0:9300->9300/tcp, :::9200->9200/tcp, :::9300->9300/tcp
flink-only-sql-init-kafka-1    "/bin/sh -c '\n# bloc…"   init-kafka          exited (0)
flink-only-sql-jobmanager-1    "/docker-entrypoint.…"    jobmanager          running             0.0.0.0:8081->8081/tcp, :::8081->8081/tcp
flink-only-sql-mysql-1         "docker-entrypoint.s…"    mysql               running             0.0.0.0:3306->3306/tcp, :::3306->3306/tcp
flink-only-sql-sql-client-1    "/docker-entrypoint.…"    sql-client          exited (0)
flink-only-sql-taskmanager-1   "/docker-entrypoint.…"    taskmanager         running             8081/tcp
flink-only-sql-web-1           "/docker-entrypoint.…"    web                 running             0.0.0.0:80->80/tcp, :::80->80/tcp
rest-proxy                     "/etc/confluent/dock…"    rest-proxy          running             0.0.0.0:8082->8082/tcp, :::8082->8082/tcp
schema-registry                "/etc/confluent/dock…"    schema-registry     running             0.0.0.0:8091->8091/tcp, :::8091->8091/tcp
zookeeper                      "/etc/confluent/dock…"    zookeeper           running             0.0.0.0:2181->2181/tcp, :::2181->2181/tcp

curl -I <http://localhost/flink/flink-docs-master/>
HTTP/1.1 404 Not Found
Content-Type: text/plain; charset=utf-8
X-Content-Type-Options: nosniff
Date: Thu, 19 Jan 2023 17:20:37 GMT
Content-Length: 19
Now go into the container and access again:
Copy code
docker exec -it flink-only-sql-web-1 /bin/bash
root@6769a7bd3b7e:/# curl -I <http://localhost/flink/flink-docs-master/>
HTTP/1.1 200 OK
Server: nginx/1.22.0
Date: Thu, 19 Jan 2023 17:21:21 GMT
Content-Type: text/html
Content-Length: 172884
Last-Modified: Thu, 19 Jan 2023 07:08:54 GMT
Connection: keep-alive
ETag: "63c8ec86-2a354"
Accept-Ranges: bytes

root@6769a7bd3b7e:/#
n
Works fine here as well: Windows 11 (not that that should matter, but ...). Oh, very cool "stuff" BTW @Martijn Visser - Thank You!