Category Archives: Technology

Use SCP to copy files between remote and local hosts

02/04/2019 Mark Jacobsen Leave a comment

So you need to copy a file you have on a remote server locally, or send a local file to a remote server? Fortunatally, it’s pretty easy with scp. Here’s an example to copy a remote server to the local machine.

scp -P 65124 remoteuser@remotehost:/var/lib/path/to/file.txt /var/lib/path/to/

…which will connect to “remotehost” on port 65124 as “remoteuser” and copy the /var/lib/path/to/file.txt on “remotehost” to the local /var/lib/path/to/ directory.

Need to copy a local file to a remote host? Just switch the parameters up!

scp -P 65124 /var/lib/path/to/file.txt remoteuser@remotehost:/var/lib/path/to/

Please remember to subscribe to the newsletter or feed to stay up to date!

Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself.

Linux

Set a proxy and carry over the values to sudo

01/25/2019 Mark Jacobsen Leave a comment

If you’ve ever been behind an enterprise proxy server and needed to reach things on the outside, you probably know how frustrating it is to try and just use your normal commands for something as simple as a wget. So, to get started you will need to know the URL and port for your proxy server, but once you have that, start by editing your .bashrc and add the following (setting proxyhost, the port, and adjusting “no_proxy” as appropriate)…

function proxyon(){
     echo -n "password (for proxy): "
     read -es password
     export http_proxy="http://$USER:$password@proxyhost.com:8181/"
     export HTTP_PROXY=$http_proxy
     export https_proxy=$http_proxy
     export HTTPS_PROXY=$http_proxy
     export ftp_proxy=$http_proxy
     export rsync_proxy=$http_proxy
     export no_proxy="localhost,127.0.0.1,localaddress,.localdomain.com,.domain.com"
     echo -e "\nProxy environment variable set."
}
function proxyoff(){
     unset HTTP_PROXY
     unset http_proxy
     unset HTTPS_PROXY
     unset https_proxy
     unset FTP_PROXY
     unset ftp_proxy
     unset RSYNC_PROXY
     unset rsync_proxy
     echo -e "\nProxy environment variable removed."
}

# remove next line if you don't want to set proxy automatically on login
proxyon

Now you can turn your proxy on and off with the “proxyon” and “proxyoff” commands, but that doesn’t help you when you try to install something with yum or apt that requires sudo. To carry over the proxy values, you’ll need to “sudo visudo” and add the “Defaults” line like shown below…

###############################################
# DO NOT ADD ANYTHING FROM HERE TO END OF FILE #
#
#includedir   /etc/sudoers.d
#
# DO NOT ADD ANYTHING ABOVE THIS LINE###########
Defaults env_keep = "http_proxy https_proxy HTTP_PROXY HTTPS_PROXY ftp_proxy"

… and now, hopefully you are all set.

Linux

Configure a Static IP in Ubuntu 18.04

01/21/2019 Mark Jacobsen Leave a comment

As with all things Linux there’s a million ways to do things, and every brilliant release comes up with a new way to do the same old things in a “better” way. Can you tell I’m be sarcastic yet? Good.

Anyway, after spending over an hour trying to get a freakin static IP on my desktop box I thought I’d share in case it saved anyone hours of their life.

My simple goal was to provide a static IP. Nothing more. Nothing less. Well, the “better” way of doing it now appears to be with “netplan”, and unless you enjoy banging your head against the wall, just create/edit this file and replace with the network interface (enp3s1), IP (192.168.20.55) and gateway (192.168.20.1) of your choice (this config appears to use the DNS servers from the router w/ DHCP turned on). Oh yeah, and don’t bother with the GUI based configuration tool, because apparently they’re not connected at all, and using this will force the config from this file (you’ve been warned and saved hours)

sudo nano /etc/netplan/01-networkd.yaml

# this is the actual file content
network:
  version: 2
  renderer: networkd
  ethernets:
    enp3s1:
      dhcp: no
      addresses: [192.168.20.55/24]
      gateway4: 192.168.20.1

DB2

Update modification timestamp on DB2 table automatically

01/03/2019 Mark Jacobsen Leave a comment

Ever want to update your modification timestamp field any time an update is made to the row without having to add application logic? Well, DB2 makes it relatively painless…

alter table XX.MY_TABLE add column last_updated_ts timestamp not null
generated by default for each row on update as row change timestamp

Check out these resources for additional information…

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0051498.html
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000888.html

Security, Technology

Is it time to quit social media?

10/21/2018 Mark Jacobsen Leave a comment

As I read this article what was running through the back of my mind was, “is it time to quit social media?”, and to be honest… but for being involved in real estate and a large bulk of that requiring being “engaged” I’m not sure I have much use for it. Never before has it been easier for marketers to target and connect with their “target audience”. You do realize that’s what social media has become right? The proverbial barrel where the fish are to shoot.

So, is it possible to take back the social networks? I’m not sure it is – at least with the current companies. Built from the ground up, or under a completely different model – maybe. But as the article linked to above points out it would be to the detriment of the “bottom line”.

Would I like a feed where I only see posts from my family, and maybe some other groups at my leisure? Of course, but unless I’m paying for that the only recourse I have is to a platform that has the resources to provide it based on the party that is willing to pay for it – the marketers.

So what would this “social media” service of the future look like? Number one, it should be built on a privacy, no-advertising first model. Second, I believe it should be decentralized, but speak a standard protocol – just like how email service is provided. Then, organizations like companies, teams, or even families could manage their own little groups and individuals could determine what they want to see or who they want to connect with…

And yet, as I sit here writing this, I wonder if it’s even possible or needed. After all, I’m able to run my own little blog right here. You can share it on social media if you so choose. In fact, I’ll probably post it to my account – and try not to look at the “likes” or “comments” that fuel the FB “engagement” engine.

So, while I may have just rambled for a number of paragraphs, let me finish by encouraging you to consider your use of social media, and at a minimum strongly consider turning off your notifications and moving the app to a sub-folder on your phone (just those two things alone have made a huge difference in my life). I would also encourage you to look into downloading and using Signal Messenger in place of text messaging and especially in favor of the social media messaging platforms.

Until we figure something out, you can always find me right here.Please remember to subscribe to the newsletter or feed to stay up to date!

Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself.

Programming

Including the version in a Maven artifact

09/27/2018 Mark Jacobsen Leave a comment

Recently I wanted to include the version of an artifact generated by a Maven build into a text file in that artifact. As Google and and good friends will help you with, I was pointed to this article that was exactly what I wanted.

Basically, create a /src/main/resources/version.txt file with the following content…

${project.version}

… then including the following snippet in your “build”…


<build>
  <resources>
    <resource>
      <directory>src/main/resources</directory>
      <filtering>true</filtering>
      <includes>
        <include>**/version.txt</include>
      </includes>
    </resource>
    <resource>
      <directory>src/main/resources</directory>
      <filtering>false</filtering>
      <excludes>
        <exclude>**/version.txt</exclude>
      </excludes>
    </resource>
  </resources>
</build>

Please remember to subscribe to the newsletter or feed to stay up to date!

Security

Stop Using WhatsApp If You Care About Your Privacy

05/10/2018 Mark Jacobsen Leave a comment

Yet another reason to use Signal…

Stop Using WhatsApp If You Care About Your PrivacyPlease remember to subscribe to the newsletter or feed to stay up to date!

Technology

This Week in Tech 663 Reasonably Miserable

05/08/2018 Mark Jacobsen Leave a comment

You need to listen to this Twit episode.

This Week in Tech 663 Reasonably Miserable | TWiT.TVPlease remember to subscribe to the newsletter or feed to stay up to date!

Technology

What’s it like to be a robot?

05/03/2018 Mark Jacobsen Leave a comment

Super interesting talk on how to adapt tech using robotics and the consequences of little design choices.

Please remember to subscribe to the newsletter or feed to stay up to date!

Security

Don’t Give Away Historic Details About Yourself

04/25/2018 Mark Jacobsen Leave a comment

Please be safe out there

Social media sites are littered with seemingly innocuous little quizzes, games and surveys urging people to reminisce about specific topics, such as “What was your first job,” or “What was your first car?” The problem with participating in these informal surveys is that in doing so you may be inadvertently giving away the answers to “secret questions” that can be used to unlock access to a host of your online identities and accounts.

Don’t Give Away Historic Details About Yourself — Krebs on SecurityPlease remember to subscribe to the newsletter or feed to stay up to date!