@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:~ $ > > Am Freitag, 26. Juni 2020 11:20:48 UTC+2 schrieb Manfred Maier: > > Sorry. Hatte ich vergessen. > > geni08...@gmail.com schrieb am Freitag, 26. Juni 2020 um 11:13:44 UTC+2: > >> Kannst du deine extensions.py bitte hier reinstellen? >> >> >> Manfred Maier schrieb am Freitag, 26. Juni 2020 um 10:41:53 UTC+2: >> >>> 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 schrieb am Freitag, 26. Juni 2020 um 10:27:06 UTC+2: >>> >>>> @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 schrieb am Freitag, 26. Juni 2020 um 07:59:42 UTC+2: >>>> >>>>> 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 schrieb am Freitag, 26. Juni 2020 um 07:43:08 >>>>> UTC+2: >>>>> >>>>>> 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? >>>>>> >>>>>> >>>>>> Pat schrieb am Donnerstag, 25. Juni 2020 um 21:32:55 UTC+2: >>>>>> >>>>>>> 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? >>>>>>> >>>>>>> >>>>>>> On Thursday, June 25, 2020 at 1:36:54 PM UTC-4, Manfred Maier wrote: >>>>>>>> >>>>>>>> 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? >>>>>>>> >>>>>>>> geni08...@gmail.com schrieb am Donnerstag, 25. Juni 2020 um >>>>>>>> 19:22:55 UTC+2: >>>>>>>> >>>>>>>>> if appTemp instead of windchill, graphics no longer work >>>>>>>>> >>>>>>>>> >>>>>>>>> Am Donnerstag, 25. Juni 2020 17:46:56 UTC+2 schrieb 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? >>>>>>>>>> >>>>>>>>>> geni08...@gmail.com schrieb am Donnerstag, 25. Juni 2020 um >>>>>>>>>> 17:34:22 UTC+2: >>>>>>>>>> >>>>>>>>>>> what is appTemp? >>>>>>>>>>> windchill corresponds to 'feels like'? >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Am Donnerstag, 25. Juni 2020 17:18:38 UTC+2 schrieb Manfred >>>>>>>>>>> Maier: >>>>>>>>>>>> >>>>>>>>>>>> Try to change it to [[[appTemp]]]. It then should correspond to >>>>>>>>>>>> the figure at the top. >>>>>>>>>>>> >>>>>>>>>>>> geni08...@gmail.com schrieb am Donnerstag, 25. Juni 2020 um >>>>>>>>>>>> 17:16:32 UTC+2: >>>>>>>>>>>> >>>>>>>>>>>>> in graphs.inc is [[[windchill]]] >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> Am Donnerstag, 25. Juni 2020 16:51:00 UTC+2 schrieb Manfred >>>>>>>>>>>>> Maier: >>>>>>>>>>>>>> >>>>>>>>>>>>>> Next try ... the "Gefühlte Temp" in your graphs.conf is >>>>>>>>>>>>>> displaying "appTemp"? >>>>>>>>>>>>>> >>>>>>>>>>>>>> geni08...@gmail.com schrieb am Donnerstag, 25. Juni 2020 um >>>>>>>>>>>>>> 16:43:53 UTC+2: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> MQTT ist not activ. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Am Donnerstag, 25. Juni 2020 15:51:16 UTC+2 schrieb 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 >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> geni08...@gmail.com schrieb am Donnerstag, 25. Juni 2020 >>>>>>>>>>>>>>>> um 15:42:15 UTC+2: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Why is there a different temperature displayed? >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>
-- 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/3d9d436a-5a9a-4607-807d-26a7338bc1dfo%40googlegroups.com.