FW (use Perl;): Perl Music Videos

Ran across “Perl Music Videos” on use Perl;

Perl Music Videos

Journal written by pudge (1) and posted by pudge on 2007.06.29 0:01
I posted two songs on YouTube: Perl, in a Nutshell and KLB. “Perl, in a Nutshell” is a parody of a Barenaked Ladies song called “Life, in a Nutshell.” Not much more needs to be said about that. “KLB” is a song I wrote years ago, with ideas from nocarrier and Schwern and others, about #perl on EFNet.

Longest Concert Evar: 008 Perl, in a Nutshell

Longest Concert Evar: 009 KLB

Share Button

Unable to remotely connect to VMware Server on Ubuntu 7.04 (Feisty)?

VMware Server running on Ubuntu 64bit:

The problem is that the Ubuntu package is a 32bit package and doesn’t take into consideration that pam 64bit will try to load the 32 bit libraries as 64 bit libraries. The workaround, discovered by PLM is to replace /etc/pam.d/vmware-authd with:

auth       sufficient       /usr/lib/vmware-server/lib/libpam.so.0/security/pam_unix2.so shadow nullok
auth       required         /usr/lib/vmware-server/lib/libpam.so.0/security/pam_unix_auth.so shadow nullok
account    sufficient       /usr/lib/vmware-server/lib/libpam.so.0/security/pam_unix2.so
account    required         /usr/lib/vmware-server/lib/libpam.so.0/security/pam_unix_acct.so

VMware Server running on Ubuntu 32bit:

The problem is that for Ubuntu 32bit, the pam authentication lines in /etc/pam.d/vmware-authd are wrong and need to be replaced by:

auth required pam_unix_auth.so shadow nullok
account required pam_unix_acct.so
Share Button


For all you knitters out there…  Ran across this on Digg.com:

Color Inspiration: Knit Socks of All Sorts

Knitters truly are color lovers. These aren’t your average socks… these wonderfully colorful knit socks show a wide variety of the endless possibilities for crafty knitters.

21 hours 58 min ago, made popular 1 hour 12 minutes ago
nendoke nendoke   (news: submissions, diggs, comments)
News » Technology » Design
Share Button

Sybase Newsgroups: Posting Guidelines

Ever have your post to the Sybase newsgroups removed?  Ever wonder why?  Sybase has just posted their rules:

Moderation Guidelines – Using Sybase Newsgroups

TeamSybase provides moderation services to all Sybase newsgroups, and will enforce good usage rules for the forums.    Please do not post content that is inappropriate for the forums topic or offensive to others.

Offensive postings will be removed in the following cases:

  1. When a the content of the posting is not relevant to the newsgroup within which it is posted. Advertisements, Help Wanted Ads, etc should be posted in the news.classifieds newsgroups.
  2. When the posting contains profanity, obscenities, racist remarks or is abusive of another forum member in any manner.
  3. When the posting is of a personal nature or contains personal information about a forum member.
  4. When the posting contains an attachment that contains a virus or is otherwise incomplete.
  5. When the posting has been added to every newsgroup for no apparent reason.

Postings will NOT remove postings in the following cases:

  1. When the posting contains constructive criticism of one of our products. This criticism may generate a conversation that could prove to be useful in shaping our products in the future.
  2. When the message has been cross posted to multiple newsgroups but the contents make it relevant for those newsgroups.

Share Button

Where should tempdb in Sybase’s ASE go?

ASE’s data cache in v12.5.0.3 and higher & writing to a filesystem for tempdb (without directio or dsync) will always outperform ASE data cache & tmpfs on LINUX because of the way that tmpfs was implemented within Linux.

Now, if you’re talking about a Linux RAM DISK which is completely and utterly different than tmpfs, as the ram disk is generally only used on Live CD distributions and some bootups….   ram disk is very very slow compared to tmpfs.  Don’t use it.

The RAM Drive, a physical ‘drive’ that contains memory instead of disk platters…  very expensive but doesn’t improve performance over ASE & filesystem much at all.  Use only if some pointy haired boss has extra $$ in his/her budget that they need to use.  Not worth the $$$.

On Solaris and AIX performance is pretty close to the same, so it is better to use a normal filesystem & ASE as the ram disk would just be wasted space.  Can’t say on HPUX as I don’t have access to such a box.

4:30 am here… I’m going back to bed.

Share Button

TechWave 2007 class registration is now available!

The class registration and listing is available on Sybase’s TechWave website

Here is my current schedule:

Sybase TechWave 2007
My Agenda
Time Session Title Learning Track Status

Tuesday, August 7, 2007

2:30 pm –
5:00 pm 

Performance and Tuning: ASE Query Optimization

Education Courses and iAnywhere TechSummits


Wednesday, August 8, 2007

8:00 am –
10:15 am 

Performance and Tuning: ASE Query Optimization

Education Courses and iAnywhere TechSummits


1:00 pm –
2:00 pm 


Using Java and Web Services within Adaptive Server Enterprise (ASE)

Enterprise Database, Data Management and Business Continuity


2:15 pm –
3:45 pm 

Designing High Performance Applications/Transaction Design (Prevention not Diagnosis & Medication)

Application Development Trends


4:00 pm –
5:30 pm 

Case-Express: Using Sybase tools and bleeding edge technologies for a feature-rich web application

Application Development Trends


Thursday, August 9, 2007

8:00 am –
10:15 am 

Migrating from ASE to Sybase IQ: An ASE DBA’s perspective

Education Courses and iAnywhere TechSummits


1:00 pm –
2:00 pm 

Setting up Replication Server and OpenSwitch for Continuous Availability and Disaster Recovery


Data Integration, Analysis, and Warehousing


3:30 pm –
5:00 pm 

Connecting Adobe Flex and Flash to Sybase Adaptive Server Enterprise (ASE) using Web Services

Application Development Trends


Friday, August 10, 2007

8:00 am –
10:15 am 

Performance and Tuning: ASE Query Optimization

Education Courses and iAnywhere TechSummits


1:00 pm –
2:30 pm 


Top Ten Adaptive Server Enterprise (ASE) MDA Tables

Enterprise Database, Data Management and Business Continuity


Share Button

Simple beauty

$ isql -Usa -i installmontables
It is no longer necessary to run this script to install the Monitoring Tables.
Monitoring Tables are now installed by the installmaster script.

This installmontables script is provided as a sample that can be copied and
modified to support remote access of Monitoring Tables. To do so you need to:
1) Replace all instances of @SERVER@ with the name of the remote ASE from which
   monitoring data is to be obtained. Note that each remote ASE to be monitored
   must be added to the local ASE's sysservers table using sp_addserver.
2) Create a database with the same name as the remote ASE. This database need
   only be of the minimum size as these tables do not store any data.
3) Remove this header (i.e. these first 21 lines).
4) Run the script against the local ASE using the isql utility as follows:
   isql -Usa -P -S -i

Seeing that the MDA tables are now part of the default install is truly beautiful. Kudos to Peter Dorfman and all the other engineers at Sybase working on the MDA tables!

Share Button

Getting “A suitable JVM could not be found” with ASE 15.0.2 setup

$ ./setup -is:$JAVA_HOME -console 
InstallShield Wizard
Initializing InstallShield Wizard...
Searching for Java(tm) Virtual Machine...
A suitable JVM could not be found. Please run the program again using the option -is:javahome
Permission denied
Permission denied

Have you ever run into this? Well, I just did and for some reason the /tmp directory had permissions of drwxr-xr-x. A quick chmod 1777 /tmp fixed it. This is an fyi in case someone else runs across this problem.

Share Button

Geek Spotlight: Michael Peppler

You are best known for creating the custom build of Perl known as SybPerl back in 1991 when Perl itself was new. What made you decide to create SybPerl?

In 1989 I moved from developing on MS-DOS and Waterloo Port (Waterloo Port was a cousin to QNX) to SunOS 4.x. I had no formal software (or OS) training, so this was a major shift, and required me to learn a lot of new things (shell, awk, sed, etc.). At the same time I first started using Sybase (SQL Server 4.0, on a Sun 386i). In 1990 I went to the Software Development conference in Oakland, and Rob Kolstad (IIRC he was at Sun at the time – a quick google search shows that he is a director of SAGE now) made a presentation on perl – and as a C programmer this made a lot of sense.Michael Peppler

I managed to download and build perl (remember – no internet back then so getting the code meant sending an email request via uucp to a mail responder that returned uuencoded chunks…). After building perl it quickly became obvious that writing perl scripts to perform various duties on the Sybase database would be ideal. The first attempt involved running isql in a subshell, via pseudo terminals. While this worked it was rather slow, and error prone.

Then around June 1990 Larry Wall added “user subs” to perl (version 3.something) and that made it comparatively easy to link a few DBLibrary calls into perl. That first version only opened a single connection, and had a number of other limitations. During the next year I expanded it to allow multiple connections, and then in September 1991 I made it public in a post to comp.lang.perl. It was a natural move for me – I had already been active for several years on a few public BBSs (mainly BIX, set up by Byte Magazine), and Usenet, and helping others had allowed me to learn my craft – making this code public was just an extension of that activity.

You wrote the Sybase module for the Perl DBI (DBD::Sybase). What difficulties did you run into when making the module? Were you also involved in the design of the Perl DBI?

The impetus for DBI was started by Buzz Moschetti – he was also a sybperl user (among other things) and was getting annoyed at having different APIs for the various database servers that he needed to access from his perl scripts. Buzz, Kevin Stock, Ted Lemon, Tim Bunce and various others (including myself) were on the original mailing list for the design of the DBI spec, although Tim certainly did most of the actual work. It took a lot of time before I started writing the DBI module (initially as an emulation layer on top of Sybase::CTlib). Then there was mostly the issue of handling multiple result sets which the DBI wasn’t really geared to handle. I think the work-around I chose (using the syb_more_results attribute to check for more results) was reasonable and allowed code written for DBD::Sybase to be compatible with “normal” DBI code. For a long time I was really still a Sybase::CTlib user, and it’s only comparatively recently (in the last couple of years) that I’ve started to use DBD::Sybase extensively for my own work.

Did you receive any help from Sybase, specifically any undocumented features of OpenClient? Has it been difficult supporting both FreeTDS and OpenClient?

I received some help from Sybase in 1995 when they were developing web.sql, which itself used perl and the Sybase::CTlib module. Since then I have received help “privately” from various people at Sybase (via email, or in the newsgroups). However, Sybase doesn’t publicly acknowledge DBD::Sybase (yet ?), which is a little unfortunate as they do acknowledge various other OpenSource interfaces (for PHP and the DBI module for SqlAnywhere).

My support for FreeTDS is minimal at the moment, due to a lack of time. I did some work on a DBD::FreeTDS module a couple of years ago (sponsored by a Wall Street brokerage firm), and I should really find the time to make this module public. The reason to have this module separate from DBD::Sybase is to allow linking with both Sybase OpenClient and FreeTDS from the same perl process, and to remove the functionality that isn’t supported by FreeTDS.

Is there anything in the pipeline from you? Any new features that will be added soon to your modules?

Not really – at the moment I’m focusing on maintenance, bug removal, and following the DBI evolution. As Tim Bunce is now a DBD::Sybase user he has contributed some significant changes (and motivation). After 17 years spent working on what is for large parts the same code it gets harder to sit down after a days work and decide to work on this or that feature.

Can you tell us a little about your professional work life?

I’m a production DBA in a large bank, with primary focus on Sybase ASE, and secondary focus on Oracle. As a production DBA I don’t do much coding, and only minimal performance tuning. Most of the applications we run are third party apps, so our maneuvering range is quite small (add cache, make sure the disks are configure corrrectly, and that’s about it). The things we do code are backup and restore scripts, DBCC checks, and so on. I’m on call one day out of five (meaning I must be able to get on to the company network in less than one hour), but other than that it’s fairly low stress – mainly because we’ve developped procedures and checks to catch problems as early as possible.

What do you do when you’re not coding?

I read a lot (Science Fiction, Crime/detective, general fiction), listen to music (I used to play guitar and bass in a band a long time ago…), I like to ski (I live in Switzerland), play golf, and just hang out with friends…

What other languages do you work with besides Perl?

SQL (well, I’m a DBA :-), and C.

For those of us that use your Perl modules, how can we express our gratitude?

Submit patches with the changes you’d like to see, help answering questions for newbies in the newsgroups and mailing lists.

Share Button

PS2 God of War 1 : I’m stuck damnit

Excerpt from IGN » Games » Guides God of War

The Challenge of Poseidon


You’ll emerge in a huge room with a few minotaurs to kill. Fight ’em off and then pull the lever at the back of the room to raise a series of platforms that leads across the room. Hop across the platforms and kill off the legionnaires that appear to grab the red orbs from the nearby chests before diving back in the water to return to the lever you just pulled.Pull the lever once more to raise the platforms and then very quickly dive into the water on the left side of the platforms. At the base of the very last platform is a small opening you can fit into, and it transfers you back to the rings of Pandora.

The problem I’m running into is that after I kill the Minotaurs, pull the lever, go up the platforms, kill the baddies, get the red orbs, read the book, and go back to the lever, it won’t let me pull the lever again because the platforms NEVER GO DOWN!  Thinking it might be a goof on my part, I do it all over again but go in to the secret room under the pillar farthest from the lever… and stay there for 20 mins.  I power off/on the PS/2 thinking it might be glitch and same thing.  None of the walk through FAQs mention this issue at all.  ARGH!

Has anyone ran into this problem or know what I can do to go down in the secret room “like an elevator”?

Share Button