This is a simple permission problem. See the User's Guide on Configuring MySQL <http://weewx.com/docs/usersguide.htm#configuring_mysql> (and Maria). In particular, pay attention to the instructions on setting permissions.
Suggestion: if you are unfamiliar with managing databases, stick with sqlite. It's a lot simpler. MySQL takes a lot more experience. -tk On Sun, Aug 19, 2018 at 5:16 PM John Clark <[email protected]> wrote: > Mysql was, and is installed. Went ahead and installed maria-server, > restarted weewx, and got this for the syslog > > pi@raspberrypi:~ $ tail -f /var/log/syslog > Aug 19 18:16:14 raspberrypi weewx[4515]: **** File > "/home/weewx/bin/weewx/manager.py", line 127, in open_with_create > Aug 19 18:16:14 raspberrypi weewx[4515]: **** connection = > weedb.connect(database_dict) > Aug 19 18:16:14 raspberrypi weewx[4515]: **** File > "/home/weewx/bin/weedb/__init__.py", line 89, in connect > Aug 19 18:16:14 raspberrypi weewx[4515]: **** return > driver_mod.connect(**db_dict) > Aug 19 18:16:14 raspberrypi weewx[4515]: **** File > "/home/weewx/bin/weedb/mysql.py", line 57, in connect > Aug 19 18:16:14 raspberrypi weewx[4515]: **** > database_name=database_name, engine=engine, autocommit=autocommit, **kwargs) > Aug 19 18:16:14 raspberrypi weewx[4515]: **** File > "/home/weewx/bin/weedb/mysql.py", line 48, in guarded_fn > Aug 19 18:16:14 raspberrypi weewx[4515]: **** raise klass(e) > Aug 19 18:16:14 raspberrypi weewx[4515]: **** DatabaseError: (1698, > "Access denied for user 'weewx'@'localhost'") > Aug 19 18:16:14 raspberrypi weewx[4515]: **** Exiting. > > > beginning to think of flush and reinstall. The funny thing is, when I > unplug the Acurite from the Dell and plug it into the Pi, I have all these > problems yet it seems it is ftp'ing to my website as there seems to be no > interruptions to CWOP or my page at weather.w0avq.org and if it means > anything, the radar refreshes fine but the web page doesn't update and > localhost says it doesn't exist (apache is installed and running) > > > > On 8/19/2018 5:35 PM, Pat O'Brien wrote: > > Sounds like you don't have MySQL installed. Did you remove it? Or > uninstall another software recently which may have removed it by mistake? > > Try > > sudo netstat -tulpn | grep 3306 > > Do you see anything? > > If not may need to reinstall with > > Sudo apt-get install mariadb-server to reinstall > > > On Sun, Aug 19, 2018, 5:25 PM John Clark <[email protected]> wrote: > >> pi@raspberrypi:~ $ sudo service mysql status >> Unit mysql.service could not be found. >> pi@raspberrypi:~ $ sudo service mysql restart >> Failed to restart mysql.service: Unit mysql.service not found. >> >> >> pi@raspberrypi:~ $ sudo service mysqld status >> Unit mysqld.service could not be found. >> pi@raspberrypi:~ $ sudo service mariadb status >> Unit mariadb.service could not be found. >> >> >> and on the Dell that runs perfectly, I get >> john@OptiPlex ~ $ sudo service mysql status >> mysql start/running, process 1284 >> john@OptiPlex ~ $ sudo service mysqld status >> mysqld: unrecognized service >> john@OptiPlex ~ $ sudo service mariadb status >> mariadb: unrecognized service >> >> > -- > *John Clark <[email protected]>* > > -- > 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.
