Joeri1594

This is awesome, thankyou

I've added an existing virtual disk to an existing vm and instead of qcow2 it ads the disk as "raw" by default. I've done it with different disks ant the bugs still persist. Is this a legit bug or is it me?

Hello, i cant get any connection to my database. i run a mariadb on: 192.168.1.10 default port ferdi-server runs on 192.168.23 (i br0 almost everything because of my network setup) these are my setting Variables set: NODE_ENV=development DB_CONNECTION=MariaDB DB_HOST=192.168.1.10 DB_PORT=3306 DB_USER=ferdi DB_PASSWORD=[mypassword] DB_DATABASE=adonis IS_CREATION_ENABLED=true CONNECT_WITH_FRANZ=true DB setting are: Database: adonis latin1_swedish_ci en this is what the logs says about the DB **** DB Helper loaded **** **** Checking DB endpoint **** /var/run/s6/etc/cont-init.d/50-config: line 106: warning: command substitution: ignored null byte in input /var/run/s6/etc/cont-init.d/50-config: line 106: warning: command substitution: ignored null byte in input **** Run DB migration **** RuntimeException: E_MISSING_DB_CONNECTION: Missing database connection {MariaDB}. Make sure you define it inside config/database.js file > More details: https://err.sh/adonisjs/errors/E_MISSING_DB_CONNECTION at Function.missingDatabaseConnection (/app/node_modules/@adonisjs/lucid/src/Exceptions/index.js:36:12) at DatabaseManager.connection (/app/node_modules/@adonisjs/lucid/src/Database/Manager.js:78:33) at Object.get (/app/node_modules/@adonisjs/lucid/lib/proxyGet.js:40:77) at Migration._makeMigrationsTable (/app/node_modules/@adonisjs/lucid/src/Migration/index.js:47:36) at Migration.up (/app/node_modules/@adonisjs/lucid/src/Migration/index.js:336:16) at MigrationRun.handle (/app/node_modules/@adonisjs/lucid/commands/MigrationRun.js:72:66) at Promise (/app/node_modules/@adonisjs/ace/src/Command/index.js:565:48) at new Promise (<anonymous>) at Function.exec (/app/node_modules/@adonisjs/ace/src/Command/index.js:563:12) at Function.commanderAction (/app/node_modules/@adonisjs/ace/src/Command/index.js:540:8) at Command.listener (/app/node_modules/commander/index.js:315:8) at Command.emit (events.js:198:13) at Command.parseArgs (/app/node_modules/commander/index.js:651:12) at Command.parse (/app/node_modules/commander/index.js:474:21) at Kernel.invoke (/app/node_modules/@adonisjs/ace/src/Kernel/index.js:329:15) at Ignitor._invokeAce (/app/node_modules/@adonisjs/ignitor/src/Ignitor/index.js:532:9) can u help me understand the problem?

i've install it an hour ago and really like it! but i have a couple questions since its a littlebit new to me. how can i achieve a lower response time, how do i build up a cache. it is running local so do i need dns over https or dns over tls. and how can i configure it (sorry im new in this world) do you have some other tips for me ? Thank you very much for sharing this awsome software. comined with my sophos XG im getting more and more self hosted/safe.

This also works for me! Many thanks. i'm not at home and have my quad NIC removed from the server.so i can't test if it also works atm.

I got the same problem, stuck at boot

<?xml version='1.0' encoding='UTF-8'?> <domain type='kvm' id='9'> <name>OPsense</name> <uuid>98924821-74fc-7677-9004-584ba1210a3f</uuid> <metadata> <vmtemplate xmlns="unraid" name="FreeBSD" icon="freebsd.png" os="freebsd"/> </metadata> <memory unit='KiB'>2097152</memory> <currentMemory unit='KiB'>2097152</currentMemory> <memoryBacking> <nosharepages/> </memoryBacking> <vcpu placement='static'>2</vcpu> <cputune> <vcpupin vcpu='0' cpuset='2'/> <vcpupin vcpu='1' cpuset='3'/> </cputune> <resource> <partition>/machine</partition> </resource> <os> <type arch='x86_64' machine='pc-q35-4.2'>hvm</type> </os> <features> <acpi/> <apic/> </features> <cpu mode='host-passthrough' check='none'> <topology sockets='1' cores='2' threads='1'/> <cache mode='passthrough'/> </cpu> <clock offset='utc'> <timer name='rtc' tickpolicy='catchup'/> <timer name='pit' tickpolicy='delay'/> <timer name='hpet' present='no'/> </clock> <on_poweroff>destroy</on_poweroff> <on_reboot>restart</on_reboot> <on_crash>restart</on_crash> <devices> <emulator>/usr/local/sbin/qemu</emulator> <disk type='file' device='cdrom'> <driver name='qemu' type='raw'/> <source file='/mnt/user/isos en programs/OPNsense-20.1-OpenSSL-dvd-amd64.iso' index='2'/> <backingStore/> <target dev='hda' bus='sata'/> <readonly/> <boot order='2'/> <alias name='sata0-0-0'/> <address type='drive' controller='0' bus='0' target='0' unit='0'/> </disk> <disk type='file' device='disk'> <driver name='qemu' type='qcow2' cache='writeback'/> <source file='/mnt/user/domains/OPsense/vdisk1.img' index='1'/> <backingStore/> <target dev='hdc' bus='sata'/> <boot order='1'/> <alias name='sata0-0-2'/> <address type='drive' controller='0' bus='0' target='0' unit='2'/> </disk> <controller type='usb' index='0' model='ich9-ehci1'> <alias name='usb'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x07' function='0x7'/> </controller> <controller type='usb' index='0' model='ich9-uhci1'> <alias name='usb'/> <master startport='0'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x07' function='0x0' multifunction='on'/> </controller> <controller type='usb' index='0' model='ich9-uhci2'> <alias name='usb'/> <master startport='2'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x07' function='0x1'/> </controller> <controller type='usb' index='0' model='ich9-uhci3'> <alias name='usb'/> <master startport='4'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x07' function='0x2'/> </controller> <controller type='sata' index='0'> <alias name='ide'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x1f' function='0x2'/> </controller> <controller type='pci' index='0' model='pcie-root'> <alias name='pcie.0'/> </controller> <controller type='pci' index='1' model='pcie-root-port'> <model name='pcie-root-port'/> <target chassis='1' port='0x10'/> <alias name='pci.1'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x02' function='0x0' multifunction='on'/> </controller> <controller type='pci' index='2' model='pcie-root-port'> <model name='pcie-root-port'/> <target chassis='2' port='0x11'/> <alias name='pci.2'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x02' function='0x1'/> </controller> <controller type='pci' index='3' model='pcie-root-port'> <model name='pcie-root-port'/> <target chassis='3' port='0x12'/> <alias name='pci.3'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x02' function='0x2'/> </controller> <controller type='pci' index='4' model='pcie-root-port'> <model name='pcie-root-port'/> <target chassis='4' port='0x13'/> <alias name='pci.4'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x02' function='0x3'/> </controller> <controller type='virtio-serial' index='0'> <alias name='virtio-serial0'/> <address type='pci' domain='0x0000' bus='0x03' slot='0x00' function='0x0'/> </controller> <interface type='bridge'> <mac address='52:54:00:74:17:8e'/> <source bridge='br0'/> <target dev='vnet2'/> <model type='e1000-82545em'/> <alias name='net0'/> <address type='pci' domain='0x0000' bus='0x01' slot='0x00' function='0x0'/> </interface> <interface type='bridge'> <mac address='52:54:00:74:17:8f'/> <source bridge='br0'/> <target dev='vnet3'/> <model type='e1000-82545em'/> <alias name='net1'/> <address type='pci' domain='0x0000' bus='0x02' slot='0x00' function='0x0'/> </interface> <serial type='pty'> <source path='/dev/pts/2'/> <target type='isa-serial' port='0'> <model name='isa-serial'/> </target> <alias name='serial0'/> </serial> <console type='pty' tty='/dev/pts/2'> <source path='/dev/pts/2'/> <target type='serial' port='0'/> <alias name='serial0'/> </console> <channel type='unix'> <source mode='bind' path='/var/lib/libvirt/qemu/channel/target/domain-9-OPsense/org.qemu.guest_agent.0'/> <target type='virtio' name='org.qemu.guest_agent.0' state='disconnected'/> <alias name='channel0'/> <address type='virtio-serial' controller='0' bus='0' port='1'/> </channel> <input type='tablet' bus='usb'> <alias name='input0'/> <address type='usb' bus='0' port='1'/> </input> <input type='mouse' bus='ps2'> <alias name='input1'/> </input> <input type='keyboard' bus='ps2'> <alias name='input2'/> </input> <graphics type='vnc' port='5902' autoport='yes' websocket='5702' listen='0.0.0.0' keymap='en-us'> <listen type='address' address='0.0.0.0'/> </graphics> <video> <model type='qxl' ram='65536' vram='65536' vgamem='16384' heads='1' primary='yes'/> <alias name='video0'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x01' function='0x0'/> </video> <memballoon model='virtio'> <alias name='balloon0'/> <address type='pci' domain='0x0000' bus='0x00' slot='0x06' function='0x0'/> </memballoon> </devices> <seclabel type='dynamic' model='dac' relabel='yes'> <label>+0:+100</label> <imagelabel>+0:+100</imagelabel> </seclabel> </domain>

i'm gona try it again with your settings.

a little update for PFsense & OPsense. everytime i try it i got 1 core that get a load of 100% and than it stucks.

New log from Sophos XG. With 2 br0 adapters and no quadnic passthrought, i wass able to setup the VM. After setting it up i tought, maby i can now passthrought the Quad NIC. But no, i also used @bastl 's .xml tweak. this is the log i get. -device vfio-pci,host=0000:01:00.1,id=hostdev1,bus=pci.1,addr=0x9.0x1 \ -device vfio-pci,host=0000:01:00.2,id=hostdev2,bus=pci.1,addr=0xa.0x2 \ -device vfio-pci,host=0000:01:00.3,id=hostdev3,bus=pci.1,addr=0xb.0x3 \ -sandbox on,obsolete=deny,elevateprivileges=deny,spawn=deny,resourcecontrol=deny \ -msg timestamp=on 2020-03-12 15:47:16.829+0000: Domain id=3 is tainted: high-privileges 2020-03-12 15:47:16.829+0000: Domain id=3 is tainted: host-cpu char device redirected to /dev/pts/1 (label charserial0) 2020-03-12T15:47:18.861098Z qemu-system-x86_64: vfio: Unable to power on device, stuck in D3 2020-03-12T15:48:29.336821Z qemu-system-x86_64: vfio: Unable to power on device, stuck in D3 2020-03-12T15:49:38.967942Z qemu-system-x86_64: vfio: Unable to power on device, stuck in D3 2020-03-12T15:50:48.622748Z qemu-system-x86_64: vfio: Unable to power on device, stuck in D3 2020-03-12T15:57:29.268496Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:29.379381Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:31.360020Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:31.473187Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:42.466676Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:42.588805Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:46.826364Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:57:46.952942Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:22.427832Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:22.554454Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:26.997150Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:27.118497Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:29.430835Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:29.552656Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:31.008617Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:31.111485Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:34.000435Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:34.086476Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:36.340813Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:36.459687Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:39.596806Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:39.695139Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:42.710439Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:42.811951Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:44.609582Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:44.760635Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:46.022579Z qemu-system-x86_64: warning: no scancode found for keysym 0 2020-03-12T15:58:46.155262Z qemu-system-x86_64: warning: no scancode found for keysym 0

i doesn't do the job form me unfortunately

Hello @bastl, Thank you for your reply. i'm gona try this in a couple of minutes. i see in my own .xml file that also slot is asigned to every device. if i set them to 0 like yours, does that cause any trouble? Kind regards

Hello @toolmanz, i have made also a topic and i think we have the same kind of problem. only with different hardware. https://forums.unraid.net/topic/89686-cant-install-pfsense-opsense-and-sophos-xg/

Bios is also up to date but i think there is something wrong in there because of the D3 state of the card.

Hello Pete, Thanks for your reply. I have tried several times of rebooting Also i have recreated the xml file several times. I have tried to passthrought te quad NIC in opsense pfsense sophos and ubuntu without a good result. im beginning te be a little bit desperate at the moment.