Tom, I already did #1 so I'm thinking #2 is going to be the answer. I'll give it a go later and report back.
Dave-KB1PVH Sent from my Galaxy S9 On Fri, Feb 22, 2019, 6:55 PM Thomas Keffer <[email protected]> wrote: > 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. > -- 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.
