Archive for the ‘Power User’ Category
Posted by jpluimers on 2017/01/10
Getting the local IP (actually IPs, but most hosts only have a single IP):
# OS X:
alias whatismylocalip='ifconfig | sed -En '\''s/127.0.0.1//;s/.*inet (addr:)?(([0-9]*\.){3}[0-9]*).*/\2/p'\'''
# Linux:
alias whatismylocalip='ip a | sed -En '\''s/127.0.0.1//;s/.*inet (addr:)?(([0-9]*\.){3}[0-9]*).*/\2/p'\'''
I got them via bash – How to I get the primary IP address of the local machine on Linux and OS X? – Stack Overflow
Mac OS X and BSD have ifconfig, but most Linux distributions don’t use ifconfig any more in favour of iproute2, so you use ip a (which is shorthand for ip address show) there.
Their output is similar enough for the sed to work, though. Which surprised be because I didn’t know about the -E option (it lacks in the manual Linux page but it is in the Mac OS X one) which enables POSIX extended regular expressions. In Linux this is documented as -r, but -E also works.
I learned this through the Sed – An Introduction and Tutorial which compares the various versions of sed which also explains about the -n doing no printing.
–jeroen
Posted in *nix, *nix-tools, Apple, bash, bash, Development, Linux, Mac, Mac OS X / OS X / MacOS, Mac OS X 10.4 Tiger, Mac OS X 10.5 Leopard, Mac OS X 10.6 Snow Leopard, Mac OS X 10.7 Lion, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, openSuSE, OS X 10.10 Yosemite, OS X 10.8 Mountain Lion, OS X 10.9 Mavericks, Power User, Scripting, Software Development, SuSE Linux, Tumbleweed | Leave a Comment »
Posted by jpluimers on 2017/01/09
via: “SF has lost track of buses because SFMTA didn’t upgrade from 2G (to 3G to 4G to LTE) and AT&T finally turned it off.” – Kristian Köhntopp – Google+
If anyone ever wants to have a batch of LTE dumb phones built:
+Jeroen Wiert Pluimers I’m not aware of simple-voice-only phones with LTE modem. From my former life at a telephone producer i remember costs to get a platform running and the effort spend on special editions, i’d say if you are willing to buy 50000 we could find someone producing this for you. In China. But as written above, a basic-2G service (for M2M and emergency signalling or calls) will stay for long.
–jeroen
Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2017/01/09
Los, heb die Uhr auf. Habe ich das Urheberrecht oder du?
I’m partially word-blind and an learn by association.
So thanks to the below links, I can now remember Urheberrecht:
It’s about Ur, Heber and Recht.
–jeroen
Posted in LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2017/01/09
To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:
| Meaning: |
Column: |
Formula: |
Explanation: |
| Date1Text |
I |
=TEXT(C2,”dd/mm/yyyy”) |
Interpret date text of the original text no matter the Excel settings |
| Date1Value |
J |
=DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) |
Encode the date text to an actual date: dd#mm#yyyy format where # is any separator |
| DatesEqual |
K |
=J2=L2 |
Are the encoded dates equal? |
| Date2Value |
L |
=DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) |
Encode the date text to an actual date: mm#dd#yyyy format where # is any separator |
| Date2Text |
M |
=TEXT(N2,”mm/dd/yyyy”) |
Interpret date text of the original text no matter the Excel settings |
Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.
Source: Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons
Posted in Excel, Office, Office 2007, Office 2010, Office 2013, Power User | 1 Comment »
Posted by jpluimers on 2017/01/06
Brilliant! Helped me to track down why an original 1st generation Chromecast didn’t want to connect to a Buffalo WLAE-AG300N.
The problem there is that the original Chromecast does only 2.4Ghz WiFi and the WLAE-AG300N favours 5Ghz WiFi over 2.4Ghz when set to auto.
The solution is in the last picture: basically force the WLAE-AG300N to use 11n/g/b only which limits it to 2.4Ghz (it cannot use both frequencies at the same time).
Yes, I know the Microwaves drawback, but as the original Chromecast only does 2.4Ghz. I’d rather get the Chromecast Ethernet adapter but Google refuses to ship these outside the USA.
Source: Wifi Analyzer – Android Apps on Google Play
Force the WLAE-AG300N to use only 2.4Ghz
Posted in Chromecast, Google, Power User, WiFi | Leave a Comment »
Posted by jpluimers on 2017/01/03
Any more people having experience with these?
I’m welcoming any opinions on:
- comfort
- size (are sizes like L or XL larger or smaller than most other L or XL clothing; would L or XL better it fit a 1.84m tall person with average waist)
- durability
- what happens when you go sit in a bus/aircraft with all the pockets filled
- what if you drop the jacket with the pockets filled with laptop/ipad/…
The OTG Jacket for Men is a warm jacket with the hidden SCOTTeVEST features of concealed pockets. Carry your gadgets with you, and maintain your style, while keeping warm outside.
[WayBack] Men’s Insulated Coat – SCOTTeVEST
via
–jeroen
Posted in LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2017/01/02
Via:
Windows 7 Disk Images – Is it just me I have noticed that my Windows 7 backup disk images fail when Windows update applies security updates, if the images are more than 2 “Monthly RollUps” old. When I click the update webpage for help, Microsoft the server returnes a “page not found”. Is Microsoft trying to tell me something?
I noticed this as well for VMs that I hardly use (and can be dormant for months): updating them takes forever and I could not find the cause.
The cause seems Microsoft changing the locations for updates, but not having the updater update in the old location any more: [WayBack] Changes to Security Update Links – MSRC.
Solution: manually download the update MSU files for your Windows + architecture combination in a directory, copying a batch file there, then run the batch file.
More details at “Solution to the long search for Windows Updates on a newly installed Windows 8.1, 7 SP1 or Vista SP2”:
Yes, you have to fiddle a bit with the WUAUSERV service, but then everything should work out well.
–jeroen
via: [WayBack] Windows 7 Disk Images – Is it just me I have noticed that my Windows 7 backup…
Posted in Power User, Windows, Windows 7, Windows 8.1 | Leave a Comment »
Posted by jpluimers on 2017/01/01
The difference in changing your primary email of an Apple ID and a Microsoft ID:
- Microsoft Account still requires you to sign in with your (now defunct) old e-mail address as that *is* your primary ID but sends email to your new e-mail addres.
- Apple ID forgets about your old-email address and requires you to use the new e-mail address to sign in.
Small but important difference…
–jeroen
Posted in Apple, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2016/12/30
When you ship OpenSSL DLLs, you should provide an update mechanism outside of your regular product cycle that updates these shortly after vulnerabilities are fixed.
Few if any products do that. So I made an overview from products and OpenSSL DLL versions I had installed on various systems.
I’m a developer, so the list is biased towards tools I use often.
All of them are vulnerable: [WayBack] https://www.openssl.org/news/vulnerabilities.html
- 1.0.2.h by ContinuaCI 1.8.1.185 PostgreSQL and Avast 12.3
- 1.0.2.g by SourceTree 1.9.x embedded git_local
- 1.0.2d by Git for Windows 2.6.1
- 1.0.2a by SQLite browser 3.7.0
- 1.0.1m by Delphi 10.0 Seattle
- 1.0.1l by Ruby 2.3
- 1.0.1f by SlikSvn 1.8.5
- 1.0.1g by Delphi XE8, Delphi XE7, VMware Workstation OVF tool and Adobe Creative Cloud 2.8.1
- 1.0.0g by Delphi XE6, Delphi XE5, Delphi XE4, Delphi XE3, Appmethod 1.13 and CollabNet SVN Client 1.7.5
- 1.00d by MarkdownPad 2
- 1.0.0 by FinalBuider 7 XE2 and FinalBuilder 7 EE
- 0.9.8za by VMware Remote Console Plug-in 5.1 and VMware Virtual Infrastructure Client 5.1
- 0.9.8y by VMware VIX Workstation 10
- 0.9.8t by Veaam Backup and Replication
- 0.9.8r by ContinuaCI 1.8.1.185 hg support, VMware VIX and VMware Workstation 8.0.2
- 0.9.8q by Veeam Backup Transport, Veaam Backup, xampp 1.7.4 and Replication and VMware Virtual Infrastructure Client 5.0
- 0.9.8o by xampp 1.7.4
- 0.9.8l by xampp 1.7.4
- 0.9.8n by Delphi XE2, Delphi XE and VMware VIX Workstation 7.1.0
- 0.9.8m by VMware VMRC Plug-in, VMware VIX and VMware Workstation 8.0.2
- 0.9.8i by VMware Virtual Infrastructure Client 4.1
- 0.9.8d by Database Workbench Pro 4.4.3, Database Workbench Pro 5.2.4 and VMware vSphere CLI Perl
- 0.9.8b by Adobe Creative Suite 5
- 0.9.7m by VMware VIX server 1.0.9
- 0.9.7l by VMware VIX VIServer 2
- N/A by Adobe Create Suite 5 and VMware VIX server 1
–jeroen
via: [WayBack] Does Delphi installer install OpenSSL dll’s?
PS: Below some Software Archeology related links in the comments.
Posted in .NET, CollabNet, Delphi, Development, DVCS - Distributed Version Control, git, OpenSSL, Power User, Ruby, Security, Software Development, Source Code Management, SourceTree, Subversion/SVN | 7 Comments »
The Wiert Corner - irregular stream of stuff 