You can also use MySQL without a password if you switch users to root.
At the risk of confusing things further because I believe you should
use sqlite for its simplicity and portability....
You can try sudo su It may or may not challenge you. If it does Type
in your pi password
Then typemysql and it should let you into the console. From there you
can complete the commands above to find permissions.
garagepi.png <about:invalid#zClosurez>
On Monday, August 20, 2018 at 5:25:34 PM UTC-4, Thomas Keffer wrote:
You have a MySQL password problem. Straighten that out. Or, use
sqlite.
Focus on the system log. Forget about the webserver for a moment.
The log will tell you what is going on. You should learn how to
cut and paste from it. The easiest is:
$ cat /var/log/syslog
(this will print out a *lot* of text)
Then highlight what you want to copy, then right click and select
"Copy". Then paste into your email app.
If your email is on a different machine, then ssh
<https://www.raspberrypi.org/documentation/remote-access/ssh/>
into the RPi, then do the above.
-tk
On Mon, Aug 20, 2018 at 2:05 PM John Clark <w0a...@gmail.com
<javascript:>> wrote:
On 8/20/2018 1:49 PM, Thomas Keffer wrote:
John,
Please don't summarize what you're finding. Cut-and-paste
explicitly into the email. For example, when you say '**I get
access denied**' when trying to use mysql, did it prompt for
a password first (it should have)? You should have given it
the MySQL root password you used when setting up MySQL. If
you don't remember it, then you're stuck. Reinstall, and this
time remember it. Incidentally, this is a good example of
how MySQL is more difficult to manage.
I tried "weewx" as it said in the weewx.conf file, and I also
tried the system root password.
I don't know what you mean by anything in the "grins and
giggles" paragraph. What "not found" error? And, again, don't
summarize what you think you're seeing in syslog --- post it.
It is my assumption that Apache is running here.
Don't take these setbacks personally. The RPi is not out to
get you. Give it the right commands and it will do the right
thing.
-tk
I never take it personally. I always tell people that
computers are very literal, and very stupid. They will only do
exactly what you tell them, so if something doesn't work as
planned, you aren't telling them correctly.
On Mon, Aug 20, 2018 at 11:32 AM John Clark <w0a...@gmail.com
<javascript:>> wrote:
On 8/20/2018 12:24 PM, Thomas Keffer wrote:
Nothing wrong with the Rapsberry Pi as a platform:
thousands of WeeWX users are using it successfully.
However, you should reconsider your decision to use
MySQL if you are not familiar with it. It is much more
complex to administer then the default sqlite database.
In any case, check the access permissions for user
weewx. To do this, run 'mysql' either as user weewx or
user root. Then use the SHOW GRANTS command:
$ *mysql -u root -p
*
mysql> *SHOW GRANTS FOR 'weewx'@'localhost';
*
$ mysql -u root -p **I get access denied**
mysql> SHOW GRANTS FOR 'weewx'@'localhost'; **I get no
results**
Just for grins and giggles I set it to use sqlite and it
did "run" but there was nothing displayed with
"localhost/weewx" just the "not found"error and according
to the syslog it wasn't uploading to my website*.
*So, I am gonna give it a break before I use a hammer on
it. THEN, I'm not sure WHAT I'll do.*
*
--
*/John Clark <javascript:>/*
--
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 weewx-user+...@googlegroups.com
<javascript:>.
For more options, visit
https://groups.google.com/d/optout
<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 weewx-user+...@googlegroups.com
<javascript:>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
*/John Clark <javascript:>/*
--
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 weewx-user+...@googlegroups.com
<javascript:>.
For more options, visit https://groups.google.com/d/optout
<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 weewx-user+unsubscr...@googlegroups.com
<mailto:weewx-user+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.