As I said, this is a lot easier to debug using the client app 'mysql', than using WeeWX.
-tk On Fri, Feb 22, 2019 at 5:51 PM Dave Webb KB1PVH <[email protected]> wrote: > So I just did a stop + start of mysql and now have this error. Looks like > I have the wrong password but can't figure out where it's coming from or > how to change. > > Feb 22 20:40:22 odroid weewx[26350]: cheetahgenerator: **** Ignoring > template /home/weewx/skins/Standard/index.html.tmpl > Feb 22 20:40:22 odroid weewx[26350]: cheetahgenerator: **** Reason: (1045, > "Access denied for user 'weewx'@'odroid.fios-router.home' (usi > ng password: YES)") > Feb 22 20:40:22 odroid weewx[26350]: **** Traceback (most recent call > last): > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 330, in generate > Feb 22 20:40:22 odroid weewx[26350]: **** print >> _file, > compiled_template > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in > __str__ > Feb 22 20:40:22 odroid weewx[26350]: **** rc = getattr(self, > mainMethName)() > Feb 22 20:40:22 odroid weewx[26350]: **** File > "cheetah__home_weewx_skins_Standard_index_html_tmpl_1550886019_7_59410.py", > line 975, i n respond > Feb 22 20:40:22 odroid weewx[26350]: **** File > "cheetah__home_weewx_skins_Standard_index_html_tmpl_1550886019_7_59410.py", > line 98, in __errorCatcher5 > Feb 22 20:40:22 odroid weewx[26350]: **** File "<string>", line 1, in > <module> > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/tags.py", line 369, in latest > Feb 22 20:40:22 odroid weewx[26350]: **** manager = > self.db_lookup(data_binding) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/manager.py", line 870, in db_lookup > Feb 22 20:40:22 odroid weewx[26350]: **** return > self.get_manager(data_binding) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/manager.py", line 857, in get_manager > Feb 22 20:40:22 odroid weewx[26350]: **** > self.manager_cache[data_binding] = open_manager(manager_dict, initialize) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/manager.py", line 1009, in open_manager > Feb 22 20:40:22 odroid weewx[26350]: **** manager_dict['table_name']) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weewx/manager.py", line 101, in open > Feb 22 20:40:22 odroid weewx[26350]: **** connection = > weedb.connect(database_dict) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weedb/__init__.py", line 89, in connect > Feb 22 20:40:22 odroid weewx[26350]: **** return > driver_mod.connect(**db_dict) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weedb/mysql.py", line 57, in connect > Feb 22 20:40:22 odroid weewx[26350]: **** > database_name=database_name, engine=engine, autocommit=autocommit, **kwargs) > Feb 22 20:40:22 odroid weewx[26350]: **** File > "/home/weewx/bin/weedb/mysql.py", line 48, in guarded_fn > Feb 22 20:40:22 odroid weewx[26350]: **** raise klass(e) > Feb 22 20:40:22 odroid weewx[26350]: **** BadPasswordError: (1045, > "Access denied for user 'weewx'@'odroid.fios-router.home' (using pass > word: YES)") > Feb 22 20:40:22 odroid weewx[26350]: cheetahgenerator: Generated 16 files > for report BigReport in 2.02 seconds > Feb 22 20:40:24 odroid weewx[26350]: imagegenerator: Generated 11 images > for BigReport in 1.60 seconds > Feb 22 20:40:24 odroid weewx[26350]: copygenerator: copied 0 files to > /home/weewx/public_html/big > > > On Fri, Feb 22, 2019 at 8:04 PM Dave Webb KB1PVH <[email protected]> wrote: > >> Vince, >> >> I didn't stop and start mysql after making changes, I'll try that along >> with the other points you mentioned. I'll probably revisit this after a >> calming adult beverage...or two. >> >> Dave-KB1PVH >> >> >> Sent from my Galaxy S9 >> >> On Fri, Feb 22, 2019, 7:55 PM vince <[email protected]> wrote: >> >>> On Friday, February 22, 2019 at 4:40:02 PM UTC-8, Dave Webb wrote: >>>> >>>> Doing #2 didn't fix it, still getting same error. I'm going to abort >>>> mission until tomorrow or Sunday. >>>> >>>> >>> A few thoughts: >>> >>> - after you change the mysql config to listen to non-localhost >>> traffic, you probably need to start+stop mysql on the database server to >>> have it take effect >>> - you might be blocking incoming traffic with a packet filter on >>> your database server (ok, that one's more of a stretch) >>> - it could be DNS resolution on the weewx system as well. Can the >>> weewx system resolve the hostname 'sdr-pi' that you defined for the db >>> server ? >>> - and Tom's item3 is the acid test - can you connect from the weewx >>> system via the shell directly, using the hostname/db/user/pass you >>> defined >>> in weewx.conf ? >>> >>> >>> -- >>> 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]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
