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

    • Ryan Collins says:

      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.

  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 . 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 to Jim Groom Cancel 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.