It would be nice to have some kind of `CASE WHEN... THEN ... ELSE.. END` function that we could use in the SELECT part of a query. This way we could 'transorm' data like ```SQL SELECT CASE HealthCheckStatus WHEN 0 THEN 'Unhealthy' WHEN 1 THEN 'Degraded' WHEN 2 THEN 'Healthy' END AS Health status FROM Stream
Posted by Guilhem about a year ago
We are in the process of procuring a license for SEQ. As part of our software procurement process, we need to carry out an assessment of the security of the software/system. Do you have documentation detailing ... - how security is built into the software by design? - how identified vulnerabilities in the system are responded to? - frequently security & bug patches are released? - authentication and restricted access controls in the functionality of the system? - passwords are securely stored? - data in transit is encrypted? - (any other security related issues or items) Kind Regards, Eamonn Pugh
Posted by Eamonn Pugh about a year ago
Hello, I have stored the SEQ Docker Image 5.1 in an Azure Container Instance and connected it to an Azure File Share. The file share is displayed inside the container in the interactive bash. Using the bash console I can also navigate within the share and display subdirectories and files and create new files. These files are then displayed in the FileShare of the storage account and I can download them. But SEQ itself does not write anything into the mounted path. But in the Environment Settings of the container I set the HOST_PATH_TO_SEQ to this path. Does SEQ still need any permissions on the mounted path? Translated with www.DeepL.com/Translator (free version)
Posted by Christian Bohnebuck about a year ago
We are putting together the implementation for SEQ on our solution. The infrastructure provider is providing the bulk storage through SAN. Can we store the data SEQ is collecting to a UNC shared folder path instead of a local drive mapping?
Posted by Carl about a year ago
From reading the discussions on this site as well as the Seq documentation; I'm left with the belief that organizations are deploying Seq on a standalone server that is receiving log events from multiple application servers. I'm looking for any Seq documentation suggesting this is a recommended deployment strategy. Is there any documentation suggesting how many transactions per second a central server could reliably process? I'm also looking for Seq documentation describing how log events written to the Seq sink from an application utilizing Serilog are managed in an environment that experiences network disruption. I want to understand if there will be a loss of log events or if the sink will buffer these events.
Posted by Brian Johnston about a year ago
I tried to follow the instructions here: https://docs.datalust.co/docs/signals But I get an error when saving: Could not save current signal An unhandled error occurred while serving the request (token: a3ee99....). Some advice?
Posted by Jiří Trávníček about a year ago
Hi there. I did the MSI install for Windows with the default http only configuration. Everything seems to install fine but when I navigate to http://localhost:5341/ I get a 307 redirect and then the message "The connection for this site is not secure". I've been able to navigate other http only sites before so I'm guessing it's not the browser.
Posted by Troy Hughes about a year ago
We've been using Seq's ability to serialize complex structures into the structured message. When it comes to querying that data later on, for some collections that are indexed by string, seq uses the strings to access them via query. This is fine as long as the string contains no white space, but when the string is something like 'Input Power' there doesn't seem to be any way of accessing it via query. "select Telemetry.Input Power" => this doesn't work. Fails with ' unexpected identifier `Power`' "select Telemetry.Input%20Power" => this doesn't work. Fails with 'Syntax error (line 1, column 26): unexpected `P`, expected digit.' Is there any way to access a property with a white space in the name?
Posted by Aaron Schnarr about a year ago
I'm trying to use Sqelf to capture logging from a container in my docker-compose application. Using the simplest version of a docker-compose file I can manage, I am unable to properly connect to sqelf from the container that I want to capture logging from. I get the same error every time: failed to initialize logging driver: gelf: cannot connect to GELF endpoint: sqelf:12201 dial udp: lookup sqelf on 192.168.65.1:53: no such host The docker-compose file I'm using looks like this: version: '3' services: sqelf: image: datalust/sqelf:latest depends_on: - seq ports: - "12201:12201/udp" environment: SEQ_ADDRESS: "http://seq:5341" restart: unless-stopped seq: image: datalust/seq:latest ports: - "5341:80" environment: ACCEPT_EULA: Y restart: unless-stopped volumes: - ./seq-data:/data redis: image: "redis:alpine" logging: driver: gelf options: gelf-address: "udp://sqelf:12201" If I remove the logging configuration from the redis service, redis starts just fine and logs to the console. If I inspect the docker network created by docker-compose and use the ip address of the sqelf container instead of the hostname in the gelf-address configuration, logging is correctly routed to sqelf and then to Seq. I'm stumped as to what the problem is or how to fix it.
Posted by Marty Tippin about a year ago
is it there any way of install the extension out of GUI. i Understand we do have option of installing Nuget package under/settings/Apps. our objective is to install that package through powershell. we don't want to install that manually. is it possible to do so?
Posted by Varun kumar about a year ago
I'm considering using Seq for logging from multiple .NET apps. Some apps are ASP.NET Core web apps and some are .NET Core console apps. We run all of our apps on a well-provisioned Azure VM running Windows Server 2016 Datacenter. I want to know if there are any caveats to installing Seq on this same server other than performance concerns. My main concern is than since this server is running IIS, I wouldn't want Seq to clash with IIS in any way. I can't think of why it would, but I wanted to make sure before I install Seq there. Thanks! Randy
Posted by Randy Blackmond about a year ago
I followed the steps to add AAD integration for authentication. There seems to be two issues. 1. The redirect url in the login request is http and https as specified in the azure portal (the seq server is served at https) 2. When correcting the redirect url by editing inn the browser address bar, it complains about the client secret being invalid. So I am unable to get into the server to check/change the client secret
Posted by Thor Arne Johansen about a year ago
I'm using Seq v51.3364 through Serilog. The events display shows the date time of the event with .000 as the milliseconds. If I hover on the timestamp the millisecond is displayed in the hyperlink. Is this a configuration option, a design choice, a bug? Are the entries displayed descending timestamp, including millisecond even though not displayed? (Is there a way to post an image with the question?)
Posted by Al Schrank about a year ago
I've configured my Seq like this: api.ingestionPort=8111 api.listenUris=https://example.net:8111,http://localhost:8888 I've also associated the SSL certificate to the port 8111. If I try to access http://localhost:8888, everything works as expected. However, once I try to access https://example.net:8111, either via the machine where Seq is hosted or from another computer, I always get the following message: Error 403: "Forbidden." How can I fix this?
Posted by Pedro Faustino about a year ago