Unable to log into dremio

I have just uninstalled Dremio 3.0 and installed Dremio 3.1 on a Redhat Linux server. When accessing the interface via http://hostname:9047 I am directed to the Welcome to Dremio, please log in page. I do not have a login as I have not yet set up any users. There used to be an initial admin screen in version 3.0 where the first user would be created but I am unable to access that page in version 3.1. I am also not able to add users using the dremio-admin utility. We’re stuck on the login page. I’m wondering if when we removed Dremio 3.0 we left behind some files that Dremio 3.1 sees and therefore is preventing the “first user” page from displaying.

Can you help me understand how to get past this login page?

Hi @summersmd,

Did you attempt to upgrade Dremio from 3.0 to 3.1 using the dremio-admin upgrade script docs here, or did you try a “manual” uninstall of 3.0 with the goal of starting fresh?

I did a manual install with the goal of starting fresh

Hi @summersmd

Can you please send us your dremio.conf?

Thanks
@balaji.ramaswamy

#
# Copyright (C) 2017-2018 Dremio Corporation
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

paths: {
  # the local path for dremio to store data.
  local: "/app/dremio/data"

  # the distributed path Dremio data including job results, downloads, uploads,
etc
  #dist: "pdfs://"${paths.local}"/pdfs"
}

services: {
  coordinator.enabled: true,
  coordinator.master.enabled: true,
  executor.enabled: true
}

[https://sjc6.discourse-cdn.com/standard14/user_avatar/community.dremio.com/balaji.ramaswamy/45/843_2.png]

balaji.ramaswamyhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_balaji.ramaswamy&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=6PGl_w-PBcfxNJFTfpqYHrcqc9iRyGaXeJH2H_n3q0E&e=
January 29

Hi @summersmdhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_summersmd&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=VAIq62_OBsoyRypc9Oz9nVPr802BC3nhBEN-nmaDWU8&e=

Can you please send us your dremio.conf?

Thanks
@balaji.ramaswamyhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_balaji.ramaswamy&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=6PGl_w-PBcfxNJFTfpqYHrcqc9iRyGaXeJH2H_n3q0E&e=

(Attachment dremio.conf is missing)

(Attachment dremio.conf is missing)

[https://sjc6.discourse-cdn.com/standard14/user_avatar/community.dremio.com/balaji.ramaswamy/45/843_2.png]

balaji.ramaswamyhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_balaji.ramaswamy&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=6PGl_w-PBcfxNJFTfpqYHrcqc9iRyGaXeJH2H_n3q0E&e=
January 29

Hi @summersmdhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_summersmd&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=VAIq62_OBsoyRypc9Oz9nVPr802BC3nhBEN-nmaDWU8&e=

Can you please send us your dremio.conf?

Thanks
@balaji.ramaswamyhttps://urldefense.proofpoint.com/v2/url?u=https-3A__community.dremio.com_u_balaji.ramaswamy&d=DwMFaQ&c=UE1eNsedaKncO0Yl_u8bfw&r=OyoDGdvh3ZTUb1GZtSW8ewhli64K0KtfhrleJVWCLEw&m=K6aEvCP6T4jGQTROLa3bdXZ_FSXfSi3yn3pYNGHL5CA&s=6PGl_w-PBcfxNJFTfpqYHrcqc9iRyGaXeJH2H_n3q0E&e=

dremio.conf.zip (690 Bytes)

dremio.conf.zip (690 Bytes)

More detail:

We’re running Dremio in a single node.

Should I reinstall the previous version and then try the upgrade feature to install 3.1?

We really need to get this back up and running.

Hi @summersmd

If you do not want anything from the previous version like reflections/VDS, you can shutdown Dremio, simply delete data folder under /app/dremio and then start Dremio again. This should bring back the
welcome page

If you want to upgrade by rolling back, do you have a copy of /app/dremio/data from the previous install?

Thanks
@balaji.ramaswamy

1 Like

That worked. Thank you.