Get the Nginx configuration to force https- Figure out why Bitninja external firewall wreaks havoc when activated (php-fpm and/or Nginx conflicts?)
Experiment with phpMyAdmin versus SequelPro to see how I want to manage the database going forwardSetup monitoring so I know when the server goes downFigure out how to ensure MariaDb automatically starts when server rebooted- Track down the “Post-processing of the image failed. If this is a photo or a large image, please scale it down to 2500 pixels and upload it again” error when uploading larger images (wonder if this is server or application related)
- Optimizie MySQL
Install NCDU
Watch the bava blog trailer!
about
is an ongoing conversation about media of all kinds ...
Testimonials:
Generations from now, they won't call it the Internet anymore. They'll just say, "I logged on to the Jim Groom this morning.
-Joe McMahon
Everything Jim Groom touches is gold. He's like King Midas, but with the Internet.
-Serena Epstein
My understanding is that an essential requirement of the internet is to do whatever Jim Groom asks of you while you're online.
-James D. Calder
@jimgroom is the Billy Martin of edtech.
-Luke Waltzer
My 3yr old son is VERY intrigued by @jimgroom's avatar. "Is he a superhero?" "Well, yes, son, to many he is."
-Clint Lalonde
Jim Groom is a fiery man.
-Antonella Dalla Torre
“Reverend” Jim “The Bava” Groom, alias “Snake Pliskin” is a charlatan and a fraud, a self-confessed “used car salesman” clawing his way into the glamour of the education technology keynote circuit via the efforts of his oppressed minions at the University of Mary Washington’s DTLT and beyond. The monster behind educational time-sink ds106 and still recovering from his bid for hipster stardom with “Edupunk”, Jim spends his days using his dwindling credibility to sell cheap webhosting to gullible undergraduates and getting banned from YouTube for gross piracy.
I am Jim Groom
Find out more about me here.
Recent comments
- Reverend on Scramble Project Update: Stenciling the Side Art
- Reverend on Scramble Project Update: Stenciling the Side Art
- Terry Fonder on Scramble Project Update: Stenciling the Side Art
- Weekly Training – Reflection #1: Introduction to Digital Humanities Tools and Frameworks – Portfolio on What Richard Scarry has to Teach Us About Domains
- John on On This Day
- Alan Levine on On This Day
- On This Day | bavatuesdays on Bad Boys (1983)
- On This Day | bavatuesdays on Broadway Danny Rose – “You’re living like a loser”
- On This Day | bavatuesdays on Rosemary’s Baby: A Retrospective
- On This Day | bavatuesdays on Child Bride (1938)
- On This Day | bavatuesdays on “EdTech transmissions: We Control the Vertical and the Horizontal” at Maricopa College
- On This Day | bavatuesdays on What I’m up to….
- On This Day | bavatuesdays on Wire 106: S01E11 “The Hunt”
- On This Day | bavatuesdays on Creating GIFs with Text in GIMP
- On This Day | bavatuesdays on Multiple Hosting Accounts made easy for Domains
-
Recent Posts
- Remember to Reclaim September
- On This Day
- 9 WordPress Themes from 2007 that Still Work
- Rise of the Machines
- Mail Suppression
- Good Vibrations for MU Migrations
- Preparing for ReclaimPress
- August Community Chat: Reclaim Social Networks
- More Notes on ds106 Clean-Up
- ds106 Hacked and WordFence to the Rescue
browse the bavarchive
Contributors
some favorites
- Alan Levine
- Andy Rush
- Audrey Watters
- bava.social
- Bonnie Stewart
- Brian Lamb
- Bryan Alexander
- Chris Lott
- Clint LaLonde
- Cole Camplese
- Darcy Norman
- David Kernohan
- David Wiley
- Gardner Campbell
- GNA Garcia
- Grant Potter
- Jeffrey Keefer
- Jon Beasley-Murray
- Jon Udell
- Kate Bowles
- Kin Lane
- Laura Blankenship
- Leslie Madsen-Brooks
- Lisa M Lane
- Martha Burtis
- Martin Hawksey
- Martin Weller
- Mike Caulfield
- Mikhail Gershovich
- Mountebank
- Paul Bond
- Scott Leslie
- Serena Epstein
- Shannon Hauser
- Stephen Downes
- The OLDaily
- Tim Owens
- Tom Woodward
- Tony Hirst
AS for phpMyAdmin vs SequelPro, I vote for the latter although I’m trying to replace both with the humble command line. Using a front end abstracts me away from the commands, and I feel like I lose something in the process.
Ryan.
My command kung-fu is not nearly good enough to tackle SQL commands just yet, so at least in the near term I will need a GUI interface, and I do think Sequel Pro might be less overhead in the end, so I might start there. But I must say, if you can point me to the resource where you are learning SQL on the command line, I would be much obliged.
Sequel Pro is a good way to get started because you can use the query tab to practice.
Looks like I figured out how to force SSL on bavatuesdays, I created
/etc/nginx/conf.d/ssl-redirect.conf
And added the following configuration:
server {
listen 80;
server_name ;
return 301 https://$host$request_uri;
}
Here were the resources I found for this:
https://www.digitalocean.com/community/tutorials/how-to-create-a-self-signed-ssl-certificate-for-nginx-on-centos-7
https://stackoverflow.com/questions/34341782/nginx-server-directive-is-not-allowed-here
Pingback: The bava an A-Lister at Long Lost | bavatuesdays
Figured out the MariDB is by default configured not to restart on reboot, I was able to change this setting with the following command:
systemctl enable mariadb
After that, symlinks were created:
Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
And after that I tested it out with a reboot, and MariaDB started up automatically. Winning!
I have been experimenting with Sequel Pro, and finally managed to do a few things to get it running, I am noting them below, along with at least one concern I have:
My concern is securing MySQL, so my remote logins are secured. I am getting the error they are not secure, so credentials are being passed unencrypted. I am going to explore with issuing keys using this guide, so I still have a bit more to do on this, but I am getting there.
Instead of opening up port 3306, use an SSH tunnel in Sequel Pro.
Click on the SSH tab, fill out the SSH info at the bottom, and connect to MariaDB on 127.0.0.1/3306. Sequel Pro will take care of the rest.
This way logins are secure and not available across the internet.
Good call, will work on this today!
Monitoring is pretty easy to do, we use Uptime Monitor for Reclaim Hosting, so I just added a keyword search monitor that will alert me when the keyword “bavatuesdays” is not found at . If it does not see it for more than 10 minutes there will be an alert sent into Reclaim’s Slack channel for monitoring.