Thanks Doug I will check into this further; I had always used APC UPS's
but of late units don't come with acceess to detailed logging details
wrt short surge type failures any more. I used to be able to get timing
messages from that log that helped in troubleshooting.
I have slowly changed to higher capacity CyberPower units with a bit
better monitoring and logging but still not a lot of of tech dails in
that even to satisfy my Retire Eng Etech background.
On 2022-06-27 16:55, Doug Jenkins wrote:
Andy:
I use dbeaver (dbeaver.io <http://dbeaver.io>) to manage all my
databases. It is a client tool, but it connects to MariaDB, MySQL, and
SQLite databases. You can manage the database here.
For your power problem, I would suggest NUT (Network UPS Tool). This
can run as a service on your linux server (Including RPi) and you can
configure it to talk directly to your UPS (they have many drivers).
Here is a good video walkthrough in setting up the tool and creating a
quick interface for it.
image.png
On Mon, Jun 27, 2022 at 5:32 PM VE4PER Andy
<[email protected]> wrote:
I had a major commercial power failure about 10 days ago. In the
process
it ran the UPS down almost completely such that when the last few
power
surge/bumps/fails occured something in the date time pointer
system , I
believe in the SQL databse became disconnected and immediate
restart of
the program on power restoral Had the local /var/www/html page was a
wrong date and the FTP'd page sent to my web site also had a corrupt
date/Time string and neither agreed nor were either at all real
cuurent
time accurate.
I shut down the PC with the intent of looking for a mySQL dB
troubleshooting/repair software application and attempting to correct
the corrupted data when I had time. About a week later I found
time to
take a look at the problem and when I restated the PC , with the
intent
of halting weewx to troubleshooting the dB. It all came back working
normally but with no back archived data available but it appears the
delay from it being down so long allowed it to restart and regenerate
the consistent web pages and messages.
So although it is back working now, I would like to know if their
is a
recommended dB software /data repair/maintenance package available
that
is open source freeware either standalone program or possibly
something
like a plug option/package to use with a browser similar to
phpmyadmin.
My 2nd takeaway is when urgent commercial power fails get to the
weewx
PC and shut it down immediately in an orderly fashion before the 8-10
min UPS backup support runs out.
Any pointers are welcome, considering so many outside agancies use
the
data (eg AWEKAS, CWOP/NOAA/aprs/ WeatherUnderground in addition to
my on
local and www page.
Thanks 73
Andy
--
You received this message because you are subscribed to the Google
Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:weewx-user%[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/31c1e793-4db7-672c-ffc0-01361e7aec82%40gmail.com.
--
You received this message because you are subscribed to the Google
Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/CACC0i0yma27VUTjTdoW-KedaMBZrrUYWhfBKj6tk4-krtyLtSA%40mail.gmail.com
<https://groups.google.com/d/msgid/weewx-user/CACC0i0yma27VUTjTdoW-KedaMBZrrUYWhfBKj6tk4-krtyLtSA%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/84dd1e8c-b971-db8a-f7a1-5a416860530f%40gmail.com.
