Hi
Here are the docker logs :
Machine is a test machine, e2 micro, 2vcpu, 1Gb memory, debian 11
Warning: environ value jdk-11.0.7+10 for key :java-version has been overwritten with 11.0.7
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2021-08-24 15:33:24,877 INFO metabase.util :: Maximum memory available to JVM: 235.9 MB
2021-08-24 15:33:39,741 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. 🔓
For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2021-08-24 15:33:48,545 INFO metabase.core ::
Metabase v0.37.0.2 (ba7be09 release-x.37.x)
Copyright © 2021 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2021-08-24 15:33:48,560 WARN metabase.core :: WARNING: You have enabled namespace tracing, which could log sensitive information like db passwords.
2021-08-24 15:33:48,561 INFO metabase.core :: Starting Metabase in STANDALONE mode
2021-08-24 15:33:48,625 INFO metabase.server :: Launching Embedded Jetty Webserver with config:
{:port 3000, :host "0.0.0.0"}
2021-08-24 15:33:48,711 INFO metabase.core :: Starting Metabase version v0.37.0.2 (ba7be09 release-x.37.x) ...
2021-08-24 15:33:48,762 INFO metabase.core :: System info:
{"file.encoding" "UTF-8",
"java.runtime.name" "OpenJDK Runtime Environment",
"java.runtime.version" "11.0.7+10",
"java.vendor" "AdoptOpenJDK",
"java.vendor.url" "https://adoptopenjdk.net/",
"java.version" "11.0.7",
"java.vm.name" "OpenJDK 64-Bit Server VM",
"java.vm.version" "11.0.7+10",
"os.name" "Linux",
"os.version" "5.10.0-8-cloud-amd64",
"user.language" "en",
"user.timezone" "GMT"}
2021-08-24 15:33:48,764 INFO metabase.plugins :: Loading plugins in /plugins...
2021-08-24 15:33:49,531 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
2021-08-24 15:33:53,019 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
2021-08-24 15:33:53,032 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
2021-08-24 15:33:53,261 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
2021-08-24 15:33:53,515 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
2021-08-24 15:33:58,516 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
2021-08-24 15:33:59,015 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
2021-08-24 15:33:59,036 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
2021-08-24 15:33:59,262 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
2021-08-24 15:33:59,267 INFO util.files :: Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
2021-08-24 15:33:59,282 INFO util.files :: Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
2021-08-24 15:33:59,508 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
2021-08-24 15:33:59,768 INFO util.files :: Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
2021-08-24 15:34:02,031 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :redshift...e[0m
2021-08-24 15:34:05,016 INFO driver.impl :: e[34mRegistered abstract driver :sqle[0m 🚚
e[32mLoad driver :sql took 1.3 se[0m
2021-08-24 15:34:05,033 INFO driver.impl :: e[34mRegistered abstract driver :sql-jdbce[0m (parents: [:sql]) 🚚
e[32mLoad driver :sql-jdbc took 1.5 se[0m
2021-08-24 15:34:05,038 INFO driver.impl :: e[34mRegistered driver :postgrese[0m (parents: [:sql-jdbc]) 🚚
e[32mLoad driver :postgres took 3.2 se[0m
2021-08-24 15:34:05,278 INFO driver.impl :: e[34mRegistered driver :redshifte[0m (parents: [:postgres]) 🚚
2021-08-24 15:34:05,511 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :druid...e[0m
2021-08-24 15:34:05,512 INFO driver.impl :: e[34mRegistered driver :druide[0m 🚚
2021-08-24 15:34:05,773 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :hive-like...e[0m
2021-08-24 15:34:05,775 INFO driver.impl :: e[34mRegistered abstract driver :hive-likee[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:05,776 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sparksql...e[0m
2021-08-24 15:34:05,777 INFO driver.impl :: e[34mRegistered driver :sparksqle[0m (parents: [:hive-like]) 🚚
2021-08-24 15:34:06,024 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :snowflake...e[0m
2021-08-24 15:34:06,027 INFO driver.impl :: e[34mRegistered driver :snowflakee[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:06,032 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :google...e[0m
2021-08-24 15:34:06,034 INFO driver.impl :: e[34mRegistered abstract driver :googlee[0m 🚚
2021-08-24 15:34:06,261 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Oracle Driver due to required dependencies.e[0m Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.
2021-08-24 15:34:06,267 INFO plugins.dependencies :: Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
2021-08-24 15:34:06,269 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Oracle Driver"]e[0m
2021-08-24 15:34:06,286 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :mongo...e[0m
2021-08-24 15:34:06,508 INFO driver.impl :: e[34mRegistered driver :mongoe[0m 🚚
2021-08-24 15:34:06,519 INFO plugins.dependencies :: Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-08-24 15:34:06,521 INFO plugins.dependencies :: Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-08-24 15:34:06,525 WARN plugins.lazy-loaded-driver :: e[31mWarning: plugin manifest for :bigquery does not include connection propertiese[0m
2021-08-24 15:34:06,526 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :bigquery...e[0m
2021-08-24 15:34:06,528 INFO driver.impl :: e[34mRegistered driver :bigquerye[0m (parents: [:sql :google]) 🚚
2021-08-24 15:34:06,766 INFO plugins.dependencies :: Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
2021-08-24 15:34:06,768 INFO plugins.dependencies :: Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
2021-08-24 15:34:06,770 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :googleanalytics...e[0m
2021-08-24 15:34:06,772 INFO driver.impl :: e[34mRegistered driver :googleanalyticse[0m (parents: [:google]) 🚚
2021-08-24 15:34:06,788 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlite...e[0m
2021-08-24 15:34:07,012 INFO driver.impl :: e[34mRegistered driver :sqlitee[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:07,024 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :presto...e[0m
2021-08-24 15:34:07,031 INFO driver.impl :: e[34mRegistered driver :prestoe[0m (parents: [:sql]) 🚚
2021-08-24 15:34:07,261 DEBUG plugins.lazy-loaded-driver :: e[35mRegistering lazy loading driver :sqlserver...e[0m
2021-08-24 15:34:07,263 INFO driver.impl :: e[34mRegistered driver :sqlservere[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:07,268 INFO plugins.dependencies :: e[31mMetabase cannot initialize plugin Metabase Vertica Driver due to required dependencies.e[0m Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.
2021-08-24 15:34:07,269 INFO plugins.dependencies :: Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
2021-08-24 15:34:07,270 INFO plugins.dependencies :: e[33mPlugins with unsatisfied deps: ["Metabase Vertica Driver" "Metabase Oracle Driver"]e[0m
2021-08-24 15:34:07,277 INFO driver.impl :: e[34mRegistered driver :h2e[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:07,515 INFO driver.impl :: e[34mRegistered driver :mysqle[0m (parents: [:sql-jdbc]) 🚚
2021-08-24 15:34:07,533 INFO metabase.core :: Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
2021-08-24 15:34:07,536 WARN metabase.db :: e[31mWARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.htmle[0m
2021-08-24 15:34:07,766 INFO metabase.db :: e[36mVerifying h2 Database Connection ...e[0m
2021-08-24 15:34:07,772 INFO driver.impl :: e[33mInitializing driver :sql...e[0m
2021-08-24 15:34:07,778 INFO driver.impl :: e[33mInitializing driver :sql-jdbc...e[0m
2021-08-24 15:34:07,779 INFO driver.impl :: e[33mInitializing driver :h2...e[0m
2021-08-24 15:34:12,778 ERROR driver.util :: Database connection error
java.util.concurrent.TimeoutException: Timed out after 5.0 s
at metabase.util$deref_with_timeout.invokeStatic(util.clj:315) ~[metabase.jar:?]
at metabase.util$deref_with_timeout.invoke(util.clj:307) ~[metabase.jar:?]
at metabase.util$do_with_timeout.invokeStatic(util.clj:321) ~[metabase.jar:?]
at metabase.util$do_with_timeout.invoke(util.clj:318) ~[metabase.jar:?]
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:34) [metabase.jar:?]
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:23) [metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:442) [metabase.jar:?]
at clojure.lang.Var.invoke(Var.java:393) [metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21801$fn__21802.invoke(db.clj:316) [metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21801.invoke(db.clj:315) [metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798.invoke(db.clj:307) [metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21799.invoke(db.clj:310) [metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798.invoke(db.clj:307) [metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_$fn__21837.invoke(db.clj:352) [metabase.jar:?]
at metabase.util$do_with_us_locale.invokeStatic(util.clj:670) [metabase.jar:?]
at metabase.util$do_with_us_locale.invoke(util.clj:656) [metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:351) [metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:346) [metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:365) [metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:358) [metabase.jar:?]
at metabase.db$setup_db_BANG_$fn__21842.invoke(db.clj:375) [metabase.jar:?]
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:373) [metabase.jar:?]
at metabase.db$setup_db_BANG_.invoke(db.clj:368) [metabase.jar:?]
at metabase.core$init_BANG_.invokeStatic(core.clj:96) [metabase.jar:?]
at metabase.core$init_BANG_.invoke(core.clj:75) [metabase.jar:?]
at metabase.core$start_normally.invokeStatic(core.clj:140) [metabase.jar:?]
at metabase.core$start_normally.invoke(core.clj:134) [metabase.jar:?]
at metabase.core$_main.invokeStatic(core.clj:173) [metabase.jar:?]
at metabase.core$_main.doInvoke(core.clj:167) [metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:397) [metabase.jar:?]
at clojure.lang.AFn.applyToHelper(AFn.java:152) [metabase.jar:?]
at clojure.lang.RestFn.applyTo(RestFn.java:132) [metabase.jar:?]
at metabase.core.main(Unknown Source) [metabase.jar:?]
2021-08-24 15:34:13,037 ERROR metabase.core :: Metabase Initialization FAILED
java.lang.Exception: Timed out after 5.0 s
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:40) ~[metabase.jar:?]
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:23) ~[metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:442) ~[metabase.jar:?]
at clojure.lang.Var.invoke(Var.java:393) ~[metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21801$fn__21802.invoke(db.clj:316) ~[metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21801.invoke(db.clj:315) ~[metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798.invoke(db.clj:307) ~[metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798$fn__21799.invoke(db.clj:310) ~[metabase.jar:?]
at metabase.db$fn__21789$verify_db_connection__21798.invoke(db.clj:307) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_$fn__21837.invoke(db.clj:352) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invokeStatic(util.clj:670) ~[metabase.jar:?]
at metabase.util$do_with_us_locale.invoke(util.clj:656) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invokeStatic(db.clj:351) ~[metabase.jar:?]
at metabase.db$setup_db_BANG__STAR_.invoke(db.clj:346) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invokeStatic(db.clj:365) ~[metabase.jar:?]
at metabase.db$setup_db_from_env_BANG_.invoke(db.clj:358) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_$fn__21842.invoke(db.clj:375) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:373) ~[metabase.jar:?]
at metabase.db$setup_db_BANG_.invoke(db.clj:368) ~[metabase.jar:?]
at metabase.core$init_BANG_.invokeStatic(core.clj:96) ~[metabase.jar:?]
at metabase.core$init_BANG_.invoke(core.clj:75) ~[metabase.jar:?]
at metabase.core$start_normally.invokeStatic(core.clj:140) [metabase.jar:?]
at metabase.core$start_normally.invoke(core.clj:134) [metabase.jar:?]
at metabase.core$_main.invokeStatic(core.clj:173) [metabase.jar:?]
at metabase.core$_main.doInvoke(core.clj:167) [metabase.jar:?]
at clojure.lang.RestFn.invoke(RestFn.java:397) [metabase.jar:?]
at clojure.lang.AFn.applyToHelper(AFn.java:152) [metabase.jar:?]
at clojure.lang.RestFn.applyTo(RestFn.java:132) [metabase.jar:?]
at metabase.core.main(Unknown Source) [metabase.jar:?]
Caused by: java.util.concurrent.TimeoutException: Timed out after 5.0 s
at metabase.util$deref_with_timeout.invokeStatic(util.clj:315) ~[metabase.jar:?]
at metabase.util$deref_with_timeout.invoke(util.clj:307) ~[metabase.jar:?]
at metabase.util$do_with_timeout.invokeStatic(util.clj:321) ~[metabase.jar:?]
at metabase.util$do_with_timeout.invoke(util.clj:318) ~[metabase.jar:?]
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:34) ~[metabase.jar:?]
... 28 more
2021-08-24 15:34:13,277 INFO metabase.core :: Metabase Shutting Down ...
2021-08-24 15:34:13,278 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
2021-08-24 15:34:13,767 INFO metabase.core :: Metabase Shutdown COMPLETE
Regarding nginx logs (anonymized), 2 sample lines
91.91.91.91 - - [24/Aug/2021:15:32:22 +0000] "GET /wp-content/plugins/revslider/public/assets/fonts/revicons/revicons.woff?5510888 HTTP/1.1" 200 7536 "ref=https://www.toto.fr/wp-content/plugins/revslider/public/assets/css/rs6.css?ver=6.1.1" "ua=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Safari/537.36" "rLoc=-" "reqt=0.004" "respt=0.004" "host=www.toto.fr" "cache=-" "upstream=10.216.124.44:9010" "uheadt=0.004"
93.93.93.93 - - [24/Aug/2021:15:32:22 +0000] "GET /wp-content/uploads/sites/8356/2020/04/pellets-1.jpg HTTP/1.1" 200 148831 "ref=https://www.toto.fr/titi/nos-produits/" "ua=Mozilla/5.0 (Linux; Android 11; SM-A705FN) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.159 Mobile Safari/537.36" "rLoc=-" "reqt=0.004" "respt=0.000" "host=www.tutu.fr" "cache=-" "upstream=10.216.124.44:9010" "uheadt=0.000"
And last problem, regarding prometheus/grafana, the metric
cs_reader_hits_total
is not exposed by the prometheus exporter
root@toto:/var/log/nginx# curl -s http://127.0.0.1:9169/metrics|grep reader
root@toto:/var/log/nginx# curl -s http://127.0.0.1:9169/metrics|grep cs_
# HELP cs_bucket_created_total Total buckets were instanciated.
# TYPE cs_bucket_created_total counter
cs_bucket_created_total{name="crowdsecurity/http-bf-wordpress_bf"} 2544
Prom config :
prometheus:
enabled: true
level: full
listen_addr: 0.0.0.0
listen_port: 9169
Thanks a lot