Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

Category Archives: mod_perl

An easy way to view maintenance logs using a browser using Perl & Mason

by Jason L Froebe on February 7, 2007, no comments

stats/index.html: < %method title> DBServices: Update Statistics Logs <center> <h1>Update Statistics Logs</h1> < & ‘../.components/ase/maint_logs.comp’, path => "/dbms/sybase/dba/out", file_part => "update_stats" &> </center> stats/dhandler: < %perl> my $self = shift; $self->{once_header} = ”; $self->{header} = ”; $self->{body} = ”; $self->{footer} = ”; $self->{current_block} = ”; my $log_path = ‘/dbms/sybase/dba/out/’; my $file = $m->dhandler_arg; $file =~ [...]

Share Button

disappearing alert override table SOLVED!

by Jason L Froebe on November 27, 2006, no comments

At work, I created a web page that would raise alerts depending on various criteria and could be overridden by an entry in a db table. Server Name Override Start Override End Authorized By Comments my_server Nov 20 2006 3:24PM CST Dec 4 2006 12:00PM CST RG add space Well, I solved it!  When you [...]

Share Button

Perl Problem with filtered Mason code & db connection

by Jason L Froebe on November 6, 2006, no comments

Hi, In chapter 5 (Advanced Features pgs 82,83) of Embedding Perl in HTML with Mason from O’Reilly, the"a simple SQL select expressed in something like a taglib style" example appears to be straight forward.  It is but it doesn’t seem to work too well. The premise is that the ".components/sql/select" will filter the chunk of [...]

Share Button

Apache 2, mod_perl 2 and security (Apache2::Const)

by Jason L Froebe on September 12, 2006, no comments

Problem: I want to send a 404 (not found) error back to the browser when any ".*" or "*.mas" or "*handler" files are requested.  The example in the Mason book is for mod_perl v1 and so far, I haven’t been able to find a working example of how to send the 404 return code using [...]

Share Button

Using Perl, Mason, mod_perl and DBI: Result sets

by Jason L Froebe on August 13, 2006, one comment

I’m new to Mason and am having trouble printing a simple html table pulling data from a table on a database.  I know this has to do with scope but there has to be an easier way other than putting the entire dbms call (including printing the table) within a perl code section. One thing [...]

Share Button
Facebook login by WP-FB-AutoConnect