serfGeek's Geek::Blog: 11/01/2006

Thursday, November 30, 2006

Determining which package(s)/product(s) own(s) a file on Solaris

You can do:

pkgchk -l -p /full/path/name

Or grep for the filename in /var/sadm/install/contents

Monday, November 27, 2006

Recording macros in vim

http://www.vim.org/tips/tip.php?tip_id=144

Friday, November 10, 2006

Installing Solaris packages to a remote machine from a local CD

If you put the Solaris CD in the drive on a Windows machine it doesn't read the CD filesystem correctly.
You will see directories and files with DOS (i.e. 8.3) filenames:
(created under Cygwin on Windows XP):


# tar tvf SUNWi1cs.windows.tar
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/ARCHIVE/
-r--r--r-- 18403/10545  18457 Nov 24 20:55 1999 SUNWi1cs/ARCHIVE/NONE
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/INSTALL/
-r--r--r-- 18403/10545     59 Oct 14 10:59 1999 SUNWi1cs/INSTALL/COPYRIGH
-r--r--r-- 18403/10545   1935 Nov 24 20:55 1999 SUNWi1cs/INSTALL/I_NONE
-r--r--r-- 18403/10545    829 Aug 31 23:09 2000 SUNWi1cs/PKGINFO
-r--r--r-- 18403/10545    889 Aug 31 23:09 2000 SUNWi1cs/PKGMAP
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/LIB/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/LIB/LOCALE/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/LIB/LOCALE/ISO_8859/
-r-xr-xr-x 18403/10545      0 Nov 24 20:55 1999 SUNWi1cs/RELOC/USR/LIB/LOCALE/ISO_8859/LC_CTYPE/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/OPENWIN/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/OPENWIN/LIB/
-r-xr-xr-x 18403/10545      0 Aug 31 23:24 2000 SUNWi1cs/RELOC/USR/OPENWIN/LIB/LOCALE/
-r-xr-xr-x 18403/10545      0 Nov 24 20:55 1999 SUNWi1cs/RELOC/USR/OPENWIN/LIB/LOCALE/ISO8859_/

If you have a Mac, that will read the CDs fine :o)
(and I expect Linux will too)

(Created on an iMac):


# tar tvf SUNWi1cs.tar
drwxr-xr-x   0/1        0 Aug 31 15:24 2000 SUNWi1cs/
drwxr-xr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/archive/
-rw-r--r--   0/10   18457 Nov 24 12:55 1999 SUNWi1cs/archive/none
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/install/
-rwxr-xr-x   0/10      59 Oct 14 02:59 1999 SUNWi1cs/install/copyright
-rw-r--r--   0/10    1935 Nov 24 12:55 1999 SUNWi1cs/install/i.none
-rw-r--r--   0/1      829 Aug 31 15:09 2000 SUNWi1cs/pkginfo
-rw-r--r--   0/1      889 Aug 31 15:09 2000 SUNWi1cs/pkgmap
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/lib/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/lib/locale/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/lib/locale/iso_8859_1/
drwxr-sr-x   0/10       0 Nov 24 12:55 1999 SUNWi1cs/reloc/usr/lib/locale/iso_8859_1/LC_CTYPE/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/openwin/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/openwin/lib/
drwxr-sr-x   0/10       0 Aug 31 15:24 2000 SUNWi1cs/reloc/usr/openwin/lib/locale/
drwxr-sr-x   0/10       0 Nov 24 12:55 1999 SUNWi1cs/reloc/usr/openwin/lib/locale/iso8859-1/

I needed SUNWi1cs and SUNWi15cs which are on Software CD 1 of 2 on Solaris 8
which are required for installing the Oracle 10.2.0.1 client...

On the Mac

I put the CD in the drive on the Mac

I then did a 'mount' to see where the CD was mounted:


hostname:~ john$ mount
/dev/disk0s10 on / (local, journaled)
devfs on /dev (local)
fdesc on /dev (union)
<volfs> on /.vol
automount -nsl [335] on /Network (automounted)
automount -fstab [345] on /automount/Servers (automounted)
automount -static [345] on /automount/static (automounted)
afp_2lYWSz0UiuFX000009000000-6.2e000003 on /Volumes/ast (nodev, nosuid, mounted by john)
afp_2lYWSz0UiuFX000009000000-5.2e000004 on /Volumes/EtherShare (nodev, nosuid, mounted by john)
/dev/disk1s0 on /Volumes/SOL_8_1000_SPARC (local, nodev, nosuid, read-only)

Change directory into the Product directory:


hostname:~ john$ cd /Volumes/SOL_8_1000_SPARC/Solaris_8/Product/

List the packages you need to see they're there...


hostname:/Volumes/SOL_8_1000_SPARC/Solaris_8/Product john$ ls -ld SUNWi1cs SUNWi15cs
drwxr-xr-x    5 root  daemon     2048 31 Aug  2000 SUNWi15cs
drwxr-xr-x    5 root  daemon     2048 31 Aug  2000 SUNWi1cs

Tar up the packages to a writable directory (i.e. outside the CD):


hostname:/Volumes/SOL_8_1000_SPARC/Solaris_8/Product john$ tar cvf ~/SUNWi15cs.tar SUNWi15cs
SUNWi15cs/
SUNWi15cs/archive/
SUNWi15cs/archive/none
SUNWi15cs/install/
SUNWi15cs/install/copyright
SUNWi15cs/install/i.none
SUNWi15cs/pkginfo
SUNWi15cs/pkgmap
SUNWi15cs/reloc/
SUNWi15cs/reloc/usr/
SUNWi15cs/reloc/usr/lib/
SUNWi15cs/reloc/usr/lib/locale/
SUNWi15cs/reloc/usr/lib/locale/iso_8859_15/
SUNWi15cs/reloc/usr/lib/locale/iso_8859_15/LC_CTYPE/
SUNWi15cs/reloc/usr/openwin/
SUNWi15cs/reloc/usr/openwin/lib/
SUNWi15cs/reloc/usr/openwin/lib/locale/
SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15/
SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15/OW_FONT_SETS/
SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15/print/
hostname:/Volumes/SOL_8_1000_SPARC/Solaris_8/Product john$ tar cvf ~/SUNWi1cs.tar SUNWi1cs
SUNWi1cs/
SUNWi1cs/archive/
SUNWi1cs/archive/none
SUNWi1cs/install/
SUNWi1cs/install/copyright
SUNWi1cs/install/i.none
SUNWi1cs/pkginfo
SUNWi1cs/pkgmap
SUNWi1cs/reloc/
SUNWi1cs/reloc/usr/
SUNWi1cs/reloc/usr/lib/
SUNWi1cs/reloc/usr/lib/locale/
SUNWi1cs/reloc/usr/lib/locale/iso_8859_1/
SUNWi1cs/reloc/usr/lib/locale/iso_8859_1/LC_CTYPE/
SUNWi1cs/reloc/usr/openwin/
SUNWi1cs/reloc/usr/openwin/lib/
SUNWi1cs/reloc/usr/openwin/lib/locale/
SUNWi1cs/reloc/usr/openwin/lib/locale/iso8859-1/

Go to that directory and list the files:


hostname:/Volumes/SOL_8_1000_SPARC/Solaris_8/Product john$ cd
hostname:~ john$ ls -l SUNW*
-rw-r--r--   1 john  staff  30720 10 Nov 15:31 SUNWi15cs.tar
-rw-r--r--   1 john  staff  40960 10 Nov 15:31 SUNWi1cs.tar

Copy the files to the Solaris machine:


hostname:~ john$ scp *.tar solarisbox:
john@solarisbox's password:
SUNWi15cs.tar                                 100%   30KB   2.8MB/s   00:00
SUNWi1cs.tar                                  100%   40KB   3.5MB/s   00:00

Now on the Solaris machine...

Move the tars somewhere:


# mkdir packages
# mv SUNW*.tar packages/
# cd packages
# ls -l SUNW*.tar
-rw-r--r--   1 jharrison cascade    30720 Nov 10 15:32 SUNWi15cs.tar
-rw-r--r--   1 jharrison cascade    40960 Nov 10 15:32 SUNWi1cs.tar

Unpack the tar files:


# tar xvf SUNWi15cs.tar
x SUNWi15cs, 0 bytes, 0 tape blocks
x SUNWi15cs/archive, 0 bytes, 0 tape blocks
x SUNWi15cs/archive/none, 7825 bytes, 16 tape blocks
x SUNWi15cs/install, 0 bytes, 0 tape blocks
x SUNWi15cs/install/copyright, 59 bytes, 1 tape blocks
x SUNWi15cs/install/i.none, 1935 bytes, 4 tape blocks
x SUNWi15cs/pkginfo, 724 bytes, 2 tape blocks
x SUNWi15cs/pkgmap, 1303 bytes, 3 tape blocks
x SUNWi15cs/reloc, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/lib, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/lib/locale, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/lib/locale/iso_8859_15, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/lib/locale/iso_8859_15/LC_CTYPE, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin/lib, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin/lib/locale, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15/OW_FONT_SETS, 0 bytes, 0 tape blocks
x SUNWi15cs/reloc/usr/openwin/lib/locale/iso8859-15/print, 0 bytes, 0 tape blocks
# tar xvf SUNWi1cs.tar
x SUNWi1cs, 0 bytes, 0 tape blocks
x SUNWi1cs/archive, 0 bytes, 0 tape blocks
x SUNWi1cs/archive/none, 18457 bytes, 37 tape blocks
x SUNWi1cs/install, 0 bytes, 0 tape blocks
x SUNWi1cs/install/copyright, 59 bytes, 1 tape blocks
x SUNWi1cs/install/i.none, 1935 bytes, 4 tape blocks
x SUNWi1cs/pkginfo, 829 bytes, 2 tape blocks
x SUNWi1cs/pkgmap, 889 bytes, 2 tape blocks
x SUNWi1cs/reloc, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/lib, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/lib/locale, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/lib/locale/iso_8859_1, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/lib/locale/iso_8859_1/LC_CTYPE, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/openwin, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/openwin/lib, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/openwin/lib/locale, 0 bytes, 0 tape blocks
x SUNWi1cs/reloc/usr/openwin/lib/locale/iso8859-1, 0 bytes, 0 tape blocks

List the files:


# ls -l
total 144
drwxr-xr-x   5 root     other        512 Aug 31  2000 SUNWi15cs
-rw-r--r--   1 jharrison cascade    30720 Nov 10 15:32 SUNWi15cs.tar
drwxr-xr-x   5 root     other        512 Aug 31  2000 SUNWi1cs
-rw-r--r--   1 jharrison cascade    40960 Nov 10 15:32 SUNWi1cs.tar

Now you can ddd the packages, using the directory you untarred the package directories into as the directory for pkgadd to search for packages:


# pkgadd -d .

The following packages are available:
  1  SUNWi15cs     X11 ISO8859-15 Codeset Support
                   (sparc) 2.0,REV=1999.12.09.13.36
  2  SUNWi1cs      X11 ISO8859-1 Codeset Support
                   (sparc) 2.0,REV=1999.11.24.17.23

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]: <Enter>

Processing package instance <SUNWi15cs> from </export/home/john/packages>

X11 ISO8859-15 Codeset Support
(sparc) 2.0,REV=1999.12.09.13.36
Copyright 2000 Sun Microsystems, Inc. All rights reserved.
Using </> as the package base directory.
## Processing package information.
## Processing system information.
   8 package pathnames are already properly installed.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
  /usr <attribute change only>
  /usr/lib <attribute change only>
  /usr/openwin <attribute change only>
  /usr/openwin/lib/locale/iso8859-15/Compose
  /usr/openwin/lib/locale/iso8859-15/OW_FONT_SETS/OpenWindows.fs
  /usr/openwin/lib/locale/iso8859-15/OWfontpath
  /usr/openwin/lib/locale/iso8859-15/XLC_LOCALE
  /usr/openwin/lib/locale/iso8859-15/print/prolog.ps

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

This package contains scripts which will be executed with super-user
permission during the process of installing this package.

Do you want to continue with the installation of <SUNWi15cs> [y,n,?] y

Installing X11 ISO8859-15 Codeset Support as <SUNWi15cs>

## Installing part 1 of 1.

Installation of <SUNWi15cs> was successful.

Processing package instance <SUNWi1cs> from </export/home/john/packages>

X11 ISO8859-1 Codeset Support
(sparc) 2.0,REV=1999.11.24.17.23
Copyright 2000 Sun Microsystems, Inc. All rights reserved.
Using </> as the package base directory.
## Processing package information.
## Processing system information.
   9 package pathnames are already properly installed.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
  /usr/lib/locale/iso_8859_1 <attribute change only>
  /usr/lib/locale/iso_8859_1/LC_CTYPE <attribute change only>
  /usr/openwin/lib/locale/iso8859-1/Compose
  /usr/openwin/lib/locale/iso8859-1/xomEuro.so.2

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

This package contains scripts which will be executed with super-user
permission during the process of installing this package.

Do you want to continue with the installation of <SUNWi1cs> [y,n,?] y

Installing X11 ISO8859-1 Codeset Support as <SUNWi1cs>

## Installing part 1 of 1.

Installation of <SUNWi1cs> was successful.

The following packages are available:
  1  SUNWi15cs     X11 ISO8859-15 Codeset Support
                   (sparc) 2.0,REV=1999.12.09.13.36
  2  SUNWi1cs      X11 ISO8859-1 Codeset Support
                   (sparc) 2.0,REV=1999.11.24.17.23

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]: q
#

Done! :o)

Problem installing DBD::Oracle on Solaris

I'm having problems compiling DBD::Oracle on Solaris 7.
I've run a make realclean, then perl Makefile.PL, then when I run the make I get:


cp Oracle.pm blib/lib/DBD/Oracle.pm
cp mkta.pl blib/lib/DBD/mkta.pl
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/local/bin/perl -p -e "s/~DRIVER~/Oracle/g" /usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/auto/DBI/Driver.xst > Oracle.xsi
/usr/local/bin/perl /usr/local/lib/perl5/5.8.3/ExtUtils/xsubpp  -typemap /usr/local/lib/perl5/5.8.3/ExtUtils/typemap -typemap typemap  Oracle.xs > Oracle.xsc && mv Oracle.xsc Oracle.c
gcc -B/usr/ccs/bin/ -c  -I/app/oracle/product/8.1.5/rdbms/demo -I/app/oracle/product/8.1.5/rdbms/demo -I/app/oracle/product/8.1.5/rdbms/public -I/app/oracle/product/8.1.5/plsql/public -I/app/oracle/product/8.1.5/network/public -I/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/perl5/5.8.3/sun4-solaris/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.5.0\" Oracle.c
gcc -B/usr/ccs/bin/ -c  -I/app/oracle/product/8.1.5/rdbms/demo -I/app/oracle/product/8.1.5/rdbms/demo -I/app/oracle/product/8.1.5/rdbms/public -I/app/oracle/product/8.1.5/plsql/public -I/app/oracle/product/8.1.5/network/public -I/usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris/auto/DBI -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"1.19\" -DXS_VERSION=\"1.19\" -fPIC "-I/usr/local/lib/perl5/5.8.3/sun4-solaris/CORE"  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\"8.1.5.0\" dbdimp.c
dbdimp.c: In function `ora_db_login6':
dbdimp.c:456: warning: unused variable `rsize'
dbdimp.c: In function `ora2sql_type':
dbdimp.c:2487: error: `SQLT_TIMESTAMP_LTZ' undeclared (first use in this function)
dbdimp.c:2487: error: (Each undeclared identifier is reported only once
dbdimp.c:2487: error: for each function it appears in.)
make: *** [dbdimp.o] Error 1
 /usr/local/bin/make  -- NOT OK
Running make test
 Can't test without successful make
Running make install
 make had returned bad status, install seems impossible
Failed during this command:
 PYTHIAN/DBD-Oracle-1.19.tar.gz               : make NO

Versions:


# uname -a
SunOS apollo 5.7 Generic_106541-42 sun4u sparc SUNW,Ultra-Enterprise

# perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 3) configuration:
 Platform:
   osname=solaris, osvers=2.7, archname=sun4-solaris
   uname='sunos 5.7 generic_patch sun4u sparc sunw,ultra-1 solaris '
   config_args='-Dcc=gcc -B/usr/ccs/bin/'
   hint=recommended, useposix=true, d_sigaction=define
   usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
   useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
   use64bitint=undef use64bitall=undef uselongdouble=undef
   usemymalloc=n, bincompat5005=undef
 Compiler:
   cc='gcc -B/usr/ccs/bin/', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
   optimize='-O',
   cppflags='-fno-strict-aliasing -I/usr/local/include'
   ccversion='', gccversion='3.3.2', gccosandvers='solaris2.7'
   intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
   d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
   ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
   alignbytes=8, prototype=define
 Linker and Libraries:
   ld='gcc -B/usr/ccs/bin/', ldflags =' -L/usr/local/lib '
   libpth=/usr/local/lib /usr/lib /usr/ccs/lib
   libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc
   perllibs=-lsocket -lnsl -ldl -lm -lc
   libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
   gnulibc_version=''
 Dynamic Linking:
   dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
   cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
 Compile-time options: USE_LARGE_FILES
 Built under solaris
 Compiled at Feb  9 2004 03:12:16
 @INC:
   /usr/local/lib/perl5/5.8.3/sun4-solaris
   /usr/local/lib/perl5/5.8.3
   /usr/local/lib/perl5/site_perl/5.8.3/sun4-solaris
   /usr/local/lib/perl5/site_perl/5.8.3
   /usr/local/lib/perl5/site_perl
   .

# gcc --version
gcc (GCC) 3.4.6
Copyright (C) 2006 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

In case it was the compiler version I rolled back to gcc 3.3.2
But with gcc 3.3.2 I got the same error.

This file I found on Google references SQLT_TIMESTAMP_LTZ:
http://ftp.emini.dk/pub/php/win32/dev/php_build/oci805/include/ocidfn.h

I found this file in:


(ORACLE)/rdbms/demo/ocidfn.h

I upgraded to 10.2.0.1 and that worked.
In trying to get it working with 8.1.5 I tried adding more directories to CFLAGS
This didn't work.
What did get it to compile was hacking dbdimp.c and adding:


#include 
#define SQLT_TIMESTAMP_LTZ             232        /* TIMESTAMP WITH LOCAL TZ */

but I think that's a bit of a nasty hack...

Thursday, November 09, 2006

Can't install PathTools on Cygwin


user@hostname /opt/pkg/cpan/build/PathTools-3.23
$ make install
Cannot forceunlink /usr/lib/perl5/5.8/cygwin/auto/Cwd/Cwd.dll: Permission denied at /usr/lib/perl5/5.8/File/Find.pm line 907
make: *** [pure_perl_install] Error 13
user@hostname /opt/pkg/cpan/build/PathTools-3.23
$ ll /usr/lib/perl5/5.8/cygwin/auto/Cwd/Cwd.dll
-rw-rw-rw-+ 1 user group 9216 Dec 30  2005 /usr/lib/perl5/5.8/cygwin/auto/Cwd/Cwd.dll
user@hostname /opt/pkg/cpan/build/PathTools-3.23
$ cd /usr/lib/perl5/5.8/cygwin/auto/Cwd/
user@hostname /usr/lib/perl5/5.8/cygwin/auto/Cwd
$ ll
total 16
drwxrwx---+  2 user group    0 Nov  8 10:27 .
drwxrwx---+ 39 user group    0 Nov  9 09:30 ..
-rwxr-x---+  1 user group    0 Dec 30  2005 Cwd.bs
-rw-rw-rw-+  1 user group 9216 Dec 30  2005 Cwd.dll
-rwxr-x---+  1 user group 2596 Dec 30  2005 libCwd.dll.a
user@hostname /usr/lib/perl5/5.8/cygwin/auto/Cwd
$ mv Cwd.dll Cwd.dll.orig
`Cwd.dll' -> `Cwd.dll.orig'
user@hostname /usr/lib/perl5/5.8/cygwin/auto/Cwd
$ ll
total 16
drwxrwx---+  2 user group    0 Nov  9 11:37 .
drwxrwx---+ 39 user group    0 Nov  9 09:30 ..
-rwxr-x---+  1 user group    0 Dec 30  2005 Cwd.bs
-rw-rw-rw-+  1 user group 9216 Dec 30  2005 Cwd.dll.orig
-rwxr-x---+  1 user group 2596 Dec 30  2005 libCwd.dll.a
user@hostname /usr/lib/perl5/5.8/cygwin/auto/Cwd
$ cd -
/opt/pkg/cpan/build/PathTools-3.23
user@hostname /opt/pkg/cpan/build/PathTools-3.23
$ make install
Installing /usr/lib/perl5/5.8/cygwin/auto/Cwd/Cwd.dll
Installing /usr/lib/perl5/5.8/cygwin/auto/Cwd/libCwd.dll.a
Files found in blib/arch: installing files in blib/lib into architecture dependent library tree
Installing /usr/lib/perl5/5.8/cygwin/Cwd.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Cygwin.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Epoc.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Functions.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Mac.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/OS2.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Unix.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/VMS.pm
Installing /usr/lib/perl5/5.8/cygwin/File/Spec/Win32.pm
Writing /usr/lib/perl5/5.8/cygwin/auto/Cwd/.packlist
Appending installation info to /usr/lib/perl5/5.8/cygwin/perllocal.pod
user@hostname /opt/pkg/cpan/build/PathTools-3.23
$

Solaris OpenSSH motd displays twice...

http://www.informit.com/articles/article.asp?p=100574&seqNum=4&rl=1

http://www.brandonhutchinson.com/Installing_OpenSSH.html

cpan broken: Writing Makefile for ... NOT OK

http://comments.gmane.org/gmane.os.cygwin.perl/64

http://www.cpanforum.com/threads/502

Reconfigure CPAN
http://sial.org/howto/perl/life-with-cpan/#s5

Wednesday, November 01, 2006

Highlight part of an image in GIMP

Take your image (maybe a screenshot)...

Select the part you want to highlight.
Duplicate the image layer.
do Select -> Invert
Double click on the forground colour to get the colour selection dialogue.
Type "c0c0c0" in the "HTML Notation" box.
Click OK in the colour selection dialogue.
Select the copy layer
Flood fill the bottom one with c0c0c0.
Select each layer in the layer dialogue and change the blending mode to multiply or to darken only (which ever looks best)