Re: [weewx-user] weewx sql database repair tools

2022-06-28 Thread VE4PER Andy
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 
 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 weewx-user+unsubscr...@googlegroups.com
<mailto:weewx-user%2bunsubscr...@googlegroups.com>.
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 weewx-user+unsubscr...@googlegroups.com.
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_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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/84dd1e8c-b971-db8a-f7a1-5a416860530f%40gmail.com.


Re: [weewx-user] weewx sql database repair tools

2022-06-28 Thread VE4PER Andy
I am not exactly sure what occurred which is why I was looking for a 
tool to inspect it deeper. Only thing I know for sure was that UPS 
backup was so run down and deteriorated that the commercial power 
slamming off and on in rapid succession was passed through to the PC and 
if it occurred right during a data update cycle from the sensors somehow 
the whole transaction became so confused that the local page in the 
/var/www/html folder did not have a correct date time string on it; and 
a simmilar problem happened to the report generated for transfer via ftp 
to my personal web page. and neither of these agreed with each other. 
and neither was the actual time of the data update. Successive updates 
or page reloads/refreshes displayed these same frozen data pages. Once 
the system shut down for a week and restarted it began with no existing 
archive data showing on any graphs but current display data from sensors 
properly processed and updated properly every 5 mins approx.



On 2022-06-27 18:01, Tom Keffer wrote:
Not clear what you're asking, but I'd like to know more about the 
corruption of the database. I spent a lot of time making sure that 
commits were atomic. Did I miss something? Could you be more specific 
about what's wrong with the database?


On Mon, Jun 27, 2022 at 2:32 PM VE4PER Andy 
 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 weewx-user+unsubscr...@googlegroups.com
<mailto:weewx-user%2bunsubscr...@googlegroups.com>.
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/CAPq0zEDqJCB-hn39gPTFqVUg%3DRmerrsqAFWqDLx6%2Bxxztq%3DYQg%40mail.gmail.com 
<https://groups.google.com/d/msgid/weewx-user/CAPq0zEDqJCB-hn39gPTFqVUg%3DRmerrsqAFWqDLx6%2Bxxztq%3DYQg%40mail.gmail.com?utm_medium=email_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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d41ca5ad-25b7-86f2-6e77-c049bb0c34e6%40gmail.com.


[weewx-user] weewx sql database repair tools

2022-06-27 Thread VE4PER Andy
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/31c1e793-4db7-672c-ffc0-01361e7aec82%40gmail.com.


[weewx-user] #interaction between different mfrs display units and wx stns query

2022-01-11 Thread VE4PER Andy
I am running an ACURite 1035 local wx stn. and comms between sensor on 
mast and indoor display unit is in 430 MHz band area.


I recently bought a Taylor remote indoor/outdoor temp monitor unit with 
outdoor temp sensor and indoor display unit; testing the remote sensor 
showed it did not work. Need to determine if sensor is faulty or is 
being interfered with by another neighbour's sensor or other source of 
RFI/EMI . Disabling the outdoor sensor the display unit appears to have 
locked onto either another Taylor sensor in a neighbour's yard or else 
the format is compatible with my ACURite station because the Taylor 
display unit is displaying and tracking the actual outdoor temp 
correctly without my remote sensor being activated.


My purpose for needing the remote sensor was to place it in a partially 
heated container outside and monitor temp so couriers can leave 
temperature sensitive medical sensors inside the box to avoid freezing 
and damaging the medical sensors.


Anyone have any tech spectrum info on the Taylor units? Contacting 
Taylor got me handed off to another instrument mfr and then to another 
USA mfr who has not replied at all.



Thanks for whatever info you may offer.


--
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/1635e0fd-1baf-25db-ffb0-51f94b218406%40gmail.com.


Fwd: [weewx-user] Fog detection?

2021-08-31 Thread VE4PER / Andy


per request

 Forwarded Message 
Subject:Re: [weewx-user] Fog detection?
Date:   Tue, 31 Aug 2021 15:26:46 -0500
From:   VE4PER / Andy 
To: Greg Troxel 



I think the sensor is referred to as transmissometer; usually in pro 
unattended observer stations that is used and also a similar ceilometer 
for cloud heights


On 2021-08-31 3:19 p.m., Greg Troxel wrote:

František Slimařík  writes:


I got question for hardcore meteorologists here. Is it possible to detect
fog based on classic meassured values like temperature, humidity, 
preasure,

etc?
Logically I would say fog appears when dew point equals current
temeperature but I guess it will not be so easy. Fogs didn't appear here
this year in my locality so I am waiting for autumn to start with
observations.

Good question, but my impression is that it is really difficult to
measure humidity above 95%. I more or less have the impression that
fog happens when temp/dewpoint are about the same and the temperature
falls.

I think you need a fog sensor that actually measures impaired light
transmission. Surely there is a norm for measuring that already. I
need one too, right after I build a seismograph.



--
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/20fd4e10-0950-238c-5319-a488123f7618%40gmail.com.


Re: [weewx-user] Data Not Being Stored in Database

2020-09-09 Thread VE4PER / Andy
I noticed similar situation with mine also. Except I discovered it in 
message in Acurite 1035 Display Unit ticker window "Data Logger Full 
Please Connect to PC to Transfer Data" . I assumed USB connection was 
hung up for some reason and did full PC restart and Display Unit Reset; 
just waiting to see if error returns. Current data transfers via ftp etc 
appear to be getting sent to AWEKAS, CWOP, WeatherUnderground and 
personal website OK (ftp).


Platform is linux ubuntustudio 20.04 LTS and database is MariaDB also.

cheers ,73 & Gud DX


On 2020-09-09 8:22 a.m., jone...@gmail.com wrote:
I've been running Weewx for about 6 years now on a Raspberry Pi and 
storing data in a MariaDB database.  My Pi died about a month ago.  I 
though it was the Pi itself, but it turned out to be the SD card.  Set 
up a new Pi 3 and configured it to send data to the MariaDB, however 
after a little testing I  noticed that Weewx stopped recording data in 
the database in 2017 and still isn't inserting data.  I used the 
utilities and pulled all of my data down from Weather Underground 
using the Weewx utilities and got the database updated.  Weewx still 
doesn't insert data into the database.  It does continue to send data 
to Wunderground, just won't put it into the database.  I thought there 
could be an issue with the database so I backed up my data, deleted 
the database and had Weewx create a new database, still not adding 
data.  I've double/triple checked the database connection strings.  
I've removed the password and get an error that it can't connect.  It 
used the config files to create the new database, so it can connect 
and is going to the correct database.  Just isn't adding records.  
I've set the logging to debug and there are no errors in the logs. I'm 
at a loss.  Anything else I can check? --
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 weewx-user+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/40406f90-2f4a-4785-a0b2-2de05e16ee8dn%40googlegroups.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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/5c47436c-589c-1985-f63f-35000f3d1c32%40gmail.com.


Re: [weewx-user] Fwd: weewx wx data not updating to display html files

2020-08-21 Thread VE4PER / Andy

Hi Graham

I did as you suggested but also changed USB port it is connected to and 
it started working again. so we just keep your suggestions in email in 
archives here for future troubleshooting


Thanks for the tips and your time and trouble.


On 2020-08-21 12:43 a.m., Graham Eddy wrote:

could you turn on debug (try level 2) and repost log?
also, could you post last ten entries of archive table? (only dateTime 
and outTemp needed)

cheers

On 21 Aug 2020, at 3:39 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO __main__: Debug is 0


--
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 weewx-user+unsubscr...@googlegroups.com 
<mailto:weewx-user+unsubscr...@googlegroups.com>.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/5BB82252-6288-4334-B4B6-7FE349588987%40gmail.com 
<https://groups.google.com/d/msgid/weewx-user/5BB82252-6288-4334-B4B6-7FE349588987%40gmail.com?utm_medium=email_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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/3efb8e49-80c5-cf6f-74ba-fe159455d5f9%40gmail.com.


[weewx-user] Fwd: weewx wx data not updating to display html files

2020-08-20 Thread VE4PER / Andy
It would appear that attachments prevent distribution so here is text 
contents of original message syslog info minus png of html page display.


* Forwarded Message *

Subject:*weewx wx data not updating to display html files*
Date:   *Thu, 20 Aug 2020 23:07:33 -0500*
From:   *VE4PER / Andy *
To: *weewx-user *

***
**
**I just began having problem with weewx suddenly not inserting data 
into files properly.**

**
**I tried stopping and restarting weewx, then rebooting the PC, to no 
avail them remove weewx software saving config files and reinstalling 
weewx software**

**
**still no joy. The output html files I use to monitor stn output (ie 
local html copy and ftp'd cop to my personal web site) get generated 
properly as the date time is updated correctly with each update every 
300 secs but all data slots display N/A.**

**
**The SQL database using phpmyadmin  shows data normal as do syslog 
message indications (see att docx) and the AcuRite display shows data is 
being updated correctly from the 5 in 1 sensor. lsusb shows the display 
unit is being properly detected and proper driver loaded yet no data is 
being inserted.**

**
**Attached docx file shows syslog sequence for  start stop of weewx and 
two successive update sequences with apparently no tech errors.**

**
**Any assistance would be appreciated; thanks**
**
**73 & Gud DX Andy*

{user ID}@{w/s ID}:~$ sudo tail -f /var/log/syslog


Aug 20 22:23:56 {w/s ID} weewx[12963]: ...done.

Aug 20 22:23:56 {w/s ID} systemd[1]: weewx.service: Succeeded.

Aug 20 22:23:56 {w/s ID} systemd[1]: Stopped LSB: weewx weather system.

Aug 20 22:24:22 {w/s ID} systemd[1]: Starting LSB: weewx weather system...

Aug 20 22:24:22 {w/s ID} weewx[13017]: * Starting weewx weather system weewx

Aug 20 22:24:22 {w/s ID} weewx[13046] INFO __main__: Initializing weewx 
version 4.1.1


Aug 20 22:24:22 {w/s ID} weewx[13046] INFO __main__: Using Python 3.8.2 
(default, Jul 16 2020, 14:00:26) #012[GCC 9.3.0]


Aug 20 22:24:22 {w/s ID} weewx[13046] INFO __main__: Platform 
Linux-5.4.0-42-lowlatency-x86_64-with-glibc2.29


Aug 20 22:24:22 {w/s ID} weewx[13046] INFO __main__: Locale is 'en_CA.UTF-8'

Aug 20 22:24:22 {w/s ID} weewx[13046] INFO __main__: PID file is 
/var/run/weewx.pid


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO __main__: Using configuration 
file /etc/weewx/weewx.conf


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO __main__: Debug is 0

Aug 20 22:24:22 {w/s ID} weewx[13049] INFO weewx.engine: Loading station 
type AcuRite (weewx.drivers.acurite)


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO weewx.drivers.acurite: driver 
version is 0.4


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO weewx.drivers.acurite: R2 
will be decoded using sensor constants


Aug 20 22:24:22 {w/s ID} weewx[13049] INFO weewx.engine: StdConvert 
target unit is 0x10


Aug 20 22:24:22 {w/s ID} weewx[13017]: ...done.

Aug 20 22:24:22 {w/s ID} systemd[1]: Started LSB: weewx weather system.

Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.wxservices: The 
following values will be calculated: pressure=prefer_hardware, 
barometer=prefer_hardware, altimeter=prefer_hardware, 
windchill=prefer_hardware, heatindex=prefer_hardware, 
dewpoint=prefer_hardware, inDewpoint=prefer_hardware, 
rainRate=prefer_hardware, maxSolarRad=prefer_hardware, 
cloudbase=prefer_hardware, humidex=prefer_hardware, 
appTemp=prefer_hardware, ET=prefer_hardware, windrun=prefer_hardware


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.wxservices: The 
following algorithms will be used for calculations: altimeter=aaASOS, 
maxSolarRad=RS


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.engine: Archive will 
use data binding wx_binding


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.engine: Record 
generation will be attempted in 'hardware'


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.engine: Using archive 
interval of 300 seconds (specified in weewx configuration)


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: StationRegistry: 
Station will be registered.


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: 
Wunderground-PWS: Data for station IPORTAGE5 will be posted


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: PWSWeather: Data 
for station VE4PER will be posted


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: CWOP: Data for 
station VE4PER will be posted


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: WOW: Posting not 
enabled.


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.restx: AWEKAS: Data 
will be uploaded for user VE4PER


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO __main__: Starting up weewx 
version 4.1.1


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.engine: Using binding 
'wx_binding' to database 'weewx'


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.manager: Starting 
backfill of daily summaries


Aug 20 22:24:23 {w/s ID} weewx[13049] INFO weewx.engine: Starting main 
packet loop.


Aug 20 22:25:17 {w/s ID} weewx[13049] 

Fwd: Re: [weewx-user] Newbie Looking For Hardware Recommendations

2020-06-29 Thread VE4PER / Andy

FYI for the group



 Forwarded Message 
Subject:Re: [weewx-user] Newbie Looking For Hardware Recommendations
Date:   Mon, 29 Jun 2020 15:31:02 -0500
From:   VE4PER / Andy 
To: Anthony 



Anthony,

I am using an AcuRite 1035 5 in 1 sensor system here and weewx linux 
software. The system has been fairly reliable for the price (about $135 
- $155 for display/usb comm unit and outdoor mast sensor unit freight 
included) The only problem I have with it is the wind speed anemometer 
cups got broken on a battery change session and I ordered a whole 
replacement 5 in 1 sensor unit to replace it through amazon and they 
sent two units, supposedly new , that were both U/S. One had no 433 MHz 
RF output to talk to display unit and 2nd one had RF but no data stream. 
So sent both back. While waiting to sort it out I came across 
replacement cups that were inexpensive (less than $15 Cdn) free shipping 
if combined with something else so I ordered a set and repaired my 
current 5 in 1 sensor and it is back online now. It feeds CWOP, AWEKAS, 
WeatherUnderground as well as my own web site in addition to WEEWX 
site/maps.


I am a radio amateur and only interested in it from CANWARN/SKYWARN 
perspective so am not into as much data manipulation or coding of 
presentations. I have it running and feeding a MySQL/MariadB  on the 
same UbuntuStudio 20.04LTS machine. I like that optionas I can access 
the data with LibreOffice Base report generators and/or MS Access odbc 
connections and use it as interface to generate reports from there as 
well. I have been planning to have the SQL dB run on a separate 
dedicated server box, fortunately I have been a little slow in 
implementing that as vers 20.04LTS recent updates have made some changes 
that would affect the operation of the nfs-kernel-server such that it 
does not start without errors now and thus not a reliable connection 
resource for weewx.  dB resident on same machine as weewx avoids that so 
something to keep in mind.


Libre Office base is not yet as mature and super user intuitive and 
friendly as Access esp when using visual design views to run different 
types of queries easily. SELECT ones are OK but if you want to do UPDATE 
or other types the visual tools aren't there yet and one has to fall 
back on pure SQL text strings to do the job which isn't super convenient.


I don't have lightning sensors either but would definitely be of use to me.

When AWEKAS emails failure reports to me troubleshooting the comm link 
between the sensor and display unit is great help; I am using an RSP1A 
SDR receiver that can tune up into the 433 MHz freq band and sees the RF 
signals and rich T in a couple of previous posts here in the last couple 
of days has a way to decode those signals so you can see the actual real 
data sent from the sensor to the display to confirm it is serviceable.


If your interest lies in coding a bit with different skins etc to 
manipulate the interpretations of a lot of the data them probably await 
comments from a few others in the group here.


Cheers and good luck deciding  ---> choices are as wide and they are 
long LOL



On 2020-06-29 2:16 p.m., Anthony wrote:

Hello!

I am interested in starting down the rabbit hole that is weather 
stations and data logging.  I've had a simple weather station for 
about 10 years (a simple indoor and outdoor temperature probe setup 
with standalone display), but this weather station recently bit the 
dust.  I figure it's time to step up.  I'm a geek/nerd by nature 
(sysadmin by trade) and the idea that I can build a WeeWX server and 
collect local weather data sounds like a lot of fun.


I'm looking at the list of supported hardware 
(http://weewx.com/hardware.html) and my head is starting to spin, 
heh.  I'm hoping the fine folks of this list can help point me in a 
direction.


I'm looking for a setup that meets the following requirements:

    - A "dummy resistant" local display for the family.
    - Multiple datapoints...Temp, wind speed, wind direction, rain 
gauge, relative humidity
    - The ability to collect data "off the grid". Meaning, I don't 
want to be dependent on any sort of "cloud" service.


Some things that would be nice, but are definitely not required:

    - Lightning detection would be neat, I think.  Or at least the 
ability to *add* a lightning detection sensor.
    - Hard-wired sensor array (I am no stranger to pulling cable).  My 
philosophy is that if it's a fixed device, it is cabled. :-D


I don't have a particular budget in mind.  My initial gut is to try to 
spend no more than ~$200 or so (excluding installation stuffs), but 
this is flexible if there is compelling reasons to expand the budget.


Any advice would be very much appreciated.

Thanks in advance!

~ Anthony
--
You received this message because you are subscribed to the Google 
Groups "weewx-user" group.
To unsubscribe from this group and st

[weewx-user] AcuRite 1035 UHF data link tech characteristics query

2020-06-27 Thread VE4PER / Andy
I am trying to get SDR Uno &  RSP1A to detect and decode signal between 
5 in 1 sensor unit to display unit so I can have a backup diagnostic to 
verify that data comm link.


I can see what appears  I suspect to be it, but it looks like 
cyclical/repetitive  short bursts on the same approx length of xmssn as 
FT8, but the bursts seem to be occurring on six different discreet UHF 
freqs in a channel width of about 433.8 MHz to 434.1 MHz.


Does anyone have any more tech info about this beyond AcuRite's brochure 
that just says it is in 433 MHz band area? I can feed detected burst 
audio via VAC to decoders of sorts but need to know what program to use 
to detect and decode it.


Does each sensor on the mast unit xmit on it's own? I can maybe grab a 
short vid clip to show it if that might be of use?


Thanks for any info.

73 & Gud DX


--
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/8bd1af9c-a5af-a8c1-3604-e0bed165eada%40gmail.com.


Re: [weewx-user] weewx 4.1.1.1 error query

2020-06-07 Thread VE4PER / Andy

OK thanks found the site   http://www.weewx.com/stations.html


On 2020-06-07 3:01 a.m., Graham Eddy wrote:

you should have a line like the following under [Station] stanza:
    station_url = http://www.example.com< < < < your weather station 
website
this is required along with ‘register_this_station = true’ to 
register, but it is harmless if you do not register station


this is the second of two fundamental stanzas in your weewx.conf. i 
don’t know the history of your confg file, but i recommend a thorough 
comparison with a recent distribution to look for more gaps.

cheers
g-eddy

On 7 Jun 2020, at 5:55 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


Thanks for your time and tips Graham.

Andy


weewx.conf entries StdRESTful related

I changed the red statements to what is shown in green below; the key 
error appears corrected but I got the following error msg about 
missing station URL and not sure where to specify it or what format 
it has to be.


Everything appears to work properly now and wx data is being sent but 
wind data will be in error until I get replacement anemometer cups 
(enroute I'm told)


Jun  7 02:22:27 cedar weewx[49295] INFO weewx.restx: StationRegistry: 
*Station will not be registered: no station_url specified.**

*



#   This section is for uploading data to Internet sites
#
#[StdRESTful]
 #
  #  [[StationRegistry]]
    # To register this weather station with weewx, set this to true
   # register_this_station = false

#   This section is for uploading data to Internet sites

[StdRESTful]

   [[StationRegistry]]
    # To register this weather station with weewx, set this to true
    register_this_station = true

   #   This section configures the internal weewx engine.

[Engine]

    [[Services]]
    # This section specifies the services that should be run. 
They are

    # grouped by type, and the order of services within each group
    # determines the order in which the services will be run.
    prep_services = weewx.engine.StdTimeSynch
    data_services = ,
    process_services = weewx.engine.StdConvert, 
weewx.engine.StdCalibrate, weewx.engine.StdQC, 
weewx.wxservices.StdWXCalculate

    archive_services = weewx.engine.StdArchive
    restful_services = weewx.restx.StdStationRegistry, 
weewx.restx.StdWunderground, weewx.restx.StdPWSweather, 
weewx.restx.StdCWOP, weewx.restx.StdWOW, weewx.restx.StdAWEKAS

    report_services = weewx.engine.StdPrint, weewx.engine.StdReport





On 2020-06-07 1:54 a.m., Graham Eddy wrote:
you would probably get that error if you tell weewx to use 
StdStationRegistry service e.g. in weewx.conf something like:

    restful_service = weewx.restx.StdStationRegistry, ...
but not defined a RESTful definition stanza in weewx.conf e.g.
    [StdRESTful] < < < < this key missing
    [[StationRegistry]]
  register_this_station = true
g-eddy

On 7 Jun 2020, at 4:16 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


My wind speed cups are physically broken; so no wind data 
---awaiting delivery of parts and since it is down anyway I decided 
to do all the updates now while I wait.


I recently upgraded ubuntu OS to 20.04LTS, python to python3 and it 
appears the update process also updated weewx to 4.1.1.1.


It appears that the install properly created the mysql/MariadB 
weewx and set up data tables properly.


However, some error messages showed up when I used the "sudo tail 
-f /var/log/syslog" command after database update was successful. 
Some were clearly missing modules that I was able to install and 
clear those up but one repeated one I don't understand what it is 
telling me nor what process to follow to correct it, it seems 
possibly something related to a common key error that appears to 
apply to a number scripts/program code strings?


Jun 7 01:08:04 cedar weewx[47128] CRITICAL __main__: Caught 
unrecoverable exception:
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
'StdRESTful'
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
Traceback (most recent call last):
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewxd", line 148, in main
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
engine = weewx.engine.StdEngine(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 75, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  
self.loadServices(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 138, in loadServices
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
obj = weeutil.weeutil.get_object(svc)(self,config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
Fi

Re: [weewx-user] weewx 4.1.1.1 error query

2020-06-07 Thread VE4PER / Andy

OK

tis done Sir.

where is web site with registered station located? Never cam across it 
in any docs so far


On 2020-06-07 03:01, Graham Eddy wrote:

you should have a line like the following under [Station] stanza:
    station_url = http://www.example.com< < < < your weather station 
website
this is required along with ‘register_this_station = true’ to 
register, but it is harmless if you do not register station


this is the second of two fundamental stanzas in your weewx.conf. i 
don’t know the history of your confg file, but i recommend a thorough 
comparison with a recent distribution to look for more gaps.

cheers
g-eddy

On 7 Jun 2020, at 5:55 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


Thanks for your time and tips Graham.

Andy


weewx.conf entries StdRESTful related

I changed the red statements to what is shown in green below; the key 
error appears corrected but I got the following error msg about 
missing station URL and not sure where to specify it or what format 
it has to be.


Everything appears to work properly now and wx data is being sent but 
wind data will be in error until I get replacement anemometer cups 
(enroute I'm told)


Jun  7 02:22:27 cedar weewx[49295] INFO weewx.restx: StationRegistry: 
*Station will not be registered: no station_url specified.**

*



#   This section is for uploading data to Internet sites
#
#[StdRESTful]
 #
  #  [[StationRegistry]]
    # To register this weather station with weewx, set this to true
   # register_this_station = false

#   This section is for uploading data to Internet sites

[StdRESTful]

   [[StationRegistry]]
    # To register this weather station with weewx, set this to true
    register_this_station = true

   #   This section configures the internal weewx engine.

[Engine]

    [[Services]]
    # This section specifies the services that should be run. 
They are

    # grouped by type, and the order of services within each group
    # determines the order in which the services will be run.
    prep_services = weewx.engine.StdTimeSynch
    data_services = ,
    process_services = weewx.engine.StdConvert, 
weewx.engine.StdCalibrate, weewx.engine.StdQC, 
weewx.wxservices.StdWXCalculate

    archive_services = weewx.engine.StdArchive
    restful_services = weewx.restx.StdStationRegistry, 
weewx.restx.StdWunderground, weewx.restx.StdPWSweather, 
weewx.restx.StdCWOP, weewx.restx.StdWOW, weewx.restx.StdAWEKAS

    report_services = weewx.engine.StdPrint, weewx.engine.StdReport





On 2020-06-07 1:54 a.m., Graham Eddy wrote:
you would probably get that error if you tell weewx to use 
StdStationRegistry service e.g. in weewx.conf something like:

    restful_service = weewx.restx.StdStationRegistry, ...
but not defined a RESTful definition stanza in weewx.conf e.g.
    [StdRESTful] < < < < this key missing
    [[StationRegistry]]
  register_this_station = true
g-eddy

On 7 Jun 2020, at 4:16 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


My wind speed cups are physically broken; so no wind data 
---awaiting delivery of parts and since it is down anyway I decided 
to do all the updates now while I wait.


I recently upgraded ubuntu OS to 20.04LTS, python to python3 and it 
appears the update process also updated weewx to 4.1.1.1.


It appears that the install properly created the mysql/MariadB 
weewx and set up data tables properly.


However, some error messages showed up when I used the "sudo tail 
-f /var/log/syslog" command after database update was successful. 
Some were clearly missing modules that I was able to install and 
clear those up but one repeated one I don't understand what it is 
telling me nor what process to follow to correct it, it seems 
possibly something related to a common key error that appears to 
apply to a number scripts/program code strings?


Jun 7 01:08:04 cedar weewx[47128] CRITICAL __main__: Caught 
unrecoverable exception:
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
'StdRESTful'
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
Traceback (most recent call last):
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewxd", line 148, in main
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
engine = weewx.engine.StdEngine(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 75, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  
self.loadServices(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 138, in loadServices
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
obj = weeutil.weeutil.get_object(svc)(self,config_dict)
Jun  7 01:08:04 cedar 

Fwd: Re: [weewx-user] weewx 4.1.1.1 error query

2020-06-07 Thread VE4PER / Andy
If somebody knows what URL and it's format is in question here and where 
to enter it I would appreciate knowing


Thanks

and Thanks again Graham


Andy



 Forwarded Message 
Subject:Re: [weewx-user] weewx 4.1.1.1 error query
Date:   Sun, 7 Jun 2020 02:55:55 -0500
From:   VE4PER / Andy 
To: Graham Eddy 



Thanks for your time and tips Graham.

Andy


weewx.conf entries StdRESTful related

I changed the red statements to what is shown in green below; the key 
error appears corrected but I got the following error msg about missing 
station URL and not sure where to specify it or what format it has to be.


Everything appears to work properly now and wx data is being sent but 
wind data will be in error until I get replacement anemometer cups 
(enroute I'm told)


Jun  7 02:22:27 cedar weewx[49295] INFO weewx.restx: StationRegistry: 
*Station will not be registered: no station_url specified.**

*



#   This section is for uploading data to Internet sites
#
#[StdRESTful]
 #
  #  [[StationRegistry]]
    # To register this weather station with weewx, set this to true
   # register_this_station = false

#   This section is for uploading data to Internet sites

[StdRESTful]

   [[StationRegistry]]
    # To register this weather station with weewx, set this to true
    register_this_station = true

   #   This section configures the internal weewx engine.

[Engine]

    [[Services]]
    # This section specifies the services that should be run. They are
    # grouped by type, and the order of services within each group
    # determines the order in which the services will be run.
    prep_services = weewx.engine.StdTimeSynch
    data_services = ,
    process_services = weewx.engine.StdConvert, 
weewx.engine.StdCalibrate, weewx.engine.StdQC, 
weewx.wxservices.StdWXCalculate

    archive_services = weewx.engine.StdArchive
    restful_services = weewx.restx.StdStationRegistry, 
weewx.restx.StdWunderground, weewx.restx.StdPWSweather, 
weewx.restx.StdCWOP, weewx.restx.StdWOW, weewx.restx.StdAWEKAS

    report_services = weewx.engine.StdPrint, weewx.engine.StdReport





On 2020-06-07 1:54 a.m., Graham Eddy wrote:
you would probably get that error if you tell weewx to use 
StdStationRegistry service e.g. in weewx.conf something like:

    restful_service = weewx.restx.StdStationRegistry, ...
but not defined a RESTful definition stanza in weewx.conf e.g.
    [StdRESTful] < < < < this key missing
        [[StationRegistry]]
  register_this_station = true
g-eddy

On 7 Jun 2020, at 4:16 pm, VE4PER / Andy 
<mailto:andrew.webb.501.ve4...@gmail.com>> wrote:


My wind speed cups are physically broken; so no wind data ---awaiting 
delivery of parts and since it is down anyway I decided to do all the 
updates now while I wait.


I recently upgraded ubuntu OS to 20.04LTS, python to python3 and it 
appears the update process also updated weewx to 4.1.1.1.


It appears that the install properly created the mysql/MariadB weewx 
and set up data tables properly.


However, some error messages showed up when I used the "sudo tail -f 
/var/log/syslog" command after database update was successful. Some 
were clearly missing modules that I was able to install and clear 
those up but one repeated one I don't understand what it is telling 
me nor what process to follow to correct it, it seems possibly 
something related to a common key error that appears to apply to a 
number scripts/program code strings?


Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__: Caught 
unrecoverable exception:
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
'StdRESTful'
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
Traceback (most recent call last):
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewxd", line 148, in main
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
engine = weewx.engine.StdEngine(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 75, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  
self.loadServices(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/engine.py", line 138, in loadServices
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
obj = weeutil.weeutil.get_object(svc)(self,config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/share/weewx/weewx/restx.py", line 1366, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
_registry_dict = 
accumulateLeaves(config_dict['StdRESTful']['StationRegistry'], 
max_level=1)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     
File "/usr/lib/python3/dist-packages/configobj.py"

[weewx-user] weewx 4.1.1.1 error query

2020-06-07 Thread VE4PER / Andy
My wind speed cups are physically broken; so no wind data ---awaiting 
delivery of parts and since it is down anyway I decided to do all the 
updates now while I wait.


I recently upgraded ubuntu OS to 20.04LTS, python to python3 and it 
appears the update process also updated weewx to 4.1.1.1.


It appears that the install properly created the mysql/MariadB weewx and 
set up data tables properly.


However, some error messages showed up when I used the "sudo tail -f 
/var/log/syslog" command after database update was successful. Some were 
clearly missing modules that I was able to install and clear those up 
but one repeated one I don't understand what it is telling me nor what 
process to follow to correct it, it seems possibly something related to 
a common key error that appears to apply to a number scripts/program 
code strings?


Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__: Caught 
unrecoverable exception:

Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  'StdRESTful'
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  Traceback 
(most recent call last):
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     File 
"/usr/share/weewx/weewxd", line 148, in main
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   engine = 
weewx.engine.StdEngine(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     File 
"/usr/share/weewx/weewx/engine.py", line 75, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
self.loadServices(config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     File 
"/usr/share/weewx/weewx/engine.py", line 138, in loadServices
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   obj = 
weeutil.weeutil.get_object(svc)(self,config_dict)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     File 
"/usr/share/weewx/weewx/restx.py", line 1366, in __init__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   
_registry_dict = 
accumulateLeaves(config_dict['StdRESTful']['StationRegistry'], max_level=1)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:     File 
"/usr/lib/python3/dist-packages/configobj.py", line 554, in __getitem__
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:   val = 
dict.__getitem__(self, key)
Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  KeyError: 
'StdRESTful'

Jun  7 01:08:04 cedar weewx[47128] CRITICAL __main__:  Exiting.

 Any and all tips or help would be appreciated, Thanks

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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/b5c011ec-e838-2ce1-26ea-5bf0e863de3d%40gmail.com.


[weewx-user] Re: importing weewx.sql not working

2020-05-19 Thread VE4PER / Andy
On further inspection the table created in the updated machine was a single 
table with 114 columns; the tables created in the older version sql 
database  appears to be 114 separate archive tables.

Is Vers 4 supposed to create the needed mysql database tables on install 
the same as the previous vers of weewx did on install? so before installing 
weewx  just creatie an empty database weewx with weewx userID and weewx 
PW?  Clearly a good reason why problems occurring when table structures are 
incorrect.


On Sunday, May 17, 2020 at 8:07:46 PM UTC-5, VE4PER / Andy wrote:
>
> Hello,
>
> I did an export database from old mysql db using phpmyadmin. I copied the 
> weewx.sql file over to the new machine and tried to import data into the 
> empty weewx database using phpmyadmin. I kept getting errors on import; I 
> amend UPLOAD_MAX  POST_MAX to 64MB and also doubled time to 60 from 30 but 
> still generating errors size is 55.4 MB for weewx.sql file;  zipped it is 
> 8.1 MB but neither will import using phpmyadmin.
>
> Tried using mysql command line and all it seems to do is generate command 
> syntax errors. took commands from examples in mysql ref manual for vers 8
>
> I have system down for a number of hours now and unable to get old data in 
> to create the required archive table so info not being sent to remote 
> users. Usually in the past, if I remove /uninstall weewx and then reinstall 
> it from scratch it created the mysql database and tables ; doesn't now 
> though.
>
> Any tips or pointers would be appreciated
>
> Thanks
> 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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/1458064d-3457-4bff-bf00-918f9d84d597%40googlegroups.com.


[weewx-user] Re: importing weewx.sql not working

2020-05-18 Thread VE4PER / Andy
I use mysql because I am familiar with it.

I managed to get weewx ver 4 communicate with ACUrite display unit ptoper 
and with no logged errors. I was able to create a database named "weewx" 
with a new empty table with 114 columns named as posted here in this group 
post. I created the weewx user with password weewx on that database. I was 
able to log into the database using that userID and PW to verify the 
existence of the proper empty table which of course proves weewx ver 4 shud 
be able to log in and update the database; but it does not do it. Why I do 
not know. I purged all of weewx and re-installed it fresh to ensure it had 
not missed an initial connection to the database during the install 
process. To no avail; I have moved the display unit back onto the machine 
running linux 18.04lts instead of the currently available 20.04, and it is 
running weewx older version; BUT IT WORKS properly. 



On Sunday, May 17, 2020 at 8:07:46 PM UTC-5, VE4PER / Andy wrote:
>
> Hello,
>
> I did an export database from old mysql db using phpmyadmin. I copied the 
> weewx.sql file over to the new machine and tried to import data into the 
> empty weewx database using phpmyadmin. I kept getting errors on import; I 
> amend UPLOAD_MAX  POST_MAX to 64MB and also doubled time to 60 from 30 but 
> still generating errors size is 55.4 MB for weewx.sql file;  zipped it is 
> 8.1 MB but neither will import using phpmyadmin.
>
> Tried using mysql command line and all it seems to do is generate command 
> syntax errors. took commands from examples in mysql ref manual for vers 8
>
> I have system down for a number of hours now and unable to get old data in 
> to create the required archive table so info not being sent to remote 
> users. Usually in the past, if I remove /uninstall weewx and then reinstall 
> it from scratch it created the mysql database and tables ; doesn't now 
> though.
>
> Any tips or pointers would be appreciated
>
> Thanks
> 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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/674b0c35-78e3-42a6-99ce-94dc6d2a7538%40googlegroups.com.


[weewx-user] importing weewx.sql not working

2020-05-17 Thread VE4PER / Andy
Hello,

I did an export database from old mysql db using phpmyadmin. I copied the 
weewx.sql file over to the new machine and tried to import data into the 
empty weewx database using phpmyadmin. I kept getting errors on import; I 
amend UPLOAD_MAX  POST_MAX to 64MB and also doubled time to 60 from 30 but 
still generating errors size is 55.4 MB for weewx.sql file;  zipped it is 
8.1 MB but neither will import using phpmyadmin.

Tried using mysql command line and all it seems to do is generate command 
syntax errors. took commands from examples in mysql ref manual for vers 8

I have system down for a number of hours now and unable to get old data in 
to create the required archive table so info not being sent to remote 
users. Usually in the past, if I remove /uninstall weewx and then reinstall 
it from scratch it created the mysql database and tables ; doesn't now 
though.

Any tips or pointers would be appreciated

Thanks
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/d26bc82f-381f-478c-8d63-61bd08826d9e%40googlegroups.com.


[weewx-user] Unable to install on UbuntuStudio 20.04LTS

2020-05-17 Thread VE4PER / Andy
Hi,
I have tried to install weewx on my upgraded UbuntuStudio 20.04LTS OS 
(debian based) system. It does not install as there appears to be some 
python related roadblocks due to new OS's config wrt python software not 
being included as it was under 18.04LTS.

Has there been a fix or workaround for this recommended; does anyone know ?
Thanks
73 & good DX
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 weewx-user+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/cc342048-a1cd-400f-8f58-6c4c05f698a2%40googlegroups.com.