Go to advanced search

by RDK
Wed Sep 04, 2019 9:44 am
Forum: Beginners
Topic: How can I get the latest version of MariaDB?
Replies: 19
Views: 442

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

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...
by RDK
Tue Sep 03, 2019 12:03 pm
Forum: Beginners
Topic: How can I get the latest version of MariaDB?
Replies: 19
Views: 442

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

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...
by RDK
Tue Sep 03, 2019 7:36 am
Forum: Beginners
Topic: Seeing SAMBA shared in Windows 10 Network display
Replies: 3
Views: 105

Seeing SAMBA shared in Windows 10 Network display

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 ...
by RDK
Tue Sep 03, 2019 7:30 am
Forum: Beginners
Topic: How can I get the latest version of MariaDB?
Replies: 19
Views: 442

How can I get the latest version of MariaDB?

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...
by RDK
Fri Aug 16, 2019 10:32 am
Forum: Beginners
Topic: Problem running a CRON job
Replies: 5
Views: 276

Solved: Problem running a CRON job

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 ...
by RDK
Thu Aug 15, 2019 4:53 pm
Forum: Beginners
Topic: Problem running a CRON job
Replies: 5
Views: 276

Re: Problem running a CRON job

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...
by RDK
Thu Aug 15, 2019 12:45 pm
Forum: Beginners
Topic: Problem running a CRON job
Replies: 5
Views: 276

Re: Problem running a CRON job

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...
by RDK
Thu Aug 15, 2019 7:04 am
Forum: Beginners
Topic: Problem running a CRON job
Replies: 5
Views: 276

Problem running a CRON job

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...
by RDK
Tue Aug 13, 2019 11:00 am
Forum: Raspbian
Topic: Client email to send emails from command line
Replies: 35
Views: 11021

Re: Client email to send emails from command line

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
by RDK
Tue Aug 13, 2019 5:48 am
Forum: Raspbian
Topic: Client email to send emails from command line
Replies: 35
Views: 11021

Re: Client email to send emails from command line

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...
by RDK
Tue Jun 11, 2019 12:55 pm
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

Folks....using Excel 2016 and it is now retrieving data from MariaDB on a Raspberry Pi. Thanks for all of your assistance....RDK
by RDK
Tue Jun 11, 2019 8:24 am
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

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
by RDK
Tue Jun 11, 2019 6:35 am
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

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...
by RDK
Mon Jun 03, 2019 11:23 am
Forum: Beginners
Topic: How do I remove a library installed from a GIT site via a clone command?
Replies: 3
Views: 195

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

Good idea, but no, it does not like anything like that. Thanks....RDK
by RDK
Mon Jun 03, 2019 5:09 am
Forum: Beginners
Topic: How do I remove a library installed from a GIT site via a clone command?
Replies: 3
Views: 195

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

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...
by RDK
Sat Jun 01, 2019 4:40 am
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

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 ...
by RDK
Fri May 31, 2019 5:09 pm
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

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
by RDK
Fri May 31, 2019 12:36 pm
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

I returned to the setup and installed the "MySQL for Excel" application. After a reboot, I now see the "MySQL for Excel" option on the Excal/Data menu bar. When I click on it it looks like I'm headed in the right direction and the resulting menu makes sense!!! However, after I supply all of the info...
by RDK
Fri May 31, 2019 6:03 am
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

OK, I followed your links and have installed the following: MySQL Workbench 8.0.16 MySQL Shell 8.0.16 MySQL Router 8.0.16 Connector/ODBC 8.0.16 Connector/C++ *.0.16 Connector/J 8.0.16 Connector/NET 8.0.15 I did not install the Server option. There was also, as I recall, an application option that I ...
by RDK
Thu May 30, 2019 6:23 pm
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Re: Retrieving MySQL data from Windows Excel

OK, I changed the /etc/mysql/mariadb.conf.d/99-local.cnf file.

Now, not real sure what you (Dougie) are suggesting. When I go to Excel / Data tab which menu items do I select? I see "From Other Surces", "Existing Connections' and "New Query".

Thanks....Rob
by RDK
Thu May 30, 2019 4:41 am
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1280

Retrieving MySQL data from Windows Excel

I have a Raspberry Pi running Stretch and MySQL/MariaDB. It is monitoring some weather sensors and storing the data to a MariaDB database. From my Windows 10 laptop on the same home network (Intranet) I'd like to pull some of the data directly using Excel and its Data Access functions. Basically I c...
by RDK
Sat May 18, 2019 7:35 am
Forum: Troubleshooting
Topic: Windows 2003 server can not connect to SAMBA shares
Replies: 4
Views: 207

Re: Windows 2003 server can not connect to SAMBA shares

Thanks folks. This is not a very high priority, so I will proceed with lots of caution and backups.....RDK
by RDK
Fri May 17, 2019 5:31 pm
Forum: Troubleshooting
Topic: Windows 2003 server can not connect to SAMBA shares
Replies: 4
Views: 207

Windows 2003 server can not connect to SAMBA shares

There is a similar posting on this issue but for Window 8 ( https://www.raspberrypi.org/forums/viewtopic.php?p=660752 ). I have and/or have had several Windows 7, Vista and now Window 10 Pro and Windows Family and all have been able to connect to my Pi's without issues. The Pi's are all set up with ...
by RDK
Sat May 11, 2019 3:19 pm
Forum: Beginners
Topic: Python Access using mysqlbd not working
Replies: 4
Views: 203

Re: Python Access using mysqlbd not working

Yes, having to find and then match case for a library is a bit annoying. But, I'm now working with either MySQLdb or pymysql for using a DictCursor. Unlike pymysql and mysql.connector which use database for specifying the database name, MySQLdb uses db . Another thing which slowed me down. Oh well, ...
by RDK
Sat May 11, 2019 4:44 am
Forum: Beginners
Topic: Python Access using mysqlbd not working
Replies: 4
Views: 203

Re: Python Access using mysqlbd not working

Thanks for the interest. I'm using Python 2.7. This is a fresh install of Stretch on an Raspberry Pi v3. I have installed the following: sudo apt-get install mariadb-server sudo apt-get install python-mysqldb sudo apt-get -y install python-mysql.connector sudo apt-get install libmariadbclient-dev su...

Go to advanced search