View Issue Details

IDProjectCategoryView StatusLast Update
0000180My infrastructureGeneralpublic2022-12-16 16:53
Reporterdvl Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Summary0000180: change the "missing ports_categories entries" email for FreshPorts to a Nagios configuration check
DescriptionLet's change this to monitoring instead

This is a list of ports that do not have entries in the ports_categories table
This can be fixed with this query:

begin; insert into ports_categories select id, category_id from ports_active PA WHERE NOT EXISTS (SELECT * from ports_categories PC where PC.port_id = PA.id and PC.category_id = PA.category_id);

This is a list of the ports in question:

   id | category_id | name | category | port | element_pathname
--------+-------------+--------+----------+--------------+--------------------------
 109118 | 10 | libnjs | devel | devel/libnjs | /ports/head/devel/libnjs
(1 row)

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2022-12-16 16:53 dvl New Issue