Thursday, March 30, 2023

KeePassXC 2.5.2 released - KeePassXC

https://keepassxc.org/blog/2020-01-04-2.5.2-released/
https://keepassxc.org/download/
https://keepassxc.org/verifying-signatures/

https://keepassxc.org/verifying-signatures/

"C:\Program Files\Git\usr\bin\gpg" --verify KeePassXC-*-Win64.msi.sig
gpg: assuming signed data in 'KeePassXC-2.5.2-Win64.msi'
gpg: Signature made Sat Jan 4 06:20:56 2020 PST
gpg: using RSA key C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: Can't check signature: No public key

"C:\Program Files\Git\usr\bin\gpg" --verify KeePassXC-*-Win32.msi.sig
gpg: assuming signed data in 'KeePassXC-2.5.2-Win32.msi'
gpg: Signature made Sat Jan 4 06:38:57 2020 PST
gpg: using RSA key C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: Can't check signature: No public key

"C:\Program Files\Git\usr\bin\gpg" --verify KeePassXC-*.dmg.sig
gpg: assuming signed data in 'KeePassXC-2.5.2.dmg'
gpg: Signature made Sat Jan 4 07:11:27 2020 PST
gpg: using RSA key C1E4CBA3AD78D3AFD894F9E0B7A66F03B59076A8
gpg: Can't check signature: No public key

From DIGEST files:
9755d3f16b98db6f8d25e02a445a0b7f4aae822e514105cec02df4c25b53f993 KeePassXC-2.5.2.dmg
0a97a99eaa83274acb524978d32bfddae5e1500c151a2393318051e4e8bc952f *KeePassXC-2.5.2-Win32.msi
3380d96543795f56ed258ebb82e4a802887ead6820e314eb7263dc41cdcf2099 *KeePassXC-2.5.2-Win64.msi
CertUtil -hashfile KeePassXC-2.5.2.dmg sha256
SHA256 hash of KeePassXC-2.5.2.dmg:
9755d3f16b98db6f8d25e02a445a0b7f4aae822e514105cec02df4c25b53f993
CertUtil: -hashfile command completed successfully.
CertUtil -hashfile KeePassXC-2.5.2-win32.msi sha256
SHA256 hash of KeePassXC-2.5.2-win32.msi:
0a97a99eaa83274acb524978d32bfddae5e1500c151a2393318051e4e8bc952f
CertUtil: -hashfile command completed successfully.
CertUtil -hashfile KeePassXC-2.5.2-Win64.msi sha256
SHA256 hash of KeePassXC-2.5.2-Win64.msi:
3380d96543795f56ed258ebb82e4a802887ead6820e314eb7263dc41cdcf2099
CertUtil: -hashfile command completed successfully.
CertUtil -hashfile KeePassXC-2.5.2-Sierra.dmg sha256
SHA256 hash of KeePassXC-2.5.2-Sierra.dmg:
2fa99590e8390fa6333b861a48280d2dd736238c40f70ba2aa30ac32d849a669
CertUtil: -hashfile command completed successfully.

Wednesday, March 29, 2023

Exporting data from SQL Server Express to CSV (need quoting and escaping)

(Monday, October 5, 2015)

In SQL Management Studio, right click the database and select Tasks -> Export Data.

Then choose SQL Server as the source and Flat File as the destination. Name the file MyFile.csv.

Set the Text qualifier as "

Select 'Write a query to specify the data transfer' and paste in your query. You can leave the next settings as the defaults.

With the data exported, open with Excel and save in the Excel format.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

2015-10-05

For version 12.0 you need to install MDAC 2010 from here.

This has to be done on the server where you publish your application. You need to install the x86 version if the target machine is 32 bit or the x64 version if the target machine is 64 bit and your application is built with configuration Any CPU.

Source: http://stackoverflow.com/questions/11179905/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

Friday, March 24, 2023

What Makes A Software Programmer a Professional? - CodeProject

Summary article written by Rob Kraft in
https://www.codeproject.com/Articles/5129182/What-Makes-A-Software-Programmer-a-Professional

  • Use version control
  • Back up everything off site
  • Track the changes, fixes, and enhancements in each release
  • Keep the source code related to each deployed version that is in use
  • Keep a copy of your software in escrow
  • Use automated builds
  • Schedule builds
  • Write regression unit tests
  • Use a bug tracking system
  • Use a system to track tasks and features being developed
  • Keep customers informed about the progress of the software development
  • Keep third party software used updated regularly
  • Understand the security risks
  • Ensure proper compliance with industry standards such as PCI, HIPAA, SOX, and PII
  • Educate yourself continuously
  • Invest in your development tools
  • Properly license development tools and software

Wednesday, March 15, 2023

Node.js JavaScript runtime LTS Version: 18.15.0 (includes npm 9.5.0)

2023-03-15
https://nodejs.org/en/download/ Latest LTS Version: 18.15.0 (includes npm 9.5.0)
https://github.com/nodejs/node/releases/tag/v18.15.0
https://nodejs.org/dist/v18.15.0/ SHASUMS for release files

How to verify https://github.com/nodejs/node#verifying-binaries

C:\Temp\DevTools>curl -O https://nodejs.org/dist/v18.15.0/SHASUMS256.txt
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (35) schannel: next InitializeSecurityContext failed: Unknown error (0x80092012) - The revocation function was unable to check revocation for the certificate.

C:\Temp\DevTools>curl -O https://nodejs.org/dist/v18.15.0/SHASUMS256.txt.asc
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
curl: (35) schannel: next InitializeSecurityContext failed: Unknown error (0x80092012) - The revocation function was unable to check revocation for the certificate.

C:\Downloads>CertUtil -hashfile node-v18.15.0-x64.msi sha256
SHA256 hash of node-v18.15.0-x64.msi:
36de8d8fecd0920175ed6e61266934f3469888990f0cc54238e50437490515d5
CertUtil: -hashfile command completed successfully.

Search the hashsum result from CertUtil against the value in SHASUMS256.txt

%USERPROFILE%\Downloads>gpg --keyserver hkps://keys.openpgp.org --recv-keys 4ED778F539E3634C779C87C6D7062848A1AB005C
gpg: key D7062848A1AB005C: public key "Beth Griggs <bethanyngriggs@gmail.com>" imported
gpg: Total number processed: 1
gpg:               imported: 1

%USERPROFILE%\Downloads>gpg --list-key
%USERPROFILE%\AppData\Roaming\gnupg\pubring.kbx
------------------------------------------------
pub   rsa4096 2015-04-06 [SC]
      7ED10B6531D7C8E1BC296021FC624643487034E5
uid           [ unknown] Steve Dower (Python Release Signing) <steve.dower@microsoft.com>
sub   rsa4096 2015-04-06 [E]

pub   rsa2048 2018-03-26 [SC] [expires: 2025-12-31]
      4ED778F539E3634C779C87C6D7062848A1AB005C
uid           [ unknown] Beth Griggs <bethanyngriggs@gmail.com>
uid           [ unknown] Beth Griggs <Bethany.Griggs@uk.ibm.com>
uid           [ unknown] Beth Griggs <bgriggs@redhat.com>
sub   rsa2048 2018-03-26 [E] [expires: 2025-03-09]

%USERPROFILE%\Downloads>gpg --verify SHASUMS256.txt.sig SHASUMS256.txt
gpg: Signature made 3/7/2023 12:01:57 PM Pacific Standard Time
gpg:                using RSA key 4ED778F539E3634C779C87C6D7062848A1AB005C
gpg: Good signature from "Beth Griggs <bethanyngriggs@gmail.com>" [unknown]
gpg:                 aka "Beth Griggs <Bethany.Griggs@uk.ibm.com>" [unknown]
gpg:                 aka "Beth Griggs <bgriggs@redhat.com>" [unknown]
gpg: WARNING: This key is not certified with a trusted signature!
gpg:          There is no indication that the signature belongs to the owner.
Primary key fingerprint: 4ED7 78F5 39E3 634C 779C  87C6 D706 2848 A1AB 005C

Wednesday, March 8, 2023

Czech cyber watchdog warns against using TikTok | Reuters

PRAGUE, March 8 (Reuters) - The Czech cyber security watchdog warned on Wednesday against using TikTok, joining a growing number of Western agencies alleging the Chinese-owned social media app poses a security risk.

Continue reading at 

Tuesday, March 7, 2023

Don’t get caught off guard! Slam the Scam Day is March 9

National "Slam the Scam" Day is designated by Social Security's Office of the Inspector General to raise awareness of government imposter scams, which continue to spread across the United States

Read more at
https://oig.ssa.gov/news-releases/2023-02-27-don%E2%80%99t-get-caught-off-guard-slam-the-scam-day-is-march-9/

Monday, March 6, 2023

White House National Cybersecurity Strategy 2023

The White House released a National Cybersecurity this month.

You can read the full detail here:


iPhone 14 Pro vs. Galaxy S23 Ultra: Do I Regret Switching to Apple? - CNET

Excerpt from 

… there are advantages to having an iPhone that go beyond specs that'll likely keep me in the Apple ecosystem for a while. Features like Airdrop and iMessage have made the user experience more seamless. And I don't know if I could give up the iPhone's video quality for anything else.

How about you?

Sunday, March 5, 2023

Note to self – Ubuntu 20.04.5 LTS (Focal Fossa)

Ubuntu 20.04.5 LTS (Focal Fossa)
https://releases.ubuntu.com/20.04.5/

SHA256SUMS 2022-09-01 14:33202
SHA256SUMS.gpg 2022-09-01 14:33833
ubuntu-20.04.5-desktop-amd64.iso 2022-08-31 07:26 3.6G Desktop image for 64-bit PC (AMD64) computers (standard download)

$ echo "2980570ea889f3467a04df15c8421ef1dc80ecef7bb37243da97f5714cf3f8ef *ubuntu-20.04.5-desktop-amd64.iso" | shasum -a 256 --check
ubuntu-20.04.5-desktop-amd64.iso: OK

How to recognize a fake Geek Squad renewal scam | Consumer Advice

Except from  https://consumer.ftc.gov/consumer-alerts/2022/10/how-recognize-fake-geek-squad-renewal-scam Scammers are at it ag...