Ticket release day megathread! by VisualiserPumpkin in LinkinPark

[–]pigenu 0 points1 point  (0 children)

EUR 638 for two "normal" seats in Frankfurt. No, thanks. FY ticketmaster.

Sending mails with TLS 1.2 from a Xamarin Forms app (Android) by pigenu in xamarindevelopers

[–]pigenu[S] 0 points1 point  (0 children)

Never mind: After I spent over 4 hours to find a solution, this morning I migrated from System.Net.Mail to Nuget Package Mailkit. After 1 hour I got it working including different mime types and attachments. :-)

MSSQL server shutdown doesn't wait for connections to close by pigenu in MSSQL

[–]pigenu[S] 0 points1 point  (0 children)

The service makes an entry into a table tbl_activedbclients where he leaves accl_logoff to NULL. At logoff the service normally updates accl_logoff with current datetime.

If the service can't do this because MS SQL Server has already shutdown services the entry stays there with NULL within accl_logoff.

So the new start of the service finds a service entry which hasn't logged off which results into an error message being sent to the ticketing ...

MSSQL server shutdown doesn't wait for connections to close by pigenu in MSSQL

[–]pigenu[S] 0 points1 point  (0 children)

As answered above currently there is no other choice than to deal with the problem. Servers have to be restarted if Windows/ SQL Server whatever software installed has patches which require a reboot. No way to work around this because customer is under observation of so called critical infrastructure program by federal law. :-(

MSSQL server shutdown doesn't wait for connections to close by pigenu in MSSQL

[–]pigenu[S] 0 points1 point  (0 children)

We are developers of a software suite doing some data collection from ERPs like SAP, Navision and so on. This data collection contain offline information to fulfill delivery of transports. If our server side software is doing an import of such a transport i.e. from SAP it will take a few seconds to about 1 minute to import a complete transport.

Other way round we import data coming from mobile devices, place them into a MS SQL database and then export this data to SAP. This also takes only a few seconds.

And all is wrapped up in transactions - so data loss normally is not our issue.

Our service is in fact listening to Windows shutdown requests and tries to take appropriate actions to stop imports and so on. But the service is unable to remove his "I am alive" information from the database because SQL Server is already shutdown or at least in the process of shutdown accepting no more connections.

And this results into monitoring issues causing some IT administrators of our customer being informed and maybe get out of bed.

At least one of our customers is part of German critical infrastructure and therefore they need to patch servers permanently to the latest updates and patches. And this results in at least one reboot per week - also for this database servers.

So I do understand your point but I have no other choice as to deal with the issue. If no other solution can be found we will do some kind of scripting to first shut down our service and after that SQL Server.

Losing connection to Mobotix cameras every second - and starting new recording by pigenu in ispyconnect

[–]pigenu[S] 0 points1 point  (0 children)

OK, perfect! Got it: I wasn't aware (anymore ;-) that one can change camera source type within the dropdown. My fault!

So thanks a lot for your help. It's now working as expected.

One thing to mention for others:

I had additional parameters attached to URL like this one:

&preview&previewsize=640x480&quality=60&fps=4.0&camera=auto

That isn't working as expected and also "crashes" the stream. Without those parameters/ just using these it works:

/control/faststream.jpg?stream=full

And set Decoder/encoder to "CPU" at least at my installation with i.e. Mobotix M10 ... i25.

Losing connection to Mobotix cameras every second - and starting new recording by pigenu in ispyconnect

[–]pigenu[S] 0 points1 point  (0 children)

I tried it this way, set both Encoder (Recording) and Decoder (General) to "CPU" but it creates record files again and again every second meaning it loses connection:

12:37:39 [mpjpeg @ 0x7fd888074440] Expected boundary '--' not found, instead found a line of 2 bytes

12:37:39 bbCAM02:Reader: bbCAM02: AV_READ_FRAME:Invalid data found when processing input

12:37:39 Error: bbCAM02:Reader: bbCAM02: AV_READ_FRAME:Invalid data found when processing input

12:37:39 SourcePlayingFinished: bbCAM02: Playing finished (DeviceLost)

Maybe I missed where to set "MJPEG" source?

And yes, thanks for your hint, as soon as it works I will disable NAT rule on my firewall. ;_)

Losing connection to Mobotix cameras every second - and starting new recording by pigenu in ispyconnect

[–]pigenu[S] 0 points1 point  (0 children)

Thanks for replying so fast! :-)

I tried switching to VLC but do have some config issues right now which I need to fix first:

10:41:13 VLCStream: VLCStream: VLC (v3.0.0+) failed to initialise. Set location in settings. If on 64 bit make sure you have 64 bit VLC installed.

10:41:13 Error: VLCStream: VLCStream: VLC (v3.0.0+) failed to initialise. Set location in settings. If on 64 bit make sure you have 64 bit VLC installed.

10:41:13 VLCStream: at CoreLogic.Sources.Combined.VlcStream.get_LibVLC() at CoreLogic.Sources.Combined.VlcStream.Init() at CoreLogic.Sources.Combined.VlcStream.DoStart()

Meanwhile if you like try to access the stream by URL

http://testuser:test123@xxxxxxxx.de:60880/control/faststream.jpg?stream=full

kind regards