Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - DokuKäfer

Pages: [1] 2 3 ... 6

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 15, 2023, 08:17:33 pm »

Läuft nun seit Samstag ohne Probleme, aber nur auf dem Schreibtisch und noch nicht produktiv.
Am Wochenende will ich die Box dann produktive setzen.

Die meisten Probleme hatte ich komischerweise immer, wenn ich von 23.7 auf 23.7.8 aktualisiert hatte.
Dann hing es irgendwann beim Fetching und die Box startete neu und dann lief es wie im Video vom Eingangspost ab.

Das Update auf 23.7.8_1 von vor 2 Tagen lief aber schonmal ohne Probleme durch.

Wüsste sonst gerade nicht, wie ich das sonst noch testen könnte.

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 11, 2023, 10:48:06 pm »

Ok dann installiere ich dies auch noch! Danke

Ich habe gerade mal das "Hardware information" Plugin in OPNSense installiert.
Da bekomme ich folgenden Hersteller ausgespuckt:
Manufacturer CWWK
Product Name CW-AD4L-N V1

Vom Aussehen passt es zu meiner.
https://cwwk.net/products/12th-gen-intel-firewall-mini-pc-alder-lake-i3-n305-8-core-n200-n100-fanless-soft-router-proxmox-ddr5-4800mhz-4xi226-v-2-5g?variant=44614005555432

Die bieten schonmal einen Download-Bereich an.
Aber für V1 ist wohl kein Update in den Ordnern vorhanden.
Ist dann auch die Frage, ob das Passen würde.

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 11, 2023, 07:49:55 pm »

Das wars, die beiden Einträge hatten gefehlt.

Ich hatte diese aber zu 100% über System -> Settings -> Tunables eingetragen.
Sonst hätte es doch auch nicht die 11er nach einem reboot ziehen dürfen oder?

Kiste läuft nun auf 0x0000000000000012

Jetzt bin ich mal gespannt was die nächsten Tage so bringen.

Danke Danke Danke!

Code: [Select]

x86info v1.31pre
Found 4 identical CPUs
Extended Family: 0 Extended Model: 11 Family: 6 Model: 190 Stepping: 0
Type: 0 (Original OEM)
CPU Model (x86info's best guess): Unknown model.

Performance msrs:
  MSR_IA32_PERF_STATUS: 0x21d600001d00
  MSR_IA32_MISC_ENABLE: 0x850089 [Enabled: TCC PerfMon EnhancedSpeedStep ]

Thermal msrs:
  MSR_PM_THERM2_CTL: 0x0 [Thermal monitor: 1]
  MSR_IA32_THERM_CONTROL: 0x0 [Software-controlled clock disabled (full speed)]
  MSR_IA32_THERM_STATUS: 0x88300000

Machine check MSRs:
Number of reporting banks : 20
Bank: 0 (0x400)
MC0CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000001 11011110
MC0STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC0ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 1 (0x404)
MC1CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000001
MC1STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC1ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 2 (0x408)
MC2CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC2STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC2ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 3 (0x40c)
MC3CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000011
MC3STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC3ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 4 (0x410)
MC4CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC4STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC4ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 5 (0x414)
MC5CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC5STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC5ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 6 (0x418)
MC6CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 11111111
MC6STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC6ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 7 (0x41c)
MC7CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00111111
MC7STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC7ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 8 (0x420)
MC8CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC8STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC8ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 9 (0x424)
MC9CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000111 11111111
MC9STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC9ADDR:   00000000 00000000 00000000 00000000
           11111110 11110001 10101101 11000000
Bank: 10 (0x428)
MC10CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000111 11111111
MC10STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC10ADDR:   00000000 00000000 00000000 00000000
           11111110 11110001 10101101 10000000
Bank: 11 (0x42c)
MC11CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC11STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC11ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 12 (0x430)
MC12CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC12STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC12ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 13 (0x434)
MC13CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC13STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC13ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 14 (0x438)
MC14CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC14STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC14ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 15 (0x43c)
MC15CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC15STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC15ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 16 (0x440)
MC16CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC16STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC16ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 17 (0x444)
MC17CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC17STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC17ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 18 (0x448)
MC18CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC18STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC18ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 19 (0x44c)
MC19CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC19STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC19ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111

Microcode version: 0x0000000000000012

eax in: 0x00000000, eax = 00000020 ebx = 756e6547 ecx = 6c65746e edx = 49656e69
eax in: 0x00000001, eax = 000b06e0 ebx = 08800800 ecx = 7ffafbbf edx = bfebfbff
eax in: 0x00000002, eax = 00feff01 ebx = 000000f0 ecx = 00000000 edx = 00000000
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000004, eax = fc004121 ebx = 01c0003f ecx = 0000003f edx = 00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000003 edx = 10102020
eax in: 0x00000006, eax = 00578ff7 ebx = 00000002 ecx = 00000009 edx = 00000000
eax in: 0x00000007, eax = 00000002 ebx = 239ca7eb ecx = 98c007bc edx = fc184410
eax in: 0x00000008, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000009, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000a, eax = 07300605 ebx = 00000000 ecx = 00000007 edx = 00008603
eax in: 0x0000000b, eax = 00000001 ebx = 00000001 ecx = 00000100 edx = 00000008
eax in: 0x0000000c, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000d, eax = 00000207 ebx = 00000a88 ecx = 00000a88 edx = 00000000
eax in: 0x0000000e, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000f, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000010, eax = 00000000 ebx = 00000004 ecx = 00000000 edx = 00000000
eax in: 0x00000011, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000012, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000013, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000014, eax = 00000001 ebx = 000001ff ecx = 80000007 edx = 00000000
eax in: 0x00000015, eax = 00000002 ebx = 0000002a ecx = 0249f000 edx = 00000000
eax in: 0x00000016, eax = 00000320 ebx = 00000d48 ecx = 00000064 edx = 00000000
eax in: 0x00000017, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000018, eax = 00000004 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000019, eax = 00000007 ebx = 00000014 ecx = 00000003 edx = 00000000
eax in: 0x0000001a, eax = 20000001 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001b, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001c, eax = c000000b ebx = 00000007 ecx = 00000007 edx = 00000000
eax in: 0x0000001d, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001e, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001f, eax = 00000001 ebx = 00000001 ecx = 00000100 edx = 00000008
eax in: 0x00000020, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000121 edx = 2c100800
eax in: 0x80000002, eax = 65746e49 ebx = 2952286c ecx = 30314e20 edx = 00000030
eax in: 0x80000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000004, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08008040 edx = 00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000100
eax in: 0x80000008, eax = 00003027 ebx = 00000000 ecx = 00000000 edx = 00000000

Cache info
 L1 Data Cache: 32KB, 8-way associative, 64 byte line size
 L1 Instruction Cache: 64KB, 8-way associative, 64 byte line size
 L2 Unified Cache: 2048KB, 16-way associative, 64 byte line size
 L3 Unified Cache: 6144KB, 12-way associative, 64 byte line size
TLB info
 64 byte prefetching.
Found unknown cache descriptors: fe
Feature flags:
 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflsh ds acpi mmx fxsr sse sse2 ss ht tm pbe sse3 pclmuldq dtes64 monitor ds-cpl vmx est tm2 ssse3 sdbg fma cx16 xTPR pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc-deadline aes xsave osxsave avx f16c rdrnd
Extended feature flags:
 SYSCALL xd pdpe1gb rdtscp em64t lahf_lm lzcnt prefetchw dts ida arat pln ecmd ptm hwp hwp_notify hwp_act_window hwp_epp hwp_lpr [6:eax:15] [6:eax:16] [6:eax:17] [6:eax:18] [6:eax:20] [6:eax:22] fsgsbase tsc_adj bmi1 avx2 fdp_excp smep bmi2 erms invpcid nofpucs pqe rdseed adx smap clflushopt clwb ipt sha nonstop_tsc
Long NOPs supported: yes

MTRR registers:
MTRRcap (0xfe): 0x0000000000005d0a wc:1 fix:1 vcnt:10
MTRRphysBase0 (0x200): 0x0000000000000006 (physbase:0x000000 type: 0x06 (write-back))
MTRRphysMask0 (0x201): 0x0000007800000800 (physmask:0x800000 valid:1)
MTRRphysBase1 (0x202): 0x000000007c000000 (physbase:0x07c000 type: 0x00 (uncacheable))
MTRRphysMask1 (0x203): 0x0000007ffc000800 (physmask:0xffc000 valid:1)
MTRRphysBase2 (0x204): 0x0000000080000000 (physbase:0x080000 type: 0x00 (uncacheable))
MTRRphysMask2 (0x205): 0x0000007f80000800 (physmask:0xf80000 valid:1)
MTRRphysBase3 (0x206): 0x000000047fc00000 (physbase:0x47fc00 type: 0x00 (uncacheable))
MTRRphysMask3 (0x207): 0x0000007fffc00800 (physmask:0xfffc00 valid:1)
MTRRphysBase4 (0x208): 0x0000000480000000 (physbase:0x480000 type: 0x00 (uncacheable))
MTRRphysMask4 (0x209): 0x0000007ffe000800 (physmask:0xffe000 valid:1)
MTRRphysBase5 (0x20a): 0x0000000482000000 (physbase:0x482000 type: 0x00 (uncacheable))
MTRRphysMask5 (0x20b): 0x0000007fff000800 (physmask:0xfff000 valid:1)
MTRRphysBase6 (0x20c): 0x0000000483000000 (physbase:0x483000 type: 0x00 (uncacheable))
MTRRphysMask6 (0x20d): 0x0000007fff800800 (physmask:0xfff800 valid:1)
MTRRphysBase7 (0x20e): 0x0000000483800000 (physbase:0x483800 type: 0x00 (uncacheable))
MTRRphysMask7 (0x20f): 0x0000007fffc00800 (physmask:0xfffc00 valid:1)
MTRRfix64K_00000 (0x250): 0x0606060606060606
MTRRfix16K_80000 (0x258): 0x0606060606060606
MTRRfix16K_A0000 (0x259): 0x0000000000000000
MTRRfix4K_C8000 (0x269): 0x0505050505050505
MTRRfix4K_D0000 0x26a: 0x0505050505050505
MTRRfix4K_D8000 0x26b: 0x0505050505050505
MTRRfix4K_E0000 0x26c: 0x0505050505050505
MTRRfix4K_E8000 0x26d: 0x0505050505050505
MTRRfix4K_F0000 0x26e: 0x0505050505050505
MTRRfix4K_F8000 0x26f: 0x0505050505050505
MTRRdefType (0x2ff): 0x0000000000000c00 (fixed-range flag:1 enable flag:1 default type:0x00 (uncacheable))

APIC registers:
APIC MSR Base(0x1b):                    : 0x00000000fee00d00
APIC Local ID                           : 0xffffffff
APIC Local Version                      : 0xffffffff
APIC Task Priority                      : 0xffffffff
APIC Arbitration Priority               : 0xffffffff
APIC Processor Priority                 : 0xffffffff
APIC EOI                                : 0xffffffff
APIC Remote Read                        : 0xffffffff
APIC Logical Destination                : 0xffffffff
APIC Destination Format                 : 0xffffffff
APIC Spurious Interrupt Vector          : 0xffffffff
APIC In-Service (ISR0)                  : 0xffffffff
APIC In-Service (ISR1)                  : 0xffffffff
APIC In-Service (ISR2)                  : 0xffffffff
APIC In-Service (ISR3)                  : 0xffffffff
APIC In-Service (ISR4)                  : 0xffffffff
APIC In-Service (ISR5)                  : 0xffffffff
APIC In-Service (ISR6)                  : 0xffffffff
APIC In-Service (ISR7)                  : 0xffffffff
APIC Trigger Mode (TMR0)                : 0xffffffff
APIC Trigger Mode (TMR1)                : 0xffffffff
APIC Trigger Mode (TMR2)                : 0xffffffff
APIC Trigger Mode (TMR3)                : 0xffffffff
APIC Trigger Mode (TMR4)                : 0xffffffff
APIC Trigger Mode (TMR5)                : 0xffffffff
APIC Trigger Mode (TMR6)                : 0xffffffff
APIC Trigger Mode (TMR7)                : 0xffffffff
APIC Interrupt Request (IRR00)          : 0xffffffff
APIC Interrupt Request (IRR01)          : 0xffffffff
APIC Interrupt Request (IRR02)          : 0xffffffff
APIC Interrupt Request (IRR03)          : 0xffffffff
APIC Interrupt Request (IRR04)          : 0xffffffff
APIC Interrupt Request (IRR05)          : 0xffffffff
APIC Interrupt Request (IRR06)          : 0xffffffff
APIC Interrupt Request (IRR07)          : 0xffffffff
APIC Error Status                       : 0xffffffff
APIC LVT CMCI                           : 0xffffffff
APIC Interrupt Command (ICR0)           : 0xffffffff
APIC Interrupt Command (ICR1)           : 0xffffffff
APIC LVT Timer                          : 0xffffffff
APIC Thermal Sensor                     : 0xffffffff
APIC LVT Performance Monitoring Counters: 0xffffffff
APIC LVT LINT0                          : 0xffffffff
APIC LVT LINT1                          : 0xffffffff
APIC LVT Error                          : 0xffffffff
APIC Initial Count (for Timer)          : 0xffffffff
APIC Current Count (for Timer)          : 0xffffffff
APIC Divide Configuration (for Timer)   : 0xffffffff

Address sizes : 39 bits physical, 48 bits virtual
800MHz processor (estimate).

Total processor threads: 4
This system has 1 dual-core processor with hyper-threading (2 threads per core) running at an estimated 800MHz

Sollte ich dies nun trotzdem noch ausführen?

Code: [Select]

cd /usr/local/share/cpucontrol
curl -A nice -o 06-be-00.12 https://www.congenio.de/infos/06-be-00.12
reboot

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 11, 2023, 03:58:57 pm »

HUNSN habe ich diesbezüglich schon geschrieben.
Aber ja, sollte es keine Lösung geben kommt die Rückgabe.

Ausgabe von x86info -a

Code: [Select]

x86info v1.31pre
Found 4 identical CPUs
Extended Family: 0 Extended Model: 11 Family: 6 Model: 190 Stepping: 0
Type: 0 (Original OEM)
CPU Model (x86info's best guess): Unknown model.

Performance msrs:
  MSR_IA32_PERF_STATUS: 0x21e500001d00
  MSR_IA32_MISC_ENABLE: 0x850089 [Enabled: TCC PerfMon EnhancedSpeedStep ]

Thermal msrs:
  MSR_PM_THERM2_CTL: 0x0 [Thermal monitor: 1]
  MSR_IA32_THERM_CONTROL: 0x0 [Software-controlled clock disabled (full speed)]
  MSR_IA32_THERM_STATUS: 0x88350000

Machine check MSRs:
Number of reporting banks : 20
Bank: 0 (0x400)
MC0CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000001 11011110
MC0STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC0ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 1 (0x404)
MC1CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000001
MC1STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC1ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 2 (0x408)
MC2CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC2STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC2ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 3 (0x40c)
MC3CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000011
MC3STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC3ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 4 (0x410)
MC4CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC4STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC4ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 5 (0x414)
MC5CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC5STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC5ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 6 (0x418)
MC6CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 11111111
MC6STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC6ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 7 (0x41c)
MC7CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00111111
MC7STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC7ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 8 (0x420)
MC8CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC8STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC8ADDR:   00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
Bank: 9 (0x424)
MC9CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000111 11111111
MC9STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC9ADDR:   00000000 00000000 00000000 00000000
           11111110 11110001 10101101 11000000
Bank: 10 (0x428)
MC10CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000111 11111111
MC10STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC10ADDR:   00000000 00000000 00000000 00000000
           11111110 11110001 10101101 10000000
Bank: 11 (0x42c)
MC11CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC11STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC11ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 12 (0x430)
MC12CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC12STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC12ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 13 (0x434)
MC13CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC13STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC13ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 14 (0x438)
MC14CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC14STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC14ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 15 (0x43c)
MC15CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC15STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC15ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 16 (0x440)
MC16CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC16STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC16ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 17 (0x444)
MC17CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC17STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC17ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 18 (0x448)
MC18CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC18STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC18ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111
Bank: 19 (0x44c)
MC19CTL:    00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC19STATUS: 00000000 00000000 00000000 00000000
           00000000 00000000 00000000 00000000
MC19ADDR:   11111111 11111111 11111111 11111111
           11111111 11111111 11111111 11111111

Microcode version: 0x0000000000000011

eax in: 0x00000000, eax = 00000020 ebx = 756e6547 ecx = 6c65746e edx = 49656e69
eax in: 0x00000001, eax = 000b06e0 ebx = 08800800 ecx = 7ffafbbf edx = bfebfbff
eax in: 0x00000002, eax = 00feff01 ebx = 000000f0 ecx = 00000000 edx = 00000000
eax in: 0x00000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000004, eax = fc004121 ebx = 01c0003f ecx = 0000003f edx = 00000000
eax in: 0x00000005, eax = 00000040 ebx = 00000040 ecx = 00000003 edx = 10102020
eax in: 0x00000006, eax = 00578ff7 ebx = 00000002 ecx = 00000009 edx = 00000000
eax in: 0x00000007, eax = 00000002 ebx = 239ca7eb ecx = 98c007bc edx = fc184410
eax in: 0x00000008, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000009, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000a, eax = 07300605 ebx = 00000000 ecx = 00000007 edx = 00008603
eax in: 0x0000000b, eax = 00000001 ebx = 00000001 ecx = 00000100 edx = 00000008
eax in: 0x0000000c, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000d, eax = 00000207 ebx = 00000a88 ecx = 00000a88 edx = 00000000
eax in: 0x0000000e, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000000f, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000010, eax = 00000000 ebx = 00000004 ecx = 00000000 edx = 00000000
eax in: 0x00000011, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000012, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000013, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000014, eax = 00000001 ebx = 000001ff ecx = 80000007 edx = 00000000
eax in: 0x00000015, eax = 00000002 ebx = 0000002a ecx = 0249f000 edx = 00000000
eax in: 0x00000016, eax = 00000320 ebx = 00000d48 ecx = 00000064 edx = 00000000
eax in: 0x00000017, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000018, eax = 00000004 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x00000019, eax = 00000007 ebx = 00000014 ecx = 00000003 edx = 00000000
eax in: 0x0000001a, eax = 20000001 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001b, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001c, eax = c000000b ebx = 00000007 ecx = 00000007 edx = 00000000
eax in: 0x0000001d, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001e, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x0000001f, eax = 00000001 ebx = 00000001 ecx = 00000100 edx = 00000008
eax in: 0x00000020, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000

eax in: 0x80000000, eax = 80000008 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000001, eax = 00000000 ebx = 00000000 ecx = 00000121 edx = 2c100800
eax in: 0x80000002, eax = 65746e49 ebx = 2952286c ecx = 30314e20 edx = 00000030
eax in: 0x80000003, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000004, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000005, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000000
eax in: 0x80000006, eax = 00000000 ebx = 00000000 ecx = 08008040 edx = 00000000
eax in: 0x80000007, eax = 00000000 ebx = 00000000 ecx = 00000000 edx = 00000100
eax in: 0x80000008, eax = 00003027 ebx = 00000000 ecx = 00000000 edx = 00000000

Cache info
 L1 Data Cache: 32KB, 8-way associative, 64 byte line size
 L1 Instruction Cache: 64KB, 8-way associative, 64 byte line size
 L2 Unified Cache: 2048KB, 16-way associative, 64 byte line size
 L3 Unified Cache: 6144KB, 12-way associative, 64 byte line size
TLB info
 64 byte prefetching.
Found unknown cache descriptors: fe
Feature flags:
 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflsh                                                   ds acpi mmx fxsr sse sse2 ss ht tm pbe sse3 pclmuldq dtes64 monitor ds-cpl vmx e                                                  st tm2 ssse3 sdbg fma cx16 xTPR pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc-                                                  deadline aes xsave osxsave avx f16c rdrnd
Extended feature flags:
 SYSCALL xd pdpe1gb rdtscp em64t lahf_lm lzcnt prefetchw dts ida arat pln ecmd p                                                  tm hwp hwp_notify hwp_act_window hwp_epp hwp_lpr [6:eax:15] [6:eax:16] [6:eax:17                                                  ] [6:eax:18] [6:eax:20] [6:eax:22] fsgsbase tsc_adj bmi1 avx2 fdp_excp smep bmi2                                                   erms invpcid nofpucs pqe rdseed adx smap clflushopt clwb ipt sha nonstop_tsc
Long NOPs supported: yes

MTRR registers:
MTRRcap (0xfe): 0x0000000000005d0a wc:1 fix:1 vcnt:10
MTRRphysBase0 (0x200): 0x0000000000000006 (physbase:0x000000 type: 0x06 (write-b                                                  ack))
MTRRphysMask0 (0x201): 0x0000007800000800 (physmask:0x800000 valid:1)
MTRRphysBase1 (0x202): 0x000000007c000000 (physbase:0x07c000 type: 0x00 (uncache                                                  able))
MTRRphysMask1 (0x203): 0x0000007ffc000800 (physmask:0xffc000 valid:1)
MTRRphysBase2 (0x204): 0x0000000080000000 (physbase:0x080000 type: 0x00 (uncache                                                  able))
MTRRphysMask2 (0x205): 0x0000007f80000800 (physmask:0xf80000 valid:1)
MTRRphysBase3 (0x206): 0x000000047fc00000 (physbase:0x47fc00 type: 0x00 (uncache                                                  able))
MTRRphysMask3 (0x207): 0x0000007fffc00800 (physmask:0xfffc00 valid:1)
MTRRphysBase4 (0x208): 0x0000000480000000 (physbase:0x480000 type: 0x00 (uncache                                                  able))
MTRRphysMask4 (0x209): 0x0000007ffe000800 (physmask:0xffe000 valid:1)
MTRRphysBase5 (0x20a): 0x0000000482000000 (physbase:0x482000 type: 0x00 (uncache                                                  able))
MTRRphysMask5 (0x20b): 0x0000007fff000800 (physmask:0xfff000 valid:1)
MTRRphysBase6 (0x20c): 0x0000000483000000 (physbase:0x483000 type: 0x00 (uncache                                                  able))
MTRRphysMask6 (0x20d): 0x0000007fff800800 (physmask:0xfff800 valid:1)
MTRRphysBase7 (0x20e): 0x0000000483800000 (physbase:0x483800 type: 0x00 (uncache                                                  able))
MTRRphysMask7 (0x20f): 0x0000007fffc00800 (physmask:0xfffc00 valid:1)
MTRRfix64K_00000 (0x250): 0x0606060606060606
MTRRfix16K_80000 (0x258): 0x0606060606060606
MTRRfix16K_A0000 (0x259): 0x0000000000000000
MTRRfix4K_C8000 (0x269): 0x0505050505050505
MTRRfix4K_D0000 0x26a: 0x0505050505050505
MTRRfix4K_D8000 0x26b: 0x0505050505050505
MTRRfix4K_E0000 0x26c: 0x0505050505050505
MTRRfix4K_E8000 0x26d: 0x0505050505050505
MTRRfix4K_F0000 0x26e: 0x0505050505050505
MTRRfix4K_F8000 0x26f: 0x0505050505050505
MTRRdefType (0x2ff): 0x0000000000000c00 (fixed-range flag:1 enable flag:1 defaul                                                  t type:0x00 (uncacheable))

APIC registers:
APIC MSR Base(0x1b):                    : 0x00000000fee00d00
APIC Local ID                           : 0xffffffff
APIC Local Version                      : 0xffffffff
APIC Task Priority                      : 0xffffffff
APIC Arbitration Priority               : 0xffffffff
APIC Processor Priority                 : 0xffffffff
APIC EOI                                : 0xffffffff
APIC Remote Read                        : 0xffffffff
APIC Logical Destination                : 0xffffffff
APIC Destination Format                 : 0xffffffff
APIC Spurious Interrupt Vector          : 0xffffffff
APIC In-Service (ISR0)                  : 0xffffffff
APIC In-Service (ISR1)                  : 0xffffffff
APIC In-Service (ISR2)                  : 0xffffffff
APIC In-Service (ISR3)                  : 0xffffffff
APIC In-Service (ISR4)                  : 0xffffffff
APIC In-Service (ISR5)                  : 0xffffffff
APIC In-Service (ISR6)                  : 0xffffffff
APIC In-Service (ISR7)                  : 0xffffffff
APIC Trigger Mode (TMR0)                : 0xffffffff
APIC Trigger Mode (TMR1)                : 0xffffffff
APIC Trigger Mode (TMR2)                : 0xffffffff
APIC Trigger Mode (TMR3)                : 0xffffffff
APIC Trigger Mode (TMR4)                : 0xffffffff
APIC Trigger Mode (TMR5)                : 0xffffffff
APIC Trigger Mode (TMR6)                : 0xffffffff
APIC Trigger Mode (TMR7)                : 0xffffffff
APIC Interrupt Request (IRR00)          : 0xffffffff
APIC Interrupt Request (IRR01)          : 0xffffffff
APIC Interrupt Request (IRR02)          : 0xffffffff
APIC Interrupt Request (IRR03)          : 0xffffffff
APIC Interrupt Request (IRR04)          : 0xffffffff
APIC Interrupt Request (IRR05)          : 0xffffffff
APIC Interrupt Request (IRR06)          : 0xffffffff
APIC Interrupt Request (IRR07)          : 0xffffffff
APIC Error Status                       : 0xffffffff
APIC LVT CMCI                           : 0xffffffff
APIC Interrupt Command (ICR0)           : 0xffffffff
APIC Interrupt Command (ICR1)           : 0xffffffff
APIC LVT Timer                          : 0xffffffff
APIC Thermal Sensor                     : 0xffffffff
APIC LVT Performance Monitoring Counters: 0xffffffff
APIC LVT LINT0                          : 0xffffffff
APIC LVT LINT1                          : 0xffffffff
APIC LVT Error                          : 0xffffffff
APIC Initial Count (for Timer)          : 0xffffffff
APIC Current Count (for Timer)          : 0xffffffff
APIC Divide Configuration (for Timer)   : 0xffffffff

Address sizes : 39 bits physical, 48 bits virtual
800MHz processor (estimate).

Total processor threads: 4
This system has 1 dual-core processor with hyper-threading (2 threads per core)                                                   running at an estimated 800MHz

Hab deine BIN Datei mal versucht, aber leider bleibt der MicroCode weiterhin bei 0x0000000000000011

Code: [Select]

root@OPNsense:~ # cd /boot/firmware
root@OPNsense:/boot/firmware # mv intel-ucode.bin intel-ucode.bin.bak
root@OPNsense:/boot/firmware # curl -A nice -o intel-ucode.bin https://www.congenio.de/infos/intel-ucode.bin
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 13.5M  100 13.5M    0     0  5703k      0  0:00:02  0:00:02 --:--:-- 5704k
root@OPNsense:/boot/firmware # ls
intel-ucode.bin         intel-ucode.bin.bak
root@OPNsense:/boot/firmware # reboot

root@OPNsense:~ # kldload -q cpuctl
root@OPNsense:~ # x86info -a | fgrep -i microcode
Microcode version: 0x0000000000000011

Kannst du eventuell andere Hardware empfehlen die im Preissegment von dem HUNSN RJ36 liegt und wo die pflege von BIOS Dateien besser ist?

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 11, 2023, 10:07:34 am »

Danke für die vielen Infos!

Aber beim Bauen einer solchen Datei reichen dann meine bescheidenen Linux Kenntnisse doch nicht mehr aus.
Da kann ich nur hoffen, dass die Datei schnell für cpu-microcode bereitgestellt wird.

Frage zu deiner Anleitung, updated sich damit der MicroCode von selbst oder muss ich von Zeit zu Zeit selbst mit service microcode_update den Prozess anstoßen?

Ein Plugin innerhalb von OPNsense für diesen ganzen Prozess wäre natürlich die goldene Krone.

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 10, 2023, 09:55:46 pm »

Ich habe nun mal deine Anleitung befolgt.
Er hat ein Microcode Update von 0x000000000000000c auf 0x0000000000000011 durchgeführt:

Jetzt hoffe ich mal das die Kiste stabiler läuft.

German - Deutsch / Re: HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 10, 2023, 05:46:32 pm »

Danke für deine Antwort.

Heißt also ich Versuch mich wieder an einer Neuinstallation und führe dann deine Anleitung im angegeben Beitrag zwecks MicroCode Update aus.
MicroCodes sind wie ich kenne nicht dauerhaft, heißt wenn ich eine Neuinstallation durchführen würde, müsste ich das mit den MicroCode Update wiederholen?

Kommen neue MicroCode Updates auch mit OPNsense bzw. FreeBSD automatisch?

Danke und Grüße

German - Deutsch / HUNSN - Mini PC mit Alder Lake N100 - Vermutlich Speicherprobleme - Lösungen?

« on: November 10, 2023, 03:55:44 pm »

Hallo zusammen,

ich habe mir folgende Hardware mit Alder Lake N100 angeschafft.
https://www.amazon.de/Firewall-Appliance-Mikrotik-OPNsense-HUNSN-N100/dp/B0BZJDNB4P

Zuerst habe ich mein Problem auf die NVMe SSD geschoben. Aber auch mit einer zweiten nagelneuen NVMe habe ich so wie es für mich darstellt Speicherprobleme.

Ich bin dann bei FreeBSD in Zusammengang mit der N100 CPU auf einen BUG Fix mit Version 13.2 gestoßen:

Quote

A workaround has been implemented for a hardware page invalidation problem on Intel Alder Lake (twelfth generation) and Raptor Lake (thirteenth generation) hybrid CPUs. The bug can lead to file system corruption with UFS and MSDOSFS, and probably other memory corruption. The slower cores (E-cores) automatically use a slower method of page invalidation with the workaround. 567cc4e6bfd9 (Sponsored by The FreeBSD Foundation)

Da ich aber die neuste OPNsense 23.7 bzw. 23.7.8 installiert habe, denke ich dass diese den Bugfix enthält.
Oder liege ich hier falsch bzw. ist es womöglich ein anderes Problem?

Hier mal noch ein Video wie das ganze bei mir aussieht, z.B. nach einer Plugininstalltion oder auch nach einem Update: https://1drv.ms/v/s!AmqTVPy5Rp9T9GhGiljH31nMej83?e=HooGsD

Hat jemand ebenfalls einen Alder Lake N100 am Laufen?
Hilft vielleicht eine bestimmte Bios Einstellung?

Danke und Grüße

German - Deutsch / Hilfe zu: sqlite - database disk image is malformed

« on: October 19, 2023, 09:33:04 pm »

Hallo zusammen,

ich habe hier ein OPNSense mit Version 23.7 am laufen.
Ich kann keine Update mehr installieren, es kommt folgende Fehlermeldung:

Code: [Select]

***GOT REQUEST TO CHECK FOR UPDATES***
Currently running OPNsense 23.7 at Thu Oct 19 21:22:47 CEST 2023
Fetching changelog information, please wait... done
Updating OPNsense repository catalogue...
Fetching meta.conf: . done
Fetching packagesite.pkg: .......... done
Processing entries: .......... done
OPNsense repository update completed. 853 packages processed.
All repositories are up to date.
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Checking integrity... done (0 conflicting)
Your packages are up to date.
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
Checking for upgrades (1 candidates): . done
Processing candidates (1 candidates): . done
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 159  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'openssl' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'openssl' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 127  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'python39' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'python39' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-setuptools' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-setuptools' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 149  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 49  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 49  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 149  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 38  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 38  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 127  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 22  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 22  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 43  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 43  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
pkg: sqlite error while executing SELECT DISTINCT d.name, d.origin, p.version, 0  FROM deps AS d    LEFT JOIN packages AS p ON    (p.origin = d.origin AND p.name = d.name)  WHERE d.package_id = 159  ORDER BY d.origin DESC in file pkgdb_iterator.c:274: database disk image is malformed
pkg: sqlite error while executing END TRANSACTION; in file pkgdb.c:2333: database disk image is malformed
Checking integrity...pkg: sqlite error while executing SELECT p.name, p.origin, p.version, 0  FROM packages AS p    INNER JOIN deps AS d ON (p.id = d.package_id)  WHERE d.name = 'py39-numpy' in file pkgdb_iterator.c:412: database disk image is malformed
Assertion failed: (p != NULL), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 313.
Child process pid=46138 terminated abnormally: Abort trap
***DONE***

Der sqlite .SELFTEST spuckt mir folgendes aus:

Code: [Select]

root@OPNsense:~ # sqlite3 /var/db/pkg/local.sqlite
SQLite version 3.42.0 2023-05-16 12:36:15
Enter ".help" for usage hints.
sqlite> .selftest
Missing SELFTEST table - default checks only
1: error-code-1: database disk image is malformed
1 errors out of 1 tests

Ein .REINDEX hat leider nichts gebracht.

Code: [Select]

sqlite> REINDEX;
Runtime error: database disk image is malformed (11)

Code: [Select]

Version 23.7 is correct.
>>> Check for missing or altered base files
No problems detected.
>>> Check installed repositories
OPNsense
>>> Check installed plugins
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check locked packages
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for missing package dependencies
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages: 
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages... done
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for missing or altered package files
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages: 
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1183: database disk image is malformed
Checking all packages... done
pkg: sqlite error while executing iterator in file pkgdb_iterator.c:1110: database disk image is malformed
>>> Check for core packages consistency
Core package "opnsense" not known to package database.
***DONE***

Jetzt nun die Frage, hat jemand eine Idee wie ich dieses Problem beheben kann?
Liegt dies an einer defekten Festplatte/SSD ?

Danke und Grüße

German - Deutsch / Re: OPNsense bombardiert Digitalisierungsbox mit NAT Anfragen

« on: February 22, 2019, 07:23:56 pm »

Quote from: fabian on February 22, 2019, 05:59:07 pm

rspamd arbeitet ansonsten auch viel über DNS (DNSBL)

Dieses Plugin ist auch nicht installiert.

Könnte es evenetuell am Unbound DNS liegen?
Sollte ich mal Dnsmasq DNS versuchen?

German - Deutsch / Re: OPNsense bombardiert Digitalisierungsbox mit NAT Anfragen

« on: February 22, 2019, 07:16:33 am »

Quote from: mike69 on February 21, 2019, 12:25:11 pm

Naja, IPv6 möchte auch den Namen aufgelöst haben, daher die Zugriffe. Warum so viel/oft bin ich überfragt.

Mit "Allow DNS server list to be overridden by DHCP/PPP on WAN" nutzt Du die DNS-Server des ISP, also Telekom, genau die gleichen, wenn Du die Digi-Box als DNS-Server in der Sense einsetzt und den Haken unter "Allow DNS server list to be overridden by DHCP/PPP on WAN" entfernst.

Du könntest mal den Haken entfernt lassen und, je nachdem wie deine Paranoia ausgeprägt ist, unter der Sense alternative DNS-Server eintragen. Dann kümmert sich die Sense um die Auflösung, dei Digi-Box schleust nur durch. Eventuell wird es besser.

Paranoia hab ich keine, verwende öfters die 4x 8.

Wenn ich einen DNS eintrage, muss ich dann hinten bei Gateway die WAN Schnittstelle oder die LAN Schnittstelle auswählen oder alles auf "None" lassen?

Quote from: fabian on February 21, 2019, 10:36:02 pm

Meine Vermutung: Firewall -> Alias

Wenn du hier externe Listen verwendest, müssen Hostnamen aufgelöst werden.

Es sind dort keine Aliase gepflegt. Davon kann es nicht kommen.

German - Deutsch / Re: OPNsense bombardiert Digitalisierungsbox mit NAT Anfragen

« on: February 21, 2019, 08:22:24 am »

Hi Mike,

danke für den Tipp.
Bevor ich diesen aber nun umgesetzt habe, habe ich auf dem WAN Interface IPv6 deaktiviert.
Sofort gingen dabei dann auf der DigiBox die aktiven Verbindungen von 4000 auf ca. 400 - 600 (schwankend) runter.

Nun würde mich interessieren wieso dies passiert. Liegt hier vielleicht ein Bug vor?

Noch ein paar Verständisfragen:

1) sollte ich unter System > Settings > General trotzdem bei DNS die IP Adresse der Digibox eingeben?
Muss ich dann hinten bei "Use gateway" das WAN Interface auswählen oder auf "none" belassen?

2) sollte die Option "Allow DNS server list to be overridden by DHCP/PPP on WAN" deaktiviert werden?

3) Da ja die DigiBox sich ins Internet einwählt und somit das ganze managed.
Stellt sich mir nun die Frage: ob ich auf der OPNsense den Service "Unbound DNS" deaktivieren soll?

Grüße
Andreas

German - Deutsch / Re: OPNsense bombardiert Digitalisierungsbox mit NAT Anfragen

« on: February 20, 2019, 09:25:04 pm »

Hi Fabian,

nee mit dem Abbruch der Telefonie hat dies nichts zu tun.
Wollte damit nur sagen, dass durch die vielen DNS Anfragen die Digibox überlastet wird und deshalb die Telefonie ins stottern kommt.

Grüße
Andreas

German - Deutsch / OPNsense bombardiert Digitalisierungsbox mit NAT Anfragen

« on: February 20, 2019, 06:11:32 pm »

Hallo zusammen,

folgender Aufbau liegt vor.

Internet <-> Digitalisierungsbox Premium <-> OPNsense <-> Netzwerk (Switch, APs)

OPNsense Version 19.1.1

Die Digitalisierungsbox (DigiBox) wird seitens der OPNsense mit mehrere NAT Anfragen bombardiert.
In der Übersicht der DigiBox steht bei „Aktive Sitzungen (SIF, RTP, etc... ) ein Wert von 4000.
Dies ist das maximum dieser Box. Somit brechen nun auch dauernd der SIP-Trunk seitens Telekom zusammen.

Folgendes findet sich in der LOG Datei der DigiBox:

Die 192.168.3.101 ist die OPNsense.

Die Anfragen kommen selbst wenn ich das Netzwerkkabel der OPNsense zum Netzwerk abziehe, somit kommen diese Anfragen allein von der OPNsense.
Ziehe ich das Kabel der OPNsense zur DigiBox ab, so bauen sich die Verbindungen ebenfalls ab.

Da ich hier selbst aber nun zu wenig Ahnung habe was hier falsch sein könnte, bin ich nun auf eure Hilfe angewiesen.

Grüße
Andreas

German - Deutsch / Re: VLAN Konfiguration

« on: October 13, 2017, 09:28:52 pm »

Ouh, jetzt versteh ich.
Hab das Problem gelöst wie ich z.B. aus dem VLAN_Privat die OPNsense erreiche.

Stichwort Firewall Regel, erstmal zum Testen alles offen.

Folgendest steh nun in meiner Testumgebung:

VLAN_Gast
VLAN_Privat
VLAN_Management

DHCP auf VLAN_Gast und VLAN_Privat.
Internet funktioniert auf allen VLANs.

Durch die "Alles offen Regel" kann ich natürlich von jedem Netz in die anderen Netze pingen.

Anbei einen Screenshot der Firewallregel unter LAN_GAST.
Hier wollte ich den Zugriff von LAN_Gast auf LAN_Privat blocken.

Aber ich kann weiterhin vom LAN_Gast auf LAN_Privat pingen.
Wo liegt hier noch der Fehler?

Ich denk mal wenn ich das nun verstehe, hab ich alle Puzzleteile zusammen.

EDIT oh man peinlich. Netze durcheinander gebracht. Nun funktioniert auch das Regelwerk

Pages: [1] 2 3 ... 6