bavaserver To-do List

This entry was posted in bavatuesdays, sysadmin and tagged , . Bookmark the permalink.

10 Responses to bavaserver To-do List

  1. Ryan Collins says:

    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.

    • Jim Groom says:

      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.

  2. Jim Groom says:

    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 bavatuesdays.com;
    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

  3. Pingback: The bava an A-Lister at Long Lost | bavatuesdays

  4. Reverend says:

    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!

  5. Reverend says:

    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.

  6. Reverend says:

    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 bavatuesdays.com. If it does not see it for more than 10 minutes there will be an alert sent into Reclaim’s Slack channel for monitoring.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.