Hello Vince,
The quickest way I found was to install linux either on a separate HD or
HD partition so you can dual boot OS's (ie be able to pick one) or else
install the linux OS onto a USB thumb drive and just boot into it when
you start your PC or laptop by hitting the hotkey during startup menu to
display the boot menu and you can pick the USB drive that way. It
usually shows up as "USB Hard Drive" in the list with a abbreviation of
the mfr's name in the list.
Beware if you install it on a USB thumb drive you might want to install
the 32 bit version in case you happen to want to run it on an older 32
bit machine. Otherwise just stick with 64 bit versions since that is
commonly what hardware is available these days.
Once you get linux in, use the command line (in debian OS's like
ubuntustudio or mint etc check www.distrowatch.com to pick the one you
like) and type sudo su to give you boss privileges and then type "apt
install synaptic ntp" & when it is done then just type "synaptic" and it
will open the package manager and allow you to select the programs you
desire to install. [check with whatever version you decide to use as the
commands are different between them ie some use rpm and others use yum
instead of the sudo and apt combination mentioned here.]
I picked apache2 web server and mysql (both client and server); once
they are in and running (just open the firefox web browser and tell it
to connect to "localhost" the page will open saying it works. It is a
web server on your machine only and it is needed to run the phpmyadmin
to come the next step. Mysql will ask you for a password for the mysql
server BOSS or root user. Make note of it as everything you do in future
projects will ask for it to install different mysql databases for you.
Now go back to the synaptic package manager and tell it to install
"phpmyadmin".
It will install all the needed php code and set it up to talk on a user
friendly screen to connect to your mysql databases with a user friendly
graphic user screen. If when you try to open it, it just shows some
strange text code and no graphics as some installs have done in the past
contact me by email here and I will dig up the command statement to use
to add the missing piece so it works right for you. I use
UbuntuStudio18.04 LTS the latest version.
Then you can use this phpmyadmin to easily go in and create the mysql
user weewx with password weewx and grant all the needed permissions
requested in the weewx setup instructions. Once the user is created
change the weewx.conf (/etc/weewx/weewx.conf ) file to use myql
instead of sqllite and then tell weewx to do a conf file reload
Next time it starts and runs if you did it all correctly it will
automatically create & update the database. Using the thumb drive will
make it easy to learn and familiarize you with linux and mysql databases
in general but wouldn't be ideal to run 24/7/365 to keep database in
sync for weewx.
I had it happen to me and the solution to get it back in sync for me was
to use phpmyadmin to go in and drop /delete the weewx database then use
the synaptic package manager and use the "reinstall" option to reinstall
weewx. (be sure to back up your /etc/weewx/weewx.conf file before you
reinstall that way once the initial reinstall is done you can just stop
weewx and copy the conf file in so you don't have to re-enter all the
settings from new)
There are some instructions on doing the same thing in windows if you
prefer but being retired myself, I find linux way easier and cheaper to
use. It comes with full libreOffice or OpenOffice installed which is
fully compatible with the gold lined M$Office suite and you are not tied
to clouds or license fees ongoing. The libreoffice-base database
component has been maturing for last 15 yrs but hasn't reach full
equivalence to M$Access yet but it is close. It does have a connector
file to the MySQL databases so that you should be able to design and run
reports using it. If you just use MySQL queries they get the specific
data you want but only in raw text form; whereas using the report
function in libreOffice Base you are able to do some extra formatting
and sorting and fonts etc.
Linux includes GIMP 2.8 a robust replacement for photoshop type programs
as well as kdenlive a video editor like premiere elements.
It includes all sorts of ham programs as well.
It's biggest advantage I have found, beyond cost of software, is the
fact that once you install everything so it uses the synaptic package
manager it updates ALL software at the same time not just the OS.
Unlike Linux updates M$ OS needs to be done itself and in that case
sometimes multiple restart sessions and then you have to do SP's and
then more updates and finally each program as well as flashplayer and
JAVA separately as well. If you run a zonealarm type firewall/AV the
data updates as well as program upgrades have to be done separately as
well. All taking a lot of time and possible data overage charges too if
you are in a rural area with costly data meters running.
I run a full blown install on a 32GB USB 3.0/2.0 drive. I keep it
mostly generic so I can can quickly clone it onto a new hard drive if
one craps out on me. The other advantage with linux is you can set it
up on one machine and if something on the mainboard fails you can,
unlike windows products, just pull the SATA drive and put it into
another PC and you are up and running and fully configured in less that
20 mins from a total system failure. Linux tailors itself to the
hardware rather than you having to tailor everything to fit the OS like
windows.
Windows means wiping out the hard drive and reinstalling everything from
scratch with SP's and updates which can take as long as a whole weekend.
That is pretty costly in terms of time to me.
I have found a lot of projects often use mysql so yes that phpmyadmin
would be a big help for that.
/*LINUX Noobie links*/
https://ryanstutorials.net/linuxtutorial/
https://www.tutorialspoint.com/unix/
https://www.google.ca/search?hl=en&ei=l16dW5PAOKTVjwSiwYSgDQ&q=linux+for+dummies+pdf&oq=linux+for+dummies+&gs_l=psy-ab.1.0.0l10.5499.12188.0.17879.21.17.0.4.4.0.199.2506.0j17.17.0....0...1c.1.64.psy-ab..0.21.2517...0i67k1.0.rjJ8Owjy3cw
/*MySQL Noobie links*/
*Oracle MySQL pdf reference manual*
https://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=2ahUKEwjvrLa25L3dAhVrzIMKHbQYArgQFjAAegQICxAC&url=https%3A%2F%2Fdownloads.mysql.com%2Fdocs%2Frefman-8.0-en.pdf&usg=AOvVaw2r92NK9jbrgyOBB5NXzEJE
https://www.google.ca/search?hl=en&ei=Wl-dW_O1NqK3jwStspjgAQ&q=MySQL+for+dummies+pdf&oq=MySQL+for+dummies+pdf&gs_l=psy-ab.12..0i7i30k1l3j0i30k1j0i7i5i30k1l2j0i5i30k1j0i7i5i30k1j0i5i30k1j0i8i30k1.147128.149454.0.153851.5.5.0.0.0.0.162.740.0j5.5.0....0...1c.1.64.psy-ab..0.5.740...0i7i10i30k1j0i8i7i30k1j0i13i30k1.0.dOHwdKUFyVk
Hope this info is useful;
cheers & 73
Andy de ve4per
p.s. look into YUMI on google search to build a tech troubleshooting
thumb drive. I found boot repair, clonzilla, gparted and the install OS
sections to be really big help. I find it works OK on my windows laptop
and in rural area here none of the ISP's will troubleshoot over the
phone if I am using linux. They always ask me to disconnect my ome
network and just plug the windows laptop into their demark point
connection; so since windows has to be here I use the YUMI package to
create my troubleshooting thumb drives. I have seen write ups that there
are also linux versions of the same thing
( https://downloads.tomsguide.com/Yumi,0301-58461-59526.html )
--
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.
