Date: Thu, 18 Jan 2024 13:33:05 -0500
Hi All,
Last year we also updated our aging BMPC1 to a BMPC/2. It's currently
running Win7 on an isolated internal lab network. I've installed TigerVNC
< https://tigervnc.org/ > and use Apache Guacamole < https://github.com/flcontainers/guacamole >
for remote VNC access. This works great. We also have our own SMTP relay
(postfix) that receives mail and forwards it to us via the campus mail servers.
If you're having trouble getting smtp to work I suggest taking a look at one
of the "dev" email servers, something like maildev < https://github.com/maildev/maildev > or
smtp4dev <https://github.com/rnwood/smtp4dev >. They make it really easy to
track down where your hiccups are. I also heavily use Zerotier <https://www.zerotier.com/ >
to get *around* the campus firewalls.
I'm a linux guy and like to plot everything in Grafana
<https://grafana.com/ > which pulls data from InfluxDB. Honestly Grafana
has been the best addition to our lab hands down. It makes it so easy to
*see* trends over time and to even go back in time to check something.
The BMPC squirrels everything away into its own database at (in our case)
c:\bruker\bmpc2\BMPC2 Control\db\log.mdb. Unfortunately this is a
Microsoft ACCESS db file and kind of a pain to use. I use syncthing
<https://syncthing.net/ > to copy to one of my servers and then use mdb-sql
<https://www.kali.org/tools/mdbtools/ >to spit out the data. It's then
ingested by NodeRED <https://nodered.org/ > command node and put into my own
InfluxDB. Like this:
echo "Select
index,datetime,channelvalue1,channelvalue2,channelvalue3,channelvalue4,channelvalue5,channelvalue6,channelvalue7,channelvalue8 from datalog" | mdb-sql -P -d=, -H -F /home/justin/bmpc-data/db/log.mdb | tail -n 1 > /tmp/datalog-copy.csv
From there Grafana reads and plots the data from InfluxDB. We can access
it from the internet, set alerts, emails, all the things. It's much more
friendly than the BMPC interface itself. My only complaint is even though
we've set it to write data every 5 minutes, the mdb file is only closed and
updated every 20-30 minutes. So it's been on my mind to use an arduino
with a canbus adapter
<https://www.amazon.com/Comidox-MCP2515-Receiver-Controller-Development/dp/B07J9KZ4L4/ref=asc_df_B07J9KZ4L4/?tag=hyprod-20&linkCode=df0&hvadid=507831081029&hvpos=&hvnetw=g&hvrand=7557380611072980419&hvpone=&hvptwo=&hvqmt=&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9017361&hvtargid=pla-1247317279154&psc=1&mcid=e41e629033ab3d16a20c9f35f422ff0c&gclid=Cj0KCQiAtaOtBhCwARIsAN_x-3Jq-hIaJd_ydAP5SsJ10Fqk03ZiO1Lpr29cN06_fza6NUOIUWwiLykaAj6oEALw_wcB >
and sniff the data directly. Maybe someday.
https://pydio.campus.nd.edu/grafana/dashboard/snapshot/6NDM1DNbn7SR8CxaffiN6P3SNYntipQG
--Justin
On Thu, Jan 18, 2024 at 11:32 AM Platz Hirsch <ammrl_at_haessner.com> =
wrote:
> Dear Mike,
>
>
>
> a few years ago during my active work in Munich I created a complete
> solution to connect the BMBC computer via an additional gateway computer to
> the internet.
>
> This gave you access to a bunch of values and made a complete remote
> control of this unit using the RDP protocl possible.
>
> This was possible without security issues, because the gateway computer
> excluded any direct routing. You could apply any kind of security
> configuration to the gateway computer.
>
>
>
> Data became extracted from the BMPC - I belive they internally use an
> access database - converted and stored within a munin database and at least
> during my active time displayed using the rrdtools.
>
> Some alerts were configured too.
>
>
>
> As far as I know this installation is still running.
>
>
>
> That time I made a step by step explanation, how to install everything.
> It's written in german language. I am rather sure, that this tutorial still
> exists.
>
>
>
> I have no access and of course cannot decide about this material. But the
> people, now responsible, are reading here and they will get in touch with
> you with some probability.
>
>
>
> Greetings
>
>
>
> Rainer
>
>
>
-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#944): https://urldefense.com/v3/__https://ammrl.groups.=
io/g/main/message/944__;!!PvDODwlR4mBZyAb0!UO7SOnednwNWqd_BBsq6ltc4wggPLvVr=
NAoRWEDpBmVm6kzoZQSvuUEQLx84mxa5tP44NjI3c6OH_IlPdhkD-khYpvw$
Mute This Topic: https://urldefense.com/v3/__https://groups.io/mt/103809147=
/7559972__;!!PvDODwlR4mBZyAb0!UO7SOnednwNWqd_BBsq6ltc4wggPLvVrNAoRWEDpBmVm6=
kzoZQSvuUEQLx84mxa5tP44NjI3c6OH_IlPdhkDQ4R5XB8$
Group Owner: main+owner_at_ammrl.groups.io
-=-=-=-=-=-=-=-=-=-=-=-
(image/png attachment: image.png)
(image/png attachment: 02-image.png)