[ More Info ]

[/network/web/html] permanent link

1. Open the original image file, e.g., the JPG file.
2. If you need to do any image cleanup, you can edit the image by clicking on Edit and selecting "Show Paint dialog"; a small window will then open with image editing tools that you can use, e.g., if you need to change any stray pixels to the color you wish to use as the transparent color. You can choose View and Zoom In, if you need to zoom into the image for a closer inspection.
3. Then, to save as a transparent gif, click on File and select Save as.
4. For "Save as type", choose GIF - Compuserve GIF.
5. In the JPEG/GIF save options window, choose "Save transparent color" from the GIF section. You will then have three options: "use main window color for transparency", "choose transparent color during saving", or "set transparency value to palette entry". If you choose "choose transparent color during saving" when you save the file, you will be able to click on an area in the image that contains the color you wish to use as the transparent color.

   

6. Click on Save to save the image in the new format. Note: you need to click on the Save button on the Save Picture As window, not the Save button on the JPEG/GIF save options window. A Choose transparent color window will then open. Click somewhere on the image where the color exists that you wish to be the transparent color.

[/os/windows/software/graphics/irfanview] permanent link

[ More Info ]

[/network/web/browser/safari] permanent link

In this case, the mailbox was huge with tens of thousands of messages in a file 24 GB in size and I wanted to extract just a few pertinent messages. So I created find-email.py, which can be run in either "brief" or "full" mode by changing the value of a variable named brief in the script. In brief mode, the script will just print the "from" line for any message where a sender's email address matches the specified address followed by the subject of the message and then the date the message was sent. When all messages in the file have been processed, it will print the number of matching messages found. In "full" mode, the script will print the entire email message whenever a match is found.

[/languages/python] permanent link

[ More Info ]

[/security/firewalls/Norton_360] permanent link

1. Select a blank writable disc in the disc drive.
2. Open the Finder and navigate to where the file is located.
3. Right-click on the file, then choose Open with and Disk Utility.
4. Select the .iso file by clicking on it, then click on the Burn button at the top of the window.

[/os/os-x] permanent link

nircmd.exe setfiletime "c:\temp\myfile.txt" "24-06-2003 17:57:11" "22-11-2005 10:21:56"

Nir also provides FolderTimeUpdate, which "scans all files and folders under the base folder you choose, and updates the 'Modified Time' of every folder according the latest modified time of the files stored in it. This tool might be useful if, for example, you backup a cluster of folders and then restore them into another disk, but the backup program doesn't restore the original modified time of the folders."

You can also use Windows PowerShell, which Microsoft has made available for Windows XP and later versions of its operating system to change those time stamps using a command similar to the following ones where name is the file or directory name for which you wish to change the time stamp:

$(Get-Item name).creationtime=$(Get-Date "mm/dd/yyyy hh:mm am/pm")
$(Get-Item name).lastaccesstime=$(Get-Date "mm/dd/yyyy hh:mm am/pm")
$(Get-Item name).lastwritetime=$(Get-Date "mm/dd/yyyy hh:mm am/pm")

[ More Info ]

[/os/windows/PowerShell] permanent link

[/os/windows/win8] permanent link

1. Bitvise SSH Server
2. Copssh
3. freeSSHd
4. OpenSSH for Windows, though development ceased years ago on it and I would no longer recommend it.
5. PowerShell SSH Server for Windows
6. SilverSHielD

You can also install OpenSSH server software for Cygwin.

The Bitvise SSH Server, PowerShell SSH Server for Windows, and SilverSHieLD are commercial products which have free for personal use versions.

[/reviews/software/windows/network/ssh] permanent link

MariaDB [accounts]> UPDATE Invoices SET Date_Sent='2015-08-29' WHERE Name='Acme';

If you don't the contents of the date field will appear as 0000-00-00.

You also need to enclose the date in quotes when querying a database. E.g.:

MariaDB [accounts]> SELECT * FROM Invoices WHERE Date_Sent='2015-08-29';

Otherwise, you will get an empty set for the query results.

[/software/database/mysql] permanent link

Safari does provide a capability to change the user agent string it sends to websites, which sites use to identify the browser a visitor is using. Some sites may even limit access to material on the site to specific browsers. By changing the user agent the browser reports, you may be able to still view the content in such cases.

[ More Info ]

[/network/web/browser/safari] permanent link

If you changed the password, but have forgotten the password, you can reset it by running the PRTG Administration Tool. Once you've opened the application, click on the Administrator tab then type a new password in the Password field and retype the password in the Confirm Password field. If you've also forgotten the login name you used, you will see it on that window.

When you click on Save & Close, you will see the following message:

In order to activate the settings the following will be done by the PRTG Administration Tool:
- Stop and start the PRTG core server service.

The PRTG Administration Tool will close automatically afterwards.

OK to proceed?

If you are accessing the web interfce through a browser and provide the login credentials but don't see any message indicating that they are incorrect, but just see the page for entering the userid and password again, then you may need to enable cookies in the browser; I had to enable cookies in the K-Meleon browser to get past the login screen.

If you changed the port for the web interface, you can find it listed under the Web Server tab.

Note: these instructions apply to PRTG Administration Tool version V15.3.17.2995 and might not apply to other versions.

[/os/windows/software/network/snmp/prtg] permanent link

MariaDB [(none)]> use personnel;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [personnel]> UPDATE Sales SET `Work Phone` = '555.555.5555' WHERE LName = 'Smith'; 
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [personnel]>

You can also use the command below to update the entry without first selecting the database with the Use command.

UPDATE `personnel.`Sales` SET `Work Phone` = '555.555.5555' WHERE `Sales`.`LName` = 'Smith';

References:

1. MySQL UPDATE QUERY
   tutorialspoint - Simply easy learning

[/software/database/mysql] permanent link