I am able to access the MySQL database from PHPMyAdmin. # declare your mount volume /host/dir:/container/dir MYSQL_ROOT_PASSWORD: dbmetabaserootpassword Metabase-app_1 | at .(AbstractConnectProtocol.java:1236) Metabase-app_1 | at .(AbstractConnectProtocol.java:507) Metabase-app_1 | at .(AbstractConnectProtocol.java:703) Metabase-app_1 | at .2PasswordPlugin.process(CachingSha2PasswordPlugin.java:187) Metabase-app_1 | Caused by: : RSA public key is not available client side (option serverRsaPublicKeyFile not set) Metabase-app_1 | at java.base/(Unknown Source) Metabase-app_1 | at java.base/$n(Unknown Source) Metabase-app_1 | at java.base/.runWorker(Unknown Source) Metabase-app_1 | at java.base/.run(Unknown Source) Metabase-app_1 | at re$binding_conveyor_fn$fn_5754.invoke(core.clj:2030) I have columns AssignedTo, InternalID, Task Function, Min(STARTDATE), Max(ENDDATE) AssignedTo InternalID Task Function STARTDATE ENDDATE Joe 67077 Write the letter 05:30 AM NULL Joe 1. Metabase-app_1 | at metabase.util$do_with_timeout$fn_9176.invoke(util.clj:310) Metabase-app_1 | at $can_connect_with_details_QMARK_$fn_22354.invoke(util.clj:30) Metabase-app_1 | at _jdbc$fn_72705.invokeStatic(sql_jdbc.clj:37) Metabase-app_1 | at _nnection$can_connect_QMARK_.invoke(connection.clj:156) Metabase-app_1 | at _nnection$can_connect_QMARK_.invokeStatic(connection.clj:161) Metabase-app_1 | at $query.invokeStatic(jdbc.clj:1142) Metabase-app_1 | at $query.invoke(jdbc.clj:1126) Metabase-app_1 | at $query.invokeStatic(jdbc.clj:1164) Metabase-app_1 | at $db_query_with_resultset_STAR_.invoke(jdbc.clj:1075) Metabase-app_1 | at $db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1093) Metabase-app_1 | at $get_connection.invoke(jdbc.clj:274) Metabase-app_1 | at $get_connection.invokeStatic(jdbc.clj:411) Metabase-app_1 | at $get_driver_connection.invoke(jdbc.clj:250) Metabase-app_1 | at $get_driver_connection.invokeStatic(jdbc.clj:271) Metabase-app_1 | at java.sql/(Unknown Source) Metabase-app_1 | at .connect(Driver.java:86) Metabase-app_1 | at .newConnection(MariaDbConnection.java:142) Metabase-app_1 | at .(AbstractConnectProtocol.java:1241) Metabase-app_1 | at .(ExceptionMapper.java:262) Metabase-app_1 | : Could not connect to address=(host=mysql-db)(port=3306)(type=master) : RSA public key is not available client side (option serverRsaPublicKeyFile not set) java -cp metabase-0.12.1.jar org.h2.tools.Script -url jdbc:h2./metabase.db.h2.db and variations gave me this backup.I keep getting this error whenever I run docker-compose up: Org.h2.tools.Script also claims to dump an H2 db to SQL, but i couldn't get it to even see the H2 db file. psql -v -d metabase -f metabase.db.h2.sql, pretty much every line errored out. when i tried to load it into a postgres db with e.g. it's definitely an H2-specific dialect, though. The H2 docs led me to org.h2.tools.Recover, which gave me a full SQL dump of my db. NOTE: currently Metabase does not support migrating data from one application database to another, so if you start with H2 and then want to move to Postgres you'll have to dump the data from H2 and import it into Postgres before relaunching the application. I took a stab at migrating our existing H2 db to postgres today, based on this tease at the bottom of
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |