I mean, is there a difference in execution between `SELECT * FROM Stream WHERE @EventType = 0xxxxx AND RequestPath = '/'` and `SELECT * FROM Stream WHERE RequestPath = '/' AND @EventType = 0xxxxx` Does the WHERE conditions are evaluated in order of appearance ?
Posted by Guitou about a month ago
We rely heavily upon Seq and have been quite happy with it over the past year. However, today we found a considerable issue that resulted in us being basically blind to everything we were logging: an upstream DNS server was unresponsive. The UI on our Seq servers were rendered unresponsive apparently due to their attempts to reference external resources. Is there perhaps an alternate view that does not have this issue (maybe something we missed in the documentation)? Maybe something not quite as pleasant but still functional. If we suffer from some similar issue with an upstream provider during a critical issue then Seq will be virtually useless to us. Are we going to have to create our own UI? (Never happen, no time to spare) Or must we investigate alternatives?
Posted by Mike H about a month ago
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 month 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 3 months 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 3 months 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 3 months ago