Archive for the ‘Uncategorized’ Category

Not Enough Storage is Available to Process This Command Errors

Tuesday, June 29th, 2010

We recently started having problems on one of our servers.  Processes would start dieing with “Not enough storage is available to process this command” errors. It turns out that this is a catch all error that Windows uses when it runs out of resources of almost any kind.  It rarely has anything to do with the amount of memory or disk installed on your system.  Some of the things that can causes the error to occur are:

  1. System paged pool is exhausted.
  2. System non-page pool in exhausted.
  3. Maximum IRP stack size has been exceeded.
  4. Any number of other things that I have not been able to find documented.

(more…)

Delaying the Loading of Specific Services

Tuesday, June 29th, 2010

On some systems, it may be necessary to delay the loading of specific services in order to allow those services to start successfully.  For example, on one of our servers, the Firebird service suddenly refused to start automatically when the system was rebooted.  We could start it manually but it would fail with error 1055 (service database is locked) when attempting to start automatically.

Apparently, the service database is always locked during the early phases of the boot process.  So, in order to get Firebird to start we needed to delay Windows’ attempts to automatically start the Firebird service.  To do this, you need to make Firebird dependent on another service.  If you do that, Windows will not try to start Firebird until that other service has started.  We chose to make Firebird dependent on the Server service since all systems must have the Server service running if you want to be able to do anything at all.

(more…)

Configuring a (more-or-less) Secure FTP Site on Windows 2003

Friday, February 12th, 2010

For a long time we have had an FTP site that we used for transferring files around inside our firewall.  No one from the outside world had access so security wasn’t a concern.  We allowed anonymous FTP access and life was good.

Then we suddenly had a need to allow people from outside the firewall to upload files to our server.  It would have been too much trouble to change our existing site to forbid anonymous access because we had a lot of automated processes in place that expected to be able to log on anonymously.  So we chose to set up a second FTP site on the same server that would require users to log on with a specific user id and password and to be restricted to their own home directory once they were connected.  This turned out to be both easier and more difficult than you would expect.

(more…)

Compiling Firebird on Windows 7 64-bit

Tuesday, September 29th, 2009

Just one more aggravation on the road to 64-bit paradise.  I tried to compile Firebird on my Windows 7 64-bit system using Visual Studio 8, by following the directions given in firebird2\doc\README.build.msvc.hmtl.  Of course it didn’t work.  make_icu.bat reported all targets skipped.  Oh joy!

I turns out, if you want to build Firebird using the 32-bit compiler (which I did) on 64-bit Windows, you need to do so from a 32-bit command prompt.  I didn’t even know that there was such a thing, but there is.  The only way I could find to start a 32-bit command prompt was to browse to \Windows\SysWOW64 and start the cmd.exe found there.

Once I tried the build from the 32-bit command prompt, everything worked just like it should have.

Migrating Firebird Security Databases from 1.x.x to 2.x.x

Tuesday, June 23rd, 2009

One of the main goals of Firebird 2.0 was to enhance database security.  In order to achieve this, certain changes were made to the security database which made it incompatible with prior versions.  So now, unlike prior upgrades, you can’t just copy your old security database to the new installation directory.  If you try to do this you will get a “Cannot attach to password database” error when you try to connect to the server.  You have to put your old security database through a conversion process to be able to use it with the new Firebird.  Here is how it is done:

  1. Copy your existing security database (security.fdb or isc4.gdb) to a safe place.  NOT in the new Firebird installation directory.
  2. Install Firebird 2.x.
  3. Convert your existing security database to ODS 11 by using the gbak tool to back up and restore the database.
  4. Connect to your existing secuity database (newly converted to ODS 11) using the isql tool and run the security database update script using the input command.  This script can be found in misc\upgrade\security\security_database.sql in the Firebird 2.x installation directory.
  5. Stop the Firebird service.
  6. Save a copy of the Firebird 2.x security database (security2.fdb) in a safe place just in case.
  7. Copy the updated security database into the Firebird 2.x installation directory and rename it security2.fdb.
  8. Restart Firebird

You should now be able to connect to Firebird using all of your old user names and passwords.

IE8 and File Security

Friday, June 12th, 2009

I inadvertently installed the Internet Explorer 8 upgrade the other day and ever since then I get File Security Warning dialogues every time I try to execute a file or open a .CHM file from one of my network drives.   Apparently Microsoft has learned nothing from the Vista UAC fiasco and now they are trying to impose the same asinine access control dialogues on unsuspecting IE8 users on Windows XP.

After about 1.5 hours of googling I finally found a way to get rid of the extremely annoying warning.  You need to add your file server to your list of trusted sites under IE.  To do this you open IE and click Tools | Options.  Click the Security tab, highlight the Trusted Sites icon and click the Sites button.  Enter the UNC path for your server into the edit box like this:

file://server_name

Click the Add button and click the Close button.

Now you should be able to open all of those supposedly unsafe file from your file server without having to deal with the annoying dialogues.

As if that weren’t bad enough, the IE8 upgrade seems to have undone the changes I made a long time ago to allow the content of .CHM files from my file server to be displayed.  See my article on this subject to find out how to re-enable this.

Upgrading Firebird from 1.5.x to 2.0.x on Linux

Monday, March 30th, 2009

I recently upgraded Firebird from 1.5.x to 2.0.5 on my Linux server.  Suddenly my UDF library stopped working.  Every time I tried to execute one of the UDFs I got the following error:

invalid request BLR at offset 90
function GRCIRCLE is not defined
module name or entrypoint could not be found

I had the shared library in the UDF directory, the UDFAccess parameter was set to Restrict UDF, the file permissions were correct.  It was driving me crazy.  I finally found out that my shared library has references to libfbembed.so.1 in it.  In Firebird 2.0.x that file is renamed to libfbembed.so.2.  Simply symbollically linking libfbembed.so.2 to libfbembed.so.1 solved the problem.

We take 1st place in the Eden & Area Community Rally!!

Monday, June 9th, 2008

After four years of trying my copilot (my wife) and I took 1st place in the annual Eden & Area Coummunity Center car rally. Driving our 82 Fiat X1/9 we managed to come closest to the expected kilometers and driving time. Hurray!

Accessing .CHM Help Files from a Network Drive

Monday, February 11th, 2008

Recent security patches from Microsoft have made it impossible to access .CHM files that have been installed to a network drive without resorting to patching the registry. In order to access help files on a network drive you must specifically allow each directory that you want to be able to access or allow everything on the local intranet.

(more…)

Backing up the WordPress Database

Tuesday, July 31st, 2007

At some point you need to be able to back up your blog. Since WordPress uses a MySQL back end I had to figure out how to back up a MySQL database. It turns out that this is a fairly simple thing to do. You just use the mysqldump utility. The command to backup a database is:

mysqldump –user=<user_name> –password=<pwd> <database_name> > <backup_file>

e.g.

mysqldump –user=root –password=***** blog >c:\backups\blog.bak