search

certat / do-portal

This project is in maintenance mode and will only receive bug fixes, but no new features. A new version of this software is being developed.
5 stars 5 forks source link

RIPE/fody DB schema documentation #66

Closed davewood closed 5 years ago

davewood commented 5 years ago

the ripe db dump requires already existing structures, where do they come from?

cert_db      | ERROR:  relation "public.autonomous_system_annotation" does not exist
cert_db      | STATEMENT:  ALTER SEQUENCE fody.autonomous_system_annotation_autonomous_system_annotation_i_seq OWNED BY public.autonomous_system_annotation.autonomous_system_annotation_id;
do-portal    | psql:create_fody_schema.sql:14: ERROR:  relation "public.autonomous_system_annotation" does not exist
do-portal    | psql:create_fody_schema.sql:14: STATEMENT:  ALTER SEQUENCE fody.autonomous_system_annotation_autonomous_system_annotation_i_seq OWNED BY public.autonomous_system_annotation.autonomous_system_annotation_id;
ghost commented 5 years ago

All public. needs to be replaced by fody.. I did that, but forgot that this can be necessary two times per line - I didn't use the g-Flag of sed.

I uploaded a new version of the file, but you can just apply the replacement yourself too.

davewood commented 5 years ago

https://github.com/certat/do-portal/commit/5143248f0ef150d29468c00f4088650c74de7b5a

the docker setup now creates the correct FODY/RIPE contactdb.

the only exercise left is to figure out the minimal INSERT statements to create a RIPE org handle + abusec contact.

davewood commented 5 years ago

@wagner-certat, @MarkHofstetter : which tables do I need to fill for that?