Tom, I don't know what the password is when it asks for it and I was never asked to choose one when installing mysql on the Pi running mysql either.
Dave-KB1PVH Sent from my Galaxy S9 On Fri, Feb 22, 2019, 8:53 PM Thomas Keffer <[email protected]> wrote: > 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. > -- 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.
