I found the error, db-sql not specified extended in the weewx.conf :) Silvio Schömann schrieb am Freitag, 14. Mai 2021 um 19:14:22 UTC+2:
> Hello everyone, > > can someone help me and explain why the SunshinTime code does not run in > Weewx version 4.5.1? The calculation of the ratio_value is not carried out. > The 0 values are entered in the DB. An error message in the log is also > not output. I'm using Manfred's simplified code. extensions.py and > weewx.conf are also correct. > > Thank you greetings Silvio > > > > Manfred Maier schrieb am Samstag, 13. März 2021 um 20:25:11 UTC+1: > >> I've just looked at my installation. >> I think the only missing step is to include the extension in the >> weewx.conf: >> >> >> ############################################################################## >> >> # 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 = user.radiationhours.RadiationHours, >> weewx.engine.StdConvert, weewx.engine.StdCalibrate, weewx.engine.StdQC, >> weewx.wxservices.StdWXCalculate >> # 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, >> user.mqtt.MQTT, user.windy.Windy, user.wcloud.WeatherCloud, >> user.twitter.Twitter, user.wetter.Wetter, user.owm.OpenWeatherMap >> report_services = weewx.engine.StdPrint, weewx.engine.StdReport >> >> [email protected] schrieb am Freitag, 12. März 2021 um 10:49:16 UTC+1: >> >>> ok i think i didn't do the first extension with extension.py because >>> mine is empty :-) >>> >>> i changed schema in weewx.config and recreated the database, then i got >>> the new fields >>> >>> i am a bit confused now what to do :-) >>> >>> [DataBindings] >>> >>> [[wx_binding]] >>> # The database must match one of the sections in [Databases]. >>> # This is likely to be the only option you would want to change. >>> database = archive_sqlite >>> # The name of the table within the database >>> table_name = archive >>> # The manager handles aggregation of data for historical >>> summaries >>> manager = weewx.manager.DaySummaryManager >>> # The schema defines the structure of the database. >>> # It is *only* used when the database is created. >>> schema = user.weatherlink_live.schema >>> >>> Manfred Maier schrieb am Freitag, 12. März 2021 um 09:53:59 UTC+1: >>> >>>> I've also extended my database scheme a second time - without any >>>> issues. >>>> >>>> Here's my extensions.py >>>> I've just added the additional three fields to the already extended >>>> scheme. >>>> >>>> [email protected] schrieb am Freitag, 12. März 2021 um 08:42:17 UTC+1: >>>> >>>>> got it, thank you manfred! >>>>> >>>>> now a question about radiationhours: i have extended the schema >>>>> already one time for the weatherlink-driver: >>>>> https://github.com/michael-slx/weewx-weatherlink-live >>>>> >>>>> whats the correct way to extend the schema a second time? i tried it >>>>> one time, but then i lost the additional fields from the >>>>> weatherlink-driver >>>>> >>>>> Manfred Maier schrieb am Donnerstag, 11. März 2021 um 19:28:55 UTC+1: >>>>> >>>>>> Yes, you are correct. If the page is using https, all components need >>>>>> to have a ssl certificate. >>>>>> >>>>>> [email protected] schrieb am Donnerstag, 11. März 2021 um 10:00:07 >>>>>> UTC+1: >>>>>> >>>>>>> hi, >>>>>>> >>>>>>> thanks for this file, i will try it after mqtt-setup :-) >>>>>>> >>>>>>> i always get failed connecting on my website and i think it's >>>>>>> because my site is using https >>>>>>> >>>>>>> the test here is working fine, i get the live data >>>>>>> http://www.hivemq.com/demos/websocket-client/ >>>>>>> >>>>>>> do i have to run my local mosquitto installation also with ssl/tls >>>>>>> or is there another way to get it working? >>>>>>> >>>>>>> regards, >>>>>>> chris >>>>>>> >>>>>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 20:44:02 UTC+1: >>>>>>> >>>>>>>> I'm using the attached file, which I found somewhere here in this >>>>>>>> user forum. >>>>>>>> I've slightly adapted it to bette fit my needs. >>>>>>>> >>>>>>>> Don't get confused by the filed name 'EmptyReal'. That was just a >>>>>>>> spare field I had in my database. >>>>>>>> >>>>>>>> The calculation of the theoretical radiation level is not 100% >>>>>>>> perfect, but it does the job. >>>>>>>> >>>>>>>> >>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 20:05:55 >>>>>>>> UTC+1: >>>>>>>> >>>>>>>>> ok, i will try it locally before, but vserver is also a good >>>>>>>>> (cheap) option :-) >>>>>>>>> >>>>>>>>> another question to you: how do you calculate sun hours on your >>>>>>>>> site, is it from here? https://github.com/gjr80/weewx-weewx-wd >>>>>>>>> >>>>>>>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 19:23:40 UTC+1: >>>>>>>>> >>>>>>>>>> No, I didn't. >>>>>>>>>> >>>>>>>>>> I'm (unfortunately) sitting behind fiberglass without a static >>>>>>>>>> IPv4. >>>>>>>>>> So I anyway had to rent a vServer for running my own tunneling >>>>>>>>>> solution for my local webcam. >>>>>>>>>> >>>>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um 19:12:12 >>>>>>>>>> UTC+1: >>>>>>>>>> >>>>>>>>>>> hi manfred, >>>>>>>>>>> >>>>>>>>>>> did you try to run the broker locally before? >>>>>>>>>>> >>>>>>>>>>> i have a static ip with symmetric bandwidth. or are there other >>>>>>>>>>> reasons why it doesnt work? >>>>>>>>>>> >>>>>>>>>>> regards, >>>>>>>>>>> chris >>>>>>>>>>> >>>>>>>>>>> Manfred Maier schrieb am Mittwoch, 10. März 2021 um 15:16:35 >>>>>>>>>>> UTC+1: >>>>>>>>>>> >>>>>>>>>>>> Hi Chris, >>>>>>>>>>>> I've been in a similar situation to you. >>>>>>>>>>>> My web hosting service didn't allow me to run a MQTT broker and >>>>>>>>>>>> the (free) public brokers didn't perform very well. The majority >>>>>>>>>>>> of MQTT >>>>>>>>>>>> packages got lost and were not delivered to the web client. >>>>>>>>>>>> So in the end I've decided to rent an additional vServer and >>>>>>>>>>>> run my own MQTT broker. The setup was really easy, but there's a >>>>>>>>>>>> server >>>>>>>>>>>> cost of approx. 2€ per month. >>>>>>>>>>>> >>>>>>>>>>>> Manfred >>>>>>>>>>>> >>>>>>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um >>>>>>>>>>>> 11:59:33 UTC+1: >>>>>>>>>>>> >>>>>>>>>>>>> You need a publicly available MQTT broker. Either you install >>>>>>>>>>>>> one on your webhoster's webspace (if possible), or you use a >>>>>>>>>>>>> public broker >>>>>>>>>>>>> like test.mosquitto.org. >>>>>>>>>>>>> >>>>>>>>>>>>> [email protected] schrieb am Mittwoch, 10. März 2021 um >>>>>>>>>>>>> 07:46:52 UTC+1: >>>>>>>>>>>>> >>>>>>>>>>>>>> hello, >>>>>>>>>>>>>> >>>>>>>>>>>>>> i am uploading the reports via FTP to my webhoster. can i use >>>>>>>>>>>>>> mqtt then for live data oder do i need a locally webserver? >>>>>>>>>>>>>> >>>>>>>>>>>>>> regards, >>>>>>>>>>>>>> chris >>>>>>>>>>>>>> >>>>>>>>>>>>> -- 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/6ed311bf-39b2-4404-811a-2ef5e0845988n%40googlegroups.com.
