🐛 [Bug] USER_CONFIG_TYPE=BD with pgsql cause 500 Error

[ljcbaby]

🐛 Bug

it seems config decode error.

logs here

NOTICE: PHP message: PHP Warning:  Undefined variable $config in /usr/local/share/cypht/site/index.php on line 57
NOTICE: PHP message: PHP Stack trace:
NOTICE: PHP message: PHP   1. {main}() /usr/local/share/cypht/site/index.php:0
127.0.0.1 -  11/Jun/2025:22:40:44 +0800 "GET /index.php" 200
NOTICE: PHP message: Array
(
    [0] => INFO: Using Hm_PHP_Session with Hm_Auth_DB
    [1] => INFO: Using DB user configuration
    [2] => WARNING: Already registered module for ajax_combined_message_list re-attempted: load_user_data
    [3] => WARNING: Already registered module for ajax_imap_debug re-attempted: profile_data
    [4] => WARNING: Already registered module for servers re-attempted: compose_profile_data
    [5] => INFO: Using sapi: fpm-fcgi
    [6] => INFO: Request type: HTTP
    [7] => INFO: Request path: /
    [8] => INFO: TLS request: 0
    [9] => INFO: Mobile request: 0
    [10] => INFO: Page ID: home
    [11] => INFO: Using Hm_Cache for cache
    [12] => DANGER: Redis connect failed
    [13] => INFO: CACHE backend using: memcache
    [14] => WARNING: TRANSLATION NOT FOUND :Cypht:
    [15] => WARNING: TRANSLATION NOT FOUND :Are you sure you want to delete this server? :
    [16] => WARNING: TRANSLATION NOT FOUND :You need to have Javascript enabled to use %s, sorry about that!:
    [17] => INFO: PHP version 8.1.32
    [18] => INFO: Zend version 4.1.32
    [19] => INFO: Peak Memory: 16384
    [20] => INFO: PID: 1874
    [21] => INFO: Included files: 147
)
192.168.2.8 - - [11/Jun/2025:22:40:44 +0800] "GET / HTTP/1.1" 200 167633 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 Edg/137.0.0.0"
127.0.0.1 -  11/Jun/2025:22:40:47 +0800 "POST /index.php" 500
NOTICE: PHP message: PHP Fatal error:  Uncaught TypeError: base64_decode(): Argument #1 ($string) must be of type string, resource given in /usr/local/share/cypht/lib/crypt_sodium.php:28
Stack trace:
#0 /usr/local/share/cypht/lib/crypt_sodium.php(28): base64_decode()
#1 /usr/local/share/cypht/lib/config.php(362): Hm_Crypt::plaintext()
#2 /usr/local/share/cypht/lib/config.php(387): Hm_User_Config_DB->decrypt_settings()
#3 /usr/local/share/cypht/modules/core/handler_modules.php(704): Hm_User_Config_DB->load()
#4 /usr/local/share/cypht/lib/modules_exec.php(177): Hm_Handler_load_user_data->process()
#5 /usr/local/share/cypht/lib/modules_exec.php(155): Hm_Module_Exec->run_handler_module()
#6 /usr/local/share/cypht/lib/dispatch.php(218): Hm_Module_Exec->run_handler_modules()
#7 /usr/local/share/cypht/lib/dispatch.php(188): Hm_Dispatch->process_request()
#8 /usr/local/share/cypht/site/index.php(55): Hm_Dispatch->__construct()
#9 {main}
  thrown in /usr/local/share/cypht/lib/crypt_sodium.php on line 28
192.168.2.8 - - [11/Jun/2025:22:40:48 +0800] "POST / HTTP/1.1" 500 11 "http://192.168.3.4:3008/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 Edg/137.0.0.0"
NOTICE: PHP message: PHP Warning:  Undefined variable $config in /usr/local/share/cypht/site/index.php on line 57
NOTICE: PHP message: PHP Stack trace:
NOTICE: PHP message: PHP   1. {main}() /usr/local/share/cypht/site/index.php:0
127.0.0.1 -  11/Jun/2025:22:40:48 +0800 "GET /index.php" 200
NOTICE: PHP message: Array
(
    [0] => INFO: Using Hm_PHP_Session with Hm_Auth_DB
    [1] => INFO: Using DB user configuration
    [2] => WARNING: Already registered module for ajax_combined_message_list re-attempted: load_user_data
    [3] => WARNING: Already registered module for ajax_imap_debug re-attempted: profile_data
    [4] => WARNING: Already registered module for servers re-attempted: compose_profile_data
    [5] => INFO: Using sapi: fpm-fcgi
    [6] => INFO: Request type: HTTP
    [7] => INFO: Request path: /favicon.ico/
    [8] => INFO: TLS request: 0
    [9] => INFO: Mobile request: 0
    [10] => INFO: Page ID: home
    [11] => INFO: Using Hm_Cache for cache
    [12] => DANGER: Redis connect failed
    [13] => INFO: CACHE backend using: memcache
    [14] => INFO: Deleting cookie: name: hm_session, lifetime: 1749649248, path: /favicon.ico/, domain: 192.168.3.4, secure: , html_only 1
    [15] => INFO: Deleting cookie: name: hm_id, lifetime: 1749649248, path: /favicon.ico/, domain: 192.168.3.4, secure: , html_only 1
    [16] => INFO: Deleting cookie: name: hm_reload_folders, lifetime: 1749649248, path: , domain: 192.168.3.4, secure: , html_only 
    [17] => INFO: Deleting cookie: name: hm_msgs, lifetime: 1749649248, path: /favicon.ico/, domain: 192.168.3.4, secure: , html_only 1
    [18] => DANGER: HTTP header fingerprint check failed
    [19] => WARNING: TRANSLATION NOT FOUND :Cypht:
    [20] => WARNING: TRANSLATION NOT FOUND :Are you sure you want to delete this server? :
    [21] => WARNING: TRANSLATION NOT FOUND :You need to have Javascript enabled to use %s, sorry about that!:
    [22] => INFO: PHP version 8.1.32
    [23] => INFO: Zend version 4.1.32
    [24] => INFO: Peak Memory: 16384
    [25] => INFO: PID: 1874
    [26] => INFO: Included files: 147
)
192.168.2.8 - - [11/Jun/2025:22:40:48 +0800] "GET /favicon.ico HTTP/1.1" 200 167642 "http://192.168.3.4:3008/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36 Edg/137.0.0.0"
NOTICE: PHP message: PHP Warning:  Undefined variable $config in /usr/local/share/cypht/site/index.php on line 57
NOTICE: PHP message: PHP Stack trace:
NOTICE: PHP message: PHP   1. {main}() /usr/local/share/cypht/site/index.php:0
NOTICE: PHP message: Array
127.0.0.1 -  11/Jun/2025:22:40:53 +0800 "GET /index.php" 200
(
    [0] => INFO: Using Hm_PHP_Session with Hm_Auth_DB
    [1] => INFO: Using DB user configuration
    [2] => WARNING: Already registered module for ajax_combined_message_list re-attempted: load_user_data
    [3] => WARNING: Already registered module for ajax_imap_debug re-attempted: profile_data
    [4] => WARNING: Already registered module for servers re-attempted: compose_profile_data
    [5] => INFO: Using sapi: fpm-fcgi
    [6] => INFO: Request type: HTTP
    [7] => INFO: Request path: /
    [8] => INFO: TLS request: 0
    [9] => INFO: Mobile request: 0
    [10] => INFO: Page ID: home
    [11] => INFO: Using Hm_Cache for cache
    [12] => DANGER: Redis connect failed
    [13] => INFO: CACHE backend using: memcache
    [14] => WARNING: TRANSLATION NOT FOUND :Cypht:
    [15] => WARNING: TRANSLATION NOT FOUND :Are you sure you want to delete this server? :
    [16] => WARNING: TRANSLATION NOT FOUND :You need to have Javascript enabled to use %s, sorry about that!:
    [17] => INFO: PHP version 8.1.32
    [18] => INFO: Zend version 4.1.32
    [19] => INFO: Peak Memory: 16384
    [20] => INFO: PID: 1873
    [21] => INFO: Included files: 147
)
127.0.0.1 - - [11/Jun/2025:22:40:53 +0800] "GET / HTTP/1.1" 200 552198 "-" "curl/7.88.1"
NOTICE: PHP message: PHP Warning:  Undefined variable $config in /usr/local/share/cypht/site/index.php on line 57
NOTICE: PHP message: PHP Stack trace:
NOTICE: PHP message: PHP   1. {main}() /usr/local/share/cypht/site/index.php:0
127.0.0.1 -  11/Jun/2025:22:41:23 +0800 "GET /index.php" 200
NOTICE: PHP message: Array
(
    [0] => INFO: Using Hm_PHP_Session with Hm_Auth_DB
    [1] => INFO: Using DB user configuration
    [2] => WARNING: Already registered module for ajax_combined_message_list re-attempted: load_user_data
    [3] => WARNING: Already registered module for ajax_imap_debug re-attempted: profile_data
    [4] => WARNING: Already registered module for servers re-attempted: compose_profile_data
    [5] => INFO: Using sapi: fpm-fcgi
    [6] => INFO: Request type: HTTP
    [7] => INFO: Request path: /
    [8] => INFO: TLS request: 0
    [9] => INFO: Mobile request: 0
    [10] => INFO: Page ID: home
    [11] => INFO: Using Hm_Cache for cache
    [12] => DANGER: Redis connect failed
    [13] => INFO: CACHE backend using: memcache
    [14] => WARNING: TRANSLATION NOT FOUND :Cypht:
    [15] => WARNING: TRANSLATION NOT FOUND :Are you sure you want to delete this server? :
    [16] => WARNING: TRANSLATION NOT FOUND :You need to have Javascript enabled to use %s, sorry about that!:
    [17] => INFO: PHP version 8.1.32
    [18] => INFO: Zend version 4.1.32
    [19] => INFO: Peak Memory: 16384
    [20] => INFO: PID: 1874
    [21] => INFO: Included files: 147
)
127.0.0.1 - - [11/Jun/2025:22:41:23 +0800] "GET / HTTP/1.1" 200 552197 "-" "curl/7.88.1"

Version & Environment

Rev: [daily]

OS: [docker.io/cypht/cypht]

[Shadow243]

@ljcbaby thanks for the report.

I'm currently testing on my side, with my local instance, everything is working fine so far. I'm pulling the latest image daily from Docker Hub, and I haven't been able to reproduce the issue yet.

I'll keep testing, and if I'm still unable to reproduce it, maybe we could consider doing a screen share, if that works for you.

[ljcbaby]

@ljcbaby thanks for the report.

I'm currently testing on my side, with my local instance, everything is working fine so far. I'm pulling the latest image daily from Docker Hub, and I haven't been able to reproduce the issue yet.

I'll keep testing, and if I'm still unable to reproduce it, maybe we could consider doing a screen share, if that works for you.

my compose is here, pg backend is 170004

services:
  cypht:
    image: cypht/cypht:daily
    container_name: cypht
    restart: unless-stopped
    environment:
      - TZ=Asia/Shanghai
      - UMASK=0022
      - ADMIN_USERS=ljcbaby
      - USER_CONFIG_TYPE=DB
      - DEFAULT_LANGUAGE=zh-Hans
      - ALLOW_LONG_SESSION=true
      - DISABLE_IP_CHECK=true
      - DEFAULT_SETTING_TIMEZONE=Asia/Shanghai
      - DEFAULT_SETTING_LANGUAGE=zh-Hans
      - DB_CONNECTION_TYPE=host
      - DB_HOST=postgres
      - DB_PORT=5432
      - DB_NAME=cypht
      - DB_USER=cypht
      - DB_PASS=bf4610e60d38df1d956dbf567952895b
      - DB_DRIVER=pgsql
      - DEFAULT_SETTING_NO_PASSWORD_SAVE=false
      - AUTH_USERNAME=ljcbaby
      - AUTH_PASSWORD=Lu@585821
    networks:
      - apps
    ports:
      - 3008:80
    volumes:
      - /mnt/Data/apps/cypht:/var/lib/hm3/attachments

networks:
  apps:
    external: true

It now appears that when there is no entry in the hm_user_settings (after the user first logs in or manually deletes the configuration entry) , the user log in is normal. There will be entries after landing 500 error. Do I need to export an entry that causes an exception?

[ljcbaby]

exported data here

/*
 Navicat Premium Dump SQL

 Source Server         : TNAS-XG
 Source Server Type    : PostgreSQL
 Source Server Version : 170004 (170004)
 Source Host           : 192.168.3.4:5432
 Source Catalog        : cypht
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 170004 (170004)
 File Encoding         : 65001

 Date: 26/06/2025 15:09:49
*/


-- ----------------------------
-- Table structure for hm_user_settings
-- ----------------------------
DROP TABLE IF EXISTS "public"."hm_user_settings";
CREATE TABLE "public"."hm_user_settings" (
  "username" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "settings" bytea
)
;

-- ----------------------------
-- Records of hm_user_settings
-- ----------------------------
INSERT INTO "public"."hm_user_settings" VALUES ('ljcbaby', E'AQYEmB/7FKavAvwYzCbSFy2ZwBvjD8tzJYa7Cu8SLZtnRJAP73zawDv6sPOK2WxK+Skla/QjvAtuWwBDBESctPAaUPmwUn15c/5A1UkEIhmJJiG02Qy1wj4W2SlZgWPFP1OM2wQX4uxNVv7JlhZa/ixQlOENLgwKjNg8djnLz1ZFKpIKdoiY4T61I48i4yUi3U+l+LKYIkT2TBQ6YIUAimvrYuAjvLnuL0kGiOLlxkV+3AAvQObUiVtnFKRMzTf5XXvDoOq5TP/Hf9VrH22FBRS/IeWra1kPF90xw5ERXGI3IWj/U1GJeXjmMrkWUlMRfxH6bGX3yfefyli7q+/0YkD2Rgf1CR087kopYqSgaAVuQMvNnLVDSMD/9v/dlgLFZXJjIxbH6SuN0tpdQUtiD5FoO9etxgWt9Nrs4Gy2NpP5Se770a+TOL/imK7f/W1Bfald1zF3fO/UQtGn/iyWfJxUI329uLTihUZgfQFCqwtyVOdZ5/kVeevXiLfsjsmGrhh8nfeeIhmaowqvbeUAjobBi/sm3Eorm3HARWhwalUmzLqEkViKHCDyQ3jxKJzWOljwVLAYehPYOJ0WWACsqPDMSW+AyBNhdhcdznsXunnFTpuceCVI5b8/kKOKBzY8HDXsmCpHJypqBp6Pf0bOYdMKY5sWX1b42mR2rkZS1itrTzHZ2KIu/wD8mBA1OSR7I+MTokQczN3Wt9pTr5/Qg4VCtwSTLt2E3iYTU0KwC8ThQ/CBS4SCtrxZSteosg8909oULF90uaSC0cUu8ttNRd9uKKwai16dpwIbkChJ0K99X42/NDzDBz3fdH4/CAhRBYWGZYnnSb++nfUho2CaKnoRSKYuAoM+iOcuBPpyqxm3a9MGJWGzDYmkw9Ft7zmy886KT3aYdDcHY40lQcoaGWjJ9rbq33TGox7LC0dLsGGptYv8VGOz8XV/oEQlnbABsSrq8l59yLsDABpevauWpwW2OeBgRF3QfC+QtC+RbFrROryh7t5YrnoS3sjhCDn3NmKDWQmJ1q4b9l0JfGF1iolXmpnWyWsPHL+0oAyMg2NigZrwJxkpCtKhaj0B+dHgaYwnhoTa3Y/vSs502BUUbePHR406iuvTv599LwIYB/PJ1YbXVsTUdHhXpumyM+n+BZLUsx6uMeIvVvm68qQCBVFT4HIF3Lop8k+IpefA+I92H9v8fvnjT5NEsWTCLkv/aAkyYky+axRW8i2q0KzCDxCq+6Qrph94N5y6Opwu0xlCkrcc1UJzpZN+QfpC9mCsixKgDat3Ie/ZP2txDnELX390GVj1F92CPVgdYgV8ve55Z9I27ST7+VEmvigh+cusZYSVCJAD6W0jEMzO50gC/3QJ4ewjBIGTlVXjQ+IiQxPMOSFyzLQmGQ07rDKChbggDSA73uboO8W7Iw7lnWvlx3yqyBanZl7vTDF/7qSn6McjZuKU9PywAhGdWpyhN4/vKvVF1PKrZYTJr2dMk41+mmxsDzAPfc3qvHlHo5Ge9ioLxRR5UAnPuvKYxTspmO0JPpJB81AgVG0wDLMLFNipQZ0VxjiN1/1U5Lf4GXrYpftnotSDY1VjMaBfdQNotPLuFLKCwtRJgPhaX6RwHpV7cXxuIrZis1TqXOuBP4+/+euKwdA2H47HitgBmf/k5DPci2Q8VOtRoqHOV504WArwFS5/C9li2WsIHduSPQphDyYGxiSlMgs3mjpm6SvOzWUeiGPr8gk4FAhWXzZ2oTGSKug5C9MyJZYFGxmUDtpxJSGe4+VzDN5J6slPkbA8SGGIq2haRkVZpXCorw4GSbmfBfC83lBQyA6ZJd2QyV3KtkLwMW3xmJLN481c8X88UjbqKele16dZJIteKn8ldwOW0AfzQpjUA9F3fr4Y4YPgyUp4cLhi73CWoGhb7XQKKo+/MFl9j1us8V1iDDHzi+aQhbjH91km9/1f7q85VuRmRrULBGcKQEu6e8mGVo+ej7ohW3DJ2R+wwsUs3vXHdGehVDHFzDK8Gi/EAwEjqxMx+ILSbhBElrpcOSXB87qEYzyreAc7gSY30zftoRV9hee0ZniZxB2NTBN1hN38NcObcqiA0O02xBgRoAGeWArmWYF9MeG2kK00BfpY111WPsNdwnrusxc+pjrXitko3QeA93urqzAw9HjPDjxU7S91iuNrS+w7io94YJUiE7tE07Qwne7vzNkYDllLMijNrOD/D7X+fUn7DilLqgeBTEdhKB8sJCHiB2hDO7T0JBBGs4WxazWDvsHki7/1qq7FZuVOVG9GrW0KtOqSl+pHFiUGBx+c0GhMGTe8sHrfpMOB+gEpIbD/YVOktdmJ0b+WTC4MeJpHqFEqmzBRv56Q6MH4CHkIgL4ZVsFb05XSwxxJdrYeudW1gwlvTiqyLfFn6HfFSd58YVyyhiSIqfpjZMQubctMcyiVxIKxxfxWIRT22oq29cbzt18rqDj3r9Zbp3ejgozA+2JeJ/DMIPfSl1lY7UGsh/Qp3mtCfMkbb+pJDuQkG5XNNwNS4o0H4trVQA0eWsYHqXVHd14royhSwrNF+OL2OzUORQTdY6qs1M6Igp5HA5zbFvpEp/Poe9vvpBKrsOvy+czNqnag4XkPuEi05xUji1EuYIqMNNK2+mPUHpVYWuPnp9izNm0XjqmggGtQgNz+xFuAyXyzfZkTosGAGp07EaEFQvMDdrA3YUb9yhMQctKLcl+m92eXlXijqv1T7lylv/UxpDx4tFb3GsWVFvyr2f9mTzcNoXvGsSk+0DHjqwpAIjs9WZsEw/+cLFFdyYkSOMm9Ho6pTk1v3eIeLBCSwWiWZZNsacbZ3QoP2bvEwNrUgTm2LaMICyPd0A1DChNR5pipJOPlGim4HwAsq4JOqF5of8+hVSrQEuwD9W/VmVt199GAalqkTCvv7awvBnOwvCfP78CckHX7zwYMRGhNiaE3Bb+/7IfMIgTMITLu6v9/xPn76YwUUkZvuF6cLR+FYiRWvfIepALSdYxeyqq46SfKIITHEVTJpYAOI8IVVtunxfkfUnmEMp4PE8saEZtGciwfsi2lk0nwGdOrbUSTkgft6DRqAX3jUFFF8NsBsA1vRNuOXcsSgMxydmRqeLYGyOJmfN3VRYSwCjM2XumXYYDTEr0JQp24dcX4NdiM2bhV+aBSeje9T2bS2PEf1H4pTL0tC8Khng3np1IsTmm7Bo9lTuEttYtrOnXpFZqpqdftdoWmJMwp98UHCVDSA4S0Xk073M5JkOMm8+vc7JJyuk6DgvBtn1sQy2uPY/lettnbnxfaPWebcO5SOJm8rRDON20UaqII4eM0q/eOPQSFbi/6cmK+mpqPrqwUcWro59cQNcptgUJQYWD/0Eyk2Zp3djygmdp5+O58/+I=');

-- ----------------------------
-- Primary Key structure for table hm_user_settings
-- ----------------------------
ALTER TABLE "public"."hm_user_settings" ADD CONSTRAINT "hm_user_settings_pkey" PRIMARY KEY ("username");

[ljcbaby]

it may caused by db data type.

i changed settings from BYTEA to VARCHAR, it runs well.