Doing #2 didn't fix it, still getting same error. I'm going to abort mission until tomorrow or Sunday.
Dave-KB1PVH Sent from my Galaxy S9 On Fri, Feb 22, 2019, 7:00 PM Dave Webb KB1PVH <[email protected]> wrote: > 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.
