@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.
>
> [email protected] 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.
>>>
>>> [email protected] 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.
>>>>>
>>>>> [email protected] 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?
>>>>>>>>
>>>>>>>> [email protected] 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?
>>>>>>>>>>
>>>>>>>>>> [email protected] 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.
>>>>>>>>>>>>
>>>>>>>>>>>> [email protected] 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"?
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> [email protected] 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
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> [email protected] 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/3d9d436a-5a9a-4607-807d-26a7338bc1dfo%40googlegroups.com.
