Go to advanced search

by RDK
Tue Jun 11, 2019 12:55 pm
Forum: Beginners
Topic: Retrieving MySQL data from Windows Excel
Replies: 20
Views: 1140

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: 1140

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: 1140

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: 155

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: 155

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: 1140

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: 1140

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: 1140

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: 1140

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: 1140

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: 1140

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: 165

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: 165

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: 165

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: 165

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...
by RDK
Thu May 09, 2019 5:10 pm
Forum: Beginners
Topic: Python Access using mysqlbd not working
Replies: 4
Views: 165

Python Access using mysqlbd not working

I'm having a world of problems using the Python mysqldb libraries in Stretch on a Pi v3. I've done a fair amount of searching on this topic and it appears that I'm not alone!! When I use "import mysqldb" I get an error "ImportError: No module named mysqldb". I've even posted this question on StackEx...
by RDK
Sun May 05, 2019 5:22 pm
Forum: Networking and servers
Topic: Putting Mysql database file on external hard drive
Replies: 16
Views: 4515

Re: Putting Mysql database file on external hard drive

Thanks, I've got a lot to learn....Rob
by RDK
Sun May 05, 2019 11:10 am
Forum: Networking and servers
Topic: Putting Mysql database file on external hard drive
Replies: 16
Views: 4515

Re: Putting Mysql database file on external hard drive

I followed the steps in the Jan 2019 entry at this reference ( https://lb.raspberrypi.org/forums/viewtopic.php?t=25978#p1397915 ) and it seems to be working: $ sudo /etc/init.d/mysql stop $ sudo mkdir /path/to/new/datadir $ sudo cp -R /var/lib/mysql/* /path/to/new/datadir $ sudo nano /etc/mysql/my.c...
by RDK
Sat May 04, 2019 5:39 pm
Forum: Networking and servers
Topic: Putting Mysql database file on external hard drive
Replies: 16
Views: 4515

Re: Putting Mysql database file on external hard drive

Thanks. The partition (usb stick) is mounted since I can access (via Simba) other files on it, both before and after I tried to restart the service. What should the permissions be set to?....RDK
by RDK
Sat May 04, 2019 4:12 pm
Forum: Networking and servers
Topic: Putting Mysql database file on external hard drive
Replies: 16
Views: 4515

Re: Putting Mysql database file on external hard drive

I added "nofail" to my mount statement in the fstab and also converted it to use the UUID. That has been working now for several weeks. and I have started using MariaDB and setting up users, etc, but no databases. Today I tried to make the changes suggested by rpdom on April 7 so I could have my dat...
by RDK
Sat Apr 13, 2019 5:26 am
Forum: Beginners
Topic: Object Programming in Python
Replies: 9
Views: 726

Re: Object Programming in Python

Heater....I have installed VS_Code on my laptop and I think it is operational. Seems like I have a lot to learn but it looks like something close to my wants. EDIT: My error: When coding an object, for example c=open(….), and I type x=c. I expected then to immediately get a drop-down of the methods ...
by RDK
Tue Apr 09, 2019 4:23 am
Forum: Beginners
Topic: Object Programming in Python
Replies: 9
Views: 726

Re: Object Programming in Python

B.Goode...No, I have not installed those libraries on the laptop. I've looked for a Windows install for pyModbus without success.

Heater....Sounds interesting. I will look at it...RDK
by RDK
Mon Apr 08, 2019 4:26 pm
Forum: Beginners
Topic: Python vs Python 3 - can't find module??
Replies: 4
Views: 322

Re: Python vs Python 3 - can't find module??

OK, well, I in fact installed it from the GIT sudo git clone https://github.com/sourceperl/pyModbusTCP.git Now should I reinstall as you propose? How do I remove the clone installed library? Thinking about it I have many libraries which I installed via the clone process, for example RTL_433. Is ther...
by RDK
Mon Apr 08, 2019 3:24 pm
Forum: Beginners
Topic: Python vs Python 3 - can't find module??
Replies: 4
Views: 322

Python vs Python 3 - can't find module??

I have a problem with Python 3 not finding a module library, but Python 2.7 does. Here is a VERY simple program: #!/usr/bin/env python # -*- coding: utf-8 -*- from pyModbusTCP.client import ModbusClient print("hello world") Below you can see back to back runs of this program only switching from pyth...
by RDK
Mon Apr 08, 2019 7:06 am
Forum: Networking and servers
Topic: Putting Mysql database file on external hard drive
Replies: 16
Views: 4515

Re: Putting Mysql database file on external hard drive

Andyroo: Thanks for the idea. Currently in my /etc/fstab I have this line: /dev/sda1 /mnt/usbdrive vfat defaults,dmask=000,fmask=111 0 0 which is configured to work for SAMBA read/write file sharing. If I understand you, and in practice it works like this, if I change USB sticks it does not matter a...

Go to advanced search