Just to be clear: you are one computer, trying to access a MySQL database
located on another computer.
Things to try:
1. Check that the MySQL host is allowing remote connections. By default,
MySQL allows only local ('localhost') connections. Find the option
bind-address among the myriad of MySQL configuration files and comment it
out. On my machine, this option is located in the file
/etc/mysql/mysql.conf.d/mysqld.cnf. So, you are changing this
bind-address = 127.0.0.1
to this
# bind-address = 127.0.0.1
2. Remote users are not the same as local users. You will need to grant a
user accessing the server remotely explicit permission to do so. On the
MySQL host machine
*mysql -u root -p*
mysql> *grant select, update, create, delete, insert on weewx.* to
weewx@odroid identified by 'weewx';*
3. Rather than debugging by using WeeWX, use the client program mysql. From
your client odroid, do this
*mysql --host=sdr-pi --user=weewx -p*
then run a few queries, such as
mysql> *select dateTime, barometer from weewx.archive limit 5;*
See if that helps.
-tk
On Fri, Feb 22, 2019 at 12:51 PM Dave Webb KB1PVH <[email protected]> wrote:
> I'm trying to use multiple bindings on my Odroid with a Davis Vue to grab
> info from another Pi running SDR. I struggled to get the mysql database
> going on the sdr Pi, but did it. My problem now is the error below when I
> add
>
> <tr>
> <td class="stats_label">Barn Temperature</td
> <td class="stats_data">$latest(data_binding='sdr_binding').
> extraTemp1</td>
> </tr>
>
> I know It's a simple permission problem but I can't manage to make it work
> after 2 hours of Googling and trial and error.
>
> Feb 22 15:20:19 odroid weewx[26288]: imagegenerator: Generated 11 images
> for StandardReport in 0.94 seconds
> Feb 22 15:20:19 odroid weewx[26288]: copygenerator: copied 0 files to
> /home/weewx/public_html
> Feb 22 15:20:21 odroid weewx[26288]: cheetahgenerator: Generate failed
> with exception '<class 'weedb.CannotConnectError'>'
> Feb 22 15:20:21 odroid weewx[26288]: cheetahgenerator: **** Ignoring
> template /home/weewx/skins/Standard/index.html.tmpl
> Feb 22 15:20:21 odroid weewx[26288]: cheetahgenerator: **** Reason: (2003,
> "Can't connect to MySQL server on 'sdr-pi' (111)")
> Feb 22 15:20:21 odroid weewx[26288]: **** Traceback (most recent call
> last):
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/cheetahgenerator.py", line 330, in generate
> Feb 22 15:20:21 odroid weewx[26288]: **** print >> _file,
> compiled_template
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
> __str__
> Feb 22 15:20:21 odroid weewx[26288]: **** rc = getattr(self,
> mainMethName)()
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "_home_weewx_skins_Standard_index_html_tmpl.py", line 975, in respond
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "_home_weewx_skins_Standard_index_html_tmpl.py", line 98, in __errorCatcher5
> Feb 22 15:20:21 odroid weewx[26288]: **** File "<string>", line 1, in
> <module>
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/tags.py", line 369, in latest
> Feb 22 15:20:21 odroid weewx[26288]: **** manager =
> self.db_lookup(data_binding)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/manager.py", line 870, in db_lookup
> Feb 22 15:20:21 odroid weewx[26288]: **** return
> self.get_manager(data_binding)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/manager.py", line 857, in get_manager
> Feb 22 15:20:21 odroid weewx[26288]: ****
> self.manager_cache[data_binding] = open_manager(manager_dict, initialize)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/manager.py", line 1009, in open_manager
> Feb 22 15:20:21 odroid weewx[26288]: **** manager_dict['table_name'])
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weewx/manager.py", line 101, in open
> Feb 22 15:20:21 odroid weewx[26288]: **** connection =
> weedb.connect(database_dict)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weedb/__init__.py", line 89, in connect
> Feb 22 15:20:21 odroid weewx[26288]: **** return
> driver_mod.connect(**db_dict)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weedb/mysql.py", line 57, in connect
> Feb 22 15:20:21 odroid weewx[26288]: ****
> database_name=database_name, engine=engine, autocommit=autocommit, **kwargs)
> Feb 22 15:20:21 odroid weewx[26288]: **** File
> "/home/weewx/bin/weedb/mysql.py", line 48, in guarded_fn
> Feb 22 15:20:21 odroid weewx[26288]: **** raise klass(e)
> Feb 22 15:20:21 odroid weewx[26288]: **** CannotConnectError: (2003,
> "Can't connect to MySQL server on 'sdr-pi' (111)")
> Feb 22 15:20:21 odroid weewx[26288]: cheetahgenerator: Generated 16 files
> for report BigReport in 2.00 seconds
> Feb 22 15:20:23 odroid weewx[26288]: imagegenerator: Generated 11 images
> for BigReport in 1.54 seconds
>
>
> Dave
>
> --
> 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.
