Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql error #1019

Closed
ghost opened this issue Apr 3, 2024 · 3 comments
Closed

sql error #1019

ghost opened this issue Apr 3, 2024 · 3 comments

Comments

@ghost
Copy link

ghost commented Apr 3, 2024

Hello, I am using the most current version of amass, go package v4.2.0, and I am using the example config.yaml file with the datasources.yaml file. I am also using a resolver.txt file that was suggested by other users.

I am able to get amass to use my config and datasources, but ONLY without the postgresql entry.

I created a user and a database for amass, but when I use it in my config I get the following error

panic: ERROR: operator class "gin_trgm_ops" does not exist for access method "gin" (SQLSTATE 42704) handling 005_assets_indexes.sql
goroutine 1 [running]:
github.com/caffix/netmap.NewGraph({0xc0001fcb90?, 0x2d?}, {0xc008c7a5f0?, 0x5?}, {0x5?, 0xc000697448?})
/home/osint/go/pkg/mod/github.com/caffix/netmap@v0.2.5/graph.go:91 +0x44c
github.com/owasp-amass/amass/v4/systems.(*LocalSystem).setupGraphDBs(0xc0001cc2a0, 0xc0003b8540)
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/systems/local.go:227 +0x317
github.com/owasp-amass/amass/v4/systems.NewLocalSystem(0xc0003b8540)
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/systems/local.go:86 +0x2bb
main.GetAllSourceInfo(0x0?)
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/cmd/amass/main.go:127 +0x4f
main.argsAndConfig({0xc000040b30, 0x1, 0x1})
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/cmd/amass/enum.go:332 +0xa8f
main.runEnumCommand({0xc000040b30?, 0xc000040b20?, 0xc0002fc3d0?})
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/cmd/amass/enum.go:150 +0x38
main.main()
/home/osint/go/pkg/mod/github.com/owasp-amass/amass/v4@v4.2.0/cmd/amass/main.go:110 +0x2f2

@The-Inceptions
Copy link
Member

how do your yaml files look? what version are you running? please redact any creds in your datasources.yaml

@ghost ghost changed the title check callback failed for the configuration sql error Apr 3, 2024
@ghost
Copy link
Author

ghost commented Apr 3, 2024

sorry, i changed the issue because I was able to get amass to run, but only when i comment out the postgresql entry.

I am using v4.2.0.

When i use the postgresql entry of the config.yaml i get the following error.
panic: ERROR: operator class "gin_trgm_ops" does not exist for access method "gin" (SQLSTATE 42704) handling 005_assets_indexes.sql

@ghost ghost closed this as completed Apr 3, 2024
@ghost ghost reopened this Apr 3, 2024
@ghost
Copy link
Author

ghost commented Apr 5, 2024

I ended up commenting out the postgresql entry and Amass worked fine.

@ghost ghost closed this as completed Apr 5, 2024
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant