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.
Am Sonntag, 28. Juni 2020 19:13:38 UTC+2 schrieb 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.
>
> 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/ddebc148-cfe8-42a8-88c4-77ac6872431eo%40googlegroups.com.
