MoonPoint Support Logo


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals

Advanced Search
Sun Mon Tue Wed Thu Fri Sat
6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          
OctNov Dec

Sun, Aug 28, 2022 3:45 pm

Setting the path variable for Java

I had installed Java on a Windows 10 system as part of the installation of the Eclipse integrated development environment (IDE), which did not add the directory where the java.exe and javac.exe executable files were installed. I could temporarily add the directory where Eclipse installed those files to the path environment variable—see Running java from an Eclipse installation from the command line—but I didn't want to continue to have to do that every time I wanted to compile a Java program at a command prompt or run one from a command-line interface (CLI). So I added the path to the executable files to the system-wide path environment variable so it would be permanent and apply to all accounts on the system.

[ More Info ]

[/languages/java] permanent link

Sun, Aug 28, 2022 1:47 pm

Setting JAVA_HOME for Gradle

While trying to set up Gradle, a software develpment build automation tool, on a Microsoft Windows 10 system, when I ran the gradle.bat file in the gradle bin directory, I saw the message below:


ERROR: JAVA_HOME is not set and no 'java' command could be found in your PATH.

Please set the JAVA_HOME variable in your environment to match the
location of your Java installation.


I had installed Java with the Eclipse integrated development environment (IDE) previously and the java.exe executable was installed beneath the C:\Users\Jim\.p2\pool\plugins\org.eclipse.justj.openjdk.hotspot.jre.full.win32.x86_64_18.0.1.v20220515-1614\jre\ directory, so I created a JAVA_HOME environment variable pointing to that directory that applied to all accounts on the system. You can create a temporary JAVA_HOME environment variable for the account under which you are currently logged in from a command line interface (CLI) as noted at Running java from an Eclipse installation from the command line, but I wanted to create a permanent environment variable so I typed advanced system settings in the Windows "Type here to search" field and then clicked on View advanced system settings when I saw that listed.

[ More Info ]

[/languages/java] permanent link

Sun, Aug 14, 2022 10:01 am

Excel Proper Case

I inherited an Excel spreadsheet containing names and addresses for all the members of an organization where all the letters for the names and addresses were capitalized. I wanted to convert the names and addresses to "proper case" where only the first letters of names, streets, and cities are capitalized (in the Python programming language proper case is known as "title case"). Fortunately, Excel provides a function, propercase, to perform that function. To perform the conversion, I inserted a new column to the right of each of the columns where all uppercase letters were used. The first column in the Excel workbook contained the last names for the members. There was a header titled "Last Name" in cell A1 with the first person's last name appearing in cell A2, so in the newly inserted column, B, I put =proper(A2) in cell B2. When I hit Enter, instead of AIKIN, JR in A2, I then had Aikin, Jr in B2. I then clicked in cell B2 and dragged the mouse pointer downwards to the last row containing a member's contact information, which resulted in all the members last names being placed in column B with the proper case, i.e., uppercase letters for the first letter of the name and lowercase letters for the rest of the name. I couldn't just delete column A then, which would cause a #REF! message to appear in column B for every name, since I was using a formula that depended on a value being in column A. So, instead, I copied all of column B by clicking on the B at the top of the column to highlight all entries in the column. I then used the Ctrl-C keys to copy all of the entries. I then needed to paste the values in column B into column A, rather than pasting in the formulas. You can do so, by right-clicking on the column designator letter, i.e.the A for column A in this case, and then choosing the appropriate paste option, To paste just the values and not the formulas and formatting, you can click on the icon of a clipboard with "123" on it.

Excel Paste Options

Or you can select Paste Special and then click on the same icon that appears beneath Paste Values.

Excel Paste Special

Once you've pasted the values that are in proper case, you can delete the column, e.g., B in this case, where the formulas are used.

Note: for addresses with Post Office boxes, any instance of "PO BOX" would be replaced with "Po Box," but you can use Excel's find and replace feature to search for all instances of "Po Box" and have it replace all those occurences with "PO Box".

[/software/office/excel] permanent link

Sat, Aug 13, 2022 6:39 pm

PeaZip temporary file location when creating an archive file

I hadn't used PeaZip as a backup utility previously, but after reading about the program, I thought it would be well-suited to copy a directory containing about 37 GB of files on a Microsoft Windows Small Business Server (SBS) 2003 server to an external USB drive so that I could transfer the directory, which was shared over the network from the server, to the new 2022 server I was setting up to replace the outdated server. I downloaded the portable version, PeaZip Portable to a USB flash drive and when I started the program, I specified the external USB drive as the location for the .tar archive I wished to create, but when the PeaZip program showed it was progressing with the backup, I did not see the archive file on that external drive. After some time wondering whether PeaZip was actually creating the tar file, I wondered whether it might be creating a temporary file elsewhere, so from a command prompt, I checked the location Windows was using to store temporary files for the account I was using with echo %temp% and, when I checked that location, found a .tar.tmp file that PeaZip was using for the ongoing archive process. Unfortunately, that temporary file was in a directory on drive C that I knew did not have enough free space left to accomodate the archive file as PeaZip progressed further, so I had to delete a lot of files from that drive and mover others there so that I would not have to restart the archive process.

C:\>echo %temp%

C:\>cd %temp%

C:\DOCUME~1\ADMINI~1.MAY\LOCALS~1\Temp>dir *.tar.tmp
 Volume in drive C has no label.
 Volume Serial Number is E88C-7773

 Directory of C:\DOCUME~1\ADMINI~1.MAY\LOCALS~1\Temp

08/12/2022  11:14 PM     5,569,092,608 Andy_2022-08-12.tar.tmp
               1 File(s)  5,569,092,608 bytes
               0 Dir(s)  33,934,786,560 bytes free


When PeaZip concluded the archive process, it moved the temporary file to the location I specified with the .tmp extension now removed, but now I know I need to ensure that the location specified with the Windows %temp% environment variable for a site has enough free space to accomodate the archive file before using PeaZip to create a .zip, .tar, etc. file archive.

[/software/archiving/PeaZip] permanent link

Fri, Aug 05, 2022 5:01 pm

Running java from an Eclipse installation from the command line

For an introductory Java class I am taking, I installed the Eclipse integrated development environment (IDE) on a Microsoft Windows 10 system. In addition to compiling and running Java programs through the IDE, though, I wanted to compile Java programs using the Java compiler, javac.exe, and run them using java.exe from Windows' command-line interface (CLI). The installation process for Eclipse installed the javac.exe and java.exe executables in a user directory with a long directory path to those executables. Note: you should install the Eclipse IDE from the account which you wish to use to compile and run java programs. The location wasn't added to the path environment variable, so if you try to run the programs from a command prompt, you will see the following, unless you specify the full path name where the executable files are located.

'java' is not recognized as an internal or external command,
operable program or batch file.

'javac' is not recognized as an internal or external command,
operable program or batch file.


I didn't want to have to copy and paste the full path on the command line or type it in every time I wanted to use the two executables from the command line. To avoid that problem you can add the directory path to the path environment variable through a set path= command or create another environment variable, e.g., JAVA_HOME that points to the directory where the two files are located, though both methods apply only to a particular command line instance. I.e., if you close a command prompt window where you've set one of the variables to include the location where Eclipse installed java.exe and javac.exe then open another command prompt window, you will have to set the environment variable again in the new instance. An alternative way to make a permanent path change from a command prompt interface is to use the Windows setx command, though I would not recommend it, since if your path variable already has a path that is more than 1,024 characters long, setx can truncate the path to 1,024 characters, so that you not only don't get the additional directory added to the path, but you may lose some of the path setting you had prior to issuing the command. If you want to make a permanent change, see responses to the "Overcoming the 1024 character limit with setx" posting at the site.

[More Info ]

[/languages/java/eclipse] permanent link

Mon, Jul 11, 2022 9:08 pm

Enabling Wake on LAN (WoL) on a Dell PC with a Realtek PCIe GBE NIC

Computers that support the Wake-on-LAN (WoL or WOL) standard can be awoken from a sleep state by sending a "magic packet" to their network card from another system. For an Ethernet card, the packet is an Ethernet frame that is sent to all systems on the local area network (LAN). The packet contains 6 bytes of the hexadecimal value FF followed by 16 repetitions of the 48-bit media access control (MAC) address of the system to be awakened from a sleep state. I tried unsuccessfully on Friday to remotely "wake" a Dell PC from another PC by connecting to the other PC on the same LAN and then sending a magic packet to the sleeping computer using the Wake-on-LAN program from—I no longer see a download link for the free software for Windows systems on the developer's website, but you can download it from a snapshot of the site taken by the Wayback Machine on December 19, 2007 at Wake-on-LAN where you can also find the utility MCGETMAC.EXE that will allow you to obtain the MAC address for a network interface card (NIC) on another computer, or you can download WakeMeOnLan, another free program for Windows systems created by Nir Sofer. After the user powered on her Dell computer this morning and left the office, I connected to her system remotely to verify that the system is configured to respond to a magic packet to wake it when it is sleeping.

[ More Info ]

[/network/wol] permanent link

Fri, Jun 24, 2022 10:22 pm

Raising a number to a power in Microsoft Excel

There are two ways to use exponentiation, i.e., to raise a number to a power in the Microsoft Excel spreadsheet program. You can use the POWER(number, exponent) function, e.g., to raise 2 to the power 3, you could put =POWER(2,3) in a cell which would yield the value 8. Or you can use the exponent operator, the caret character, i.e., ^ (shift-6 on a Windows keyboard). E.g., to calculate 2 raised to the power 3 you could put =2^3 in a cell which produces the value 8.

[/software/office/excel] permanent link

Thu, Jun 23, 2022 9:46 pm

Maximum memory for an HP 3047h Motherboard

A family member said a Windows 10 system she is using for gaming is running slowly and inquired about adding additional memory to the system. I didn't know the model of the motherboard in the system nor the maximum amount of memory it could accomodate. Rather than opening up the desktop system, I checked on the manufacturer and model of the motherboard from a command-line interface (CLI) with a Windows Management Instrumentation Command-line (WMIC) command and found it was a Hewlett-Packard (HP) 3047h motherboard.

Microsoft Windows [Version 10.0.19043.1766]
(c) Microsoft Corporation. All rights reserved.

C:\Users\Colleen>wmic baseboard get product,manufacturer,model,serialnumber,version
Manufacturer     Model  Product  SerialNumber  Version
Hewlett-Packard         3047h    MXL11925F3


I also saw 3047h listed as the "baseboard product" ("baseboard" is another name used for "motherboard") when I typed System Information in the Windows "Type here to search" field and selcted that application.

[ More Info ]

[/pc/hardware/motherboard/3047h] permanent link

Wed, Jun 22, 2022 9:49 pm

Excluding a file or directory from monitoring and scanning by Acronis Cyber Protect Home

Because Acronis® Cyber Protect Home Office, which is backup, cloning, and antivirus software for Windows and macOS systems, was prompting a user as to whether Java should be allowed to run on a Microsoft Windows system on which it was needed, I wanted to exclude the Java.exe program from monitoring. The process to exclude a program from monitoring and scanning by that application is as follows:
  1. Start Acronis Cyber Protect Home Office. When prompted "Do you want to allow this app to make changes to your device?" to allow CyberProtectHomeOfficeLauncher.exe by the verified publisher Acronis International GmbH to run, choose "Yes."
  2. Select Protection, if it is not already displayed.

    Acronis Cyber Protect - Protection

  3. Click on Protection Exclusions then click on Add exclusion and choose either Add file or Add folder depending on whether you wish to exclude either an individual file or an entire directory from being scanned and possibly flagged.

    Acronis Cyber Protect - Protection Exclusions

  4. When you select an option, e.g., Add file, you can browse to the relevant locaton and select what you wish to exclude from monitoring and scanning activities.

    Acronis Cyber 
Protect - Java Excluded

  5. Click on Save to have the application keep the changes you've made.

[/software/backup/acronis] permanent link

Tue, Apr 05, 2022 6:05 pm

Let's Encrypt Problem binding to port 80: Could not bind to IPv4 or IPv6

A couple of users notified me that they were receiving warning messages regarding the security certificate on their email server when they were checking email with Microsoft Outlook. I checked the expiration date on the security certificate for the email server with the OpenSSL command openssl s_client -connect (the system is using Dovecot, which is an open-source IMAP/POP3 software program providing users with the ability to download their email). Dovecot listens on TCP port 995 for POP3S secure email connections for downloading email. I could see the certificae was expired and I issued the quit command when I saw the "OK Dovecot ready" prompt. The email security certificate on the system is provided by Let's Encrypt, so I then tried renewing the certificate from the root account with the letsencrypt renew command, but was unsuccessful. I found the solution was to stop the Apache web server software running on the system, thanks to a post by JuergenAuer at Renewing certificate getting error: Problem binding to port 80: Could not bind to IPv4 or IPv6. After I stopped the web server software, I was able to reissue the letsencrypt command to renew the certificate without the "Problem binding to port 80" error message. I then restarted the Apache web server software and Dovecot.

[ More Info ]

[/security/encryption/openssl] permanent link

Once You Know, You Newegg AliExpress by

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo