Weather Station Hardware > Davis Instruments Weather Stations

Tutorial: Davis Station with Weewx, Ubuntu, MySQL and SLOWeather Serial Cable

<< < (2/3) > >>

DeKay:

--- Quote from: HandyGeek on February 03, 2013, 06:15:16 PM ---But MySQL refused to recognize "quit" or "quit;" or "QUIT".

I had to Ctrl-C to break out but that resulted in an "Aborted" message, which
I take to mean that the CREATE USER & GRANT lines were lost.

Why would MySQL refuse the "quit" command and how might I solve that, please?

Thanks!

--- End quote ---

I'm no SQL guru but

CREATE USER 'weewx'@'localhost' IDENTIFIED BY 'weewx.;

is almost certainly wrong.  The period just before the semicolon should be an apostrophe instead to match the opening apostrophe before weewx.  Likely a cut and paste error in the original post.

Plain out "quit" should have worked.  Don't add  semicolons as those are for MySQL commands only and not internal commands.  I think the error in that one line screwed up the stuff that followed.  I'd run the MySQL commands over again, fixing that typo.

HandyGeek:
That was it, thanks!

Curiously someone elsewhere shared the story of a 2 week hunt for a bug in FORTRAN that turned out to be one "." at the beginning of a line.

vpweather:
Great write-up. I'd like to get Weewx up and running on a Linux-box failing that a RaspberryPi. My Linux-skills are not great (practically non-existent) however I'd like to give the installation a try (following the tutorial as closely as possible that is). Currently running Cumulus-Weather software and think that in all fairness this is great compared to Weather-Link. Does Weewx allow for posts onto Twitter though? - At a guess it does. Thank you in advance for any help/suggestions. Excellent forum.

Bushman:
Run your fave flavour of Linux in a virtual box like VBox.  I run Ubuntu on my Win 7 system that way.  No need for separate hardware.

vpweather:

--- Quote from: Bushman on March 03, 2013, 07:06:12 PM ---Run your fave flavour of Linux in a virtual box like VBox.  I run Ubuntu on my Win 7 system that way.  No need for separate hardware.

--- End quote ---

Hi Bushman,
Thank you for your reply. That sounds like a good idea. Am running Cumulus-Weather on a Virtual Machine on a Mac Mini therefore running a Linux distro shouldn't be a problem.
Think that I'd prefer to opt for Ubuntu as you have done too.
Best Regards.

Navigation

[0] Message Index

[#] Next page

[*] Previous page