- Git do Root C3SL

[Git][root/services/dns][main] Add dcrmd24 and maquina-mortal
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / Serviços / DNS Commits: 5585fcbe by Fernando Monteiro Kiotheka at 2025-08-06T11:47:01-03:00 Add dcrmd24 and maquina-mortal - - - - - 5 changed files: - global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone - global-202.17.200.in-addr.arpa.zone - global-c3sl.ufpr.br.zone - interna-254.10.in-addr.arpa.zone - interna-c3local.zone Changes: ===================================== global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone ===================================== @@ -11,7 +11,7 @@ $TTL 21600 0.5.b.c.1.5.e.f.f.f.a.b.2.e.2.9.1.0 IN PTR forsyn.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490199 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490938 86400 7200 2592000 3600 0.9.0.7.5.b.e.f.f.f.7.0.a.8.6.2.1.0 IN PTR barril1.c3sl.ufpr.br. 0.9.c.f.3.3.e.f.f.f.3.4.7.0.2.0.1.0 IN PTR orval.c3sl.ufpr.br. 0.a.0.0.9.7.e.f.f.f.e.3.6.1.2.0.1.0 IN PTR cpu1.c3sl.ufpr.br. @@ -37,7 +37,6 @@ $TTL 21600 2.0.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR misp.c3sl.ufpr.br. 2.0.0.3.c.e.e.f.f.f.8.c.6.1.2.0.3.0 IN PTR liamf.c3sl.ufpr.br. 2.0.0.8.1.0.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR ctl1-k8stest.c3sl.ufpr.br. -2.1.2.7.7.d.e.f.f.f.c.c.6.1.2.0.1.0 IN PTR jughisto.c3sl.ufpr.br. 2.3.2.c.c.8.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR simcaqdev1.c3sl.ufpr.br. 2.5.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR grafana.c3sl.ufpr.br. 2.c.f.2.c.e.e.f.f.f.8.c.6.1.2.0.3.0 IN PTR wiki.c3sl.ufpr.br. ===================================== global-202.17.200.in-addr.arpa.zone ===================================== @@ -24,7 +24,6 @@ $TTL 21600 18 IN PTR abbey.c3sl.ufpr.br. 19 IN PTR ladc.c3sl.ufpr.br. 20 IN PTR ronnie.c3sl.ufpr.br. -21 IN PTR jughisto.c3sl.ufpr.br. 26 IN PTR barril1.c3sl.ufpr.br. 27 IN PTR barril2.c3sl.ufpr.br. 28 IN PTR barril3.c3sl.ufpr.br. @@ -46,4 +45,4 @@ $TTL 21600 197 IN PTR debiansec.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490197 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490938 86400 7200 2592000 3600 ===================================== global-c3sl.ufpr.br.zone ===================================== @@ -95,7 +95,7 @@ c3hpc.docs IN CNAME root.pages @ IN MX 10 mx @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490199 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490939 86400 7200 2592000 3600 @ IN TXT "google-site-verification=1QxfWQZw27Mp-PLffYIKhzRAgkU-RHSQPzQPuuHA3Go" @ IN TXT "v=spf1 a:mx.c3sl.ufpr.br mx:inf.ufpr.br mx:c3sl.ufpr.br -all" campanhas.sus IN CNAME sus @@ -237,8 +237,6 @@ jitsi IN A 200.236.31.236 jitsi IN AAAA 2801:82:80ff:8002:216:ccff:feaa:50 jmeterclient IN A 200.238.144.134 jmeterclient IN AAAA 2801:82:80ff:8003:216:ccff:fe5f:426a -jughisto IN A 200.17.202.21 -jughisto IN AAAA 2801:82:80ff:8001:216:ccff:fed7:7212 jwt.matrix.sus IN CNAME matrix.sus k8sprod IN A 200.236.31.195 k8sprod IN A 200.236.31.196 ===================================== interna-254.10.in-addr.arpa.zone ===================================== @@ -393,6 +393,7 @@ $TTL 21600 63.223 IN PTR h35.c3local. 63.224 IN PTR i36.c3local. 63.249 IN PTR jatoba1.c3local. +64.221 IN PTR dcrdm24-118.c3local. 64.223 IN PTR h36.c3local. 64.224 IN PTR i37.c3local. 64.249 IN PTR jatoba2.c3local. @@ -411,6 +412,7 @@ $TTL 21600 68.223 IN PTR h40.c3local. 68.224 IN PTR i41.c3local. 68.249 IN PTR serra1-ipmi.c3local. +69.221 IN PTR maquina-mortal.c3local. 69.223 IN PTR h41.c3local. 69.249 IN PTR serra2.c3local. 70.223 IN PTR h42.c3local. @@ -468,4 +470,4 @@ $TTL 21600 249.227 IN PTR mojito7.c3local. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490033 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490767 86400 7200 2592000 3600 ===================================== interna-c3local.zone ===================================== @@ -71,7 +71,7 @@ brioja IN A 10.254.221.54 buxfox IN A 10.254.237.8 @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490033 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490767 86400 7200 2592000 3600 caio IN A 10.254.221.1 calvin IN A 10.254.229.6 carate IN A 10.254.221.43 @@ -89,6 +89,7 @@ chuck IN A 10.254.221.6 chumbinho IN A 10.254.221.17 dagoliveira IN A 10.254.229.37 daphne IN A 10.254.221.89 +dcrdm24-118 IN A 10.254.221.64 deathstar IN A 10.254.221.81 dent IN A 10.254.221.39 dexter3 IN A 10.254.229.9 @@ -320,6 +321,7 @@ lucas IN A 10.254.232.7 mah IN A 10.254.226.5 mamao IN A 10.254.237.10 mantis IN A 10.254.221.23 +maquina-mortal IN A 10.254.221.69 marquinhos IN A 10.254.221.21 max IN A 10.254.229.23 melchior IN A 10.254.237.11 View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/5585fcbe1018f1f4b876… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/5585fcbe1018f1f4b876… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/services/dhcp][main] Edit gema MAC and add dcrdm24-118
by yyvf22 (＠yyvf22) 06 Ago '25

06 Ago '25

yyvf22 pushed to branch main at Root / Serviços / DHCP Commits: 59cff2b7 by yyvf at 2025-08-06T11:28:07-03:00 Edit gema MAC and add dcrdm24-118 - - - - - 1 changed file: - kea-dhcp4.conf Changes: ===================================== kea-dhcp4.conf ===================================== @@ -4323,7 +4323,7 @@ }, { "hostname": "gema", - "hw-address": "70:85:C2:08:88:EB", + "hw-address": "60:C7:27:2C:79:F0", "ip-address": "10.254.221.52", "user-context": { "nextbox_ip_address_id": 84 } }, @@ -4393,6 +4393,12 @@ "ip-address": "10.254.221.63", "user-context": { "nextbox_ip_address_id": 2767 } }, + { + "hostname": "dcrdm24-118", + "hw-address": "60:C7:27:29:28:95", + "ip-address": "10.254.221.64", + "user-context": { "nextbox_ip_address_id": 2770 } + }, { "hostname": "organa", "hw-address": "70:F3:95:C7:30:41", View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/59cff2b72b99a852129… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/59cff2b72b99a852129… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/services/dhcp][main] Add jughisto and lpt24
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / Serviços / DHCP Commits: e8119402 by Fernando Monteiro Kiotheka at 2025-08-06T11:25:01-03:00 Add jughisto and lpt24 - - - - - 1 changed file: - kea-dhcp4.conf Changes: ===================================== kea-dhcp4.conf ===================================== @@ -242,6 +242,12 @@ "ip-address": "200.17.202.20", "user-context": { "nextbox_ip_address_id": 2522 } }, + { + "hostname": "jughisto", + "hw-address": "00:16:CC:D7:72:12", + "ip-address": "200.17.202.21", + "user-context": { "nextbox_ip_address_id": 2768 } + }, { "hostname": "barril1", "hw-address": "24:8A:07:B5:70:90", @@ -4381,6 +4387,12 @@ "ip-address": "10.254.221.62", "user-context": { "nextbox_ip_address_id": 90 } }, + { + "hostname": "lpt24-118", + "hw-address": "60:C7:27:29:29:C3", + "ip-address": "10.254.221.63", + "user-context": { "nextbox_ip_address_id": 2767 } + }, { "hostname": "organa", "hw-address": "70:F3:95:C7:30:41", View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/e811940258c361d7ad1… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/e811940258c361d7ad1… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/services/dns][main] Add lpt24-118
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / Serviços / DNS Commits: 52cf1171 by Fernando Monteiro Kiotheka at 2025-08-06T11:24:32-03:00 Add lpt24-118 - - - - - 5 changed files: - global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone - global-202.17.200.in-addr.arpa.zone - global-c3sl.ufpr.br.zone - interna-254.10.in-addr.arpa.zone - interna-c3local.zone Changes: ===================================== global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone ===================================== @@ -11,7 +11,7 @@ $TTL 21600 0.5.b.c.1.5.e.f.f.f.a.b.2.e.2.9.1.0 IN PTR forsyn.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754489358 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490199 86400 7200 2592000 3600 0.9.0.7.5.b.e.f.f.f.7.0.a.8.6.2.1.0 IN PTR barril1.c3sl.ufpr.br. 0.9.c.f.3.3.e.f.f.f.3.4.7.0.2.0.1.0 IN PTR orval.c3sl.ufpr.br. 0.a.0.0.9.7.e.f.f.f.e.3.6.1.2.0.1.0 IN PTR cpu1.c3sl.ufpr.br. @@ -37,6 +37,7 @@ $TTL 21600 2.0.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR misp.c3sl.ufpr.br. 2.0.0.3.c.e.e.f.f.f.8.c.6.1.2.0.3.0 IN PTR liamf.c3sl.ufpr.br. 2.0.0.8.1.0.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR ctl1-k8stest.c3sl.ufpr.br. +2.1.2.7.7.d.e.f.f.f.c.c.6.1.2.0.1.0 IN PTR jughisto.c3sl.ufpr.br. 2.3.2.c.c.8.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR simcaqdev1.c3sl.ufpr.br. 2.5.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR grafana.c3sl.ufpr.br. 2.c.f.2.c.e.e.f.f.f.8.c.6.1.2.0.3.0 IN PTR wiki.c3sl.ufpr.br. ===================================== global-202.17.200.in-addr.arpa.zone ===================================== @@ -24,6 +24,7 @@ $TTL 21600 18 IN PTR abbey.c3sl.ufpr.br. 19 IN PTR ladc.c3sl.ufpr.br. 20 IN PTR ronnie.c3sl.ufpr.br. +21 IN PTR jughisto.c3sl.ufpr.br. 26 IN PTR barril1.c3sl.ufpr.br. 27 IN PTR barril2.c3sl.ufpr.br. 28 IN PTR barril3.c3sl.ufpr.br. @@ -45,4 +46,4 @@ $TTL 21600 197 IN PTR debiansec.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754309374 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490197 86400 7200 2592000 3600 ===================================== global-c3sl.ufpr.br.zone ===================================== @@ -95,7 +95,7 @@ c3hpc.docs IN CNAME root.pages @ IN MX 10 mx @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754489358 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490199 86400 7200 2592000 3600 @ IN TXT "google-site-verification=1QxfWQZw27Mp-PLffYIKhzRAgkU-RHSQPzQPuuHA3Go" @ IN TXT "v=spf1 a:mx.c3sl.ufpr.br mx:inf.ufpr.br mx:c3sl.ufpr.br -all" campanhas.sus IN CNAME sus @@ -237,7 +237,8 @@ jitsi IN A 200.236.31.236 jitsi IN AAAA 2801:82:80ff:8002:216:ccff:feaa:50 jmeterclient IN A 200.238.144.134 jmeterclient IN AAAA 2801:82:80ff:8003:216:ccff:fe5f:426a -jughisto IN CNAME maratona +jughisto IN A 200.17.202.21 +jughisto IN AAAA 2801:82:80ff:8001:216:ccff:fed7:7212 jwt.matrix.sus IN CNAME matrix.sus k8sprod IN A 200.236.31.195 k8sprod IN A 200.236.31.196 ===================================== interna-254.10.in-addr.arpa.zone ===================================== @@ -389,6 +389,7 @@ $TTL 21600 62.223 IN PTR h34.c3local. 62.224 IN PTR i35.c3local. 62.249 IN PTR pilheira1-ipmi.c3local. +63.221 IN PTR lpt24-118.c3local. 63.223 IN PTR h35.c3local. 63.224 IN PTR i36.c3local. 63.249 IN PTR jatoba1.c3local. @@ -467,4 +468,4 @@ $TTL 21600 249.227 IN PTR mojito7.c3local. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754486226 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490033 86400 7200 2592000 3600 ===================================== interna-c3local.zone ===================================== @@ -71,7 +71,7 @@ brioja IN A 10.254.221.54 buxfox IN A 10.254.237.8 @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754486227 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754490033 86400 7200 2592000 3600 caio IN A 10.254.221.1 calvin IN A 10.254.229.6 carate IN A 10.254.221.43 @@ -315,6 +315,7 @@ leffe IN A 10.254.222.14 lobo IN A 10.254.221.74 loki IN A 10.254.236.33 loski IN A 10.254.221.28 +lpt24-118 IN A 10.254.221.63 lucas IN A 10.254.232.7 mah IN A 10.254.226.5 mamao IN A 10.254.237.10 View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/52cf117117de30eb18b5… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/52cf117117de30eb18b5… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/dbroot/postgresql-sync-config][main] Remove matrixold
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / DBRoot / PostgreSQL Commits: 37b6c1ed by Fernando K at 2025-08-06T14:23:58+00:00 Remove matrixold - - - - - 1 changed file: - pg_hba.conf Changes: ===================================== pg_hba.conf ===================================== @@ -41,7 +41,6 @@ hostssl gitlab gitlab gitlab.c3sl.ufpr.br s hostssl metabase metabase metabase.c3sl.ufpr.br scram-sha-256 hostssl moodle moodle moodle.c3sl.ufpr.br scram-sha-256 hostssl gitlab metabase metabase.c3sl.ufpr.br scram-sha-256 -hostssl matrix_bd matrix_c3sl matrixold.c3sl.ufpr.br scram-sha-256 # MECRED hostssl mecred mecred mecred.c3sl.ufpr.br scram-sha-256 View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dbroot/postgresql-sync-config/-/commit/37b… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dbroot/postgresql-sync-config/-/commit/37b… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/dbroot/postgresql-sync-config][main] Add LIAMF to mecred_homologa
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / DBRoot / PostgreSQL Commits: 110fec51 by Fernando K at 2025-08-06T14:21:52+00:00 Add LIAMF to mecred_homologa - - - - - 1 changed file: - pg_hba.conf Changes: ===================================== pg_hba.conf ===================================== @@ -45,15 +45,9 @@ hostssl matrix_bd matrix_c3sl matrixold.c3sl.ufpr.br s # MECRED hostssl mecred mecred mecred.c3sl.ufpr.br scram-sha-256 -# hostssl mecred_dev mecred mecreddev.c3sl.ufpr.br scram-sha-256 -# hostssl mecred_teste mecred mecreddev.c3sl.ufpr.br scram-sha-256 hostssl mecred_homologa mecred mecredhomologa.c3sl.ufpr.br scram-sha-256 -# hostssl mecred_dev mecred mecredhomologa.c3sl.ufpr.br scram-sha-256 -# hostssl mecred_teste mecred mecredhomologa.c3sl.ufpr.br scram-sha-256 hostssl mecred_homologa mecred 10.254.221.0/24 scram-sha-256 -# hostssl mecred_dev mecred 10.254.221.0/24 scram-sha-256 -# hostssl mecred_teste mecred 10.254.221.0/24 scram-sha-256 -# hostssl mecred_teste mecred 10.254.238.0/24 scram-sha-256 +hostssl mecred_homologa mecred 10.254.238.0/24 scram-sha-256 hostssl mecred_homologa mecred 10.254.237.0/24 scram-sha-256 # Acesso ao secret hostssl mecred metabase metabase.c3sl.ufpr.br scram-sha-256 hostssl portalmec metabase metabase.c3sl.ufpr.br scram-sha-256 View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dbroot/postgresql-sync-config/-/commit/110… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dbroot/postgresql-sync-config/-/commit/110… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/services/dhcp][main] Remove some VMs and add hop23
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / Serviços / DHCP Commits: 4139d517 by Fernando Monteiro Kiotheka at 2025-08-06T11:18:21-03:00 Remove some VMs and add hop23 - - - - - 1 changed file: - kea-dhcp4.conf Changes: ===================================== kea-dhcp4.conf ===================================== @@ -897,12 +897,6 @@ "ip-address": "200.236.31.158", "user-context": { "nextbox_ip_address_id": 1577 } }, - { - "hostname": "sharelatex", - "hw-address": "00:16:C8:EC:2F:D9", - "ip-address": "200.236.31.159", - "user-context": { "nextbox_ip_address_id": 1578 } - }, { "hostname": "bdc", "hw-address": "00:16:C8:EC:2F:DA", @@ -1131,12 +1125,6 @@ "ip-address": "200.236.31.200", "user-context": { "nextbox_ip_address_id": 2674 } }, - { - "hostname": "toggles", - "hw-address": "00:16:CC:AA:00:D3", - "ip-address": "200.236.31.201", - "user-context": { "nextbox_ip_address_id": 1606 } - }, { "hostname": "wrk3-k8sprod", "hw-address": "00:16:CC:3C:7F:71", @@ -1214,12 +1202,6 @@ "hw-address": "00:16:C8:EC:2F:C6", "ip-address": "200.236.31.245", "user-context": { "nextbox_ip_address_id": 1628 } - }, - { - "hostname": "matrixold", - "hw-address": "00:16:CC:AA:00:2C", - "ip-address": "200.236.31.253", - "user-context": { "nextbox_ip_address_id": 1630 } } ], "id": 15 @@ -4381,6 +4363,12 @@ "ip-address": "10.254.221.59", "user-context": { "nextbox_ip_address_id": 2751 } }, + { + "hostname": "hop23-119", + "hw-address": "60:C7:27:29:28:A4", + "ip-address": "10.254.221.60", + "user-context": { "nextbox_ip_address_id": 2766 } + }, { "hostname": "gps20-118", "hw-address": "60:C7:27:2C:79:8D", View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/4139d51704317f4dd3e… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dhcp/-/commit/4139d51704317f4dd3e… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/services/dns][main] Remove some VMs and add hop23
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed to branch main at Root / Serviços / DNS Commits: e9c43bfb by Fernando Monteiro Kiotheka at 2025-08-06T11:15:04-03:00 Remove some VMs and add hop23 - - - - - 5 changed files: - global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone - global-31.236.200.in-addr.arpa.zone - global-c3sl.ufpr.br.zone - interna-254.10.in-addr.arpa.zone - interna-c3local.zone Changes: ===================================== global-0.8.f.f.0.8.2.8.0.0.1.0.8.2.ip6.arpa.zone ===================================== @@ -11,7 +11,7 @@ $TTL 21600 0.5.b.c.1.5.e.f.f.f.a.b.2.e.2.9.1.0 IN PTR forsyn.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754419539 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754489358 86400 7200 2592000 3600 0.9.0.7.5.b.e.f.f.f.7.0.a.8.6.2.1.0 IN PTR barril1.c3sl.ufpr.br. 0.9.c.f.3.3.e.f.f.f.3.4.7.0.2.0.1.0 IN PTR orval.c3sl.ufpr.br. 0.a.0.0.9.7.e.f.f.f.e.3.6.1.2.0.1.0 IN PTR cpu1.c3sl.ufpr.br. @@ -47,7 +47,6 @@ $TTL 21600 3.3.f.2.0.e.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR ctl1-k8sstage.c3sl.ufpr.br. 3.4.6.3.e.b.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR test-ldap.c3sl.ufpr.br. 3.a.0.0.3.7.e.f.f.f.e.3.6.1.2.0.1.0 IN PTR cloneimgteste.c3sl.ufpr.br. -3.d.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR toggles.c3sl.ufpr.br. 3.f.1.e.c.1.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR ensalamentodev.c3sl.ufpr.br. 4.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0 IN PTR debian.c3sl.ufpr.br. 4.0.0.0.9.7.e.f.f.f.e.3.6.1.2.0.1.0 IN PTR fradim.c3sl.ufpr.br. @@ -105,7 +104,6 @@ $TTL 21600 9.c.f.2.c.e.e.f.f.f.8.c.6.1.2.0.2.0 IN PTR mecredold.c3sl.ufpr.br. 9.d.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR simcaqnfdev.c3sl.ufpr.br. 9.d.2.9.6.b.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR supersetdeppdev2.c3sl.ufpr.br. -9.d.f.2.c.e.e.f.f.f.8.c.6.1.2.0.2.0 IN PTR sharelatex.c3sl.ufpr.br. a.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0 IN PTR tdf.c3sl.ufpr.br. a.0.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR gandalf.c3sl.ufpr.br. a.1.0.0.a.a.e.f.f.f.c.c.6.1.2.0.3.0 IN PTR adega.c3sl.ufpr.br. @@ -129,7 +127,6 @@ b.a.f.2.c.e.e.f.f.f.8.c.6.1.2.0.3.0 IN PTR bigsea.c3sl.ufpr. b.d.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR simcaqmonetdbdev.c3sl.ufpr.br. b.e.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR plausible.c3sl.ufpr.br. c.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0 IN PTR eclipse.c3sl.ufpr.br. -c.2.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR matrixold.c3sl.ufpr.br. c.6.0.d.d.7.e.f.f.f.c.c.6.1.2.0.1.0 IN PTR ladc.c3sl.ufpr.br. c.c.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR saruman.c3sl.ufpr.br. c.d.0.0.a.a.e.f.f.f.c.c.6.1.2.0.2.0 IN PTR mecredhomologa.c3sl.ufpr.br. ===================================== global-31.236.200.in-addr.arpa.zone ===================================== @@ -18,7 +18,7 @@ $TTL 21600 13 IN PTR turnkey.c3sl.ufpr.br. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754419568 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754489357 86400 7200 2592000 3600 129 IN PTR ctl1-k8sstage.c3sl.ufpr.br. 129 IN PTR k8sstage.c3sl.ufpr.br. 130 IN PTR pnlddados.c3sl.ufpr.br. @@ -50,7 +50,6 @@ $TTL 21600 155 IN PTR turn.c3sl.ufpr.br. 157 IN PTR gandalf.c3sl.ufpr.br. 158 IN PTR simcaqnfdev.c3sl.ufpr.br. -159 IN PTR sharelatex.c3sl.ufpr.br. 160 IN PTR bdc.c3sl.ufpr.br. 161 IN PTR mecredold.c3sl.ufpr.br. 162 IN PTR c3hpc.c3sl.ufpr.br. @@ -88,7 +87,6 @@ $TTL 21600 198 IN PTR ctl3-k8sprod.c3sl.ufpr.br. 199 IN PTR wrk1-k8sprod.c3sl.ufpr.br. 200 IN PTR wrk2-k8sprod.c3sl.ufpr.br. -201 IN PTR toggles.c3sl.ufpr.br. 203 IN PTR wrk3-k8sprod.c3sl.ufpr.br. 204 IN PTR wrk5-k8sstage.c3sl.ufpr.br. 205 IN PTR mecred.c3sl.ufpr.br. @@ -109,4 +107,3 @@ $TTL 21600 232 IN PTR moodle.c3sl.ufpr.br. 236 IN PTR jitsi.c3sl.ufpr.br. 245 IN PTR simcaqhomologa.c3sl.ufpr.br. -253 IN PTR matrixold.c3sl.ufpr.br. ===================================== global-c3sl.ufpr.br.zone ===================================== @@ -95,7 +95,7 @@ c3hpc.docs IN CNAME root.pages @ IN MX 10 mx @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754419593 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754489358 86400 7200 2592000 3600 @ IN TXT "google-site-verification=1QxfWQZw27Mp-PLffYIKhzRAgkU-RHSQPzQPuuHA3Go" @ IN TXT "v=spf1 a:mx.c3sl.ufpr.br mx:inf.ufpr.br mx:c3sl.ufpr.br -all" campanhas.sus IN CNAME sus @@ -292,8 +292,6 @@ maratona IN AAAA 2801:82:80ff:8003:21 matrix IN A 200.236.31.215 matrix.sus IN A 200.17.212.14 matrix.sus IN AAAA 2801:82:80ff:10:18c3:51ff:fe5e:b8c -matrixold IN A 200.236.31.253 -matrixold IN AAAA 2801:82:80ff:8002:216:ccff:feaa:2c mecdb4 IN A 200.236.31.169 mecdb4 IN AAAA 2801:82:80ff:8002:216:ccff:feaa:4d mecred IN A 200.236.31.205 @@ -432,8 +430,6 @@ secret IN CNAME secret.pages sentillo IN A 200.238.144.129 sentillo IN AAAA 2801:82:80ff:8003:216:ccff:fe1a:125f sfu.matrix.sus IN CNAME matrix.sus -sharelatex IN A 200.236.31.159 -sharelatex IN AAAA 2801:82:80ff:8002:216:c8ff:feec:2fd9 sharelatexprod IN CNAME sharelatex sigproffilo IN A 200.238.144.137 sigproffilo IN AAAA 2801:82:80ff:8003:216:ccff:fe9d:b8e8 @@ -496,8 +492,6 @@ tdf IN AAAA 2801:82:80ff:8000::a test-ldap IN A 200.236.31.139 test-ldap IN AAAA 2801:82:80ff:8002:216:ccff:febe:3643 tftp.boot IN CNAME estrella -toggles IN A 200.236.31.201 -toggles IN AAAA 2801:82:80ff:8002:216:ccff:feaa:d3 trisquel IN CNAME sagres trojanizador IN A 200.238.144.143 trojanizador IN AAAA 2801:82:80ff:8003:216:ccff:fee7:3257 ===================================== interna-254.10.in-addr.arpa.zone ===================================== @@ -379,6 +379,7 @@ $TTL 21600 59.221 IN PTR jz22-118.c3local. 59.223 IN PTR h31.c3local. 59.224 IN PTR i32.c3local. +60.221 IN PTR hop23-119.c3local. 60.223 IN PTR h32.c3local. 60.224 IN PTR i33.c3local. 61.221 IN PTR gps20-118.c3local. @@ -466,4 +467,4 @@ $TTL 21600 249.227 IN PTR mojito7.c3local. @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754415589 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754486226 86400 7200 2592000 3600 ===================================== interna-c3local.zone ===================================== @@ -71,7 +71,7 @@ brioja IN A 10.254.221.54 buxfox IN A 10.254.237.8 @ IN NS ns2.c3sl.ufpr.br. @ IN NS ns.c3sl.ufpr.br. -@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754415589 86400 7200 2592000 3600 +@ 21600 IN SOA ns.c3sl.ufpr.br. root.c3sl.ufpr.br. 1754486227 86400 7200 2592000 3600 caio IN A 10.254.221.1 calvin IN A 10.254.229.6 carate IN A 10.254.221.43 @@ -194,6 +194,7 @@ hdv23-desktop IN A 10.254.221.37 hipes-cockpit IN A 10.254.249.74 hipes13 IN A 10.254.227.244 honey IN A 10.254.221.33 +hop23-119 IN A 10.254.221.60 hyme IN A 10.254.229.5 i21 IN A 10.254.224.48 i22 IN A 10.254.224.49 View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/e9c43bfbf0cdd62effd5… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/services/dns/-/commit/e9c43bfbf0cdd62effd5… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/cli/netboxadm] Pushed new tag v0.1.12
by Fernando K (＠fmkiotheka) 06 Ago '25

06 Ago '25

Fernando K pushed new tag v0.1.12 at Root / CLI / Netboxadm -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/cli/netboxadm/-/tree/v0.1.12 You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0

[Git][root/dmarc-report][main] Project working with go backend
by Guiusepe (＠godp21) 06 Ago '25

06 Ago '25

Guiusepe pushed to branch main at Root / DMARC Report Commits: e551a908 by godp21 at 2025-08-06T11:02:27-03:00 Project working with go backend - - - - - 4 changed files: - + docker-compose.yml - + file - main.go - static/index.html Changes: ===================================== docker-compose.yml ===================================== @@ -0,0 +1,8 @@ +version: "3.8" + +services: + api: + build: . + container_name: dmarc-api + ports: + - "8080:8080" ===================================== file ===================================== @@ -0,0 +1,32 @@ +SELECT + *, + (CASE + WHEN dkim_align = 'fail' THEN 0 + WHEN dkim_align = 'pass' THEN 1 + ELSE 3 + END) + + + (CASE + WHEN spf_align = 'fail' THEN 0 + WHEN spf_align = 'pass' THEN 1 + ELSE 3 + END) + AS dmarc_result_min, + (CASE + WHEN dkim_align = 'fail' THEN 0 + WHEN dkim_align = 'pass' THEN 1 + ELSE 3 + END) + + + (CASE + WHEN spf_align = 'fail' THEN 0 + WHEN spf_align = 'pass' THEN 1 + ELSE 3 + END) + AS dmarc_result_max +FROM + rptrecord +WHERE + serial = 3955 +ORDER BY + ip ASC ===================================== main.go ===================================== @@ -3,7 +3,6 @@ package main import ( "database/sql" "encoding/json" - "encoding/xml" "fmt" "log" "net/http" @@ -20,17 +19,21 @@ const ( ) type Row struct { + Serial int `json:"serial"` MinDate string `json:"mindate"` MaxDate string `json:"maxdate"` Domain string `json:"domain"` Org string `json:"org"` - Messages int `json:"messages"` - ReportID string `json:"report_id"` -} - -// XML structure to extract <report_metadata><report_id>...</report_id></report_metadata> -type ReportMetadata struct { - ReportID string `xml:"report_metadata>report_id"` + ReportID string `json:"reportid"` + Email string `json:"email"` + Xtracon string `json:"extra_contact_info"` + Rcount int `json:"rcount"` + Dkim_align_min int `json:"dkim_align_min"` + Spf_align_min int `json:"spf_align_min"` + Dkim_result_min int `json:"dkim_result_min"` + Spf_result_min int `json:"spf_result_min"` + Dmarc_result_min int `json:"dmarc_result_min"` + Dmarc_result_max int `json:"dmarc_result_max"` } func main() { @@ -48,13 +51,56 @@ func main() { defer db.Close() query := ` - SELECT rpt.mindate, rpt.maxdate, rpt.domain, rpt.org, rpt.raw_xml, - count(*) as messages - FROM report as rpt - JOIN rptrecord as rcd ON rpt.serial = rcd.serial - GROUP BY rpt.serial - ORDER BY messages; + SELECT + report.serial, + mindate, + maxdate, + domain, + org, + reportid, + email, + rcount, + dkim_align_min, + spf_align_min, + dkim_result_min, + spf_result_min, + dmarc_result_min, + dmarc_result_max + FROM + report + LEFT JOIN + ( + SELECT + SUM(rcount) AS rcount, + serial, + MIN( + (CASE WHEN dkim_align = 'fail' THEN 0 WHEN dkim_align = 'pass' THEN 2 ELSE 1 END) + ) AS dkim_align_min, + MIN( + (CASE WHEN spf_align = 'fail' THEN 0 WHEN spf_align = 'pass' THEN 2 ELSE 1 END) + ) AS spf_align_min, + MIN( + (CASE WHEN dkimresult = 'fail' THEN 0 WHEN dkimresult = 'pass' THEN 2 ELSE 1 END) + ) AS dkim_result_min, + MIN( + (CASE WHEN spfresult = 'fail' THEN 0 WHEN spfresult = 'pass' THEN 2 ELSE 1 END) + ) AS spf_result_min, + MIN( + (CASE WHEN dkim_align = 'fail' THEN 0 WHEN dkim_align = 'pass' THEN 1 ELSE 3 END) + + + (CASE WHEN spf_align = 'fail' THEN 0 WHEN spf_align = 'pass' THEN 1 ELSE 3 END) + ) AS dmarc_result_min, + MAX( + (CASE WHEN dkim_align = 'fail' THEN 0 WHEN dkim_align = 'pass' THEN 1 ELSE 3 END) + + + (CASE WHEN spf_align = 'fail' THEN 0 WHEN spf_align = 'pass' THEN 1 ELSE 3 END) + ) AS dmarc_result_max + FROM rptrecord + GROUP BY serial + ) AS rptrecord + ON report.serial = rptrecord.serial ` + rows, err := db.Query(query) if err != nil { http.Error(w, err.Error(), 500) @@ -65,21 +111,97 @@ func main() { var results []Row for rows.Next() { var row Row - var rawXML string - err := rows.Scan(&row.MinDate, &row.MaxDate, &row.Domain, &row.Org, &rawXML, &row.Messages) + err := rows.Scan( + &row.Serial, + &row.MinDate, + &row.MaxDate, + &row.Domain, + &row.Org, + &row.ReportID, + &row.Email, + &row.Rcount, + &row.Dkim_align_min, + &row.Spf_align_min, + &row.Dkim_result_min, + &row.Spf_result_min, + &row.Dmarc_result_min, + &row.Dmarc_result_max, + ) if err != nil { http.Error(w, err.Error(), 500) return } + results = append(results, row) + } - var meta ReportMetadata - if err := xml.Unmarshal([]byte(rawXML), &meta); err == nil { - row.ReportID = meta.ReportID - } else { - row.ReportID = "(invalid XML)" - } + w.Header().Set("Content-Type", "application/json") + json.NewEncoder(w).Encode(results) + }) - results = append(results, row) + http.HandleFunc("/api/details", func(w http.ResponseWriter, r *http.Request) { + serial := r.URL.Query().Get("serial") + if serial == "" { + http.Error(w, "Missing serial parameter", http.StatusBadRequest) + return + } + + psqlInfo := fmt.Sprintf("host=%s port=%d user=%s password=%s dbname=%s sslmode=require", + host, port, user, password, dbname) + + db, err := sql.Open("postgres", psqlInfo) + if err != nil { + http.Error(w, err.Error(), 500) + return + } + defer db.Close() + + query := ` + SELECT + *, + (CASE WHEN dkim_align = 'fail' THEN 0 WHEN dkim_align = 'pass' THEN 1 ELSE 3 END) + + + (CASE WHEN spf_align = 'fail' THEN 0 WHEN spf_align = 'pass' THEN 1 ELSE 3 END) + AS dmarc_result_min, + (CASE WHEN dkim_align = 'fail' THEN 0 WHEN dkim_align = 'pass' THEN 1 ELSE 3 END) + + + (CASE WHEN spf_align = 'fail' THEN 0 WHEN spf_align = 'pass' THEN 1 ELSE 3 END) + AS dmarc_result_max + FROM rptrecord + WHERE serial = $1 + ORDER BY ip ASC + ` + + rows, err := db.Query(query, serial) + if err != nil { + http.Error(w, err.Error(), 500) + return + } + defer rows.Close() + + columns, _ := rows.Columns() + values := make([]interface{}, len(columns)) + results := []map[string]interface{}{} + + for rows.Next() { + entry := make(map[string]interface{}) + pointers := make([]interface{}, len(columns)) + for i := range pointers { + pointers[i] = &values[i] + } + if err := rows.Scan(pointers...); err != nil { + http.Error(w, err.Error(), 500) + return + } + for i, col := range columns { + val := values[i] + b, ok := val.([]byte) + if ok { + entry[col] = string(b) + } else { + entry[col] = val + } + } + results = append(results, entry) } w.Header().Set("Content-Type", "application/json") @@ -89,4 +211,3 @@ func main() { fmt.Println("Server running at http://localhost:8080") log.Fatal(http.ListenAndServe(":8080", nil)) } - ===================================== static/index.html ===================================== @@ -7,21 +7,33 @@ width: 100%; border-collapse: collapse; margin-top: 1em; - } + } th, td { padding: 8px; border: 1px solid #ccc; text-align: left; - } + } </style> </head> <body> + <style> + .clickable-row { + cursor: pointer; + background-color: #f9f9f9; + } + .clickable-row:hover { + background-color: #e0e0e0; + } + .detail-row td { + background-color: #f1f1f1; + } + </style> <h1>DMARC Report Table</h1> <table id="report-table"> <thead> <tr> <th>Min Date</th> - <th>Max Date</th> + <th>Max Date</th> <th>Domain</th> <th>Org</th> <th>Messages</th> @@ -31,25 +43,59 @@ <tbody></tbody> </table> - <script> - fetch('/api/data') - .then(res => res.json()) - .then(data => { - const tbody = document.querySelector('#report-table tbody'); - data.forEach(row => { - const tr = document.createElement('tr'); - tr.innerHTML = ` - <td>${row.mindate}</td> - <td>${row.maxdate}</td> - <td>${row.domain}</td> - <td>${row.org}</td> - <td>${row.messages}</td> - <td>${row.report_id}</td> - `; - tbody.appendChild(tr); +<script> + fetch('/api/data') + .then(res => res.json()) + .then(data => { + const tbody = document.querySelector('#report-table tbody'); + data.forEach(row => { + // Main row + const tr = document.createElement('tr'); + tr.classList.add('clickable-row'); + tr.innerHTML = ` + <td>${row.mindate}</td> + <td>${row.maxdate}</td> + <td>${row.domain}</td> + <td>${row.org}</td> + <td>${row.rcount || row.messages}</td> + <td>${row.reportid || row.report_id}</td> + `; + + // Collapsible detail row (initially empty) + const detailTr = document.createElement('tr'); + detailTr.classList.add('detail-row'); + detailTr.style.display = 'none'; + const detailTd = document.createElement('td'); + detailTd.colSpan = 6; + detailTd.innerHTML = '<em>Loading...</em>'; + detailTr.appendChild(detailTd); + + // On click, fetch detail by serial + tr.addEventListener('click', () => { + if (detailTr.style.display === 'none') { + fetch(`/api/details?serial=${row.serial}`) + .then(res => res.json()) + .then(detail => { + detailTd.innerHTML = ` + <strong>Details for Serial ${row.serial}:</strong><br> + <pre>${JSON.stringify(detail, null, 2)}</pre> + `; + }) + .catch(err => { + detailTd.innerHTML = `<span style="color:red;">Error loading details</span>`; + }); + + detailTr.style.display = 'table-row'; + } else { + detailTr.style.display = 'none'; + } }); + + tbody.appendChild(tr); + tbody.appendChild(detailTr); }); - </script> + }); +</script> + </body> </html> - View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dmarc-report/-/commit/e551a908f819cd517288… -- View it on GitLab: https://gitlab.c3sl.ufpr.br/root/dmarc-report/-/commit/e551a908f819cd517288… You're receiving this email because of your account on gitlab.c3sl.ufpr.br.

1 0