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

What analyzers go to the PostgreSQL database for feeds? #6560

Open
almaz045 opened this issue Apr 1, 2024 · 0 comments
Open

What analyzers go to the PostgreSQL database for feeds? #6560

almaz045 opened this issue Apr 1, 2024 · 0 comments
Labels

Comments

@almaz045
Copy link

almaz045 commented Apr 1, 2024

Hello! I supplement the feeds in the postgresql database after initialization with the init.sql script from the instructions. This is for personal purposes. My question is, what analyzers will go into this postgresql database to take feeds from there (accordingly, take my views too)?
I start DC with the following command:
dependency-check.sh -o . -s. -f HTML --dbDriverName org.postgresql.Driver --connectionString 'jdbc:postgresql://127.0.0.1:5432/depcheck?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC' --dbPassword postgres --dbUser postgres --dbDriverPath ./postgresql-42.5.4.jar --disableOssIndex --disableCentral

The second question is, do I fill the database correctly so that DC can find my feeds?
To add my own feeds I used the following commands:
insert into vulnerability (cve, description, v2severity, v2score, v3basescore, v3baseseverity) values ('CVE-2022-9998', E'SOME-description', 'HIGH', '8.0', '8.0', 'HIGH');
insert into cpeentry (part, vendor, product, version, update_version, edition, lang, sw_edition, target_sw, target_hw, other, ecosystem) values ('a', 'sweetalert2_project','sweetalert2','', '', '','','','node.js','','*','nodejs');
insert into software (cveid, cpeentryid, versionstartincluding, vulnerable) values ((select id from vulnerability where cve='CVE-2022-9998'), (select id from cpeentry where product='sweetalert2' limit 1),'11.4.9 ', true);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant