Thanks to all of you for the help. Thanks to Vince idea, I now happily am running Ubuntu Desktop on my Pi 4, which so far is a lot more polished than Raspbian OS (which is toylike by comparison). I have MariaDB successfully installed as well, which was a seamless process on Ubuntu -- this what I'm used to.
Next step is to get passwordless SSH running at least in test mode from the Pi, as my understanding is that it is required for rsync. When I can prove that out the path should be clear for rsync approach to pushing weather data to my cloud host. I doubt that there will be any issues with WeeWx install on Ubuntu + Pi but we'll see!!! This has been a rocky road. Doug I haven't had trouble with Win10 passwordless access to my Digital Ocean Ubuntu 20.04 webserver, just got stuck with Raspbian OS as the SSH client. But your checklist looks useful and I am a novice at RSA key pair authentication so it will likely come in handy. And I will take a look at Vince's recommendation for cygwin although the only problem I've had with Putty was puttygen key compatibility on Raspbian. I will report back when I get through it all... On Friday, August 12, 2022 at 2:08:15 PM UTC-7 [email protected] wrote: > I have had this issue with newer versions of MariaDB as well. The solution > was to run as root. See this thread > <https://stackoverflow.com/questions/28068155/access-denied-for-user-rootlocalhost-using-password-yes-after-new-instal> > > on SO. > > Or, maybe you already knew that. > > On Fri, Aug 12, 2022 at 9:13 AM Stephen Rogers <[email protected]> wrote: > >> Thanks Vince. I didn't include error messages because my question was >> (and is) whether there are other options for a small CPU I can use to >> replace the Pi/Raspbian. I appreciate your letting me know that you have >> confirmed Ubuntu can work on the Pi 4, I may try that. >> >> I see the differences between Ubuntu (which I am getting pretty familiar >> with) and Raspbian (which has some annoying differences in how users are >> implemented for example, plus the various issues below) as distracting from >> my main goals with WeeWx. >> >> With regard to the SSH passwordless login issue, I have been running into >> "Putty key format is too new" when using the keys created by Puttygen in >> Putty to log into a remote server. So this indicates to me that Puttygen >> is downrev on the Pi/RaspbiOS. I'm sure there is a way to make this work >> but I haven't found it. There are multiple options for generating keys. >> The ones I've tried don't work on Raspbian thus far. I have updated all >> the packages and gone through multiple reinstalls to make sure I wasn't >> tripping on some small detail. >> >> I don't see how firewalls or sudo play into these problems. >> >> I'm hearing you that you haven't had these problems with Pi. You are >> clearly much more of an expert and are working from solid install/config >> procedures that I don't have, since the (multiple) ones I've tried are not >> getting me through to the result. >> >> As for MariaDB, I have used it for years and the problems I'm running >> into with RaspiOS are ones I haven't seen on Ubuntu. Where I am stuck on >> that now is when running mysql_secure_installation after the basic MariaDB >> install, the root password is already set somewhere during the (very >> simple) database install, so it is impossible to set the root password >> (it's not blank as it is supposed to be, coming out of the install). This >> just seems to me like a bug. My motivation to use MariaDB is that I'm >> used to it, I've used sqllite before and it does not support the ability to >> do remote queries, which I'd like to do from my NodeJS web application to >> gather specific data from WeeWx data to incorporate into my app. If this >> were the only issue I'd probably just fall back to sqllite for now. >> >> I built an entire NodeJS web application for Pi that included MariaDB a >> few years ago, so I've seen MariaDB run on Pi successfully. This issue is >> new. >> >> Anyway, thanks again. I was wondering if the quality of the Pi/Raspbian >> has fallen behind but you are vouching for it so that is good input. I'll >> be thinking about my next move. >> >> What's frustrating is that I've had WeeWx running on a Pi 3 and pushing >> data via FTP for years to my hosted site, until the hardware gave out. I >> didn't think a reinstall on a new Pi 4 would surface all these issues I >> hadn't seen in my previous experiences with the Pi. >> >> >> On Thursday, August 11, 2022 at 5:07:00 PM UTC-7 vince wrote: >> >>> I think it's well established that the RaspiOS is just fine for all the >>> things you are trying to do, and my 'guess' is you are either running into >>> firewalling issues or you're not running sudo when needed. Without >>> seeing your logs and/or error messages, nobody can help you at all >>> basically. >>> >>> There 'is' ubuntu for the pi if you wanted to go that way. I just >>> installed the 64-bit variant of LTS server on a pi4 yesterday and it worked >>> fine in minimal testing, but personally I see zero reason to run other than >>> the RaspiOS which works in every way for anything I've ever tried to do on >>> it. It's just another Debian(ish) distro anyway. >>> >>> I do have to ask, however, why are you trying to use MariaDB rather than >>> the default sqlite3 ? That ups your complexity factor significantly. >>> The sqlite3 default just works right away out of the box. If you can't get >>> something simple like rsync to work, I'd suggest sticking with sqlite3 for >>> the least complicated setup if at all possible. >>> >>> -- >> 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]. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/1ef03561-aa5a-4a8e-b9b5-9d91548160e5n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/1ef03561-aa5a-4a8e-b9b5-9d91548160e5n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/48aaeab2-f3be-43b0-8de8-45537d6212a0n%40googlegroups.com.
