Recognition

Contributions

9 Contributions
  • Published Answer

    Problem with redli command on managed redis db

    Never mind… I tried reconnecting again later and the redli commands were working. I have no idea what was going on the first time…
    By JigsawBob
  • Published Question

    Problem with redli command on managed redis db

    I have set up a DO managed redis db and installed the redli command on my droplet. When I enter redli --tls -h <host> -a <password> -p 25061 on the droplet the db returns Connected to 5.0.6. But if I then enter any re...
    1 By JigsawBob DigitalOcean Managed Redis
  • Published Question

    How to debug DO managed DB throughput/latency spikes?

    I recently moved my WordPress database to a DO managed MySQL db. So, I have a single droplet connected over a private network to a single DO db. Since then, I have been seeing occasional large spikes in db throughput ...
    1 By JigsawBob DigitalOcean Managed MySQL Database
  • Published Answer

    How to change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Database?

    I just want to contribute to this thread by stating that I too was seeing the same error message after switching my WordPress (PHP)…
    By JigsawBob
  • Published Question

    Which SQL mode values to use for WordPress?

    I have a WordPress site running on a DO droplet and WordPress uses a localhost MySQL db. I want to migrate the db to a DO managed MySQL db. I have created the new db and completed migrating the db data, however, I hav...
    Accepted Answer: DO managed DBs do work with WP, I ran many tests with them. You might bump into a couple of issues: In the DO GUI DB settings, you need to set STRICTTRANSTABLES You might want to check this: https://www.digitalocean.c...
    3 By JigsawBob DigitalOcean Managed MySQL Database
  • Published Question

    Droplet experiencing high load averages during low CPU usage

    I have a Ubuntu 18.04 droplet that occasionally experiences high load averages for brief periods, but the DO monitoring charts show low and steady CPU usage, steady disk I/O, steady traffic, and a small bump in RAM (p...
    1 By JigsawBob Miscellaneous
  • Published Question

    How to set up SSH/SFTP subdomain?

    I currently connect to my droplets via SSH and SFTP by specifying the droplet's IP address and port 22 in the SSH/SFTP client programs. This works fine, but I would like to be able to specify a domain or subdomain (e....
    2 By JigsawBob DigitalOcean Ubuntu 16.04
  • Published Question

    How to change Ubuntu user email address

    My Ubuntu droplet is sending emails for things like cron output to email address my-user-name@ubuntu. The emails pile up in file /var/mail/my-user-name. How can I change this so the emails go to my external email addr...
    Accepted Answer: You can forward root's mail inbox to your email address. To do this, you can open the /etc/aliases file with your editor. You will find this inside the file. ``` See man 5 aliases for format postmaster: root ``` Ad...
    2 By JigsawBob Email Ubuntu 16.04
  • Published Answer

    Putty error: No supported authentication methods available (server sent: publickey)

    @thelunchbawx, I am having the exact same problem. Did you figure out a solution?
    By JigsawBob