bavaserver To-do List

10 Responses to bavaserver To-do List

1. Ryan Collins says:

   January 7, 2020 at 9:41 am

   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.

   Reply
   • Jim Groom says:

     January 7, 2020 at 10:53 am

     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.

     Reply
     • Ryan Collins says:

       January 12, 2020 at 8:06 pm

       Sequel Pro is a good way to get started because you can use the query tab to practice.

       Reply
2. Jim Groom says:

   January 7, 2020 at 11:15 am

   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

   Reply

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

4. Reverend says:

   January 9, 2020 at 2:04 am

   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!

   Reply
5. Reverend says:

   January 9, 2020 at 6:21 am

   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:

   • Open port 3306 in CSF
   • Adding skip-networking=0 and skip-bind-address to MariaDB config file
   • Creating new user and granting them privileges on the database I want to be able to remotely edit
   • Install Telnet on my Mac (brew install telnet) to test the port is open telent 3306 (http://osxdaily.com/2018/07/18/get-telnet-macos/)

   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.

   Reply
   • Ryan Collins says:

     January 12, 2020 at 8:06 pm

     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.

     Reply
     • Reverend says:

       January 13, 2020 at 2:54 am

       Good call, will work on this today!

       Reply
6. Reverend says:

   January 10, 2020 at 5:42 am

   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.

   Reply

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