Hi ,
installed dremio on mac – no docker , installed using tar file , it is working fine with rocks db – default,
wanna use postgre or mysql , locally it is setup I tried to modify dremio.conf file file it is not starting ,
conf file: for postgre
services: {
coordinator.enabled: true,
coordinator.master.enabled: true,
executor.enabled: true,
flight.use_session_service: true,
coordinator.metastore: {
type: “postgres”,
config: {
jdbcUrl: “jdbc:postgresql://localhost:5432/dremio_metadata”,
username: “dremio_user”,
password: “XX”
}
}
}
Error
12:13:03,353 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to ERROR
12:13:03,353 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [text] to Logger[ROOT]
12:13:03,353 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [json] to Logger[ROOT]
12:13:03,353 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
12:13:03,353 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@49dbaaf3 - Registering current configuration as safe fallback point
Dremio is exiting. Failure while starting services.
java.lang.RuntimeException: Failure reading configuration file. The following properties were invalid:
services.coordinator.metastore.type
services.coordinator.metastore.config.password
services.coordinator.metastore.config.jdbcUrl
services.coordinator.metastore.config.username
at com.dremio.config.DremioConfig.check(DremioConfig.java:325)
at com.dremio.config.DremioConfig.(DremioConfig.java:292)
at com.dremio.config.DremioConfig.create(DremioConfig.java:431)
at com.dremio.config.DremioConfig.create(DremioConfig.java:380)
at com.dremio.config.DremioConfig.create(DremioConfig.java:376)
at com.dremio.dac.server.DACConfig.newConfig(DACConfig.java:216)
at com.dremio.dac.daemon.DremioDaemon.main(DremioDaemon.java:89)