sql server layer

[flykoh]

when project have layer from sql server?
i got error 500
Layer(s) not valid

[flykoh]

i got also
QSqlDatabase: QODBC driver not loaded

how can i load the driver

[flykoh]

i also copied libqsqlodbc.so to
/usr/local/lib/qgis/server
/usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers

[flykoh]

Sat Apr 16 03:29:05.868360 2022] [env:warn] [pid 1:tid 139790809881664] AH01506: PassEnv variable _ was undefined
[Sat Apr 16 03:29:05.870112 2022] [env:warn] [pid 1:tid 139790809881664] AH01506: PassEnv variable _ was undefined
 [notice] [pid 1] AH00489: Apache/2.4.41 (Ubuntu) mod_fcgid/2.3.9 configured -- resuming normal operations
 [notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
Application path not initialized
Application path not initialized
Application path not initialized
Application path not initialized
QStandardPaths: XDG_RUNTIME_DIR not set, defaulting to '/tmp/runtime-www-data'
"Loading native module /usr/local/lib/qgis/server/libdummy.so"
"Loading native module /usr/local/lib/qgis/server/liblandingpage.so"
"Loading native module /usr/local/lib/qgis/server/libqsqlite.so"
"Loading native module /usr/local/lib/qgis/server/libqsqlodbc.so"
"Loading native module /usr/local/lib/qgis/server/libqsqlspatialite.so"
"Loading native module /usr/local/lib/qgis/server/libwcs.so"
"Loading native module /usr/local/lib/qgis/server/libwfs.so"
"Loading native module /usr/local/lib/qgis/server/libwfs3.so"
"Loading native module /usr/local/lib/qgis/server/libwms.so"
"Loading native module /usr/local/lib/qgis/server/libwmts.so"
QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QSPATIALITE
 [notice] [pid 1] AH00491: caught SIGTERM, shutting down
[Sat Apr 16 03:30:55.638729 2022] [env:warn] [pid 1:tid 139798763813952] AH01506: PassEnv variable _ was undefined
[Sat Apr 16 03:30:55.640476 2022] [env:warn] [pid 1:tid 139798763813952] AH01506: PassEnv variable _ was undefined
 [notice] [pid 1] AH00489: Apache/2.4.41 (Ubuntu) mod_fcgid/2.3.9 configured -- resuming normal operations
 [notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
1112202 - 172.17.0.1 - - [16/Apr/2022:03:09:44 +0000] "GET /?SERVICE=WMS&VERSION=1.3.0&Map=/etc/qgisserver/Proj2/Proj2.qgz&REQUEST=GetCapabilities HTTP/1.1" 500 271 "-" "PostmanRuntime/7.29.0"
985907 - 172.17.0.1 - - [16/Apr/2022:03:14:25 +0000] "GET /?SERVICE=WMS&VERSION=1.3.0&Map=/etc/qgisserver/Proj2/Proj2.qgz&REQUEST=GetCapabilities HTTP/1.1" 500 271 "-" "PostmanRuntime/7.29.0"
54510 - 172.17.0.1 - - [16/Apr/2022:03:14:36 +0000] "GET /?SERVICE=WMS&VERSION=1.3.0&Map=/etc/qgisserver/Proj2/Proj2.qgz&REQUEST=GetCapabilities HTTP/1.1" 500 271 "-" "PostmanRuntime/7.29.0"
1029045 - 172.17.0.1 - - [16/Apr/2022:03:29:47 +0000] "GET /?SERVICE=WMS&VERSION=1.3.0&Map=/etc/qgisserver/Proj2/Proj2.qgz&REQUEST=GetCapabilities HTTP/1.1" 500 271 "-" "PostmanRuntime/7.29.0"
47370 - 172.17.0.1 - - [16/Apr/2022:03:30:23 +0000] "GET /?SERVICE=WMS&VERSION=1.3.0&Map=/etc/qgisserver/Proj2/Proj2.qgz&REQUEST=GetCapabilities HTTP/1.1" 500 271 "-" "PostmanRuntime/7.29.0"

[sskras]

@flykoh, which version of the image did you use here?
And have you fixed the error?