search

camptocamp / docker-qgis-server

All that is needed to generate a proper QGIS server image
GNU General Public License v2.0
39 stars 8 forks source link

sql server layer #328

Open flykoh opened 2 years ago

flykoh commented 2 years ago

when project have layer from sql server? i got error 500

Layer(s) not valid
flykoh commented 2 years ago

i got also QSqlDatabase: QODBC driver not loaded

how can i load the driver

flykoh commented 2 years ago

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

flykoh commented 2 years ago

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_RUNTIMEDIR 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 commented 2 years ago

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