Details at http://smithii.com/si_installer.

This seemingly duplicate entry has been created as some RSS readers, such as Google Reader, do not display updates to existing blog entries, even if the update date was changed. This entry will be deleted in a week or so. Therefore, please do not post comments to this entry. Post them to the above URL instead. Thanks!

si_installer is an NSIS installer I whipped up to download and install most of the wonderful utilities found at http://sysinternals.com.

You can download the binary here and the binary with the source code here.

Here's the changelog.txt:

I've written the batch file xpsp3.cmd (updated 26-Aug-08) to automatically download and slipstream a standard Windows XP boot disk with Service Pack 2 and all post-SP3 security hotfixes.

It uses wget or curl (if either are found in the PATH), or your installed browser to download the updates. I have tested this with Internet Explorer, Firefox, and Opera. Other browsers should work, as well.

The batch file xpsp3local.cmd (updated 26-Aug-08) will update the copy of Windows XP that is installed on the computer you run the command on. You may wish to do this, if you do not have, or want, the machine you want to hotfix connected to the internet, or if you are unable to run Windows Update for some reason (for example, if Internet Explorer isn't installed, or doesn't work properly, due to a virus or similar mishap).

To slipstream the hotfixes, and burn the slipstreamed disk, I've created the makefile xpsp3.mak (updated 26-Aug-08). Details on usage below.

My sysadmin turned off root access, but gave me sudo rights to login as root.

To continue to login directly as root I copy pasted a connection profile, and then edited the property Connection / Logon Scripts / Logon script and pointed to the script sudo_root.vbs:

# $language = "VBScript"
# $interface = "1.0"

Sub Main
  crt.Screen.WaitForString "$"
  crt.Screen.Send "sudo su - root" & Chr(10)
End Sub

nirsoft_installer is an NSIS installer I whipped up to download and install most of the wonderful utilities found at http://nirsoft.net.

You can download the binary here and the binary with the source code here.

Details at http://smithii.com/nirsoft_installer.

This seemingly duplicate entry has been created as some RSS readers, such as Google Reader, do not display updates to existing blog entries, even if the update date was changed. This entry will be deleted in a week or so. Therefore, please do not post comments to this entry. Post them to the above URL instead. Thanks!

The following script will display your GRANT statements in MySQL in *nix:

$ mysql -e "SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';') FROM mysql.user" --column-names=false -B | 
mysql --column-names=false -B 2>/dev/null |
sed 's/$/;/'

Here's a sample output:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY PASSWORD '*FD1111DEADBEEFDEADBEEFDEADBEEFDEADBEEFDE'
WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' 
IDENTIFIED BY PASSWORD '*FD1111DEADBEEFDEADBEEFDEADBEEFDEADBEEFDE'
WITH GRANT OPTION;

On Windows, replace /dev/null with NUL, and remove the sed command:

c:> mysql -e "SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
FROM mysql.user" --column-names=false -B | mysql --column-names=false -B 2>nul

You will then need to add the ; character manually.

You could even do this from inside the mysql client, in *nix:

$ mysql
mysql> SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
FROM mysql.user INTO OUTFILE '/tmp/grants.sql';
mysql> source /tmp/grants.sql

and in Windows:

C:> mysql
mysql> SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
FROM mysql.user INTO OUTFILE 'c:/grants.sql';
mysql> source c:/grants.sql

If you get an error message, try your %TEMP% directory:

C:> cd /d "%TEMP%"
C:> dir /x ..
Volume in drive C is volname
Volume Serial Number is FEED-FACE

Directory of C:\DOCUME~1\ross\LOCALS~1

01/23/2008  11:09 AM    <DIR>                       Apps
08/07/2008  03:10 PM    <DIR>                       Temp
               0 File(s)              0 bytes
               2 Dir(s)   6,727,245,824 bytes free
c:> mysql
mysql> SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')

Spammers found my MediaWiki based website, and flooded the site with over 1.2GB of link spam. To fix this, I locked down my site, so only sysops can change it, by adding the following to the end of my LocalSettings.php file:

// Implicit group for all visitors
$wgGroupPermissions['*'    ]['createaccount']   = true;
$wgGroupPermissions['*'    ]['read']            = true;
$wgGroupPermissions['*'    ]['edit']            = false;
$wgGroupPermissions['*'    ]['createpage']      = false;
$wgGroupPermissions['*'    ]['createtalk']      = false;

// Implicit group for all logged-in accounts
$wgGroupPermissions['user' ]['move']            = false;
$wgGroupPermissions['user' ]['read']            = true;
$wgGroupPermissions['user' ]['edit']            = false;
$wgGroupPermissions['user' ]['createpage']      = false;
$wgGroupPermissions['user' ]['createtalk']      = false;
$wgGroupPermissions['user' ]['upload']          = false;
$wgGroupPermissions['user' ]['reupload']        = false;
$wgGroupPermissions['user' ]['reupload-shared'] = false;
$wgGroupPermissions['user' ]['minoredit']       = false;

// Implicit group for accounts that pass $wgAutoConfirmAge
$wgGroupPermissions['autoconfirmed']['autoconfirmed'] = true;

// Implicit group for accounts with confirmed email addresses
// This has little use when email address confirmation is off
$wgGroupPermissions['emailconfirmed']['emailconfirmed'] = true;

// Users with bot privilege can have their edits hidden
// from various log pages by default
$wgGroupPermissions['bot'  ]['bot']             = true;
$wgGroupPermissions['bot'  ]['autoconfirmed']   = true;
$wgGroupPermissions['bot'  ]['nominornewtalk']  = true;

// Most extra permission abilities go to this group

$wgGroupPermissions['sysop' ]['move']            = true;
$wgGroupPermissions['sysop' ]['edit']            = true;
$wgGroupPermissions['sysop' ]['createpage']      = true;

aria2 is a download utility with resuming and segmented downloading.

Using the makefile aria2.mak.

I successfully ported aria2 to Windows using the Debian MinGW cross-compiler. While aria2 compiles under native MinGW and Cygwin, the resultant executable is buggy, and numerous unit tests fail.

Update: I installed gcc 4.3.0 in MinGW using get_mingw.cmd and am now able to produce working binaries in my Windows environment. This leads me to believe that gcc 3.4.5 is not reliable under MinGW.

Version 0.13.2+1

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.13.0

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.12.0

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.11.5

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.11.4

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.11.3-1

Please see the README file here.
The binary is available on SourceForge.net
and here.

Version 0.11.3

Please see the README file here.
The binary is available on SourceForge.net and here.

Version 0.11.2

Please see the README file here.
The binary is available here. Update: this release fixes the torrent download issue with the original 0.11.2 MinGW release.

Version 0.11.1+1

The binary is available here.

Version 0.11.0

The binary is available here.

Version 0.10.2+1

The binary is available here.

Please note that while the developer states in the README file: "aria2 is in very early development stage", I've successfully downloaded using the following methods:

• HTTPS
• HTTP
• FTP
• Local metalinks
• Remote metalinks
• Local torrents
• Remote torrents

I'm aware of the following issues:

• Azureus is much faster than aria2 on my system. Initially, I thought this was due to my firewall blocking incoming UDP traffic. As aria2 only uses TCP and not UDP sockets, this does not appear to be the reason why Azureus is faster. More research is needed.
  
  
• I wasn't able to directly download the metalink http://curl.haxx.se/metalink.cgi?curl=tar.gz. A workaround would be:
  

  aria2c.exe -o local.metalink --follow-metalink=false http://curl.haxx.se/metalink.cgi?curl=tar.gz
  aria2c.exe -M local.metalink
  

The following issues have been fixed:

• Rename bug due to MinGW's rename() not deleting the destination file, if it already exists.
• HTTPS downloads failed prior to version 0.11.1+1.
• Downloads failed at 2GB prior to version 0.11.1+1.
• Due to MinGW's sscanf() function lacking support for the %Ld specifier, files larger than 2147483648 bytes will not download correctly via FTP. This is not an issue for the Cygwin version.
  
  

Here's the included README-win32.txt file:

Details at http://smithii.com/aria2.

This seemingly duplicate entry has been created as some RSS readers, such as Google Reader, do not display updates to existing blog entries, even if the creation date of the entry was updated. This entry will be deleted in a week or so. Therefore, please do not post comments to this entry. Post them to the above URL instead. Thanks!

php_installer is an NSIS installer I whipped up to download and install PHP 5.2.6, PECL, the PHP CHM manual, and the Zend Optimizer found at http://www.php.net.

You can download the binary here and the binary with the source code here.

Here's the changelog.txt:

Details at http://smithii.com/php_installer.

This seemingly duplicate entry has been created as some RSS readers, such as Google Reader, do not display updates to existing blog entries, even if the update date was changed. This entry will be deleted in a week or so. Therefore, please do not post comments to this entry. Post them to the above URL instead. Thanks!

Details at http://smithii.com/slipstream_xpsp2.

This seemingly duplicate blog entry has been created as some RSS readers, such as Google Reader, do not display updates to existing entries, even if the creation date of the entry was updated. This entry will be deleted in a week or so. Therefore, please do not post comments to this entry. Post them to the above URL instead. Thanks!

I've written the batch file xpsp2.cmd (updated 23-Apr-08) to automatically download and slipstream a standard Windows XP boot disk with Service Pack 2 and all post-SP2 security hotfixes.

It uses wget or curl (if either are found in the PATH), or your installed browser to download the updates. I have tested this with Internet Explorer, Firefox, and Opera. Other browsers should work, as well.

The batch file xpsp2local.cmd (updated 23-Apr-08) will update the copy of Windows XP that is installed on the computer you run the command on. You may wish to do this, if you do not have, or want, the machine you want to hotfix connected to the internet, or if you are unable to run Windows Update for some reason (for example, if Internet Explorer isn't installed, or doesn't work properly, due to a virus or similar mishap).

To slipstream the hotfixes, and burn the slipstreamed disk, I've created the makefile xpsp2.mak (updated 23-Apr-08). Details on usage below.

php4_installer is an NSIS installer I whipped up to download and install PHP 4.4.8, and the PHP CHM manual found at http://www.php.net.

You can download the binary here and the binary with the source code here.