Raspberry Pi Forums

RDK

I GIVE UP!!!!! The send mail problem as originally posted, is still there: Issue: g-mail is complaining that for the problem e-mail the e-mail (auto copied) recipient "root@piv3-dev" can not be sent as the domain does not exits. Of course, this is correct. For the other Pi's, setting root to nothin...

RDK

Dougie….Great idea, but I have no idea how to change the CRON log location?...RDK

RDK

Pcmanbob….Good new and bad news. G-mail did not complain about a bad e-mail address ("root@piv3-dev") and I only got one copy to my Hotmail account. HOWEVER, cron did complain in a separate message to my Hotmail account and I do not understand. I have tried to google this without any meaningful (to ...

RDK

Pcmanbob….That's cool....RDK

RDK

Pcmanbob….With the exception of the root= line your conf file is the same as mine. I really don't want the root to point to my g-mail address, so I will, for now, point it to the same address I'm using for the e-mail. I did not fully understand your final comment: the only time I get an extra email ...

RDK

Dougie….I installed "sudo apt-get install ssmtp" and "sudo apt-get install mailutils" which is working just fine for 5 out of 6 Pi's as I indicated in my original note.... Pcmanbob….I guess from the docs that ssmtp mail sends a copy of everything to the address specified by the "root=" parameter in ...

RDK

pcmanbob...Thanks for the quick reply. I already pipe the cron job output and there are no errors. Actually the e-mail is being sent just fine and arrives at my Hotmail account perfectly. This issue is that it also seems to be copied to "root@piv3-dev", which is automatic when the "root=" parameter ...

RDK

I have 6 Pi's which every night at midnight send me a status e-mail. 5 of the 6 are working correctly, the 6-th is going to make me bald. Details. The same "sendtome.sh" script is being used on all the Pi's. This script sends the e-mail using a special g-mail account I have set up, as defined in the...

RDK

Gentlemen....I wish to thank you, one and all, for your time, expertise, comments and opinions, but at this time I wish to abandon this question. I say that because the answer to my question it that I can not upgrade MariaDB on this Pi unless I'm willing to upgrade to Buster, basically a total rebui...

RDK

Wow, my question seems to have generated quite a "tempest in a teapot". I actually have Buster running on a different Pi, but it is having difficulty running some of my programs and finding drivers for a few of my HAT devices. Thus, I'm reluctant to move to Buster for this application. Can MariaDB b...

RDK

Historically, most likely before version Windows 10 1903, when I clicked the Network link in the "This PC" item in the File Explorer, it would show all of my Samba Pi shares as well as all of the other computers on my network. Now I only see the computers on my network. I can map to these Pi shares ...

RDK

About a week ago I installed MariaDB via sudo apt-get install mariadb-server and it is all working just fine. However, I just tried to use the ROW_NUMBER() function and MariaDB throws a syntax error. Further investigation ( https://mariadb.com/kb/en/library/row_number/ ) seems to indicate the this f...

RDK

The Mystery deepens or maybe clears up!!! Sometimes it is amazing how sleeping on a problem will lead to a solution. In this case sleeping had nothing to do with it, it was the passage of time that mattered. OK, I think that my earlier assumption, that CROM was misbehaving, is correct. This morning ...

RDK

Yeh, that is basically the command I reported above except I was piping the output to a file on my USB stick. Regardless, when I pointed it to output.txt (actually /home/me/output.txt) it worked. GRRRR So now, I back to trying to figure out the issue with my sendtome.sh script. I can't spend any mor...

RDK

PCMANBOB....Thanks for your reply, but I'm beginning to think there is something more fundamental going on here, maybe my CRON service is not running or is misbehaving. To test this idea I entered the following into my cron -e : 39 14 * * * /bin/ls > /mnt/usbdrive/output/CRON_output.txt 2>&1 I got n...

RDK

I'm running Stretch on a Pi v3, recently updated. I want to e-mail a note each night at midnight, so I added this line to "CRON -e": 0 0 * * * /usr/pgms/sendtome.sh "MyPi" "/mnt/usbdrive/error.log;/mnt/usbdrive/ReaderPrint.txt" > /mnt/usbdrive/CRON_output.txt 2>&1 . Where SENDTOME.SH is a BASH scrip...

RDK

Sheer stupidity!!! When I created this new Gmail account, I mistyped the userid. A subtle error, an 'n' instead of a 'r' in the middle, so it was not obvious. Thus in my config file I had the wrong Gmail authorized user name. Seems to be working now... Thanks for your time....RDK

RDK

I'm also trying, without success, to set up my Pi (V3 running Stretch) to send me a message once a day. I have basically followed this procedure: sudo apt-get install ssmtp sudo apt-get install mailutils sudo nano /etc/ssmtp/ssmtp.conf Here is my conf file: # Config file for sSMTP sendmail # # The p...

RDK

Folks....using Excel 2016 and it is now retrieving data from MariaDB on a Raspberry Pi. Thanks for all of your assistance....RDK

RDK

Dougie….I had added 0.0.0.0 to allow all hosts and even created a remote user with 192.168.0.%, BUT forgot to use that user id in the dns creation step.. Thanks for the wakeup, the dns is now created. Next to actually get to the MariaDB and extract some data. More later....RDK

RDK

I followed the instructions in Dougie's note above: To get Windows connected to MariaDB with ODBC I've started with the MSI installer. https://downloads.mariadb.com/Connector ... -win64.msi [Win]+[R] run odbcad32 Add your MariaDB data source with the server name, port, userid and password. Note: you...

RDK

Good idea, but no, it does not like anything like that. Thanks....RDK

RDK

Some time ago I installed the SunSpec library on my Raspberry Pi v3. using this process sudo easy_install -U pyserial sudo git clone --recursive https://github.com/sunspec/pysunspec.git cd pysunspec sudo python setup.py install # to test python -m unittest discover -v sunspec Now I would like to com...

RDK

Dougie….. WOW!!! Looks good. Do I need to repeat the steps you noted in your first note (of your last two notes) or only those in the last note? I'll try to get to this today but I have lots of yard work on my wife's todo list. I assume I should uninstall that "connector ensemble" that I downloaded ...

RDK

OK, thanks for your efforts. This is not a critical issue. My workaround is to run an app on the Pi to retrieve the data to a CSV file and then import it into Excell. That works but adds an extra step. Not a big deal. However, if I can get the direct access approach to work, ever better….RDK

Search found 262 matches

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Re: Problem with send mail, it insists to send a copy to root

Problem with send mail, it insists to send a copy to root

Re: How can I get the latest version of MariaDB?

Re: How can I get the latest version of MariaDB?

Seeing SAMBA shared in Windows 10 Network display

How can I get the latest version of MariaDB?

Solved: Problem running a CRON job

Re: Problem running a CRON job

Re: Problem running a CRON job

Problem running a CRON job

Re: Client email to send emails from command line

Re: Client email to send emails from command line

Re: Retrieving MySQL data from Windows Excel

Re: Retrieving MySQL data from Windows Excel

Re: Retrieving MySQL data from Windows Excel

Re: How do I remove a library installed from a GIT site via a clone command?

How do I remove a library installed from a GIT site via a clone command?

Re: Retrieving MySQL data from Windows Excel

Re: Retrieving MySQL data from Windows Excel