cant update via gui/cli

[nines]

unfortunately I cant update my installation anymore. 

opnsense-update gives me:

opnsense-update
Updating OPNsense repository catalogue...
pkg-static: Repository OPNsense load error: access repo file(/var/db/pkg/repo-OPNsense.sqlite) failed: No such file or directory

and update via gui gives my a timeout.

This is definetely not a dns issue!

Thanks for helping me out

[franco]

Can you do these three commands and provide the output?

# pkg info | wc -l
# pkg update -f
# pkg upgrade -n


Thanks,
Franco

[nines]

Code: [Select]

root@OPNsense:/home/shelladmin # pkg info | wc -l
     145
root@OPNsense:/home/shelladmin # pkg update -f
Updating OPNsense repository catalogue...
pkg: Repository OPNsense load error: access repo file(/var/db/pkg/repo-OPNsense.sqlite) failed: No such file or directory
^C <- never finishes
root@OPNsense:/home/shelladmin # pkg upgrade -n
Updating OPNsense repository catalogue...
pkg: Repository OPNsense load error: access repo file(/var/db/pkg/repo-OPNsense.sqlite) failed: No such file or directory
^C <- never finishes

Thanks
André

[franco]

Hi André,

Can't see what's going on just yet, next try with more debug output:

# pkg -d update -f


Cheers,
Franco

[nines]

Hi Franco

here we go:

pkg -d update -f
DBG(1)[9773]> pkg initialized
Updating OPNsense repository catalogue...
DBG(1)[9773]> PkgRepo: verifying update for OPNsense
pkg: Repository OPNsense load error: access repo file(/var/db/pkg/repo-OPNsense.sqlite) failed: No such file or                                                                                                    directory
DBG(1)[9773]> PkgRepo: need forced update of OPNsense
DBG(1)[9773]> Pkgrepo, begin update of '/var/db/pkg/repo-OPNsense.sqlite'
DBG(1)[9773]> Fetch: fetching from: http://pkg.opnsense.org/FreeBSD:11:amd64/18.1/libressl/meta.txz with opts "i                                                                                                   "

I can downlad the mentioned meta.txz file using another mashine in the same lan (e.g. using the same router/fw/dns

[franco]

Looks like an IPv6 setup issue.

Try these two...

# ping6 pkg.opnsense.org

# ping pkg.opnsense.org


Cheers,
Franco

[nines]

Code: [Select]

root@OPNsense:/home/shelladmin # ping6 pkg.opnsense.org
ping6: UDP connect: No route to host
root@OPNsense:/home/shelladmin # ping pkg.opnsense.org
PING pkg.opnsense.org (212.32.245.132): 56 data bytes
64 bytes from 212.32.245.132: icmp_seq=0 ttl=54 time=42.443 ms
64 bytes from 212.32.245.132: icmp_seq=1 ttl=54 time=33.263 ms
64 bytes from 212.32.245.132: icmp_seq=2 ttl=54 time=33.601 ms
^C
--- pkg.opnsense.org ping statistics ---
3 packets transmitted, 3 packets received, 0.0% packet loss
round-trip min/avg/max/stddev = 33.263/36.436/42.443/4.250 ms

in case you are interested

root@OPNsense:/home/shelladmin # ifconfig
vmx0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> metric 0 mtu 1500
        options=60009b<RXCSUM,TXCSUM,VLAN_MTU,VLAN_HWTAGGING,VLAN_HWCSUM,RXCSUM_IPV6,TXCSUM_IPV6>
        ether 00:0c:29:32:22:e3
        hwaddr 00:0c:29:32:22:e3
        inet 192.168.100.253 netmask 0xffffff00 broadcast 192.168.100.255
        inet6 fe80::20c:29ff:fe32:22e3%vmx0 prefixlen 64 scopeid 0x1
        nd6 options=21<PERFORMNUD,AUTO_LINKLOCAL>
        media: Ethernet autoselect
        status: active


[franco]

Yes, go to Interfaces: [WAN], set IPv6 to "none", save and apply.

That should fix it.


Cheers,
Franco

[nines]

It's already set to "none" on all interaces :/

[franco]

Oh, okay, then set "Prefer IPv4 over IPv6" in System: Settings: General.


Cheers,
Franco

[nines]

already set too! Doesnt make a difference

[franco]

Something is definitely off here...

# fetch -v http://pkg.opnsense.org/FreeBSD:11:amd64/18.1/libressl/meta.txz

What does this print?

[nines]

interesting:

Code: [Select]

root@OPNsense:/tmp # fetch -v http://pkg.opnsense.org/FreeBSD:11:amd64/18.1/libressl/meta.txz
resolving server address: pkg.opnsense.org:80
^Cfailed to connect to pkg.opnsense.org:80
fetch: transfer interrupted

<- never replies with an ip


root@OPNsense:/tmp # ping pkg.opnsense.org
PING pkg.opnsense.org (212.32.245.132): 56 data bytes
64 bytes from 212.32.245.132: icmp_seq=0 ttl=54 time=36.669 ms
64 bytes from 212.32.245.132: icmp_seq=1 ttl=54 time=33.050 ms
^C
--- pkg.opnsense.org ping statistics ---
2 packets transmitted, 2 packets received, 0.0% packet loss
round-trip min/avg/max/stddev = 33.050/34.859/36.669/1.809 ms


[franco]

So, err...

# cat /etc/resolv.conf


Cheers,
Franco

[nines]

Code: [Select]

root@OPNsense:/tmp # cat /etc/resolv.conf
domain unimatrix01.local
nameserver 192.168.254.251
nameserver 1.1.1.1

but it doenst make difference if I switch them around or use a completely new one