Every user has a password. For example, in section* Configuring MySQL <http://weewx.com/docs/usersguide.htm#configuring_mysql>* in the User's Guide it shows you how to set up a local user.
mysql> CREATE USER 'weewx'@'localhost' IDENTIFIED BY 'weewx'; mysql> GRANT select, update, create, delete, insert, drop ON weewx.* TO weewx@localhost; In this example, the password was set by the "IDENTIFIED BY" clause. You'll want to do something similar, except you want to set the host to something other than 'localhost'. -tk On Fri, Feb 22, 2019 at 6:35 PM Dave Webb KB1PVH <[email protected]> wrote: > 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. > -- 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.
