wieli99

Solution: it is a database user permission problem, granting the user correct permissions on the db and schema solves it

Not sure if relevant, but this is the only mention of this error I could find: https://github.com/firefly-iii/firefly-iii/issues/2915

Yup, using that one, default port aswell. Here's a more detailed log from the container itself AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.21. Set the 'ServerName' directive globally to suppress this message AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.21. Set the 'ServerName' directive globally to suppress this message [Fri Sep 01 20:39:56.021627 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.56 (Debian) configured -- resuming normal operations [Fri Sep 01 20:39:56.021668 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND' [2023-09-01 20:40:07] local.INFO: Could not create or generate installation ID. Do not continue. [2023-09-01 20:40:07] local.ERROR: Exception is: {"class":"FireflyIII\\Exceptions\\FireflyException","errorMessage":"Could not poll the database: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"configuration\" does not exist\nLINE 1: select \"id\", \"name\", \"data\" from \"configuration\" where \"name...\n ^ (Connection: pgsql, SQL: select \"id\", \"name\", \"data\" from \"configuration\" where \"name\" = is_demo_site and \"configuration\".\"deleted_at\" is null limit 1)","time":"Fri, 01 Sep 2023 20:40:07 +0200","file":"\/var\/www\/html\/app\/Support\/FireflyConfig.php","line":80,"code":0,"version":"6.0.22","url":"http:\/\/192.168.8.38:8111","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/116.0.0.0 Safari\/537.36","json":true,"method":"GET"} [2023-09-01 20:40:07] local.ERROR: Could not poll the database: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "configuration" does not exist LINE 1: select "id", "name", "data" from "configuration" where "name... The Database connection itself should work, as I had previous (user) errors with db name and pw, but both are now gone, which should mean a connection can be established

After installation, I get Could not poll the database: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "configuration" does not exist LINE 1: select "id", "name", "data" from "configuration" where "name... ^ (Connection: pgsql, SQL: select "id", "name", "data" from "configuration" where "name" = is_demo_site and "configuration"."deleted_at" is null limit 1) using postgres 15

Weird that this freezes the whole server, but that seems to have done the trick! Thx a lot

My unRAID server keeps freezing after migrating to new hardware. As I'm using an AMD processor, I already tried the fixes from the FAQs regarding the c states, but to no avail. I setup a syslog server and here is the last output I got: Jul 15 06:50:06 SilverSurfer kernel: WARNING: CPU: 8 PID: 969 at net/netfilter/nf_conntrack_core.c:1210 __nf_conntrack_confirm+0xa4/0x2b0 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: Modules linked in: xt_nat xt_tcpudp veth macvlan xt_conntrack xt_MASQUERADE nf_conntrack_netlink nfnetlink xfrm_user xfrm_algo iptable_nat nf_nat nf_conntrack nf_defrag_ipv6 nf_defrag_ipv4 xt_addrtype br_netfilter xfs md_mod zfs(PO) zunicode(PO) zzstd(O) zlua(O) zavl(PO) icp(PO) zcommon(PO) znvpair(PO) spl(O) ip6table_filter ip6_tables iptable_filter ip_tables x_tables efivarfs af_packet 8021q garp mrp bridge stp llc bonding tls amdgpu edac_mce_amd edac_core gpu_sched drm_buddy i2c_algo_bit drm_ttm_helper ttm kvm_amd drm_display_helper drm_kms_helper kvm drm sr_mod btusb crct10dif_pclmul cdrom crc32_pclmul crc32c_intel btrtl btbcm ghash_clmulni_intel btintel sha512_ssse3 wmi_bmof bluetooth aesni_intel agpgart crypto_simd cryptd nvme syscopyarea sysfillrect i2c_piix4 r8169 sysimgblt ahci ecdh_generic rapl i2c_core k10temp nvme_core ccp fb_sys_fops realtek cdc_acm ecc libahci thermal video wmi backlight acpi_tad button acpi_cpufreq unix Jul 15 06:50:06 SilverSurfer kernel: CPU: 8 PID: 969 Comm: kworker/u64:11 Tainted: P S O 6.1.36-Unraid #1 Jul 15 06:50:06 SilverSurfer kernel: Hardware name: HP HP Desktop M01-F1xxx/87D6, BIOS F.13 03/29/2021 Jul 15 06:50:06 SilverSurfer kernel: Workqueue: events_unbound macvlan_process_broadcast [macvlan] Jul 15 06:50:06 SilverSurfer kernel: RIP: 0010:__nf_conntrack_confirm+0xa4/0x2b0 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: Code: 44 24 10 e8 e2 e1 ff ff 8b 7c 24 04 89 ea 89 c6 89 04 24 e8 7e e6 ff ff 84 c0 75 a2 48 89 df e8 9b e2 ff ff 85 c0 89 c5 74 18 <0f> 0b 8b 34 24 8b 7c 24 04 e8 18 dd ff ff e8 93 e3 ff ff e9 72 01 Jul 15 06:50:06 SilverSurfer kernel: RSP: 0018:ffffc900003d8d98 EFLAGS: 00010202 Jul 15 06:50:06 SilverSurfer kernel: RAX: 0000000000000001 RBX: ffff88812ac27200 RCX: e012e3db32ff73d3 Jul 15 06:50:06 SilverSurfer kernel: RDX: 0000000000000000 RSI: 0000000000000001 RDI: ffff88812ac27200 Jul 15 06:50:06 SilverSurfer kernel: RBP: 0000000000000001 R08: 7e96d5f73588b0b9 R09: c288454296e8d8b6 Jul 15 06:50:06 SilverSurfer kernel: R10: 0e3ad73a02043d6b R11: ffffc900003d8d60 R12: ffffffff82a11440 Jul 15 06:50:06 SilverSurfer kernel: R13: 000000000001e238 R14: ffff8881954aee00 R15: 0000000000000000 Jul 15 06:50:06 SilverSurfer kernel: FS: 0000000000000000(0000) GS:ffff88840f200000(0000) knlGS:0000000000000000 Jul 15 06:50:06 SilverSurfer kernel: CS: 0010 DS: 0000 ES: 0000 CR0: 0000000080050033 Jul 15 06:50:06 SilverSurfer kernel: CR2: 000000c0001e1010 CR3: 0000000283036000 CR4: 0000000000350ee0 Jul 15 06:50:06 SilverSurfer kernel: Call Trace: Jul 15 06:50:06 SilverSurfer kernel: <IRQ> Jul 15 06:50:06 SilverSurfer kernel: ? __warn+0xab/0x122 Jul 15 06:50:06 SilverSurfer kernel: ? report_bug+0x109/0x17e Jul 15 06:50:06 SilverSurfer kernel: ? __nf_conntrack_confirm+0xa4/0x2b0 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: ? handle_bug+0x41/0x6f Jul 15 06:50:06 SilverSurfer kernel: ? exc_invalid_op+0x13/0x60 Jul 15 06:50:06 SilverSurfer kernel: ? asm_exc_invalid_op+0x16/0x20 Jul 15 06:50:06 SilverSurfer kernel: ? __nf_conntrack_confirm+0xa4/0x2b0 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: ? __nf_conntrack_confirm+0x9e/0x2b0 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: ? nf_nat_inet_fn+0xc0/0x1a8 [nf_nat] Jul 15 06:50:06 SilverSurfer kernel: nf_conntrack_confirm+0x25/0x54 [nf_conntrack] Jul 15 06:50:06 SilverSurfer kernel: nf_hook_slow+0x3d/0x96 Jul 15 06:50:06 SilverSurfer kernel: ? ip_protocol_deliver_rcu+0x164/0x164 Jul 15 06:50:06 SilverSurfer kernel: NF_HOOK.constprop.0+0x79/0xd9 Jul 15 06:50:06 SilverSurfer kernel: ? ip_protocol_deliver_rcu+0x164/0x164 Jul 15 06:50:06 SilverSurfer kernel: __netif_receive_skb_one_core+0x77/0x9c Jul 15 06:50:06 SilverSurfer kernel: process_backlog+0x8c/0x116 Jul 15 06:50:06 SilverSurfer kernel: __napi_poll.constprop.0+0x2b/0x124 Jul 15 06:50:06 SilverSurfer kernel: net_rx_action+0x159/0x24f Jul 15 06:50:06 SilverSurfer kernel: __do_softirq+0x129/0x288 Jul 15 06:50:06 SilverSurfer kernel: do_softirq+0x7f/0xab Jul 15 06:50:06 SilverSurfer kernel: </IRQ> Jul 15 06:50:06 SilverSurfer kernel: <TASK> Jul 15 06:50:06 SilverSurfer kernel: __local_bh_enable_ip+0x4c/0x6b Jul 15 06:50:06 SilverSurfer kernel: netif_rx+0x52/0x5a Jul 15 06:50:06 SilverSurfer kernel: macvlan_broadcast+0x10a/0x150 [macvlan] Jul 15 06:50:06 SilverSurfer kernel: macvlan_process_broadcast+0xbc/0x12f [macvlan] Jul 15 06:50:06 SilverSurfer kernel: process_one_work+0x1ab/0x295 Jul 15 06:50:06 SilverSurfer kernel: worker_thread+0x18b/0x244 Jul 15 06:50:06 SilverSurfer kernel: ? rescuer_thread+0x281/0x281 Jul 15 06:50:06 SilverSurfer kernel: kthread+0xe7/0xef Jul 15 06:50:06 SilverSurfer kernel: ? kthread_complete_and_exit+0x1b/0x1b Jul 15 06:50:06 SilverSurfer kernel: ret_from_fork+0x22/0x30 Jul 15 06:50:06 SilverSurfer kernel: </TASK> Jul 15 06:50:06 SilverSurfer kernel: ---[ end trace 0000000000000000 ]--- Does anyone have any suggestions?