owasp-amass / amass

In-depth attack surface mapping and asset discovery
https://owasp.org/www-project-amass/
Other
11.78k stars 1.86k forks source link

Amass MySQL database not working #885

Open vincentcox opened 1 year ago

vincentcox commented 1 year ago

I am not able to get the Amass MySQL connection working.

Version v3.20.0 MacOSx 12.5.1 (21G83) - m1 pro Installed via homebrew

Steps to reproduce:

Install MAMP. Default MySQL port is 8889, default user and password both "root".

Login into phpmyadmin, create database: "amass".

image

Verify that connection works with these default parameters and newly created database:

image

Put this information in the config:

[scope]
[graphdbs]
[graphdbs.mysql]
primary = true
url = root:root@tcp(127.0.0.1:8889)/amass?timeout=10s

Try a connection with this config file: amass db -list -config amass.ini

image

Expected behaviour: Should work

santiago0072002 commented 1 year ago

Hi Vincent,

In my experience if you have another DB running, or if you have a service running in that same port you might not get a connection. Sometimes it is a miss spelling in the code, sometimes it is just the user name wrong/ or the password. Sometimes the user do not have rights to the DB. Those are the most common issues to an error. Sometimes the DB driver is not present or the tool might not be supporting the DB. Did you do any trouble shooting with some results?