This error says you have a bad username for your database. Nothing to do
with the skin. Check your database settings in weewx.conf.
On Sunday, June 28, 2020 at 12:02:47 PM UTC-4, Geni 0815 wrote:
>
> @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/873a2fca-c3d3-4af8-a1d9-bec309792684o%40googlegroups.com.
