For the benefit of googlers finding this thread: normally errors of this type are because you installed a python2 library but are trying to use it from python3. The more I jump into Python the more I like it. The mysql install freezes, but after rebooting, it all seems to be there. I updated to the latest firmware released today and everything is working well. After this operation, 279 kB disk space will be freed. In our final tutorial in this series, we concentrate on installing and configuring WordPress on our Nginx web server.
There may be a need to close a cursor yet leave the connection open. The issue of it getting stuck on the installation was the exact same issue I was having, hence the rollback to a firmware I knew worked. Do I need to use Python 2, or is there another way? I tried installing the both pymysql and oursql using sudo apt-get install but neither package seems to be available. Closing it all up One quick way to bring down a server is leaving your connections open. Now we need to give the user wpuser access rights to the database wpdb. Love your site and tutorials man! This is part 2 in a 3 part tutorial which will ultimately see WordPress running from Nginx on your Raspberry Pi.
As in the previous examples, I'm going to create sample data from one day ago, 12 hours ago and now, and I'm going to record temperatures in three different zones. As before, I'm going to create a database named temps to store records with fields for a date, time, zone and temperature. Important, make sure you have backed up everything just in case the firmware fails to update. Now we need to install a couple of extra packages, php5-mysql and mysql-client. I am learning a lot! You will need this later to create additional users for WordPress.
If you want you can store these credentials in variables elsewhere. Your output will look like this: This Person's name is Cookie Monster This Person's name is Guy Smiley This Person's name is Big Bird This Person's name is Oscar Grouch This Person's name is Alastair Cookie You can also simply print out the row and look at the raw data: 1 2 3 loop to iterate for row in cur. For info on how to use the connector, visit It worked wonderfully. Hi Ryan, As above, I've tried both of those in order , and it hasn't solved the problem. Selecting previously unselected package python-mysqldb. You are actually closing two things: the cursor and the connection.
Just remember, for iterates but the cursor is the important part. Type this command: sudo rpi-update f6eef32dd6388c3b04dbf462bd324d93281bf397 If your firmware does not appear to be Friday May 30, skip to step 2. You should be logged into the server using these new credentials. One thing that occurred to me last night was that I was using Python 3. Getting data from the database Once data has been inserted into the database, we need to be able to retrieve it.
You might have already done a tut on this, but how do I setup mysql to hold the storage on an external drive? Note that the time and the temperature values have to be converted to a string before they can be appended to the result string. Type the following command to find which version of the firmware you have installed: sudo uname -a If your firmare reads this: Linux raspberrypi 3. Now all we need to do is create an additional user and create our database, ready for when we install WordPress. The Firmware update utility will begin running. This user is allowed to connect to the database from 'localhost'.
A complete list of privilege options is available at. When you run it you should see this output: The first name is Cookie The last name is Monster The first name is Guy The last name is Smiley The first name is Big The last name is Bird The first name is Oscar The last name is Grouch The first name is Alastair The last name is Cookie This is just a straight dump of the database. In this example, I'm going to search for records where the temperature is above 20. You should be prompted for a root password: Choose a secure password, and keep it safe. Create Your Python Script The first step of course is to create your Python Script. Login using your new credentials: mysql -u wpuser -hlocalhost wpdb -p When prompted, type the password that you assigned to your new user. I've been googling for ages now, and I'm getting no where.
This is why we do it in two steps. Done Building dependency tree Reading state information. After unpacking 279 kB will be used. I'm passionate about technology, and as long as I'm building cool stuff and helping people I'll never work a day in my life. Is this still the case? Each record is a list of values. I'm playing with my first Raspberry Pi 3 project, and I've hit a snag.
So here is how you close it up: 1 2 3 4 5 close the cursor cur. Type the following command: mysql -uroot -hlocalhost -p You will be prompted for the root password. This can be simplified using a Python context manager: with db: curs. Keep your eyes peeled for the tutorial. Go ahead and type the password that you gave for the root user in step 2. I used Oracles python libraries directly.