panic: x Configuring database... FAILED during installation

[michaelsew]

I tried installing this on Windows 10 Ubuntu WSL, but encountered an error at the database install step. Are there any diagnostic logs I can look at? I checked ~/.steampipe/db/12.1.0/logs with not much success.

msew@LAPTOP:~ $  sudo /bin/sh -c "$(curl -fsSL https://raw.githubusercontent.com/turbot/steampipe/main/install.sh)"
...
Steampipe was installed successfully to /usr/local/bin/steampipe

msew@LAPTOP:~ $ steampipe plugin install steampipe
Installed plugin: steampipe v0.1.1
Documentation:    https://hub.steampipe.io/plugins/turbot/steampipe
panic: x Configuring database... FAILED! dial tcp 127.0.0.1:9193: connect: connection refused
goroutine 1 [running]:
github.com/turbot/steampipe/utils.FailOnErrorWithMessage(0x1049a60, 0xc000522e60, 0xebb226, 0x21)
        /home/runner/work/steampipe/steampipe/utils/errors.go:28 +0x137
github.com/turbot/steampipe/db.EnsureDBInstalled()
        /home/runner/work/steampipe/steampipe/db/install.go:115 +0xd0e
github.com/turbot/steampipe/cmd.refreshConnections(0x0, 0x0)
        /home/runner/work/steampipe/steampipe/cmd/plugin.go:379 +0x40
github.com/turbot/steampipe/cmd.runPluginInstallCmd(0xc00030f080, 0xc0005178b0, 0x1, 0x1)
        /home/runner/work/steampipe/steampipe/cmd/plugin.go:258 +0x776
github.com/turbot/steampipe/cmdconfig.OnCmd.func1(0xc00030f080, 0xc0005178b0, 0x1, 0x1)
        /home/runner/work/steampipe/steampipe/cmdconfig/builder.go:30 +0x65
github.com/spf13/cobra.(*Command).execute(0xc00030f080, 0xc000517860, 0x1, 0x1, 0xc00030f080, 0xc000517860)
        /home/runner/go/pkg/mod/github.com/spf13/[email protected]/command.go:846 +0x29d
github.com/spf13/cobra.(*Command).ExecuteC(0x16e29e0, 0x1, 0x1, 0x0)
        /home/runner/go/pkg/mod/github.com/spf13/[email protected]/command.go:950 +0x349
github.com/spf13/cobra.(*Command).Execute(...)
        /home/runner/go/pkg/mod/github.com/spf13/[email protected]/command.go:887
github.com/turbot/steampipe/cmd.Execute(0xc0004465a0, 0x1)
        /home/runner/work/steampipe/steampipe/cmd/root.go:47 +0x6d
main.main()
        /home/runner/work/steampipe/steampipe/main.go:32 +0xa5

[e-gineer]

Hey @michaelsew ... thanks for trying steampipe! Sorry that we panic'ed in excitement :-)

Steampipe will try to install our embedded postgres the first time you try to use it. I believe that Configuring database... was taking that action. It appears to have failed from there though.

A few follow up questions:

• Which version did you try? Was it 0.2.2?
• Did it appear to wait a long time before failing? (i.e. trying to connect, but couldn't?)
• If you try running the command steampipe plugin install steampipe again does it fail the same way?
• If you delete your whole ~/.steampipe directory and try again, do you see the same failure?
• If you want a flood of log data, you can try setting the env var export STEAMPIPE_LOG=trace and try again.

Any info you can provide would be appreciated. In the meantime, we'll try to catch the error instead of panic'ing.

[vbolneni]

I have it hanging at configuring database and nothing happening. it was sitting there for entire night and i have to cancel it. I tried delete whole ~/.steampipe directory and install again and same thing happening. I am on windows 2019 server WSL and ubuntu.

[vbolneni]

[mbrizbee]

Same issue on my side. Process is lock on "Configuring database...".

[idoavrah]

Try upgrading your WSL to version 2. That fixed it for me.

https://docs.microsoft.com/en-us/windows/wsl/install#upgrade-version-from-wsl-1-to-wsl-2