How To

A document that explains how to perform some task.

DotNetNuke 4.4.1 Password Reset Via SQL.

I was looking to reset a password in DotNetNuke 4.4.1 and found this link:

Apparently this is for a prior version, as the 4.4.1 stored procedure uses the "ApplicationName" and not the "ApplicationID". I was successful in resetting the password using the small modification found below.

Declare @UserName NVarChar(255)
Declare @NewPassword NVarChar(255)
Declare @PasswordSalt NVarChar(128)
Declare @Application NVarChar(255)


Has programming stagnated?

Over at Coding Horror I found an article linking to Alarming Development which was hosting an article claiming that programming as reached a dead end.


Muds and teaching programming to children.

Today’s post will seem a bit off topic from the usual technology related topics, but I also do work on game designs, both for the computer and traditional board games. I also have a twelve year old son who wants to learn something about what I do all day.

A long time ago, I worked on “muds”. Muds (a.k.a. Multi User Dungeons) are the text based precursor to the current graphical games such as Everquest and World of Warcraft. Being text based, they were cheap and easy to host and could be created and extended by mere mortals instead of the massive development houses required to create a modern graphical world. Many popular muds continue to exist to this day. (Realms of Despair, one of the classics, still has hundreds and hundreds of users online at any given time).


Install additional drivers for a printer share

Open the printer folder, right click the printer and choose "Properties". Go to the "Sharing" tab and chose "Additional Drivers..." Choose the operating systems to support and click OK. You will be prompted for the location of the drivers. Supply the original driver disk and browse to the folder relevant to the operating systems to support, or download and extract such drivers and then browse to where they were extraced.


SNMP and syslogd

Logging is a critical task to perform on your network so you can perform baseline analysis and periodically check up for potential trouble. Most network equipment has SNMP (simple network management protocol) capabilities to send messages about various events that occur. But where to send them?

A cheap and easy way to handle SNMP is to send the messages to a Linux box running snmptrapd, which can log all the events. Simply install "net-snmp" tools, either from source or package and configure to run at your standard run levels for background services. One trick is isolating the messages from all the other messages on your system. To do this, change the startup options for the daemon to "-Ls0 -p /var/run/". By default this would read -Lsd which causes the default message log to be used, which can be very crowded. By sending to log "local0" you can then edit syslog.conf and add:


Daemon Shield

Linux is an excellent operating system to deploy in the roles of firewall and web server. Low and no cost options are available and it requires very few system resources to do a lot of work. Because it often is deployed on the "edge" of the network, it can be a target for brute force attacks.

Daemon Shield is a program that scans the log files and shuts out IP addresses that appear to be performing brute force attacks. It works for SSH and PAM modules and lives in the background. Highly recommend as a complement to normal security precautions such as strong passwords and limiting exposed services.


PHPWiki from CVS requires change to table.

Pulled the CVS version of PHPWiki out. After updating, attempting to post anything that would create new page links, a SQL error would occur. The new version of PHPWiki's DB code for MySQL uses an autonumber on the ID in the page table. Updated to add the auto increment property.

alter table page

Subscribe to RSS - How To