Belchertown Difference for the same temperature type

[Geni 0815]

Why is there a different temperature displayed?

[Manfred Maier]

Hi Geni,

do you have MQTT switched on?

If so, the station observations (top area) display the live data. The charts display the temperature of the last archive loop (= couple of minutes old).

Manfred

[Geni 0815]

MQTT ist not activ.

[Manfred Maier]

Next try ... the "Gefühlte Temp" in your graphs.conf is displaying "appTemp"?

[Geni 0815]

in graphs.inc is  [[[windchill]]]

[Manfred Maier]

Try to change it to [[[appTemp]]]. It then should correspond to the figure at the top.

[vince]

On Thursday, June 25, 2020 at 8:16:32 AM UTC-7, Geni 0815 wrote:

in graphs.inc is  [[[windchill]]]

One item is wind chill (sometimes called 'feels like'), the other is outside temperature.

They are usually different if you have any wind.

[Geni 0815]

what is appTemp?
windchill corresponds to 'feels like'?

[Manfred Maier]

appTemp is best translated with "Gefühlte Temperatur".

I would have to look it up in the weewx code, but I think it's calculated based on temperature, humidity and wind.

appTemp can be higher or lower than the temperature.

Windchill is normally (always?) lower than the temperature. It's therefore primarily used in winter. At least in the German news I only hear about it in winter.

Heat Index is the opposite. It's normally (always?) higher than the temperature. It useful in the summer.

Other people might want to add or correct me here!

As mentioned: appTemp get's closest to what we refer to as "Gefühlte Temperature" in Germany (and hopefully also in Switzerland).

Have you tried to put appTemp in your chart? Does the value correspond to the other value on your page?

[Geni 0815]

if appTemp instead of windchill, graphics no longer work

[Manfred Maier]

Ok. I've just seen that appTemp is not part of the standard installation of weewx. I've added it later to the database.

@Pat: In your index.html.tmpl it looks like your are displaying $current.appTemp for the "Feels like" temperature. What is used when appTemp does not exist in the database? Or is appTemp calculated by weewx anyway, but if there isn't a field in the database it's just not stored and can't be used for the charts?

[Pat]

Good question. If appTemp doesn't exist in the database, then I would have thought the entry would be empty or given an error in the syslog. Any errors?

[gjr80]

Just to clarify, as of v3.7.0 tag $current will pull data from the record included in the NEW_ARCHIVE_RECORD event rather than querying the database for the last record. This means, for example, you can use $current.appTemp in a report without actually having field appTemp in the database (provided appTemp is being calculated and added to the archive record by a service such as StdWXCalculate). Of course, you cannot plot appTemp without including appTemp in the database as you need those historical records.

Gary

[geni08...@gmail.com]

There are errors, a test with $current.appTemp and once with appTemp.
The appTemp field is not in the database, how can I modify my database?

[Manfred Maier]

Good morning!

You can use these instructions to add appTemp to your database:

https://github.com/poblabs/weewx-belchertown/wiki/Adding-a-new-observation-type-to-the-WeeWX-database

Just make sure you really have a backup of your database stored.

[geni08...@gmail.com]

@Manfred: Hast du dies schon mal gemacht? Wenn ja ohne Probleme?

Bleibt dies eine einmalige Sache oder wird dies bei jedem Update von weewx oder Belchertown wieder fällig?

Wie muss dann die extensions.py aussehen?

Ich verwende eine externe Mariadb10, wird nun eine neue DB gemacht oder die bestehende modifiziert?

Dies funktioniert auf meinem Raspberry ja nicht?

Warum wird dies nicht von der Belchertown installation gemacht?

Bin da für jede Hilfe dankbar.

[Manfred Maier]

Ich habe meine Datenbank inzwischen schon zweimal erweitert. Einmal nach ca. drei Wochen (um appTemp und maxSolarRad in der Datenbank zu haben) und dann nochmal letzte Woche, um endlich auch die Anzahl der Sonnenstunden schön darstellen zu können.

Beide Male hat es absolut ohne Probleme funktioniert. 

Schau einfach nur, dass Du ein Backup der Datenbank hast, sollte wirklich etwas schief laufen.

Mit Mariadb10 habe ich leider keinerlei Erfahrung. 

Bei meiner Installation (mit SQLite) wird einfach nur die existierende DB erweitert.

Und bei der Installation der Skin ist es einfach nicht sinnvoll, an der Datenbank rumzuspielen. 

[geni08...@gmail.com]

Kannst  du deine extensions.py bitte hier reinstellen?

[Manfred Maier]

Sorry. Hatte ich vergessen.

[geni08...@gmail.com]

@Manfred: Danke, werde dann mal die nächste Woche einen ersten Versuch starten :)

[Geni 0815]

@pat:

@Manfred:

This results in my attempt!

pi@Wetter-Raspi:~ $ sudo wee_database /etc/weewx/weewx.conf --reconfigure
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 'archive_mysql'
Traceback (most recent call last):
  File "/usr/share/weewx/weedb/mysql.py", line 52, in guarded_fn
    return fn(*args, **kwargs)
  File "/usr/share/weewx/weedb/mysql.py", line 262, in execute
    self.cursor.execute(mysql_string, tuple(sql_tuple))
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in execute
    res = self._query(query)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in _query
    rowcount = self._do_query(q)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in _do_query
    db.query(q)
  File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, in query
    _mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1044, "Access denied for user 'raspberry'@'%' to database 'weewx_new'")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/share/weewx/wee_database", line 974, in <module>
    main()
  File "/usr/share/weewx/wee_database", line 145, in main
    reconfigMainDatabase(config_dict, db_binding)
  File "/usr/share/weewx/wee_database", line 312, in reconfigMainDatabase
    weedb.create(new_database_dict)
  File "/usr/share/weewx/weedb/__init__.py", line 80, in create
    return driver_mod.create(**db_dict)
  File "/usr/share/weewx/weedb/mysql.py", line 87, in create
    cursor.execute("CREATE DATABASE %s" % (database_name,))
  File "/usr/share/weewx/weedb/mysql.py", line 61, in guarded_fn
    raise klass(e)
weedb.PermissionError: (1044, "Access denied for user 'raspberry'@'%' to database 'weewx_new'")
pi@Wetter-Raspi:~ $

[Pat]

This error says you have a bad username for your database. Nothing to do with the skin. Check your database settings in weewx.conf.

[Geni 0815]

The problem was that the user did not have enough rights. Furthermore, the import of the database did not work with phpmyAdmin because the database was too large, it worked with putty directly on the Synology with mysql.
Now this is as requested, thanks for the help.