search

mskyttner / specify-docker

Dockerized system integration project for Specify software components (desktop client, web client, web asset server, report server)
GNU Affero General Public License v3.0
0 stars 0 forks source link

Queries cannot be saved to csv #3

Open ghost opened 4 years ago

ghost commented 4 years ago

In Specify7 UI under Queries, it's not possible to save the result as csv. The user sees this notification, but the file can not be downloaded because it doesn't exist. image

When clicking 'create CSV' -> opening notifications -> clicking 'Download', the following logs are generated: proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:34 +0000] "POST /stored_query/exportcsv/ HTTP/2.0" 200 2 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:34 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A50%3A28.647698 HTTP/2.0" 200 167 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:38 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A51%3A34.597989 HTTP/2.0" 200 2 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:44 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A51%3A34.597989 HTTP/2.0" 200 2 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:45 +0000] "GET /static/depository/query_results_2019-11-21T03:51:34.445781.csv HTTP/2.0" 404 556 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:50 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A51%3A34.597989 HTTP/2.0" 200 2 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" proxy_1 | nginx.1 | specify7.gnmspecify.se 138.233.204.64 - - [21/Nov/2019:09:51:57 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A51%3A34.597989 HTTP/2.0" 200 2 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92"

wsseven_1 | 172.22.0.2 - - [21/Nov/2019:09:57:43 +0000] "POST /stored_query/exportcsv/ HTTP/1.1" 200 12 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" "138.233.204.64" wsseven_1 | 172.22.0.2 - - [21/Nov/2019:09:57:45 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A56%3A13.310888 HTTP/1.1" 200 178 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" "138.233.204.64" wsseven_1 | 172.22.0.2 - - [21/Nov/2019:09:57:47 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A57%3A43.987581 HTTP/1.1" 200 12 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" "138.233.204.64" wsseven_1 | 2019/11/21 09:57:48 [error] 7#7: *18157 open() "/tmp/query_results_2019-11-21T03:57:43.836035.csv" failed (2: No such file or directory), client: 172.22.0.2, server: , request: "GET /static/depository/query_results_2019-11-21T03:57:43.836035.csv HTTP/1.1", host: "specify7.gnmspecify.se" wsseven_1 | 172.22.0.2 - - [21/Nov/2019:09:57:48 +0000] "GET /static/depository/query_results_2019-11-21T03:57:43.836035.csv HTTP/1.1" 404 556 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" "138.233.204.64" wsseven_1 | 172.22.0.2 - - [21/Nov/2019:09:57:53 +0000] "GET /notifications/messages/?since=2019-11-21T03%3A57%3A43.987581 HTTP/1.1" 200 12 "https://specify7.gnmspecify.se/specify/query/14/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36 OPR/64.0.3417.92" "138.233.204.64"

The relevant file in wsseven container seems to be /etc/nginx/conf.d which contains: location /static/depository/ { rewrite ^/static/depository/(.*)$ /$1 break; root /tmp; autoindex on; }