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.
