Errors using DBI with Sybase
I keep getting internal server errors on my site. I've tracked down this stack trace in the apache error log file. I haven't managed to reproduce the problem and it occurs sporadically. Has anyone seen this before or know where I should start looking for a solution? Thanks for any replies, Francois error while executing /../components/loginchecknoform: DBI-gt;connect failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY (5) NUMBER = (6) Message String: ct_connect(): network packet layer: internal net library erro Net-Library operation terminated due to disconnect at /home/atkidz/src/modules/AtKidz/DBDescriptor.pm line 65 HTML::Mason::Request::__ANON__() called at /usr/local/pkgs/perl,v5.6. ib/5.6.0/Carp.pm line 119 Carp::croak() called at /usr/local/pkgs/perl,v5.6.0/lib/site_perl/5.6 sun4-solaris/DBI.pm line 385 DBI::connect() called at /usr/local/pkgs/perl,v5.6.0/lib/site_perl/5. /sun4-solaris/DBI.pm line 324 DBI::connect_cached() called at /home/atkidz/src/modules/AtKidz/DBDes ptor.pm line 65 require 0 called at /home/atkidz/src/modules/AtKidz/DBDescriptor.pm l 64 AtKidz::DBDescriptor::DBconnect() called at /home/atkidz/src/modules/ idz/User.pm line 184 AtKidz::User::validate_user() called at /home/atkidz/src/modules/AtKi User.pm line 151 AtKidz::User::find_user() called at /home/atkidz/mason/data/obj/../co nents/loginchecknoform line 25 HTML::Mason::Request::comp1() called at /usr/local/pkgs/perl,v5.6.0/l site_perl/5.6.0/HTML/Mason/Request.pm line 517 HTML::Mason::Request::comp() called at /usr/local/pkgs/perl,v5.6.0/li ite_perl/5.6.0/HTML/Mason/Commands.pm line 75 HTML::Mason::Commands::mc_comp() called at /home/atkidz/mason/data/ob utohandler line 16 HTML::Mason::Request::__ANON__() called at /home/atkidz/src/modules/At Kidz/User.pm line 321 HTML::Mason::Request::__ANON__() called at /home/atkidz/src/modules/At
mod_perl guru wanted
Hi all, We've just posted a new job description that seems relevant to this list. Feel free to drop me a note if you're interested, or contact Megan at the email address below. Thanks, Chris We are looking for a mod_perl / cgi guru to work on application development and site architecture (with a bit of Apache and Linux administration for good measure). CareScout is a small B2B and B2C internet startup which provides ratings, rankings and descriptive data on eldercare facilities, merging the internet with the decades dominant demographic shift. Come join a small IT department where the number of hats you wear is determined by the degree to which you like to get your hands dirty. The ideal candidate is adept at: · Developing architectural and application code in mod_perl and straight cgi. · Working at each stage of the project life cycle from developing tech specs through design and implementation. · Identifying how new functionality would impact other elements of the site. · Working both independently and on a team to develop projects. · Interacting with non-technical staff · Providing advice / mentoring to other developers in the office. Startup environment, lots of autonomy, good $$, stock options. Desired skills: 3 4 years Perl, mod_perl, Linux administration, MySQL, Apache administration. C, XML and Computer Science degree a plus. We are looking for a permanent, full-time on-site employee. We're located in Wellesley, MA, about 15 minutes outside of Boston. If you are interested, please contact Megan Humphreys at [EMAIL PROTECTED]
make errors - i am going crazy
Hi folks, I think now I tried every combination of compilers, perl-versions, perl compile-flags, mod_perl-versions and so on, but nothing works... My last try had following configuration: perl 5.6.0, compiled with -Ubincompat5005 -Uuselargefiles -Dcc=gcc apache 1.3.14, with mod_ssl-2.7.1-1.3.14 and php 4.0.3pl1 (this one works) mod_perl 1.24_01 with APXS (USE_APXS=1 WITH_APXS=/usr/local/apache/bin/apxs EVERYTHING=1) on a solaris 2.6 box and after: gcc -c -I../ -I/usr/local/apache/include -I/usr/local/apache/include -I/usr/local/include -O -DVERSION=\"1.00\" -DXS_VERSION=\"1.00\" -fPIC -I/usr/local/lib/perl5/5.6.0/sun4-solaris/CORE Connection.c I got following error: Connection.xs:2: mod_perl.h: No such file or directory I got the same error also with different perl-configuration. I also tried to compile mod_perl statically or with APACI to apache but then I got segmentation fault on startup which is not logged. I know it is stupid 'cause there are lots of postings with similar problems, but I think I tried all those suggestions with no success... Can anyone help me?? Thanks in advance alex -- ZENTRALES VERZEICHNIS ANTIQUARISCHER BUECHER E-Mail[EMAIL PROTECTED] WWW http://www.zvab.com Fon +49 30 / 533 12 44 00 Fax +49 30 / 533 12 44 05 Ein Unternehmensbereich der buecher.de AG
dynamic html
is there a way with an apache module to trap dynamic html i know i can do that with static html i used Apache::Footer but is it possible to do the same thing that Footer.pm does (add a couple of lines in the html) but to the html generated by scripts thanx +--+ | Rony El khoury | | Lead programmer - HBEsoftware.com| | 460 St-catherine O. suite 210 , Mtl. Ca. | | (514) 876-7881 X: 250 | +--+
Authorization handler shared database handle
I'm using Apache::DBI, DBI and DBD::Oracle The database connection is made with one username/password for best performance but a pl/sql program in the database authorizes the supplied username and password and then generates the desired output. The username and password has been obtained using basic authentication with Apache::AuthAny (pp 282-285 Apache Modules with Perl C - Stein MacEachern). Possible solutions might be: 1) connect and authorize using the authentication handler and pass the database handle to the script to do further operations on the opened connection. If this is possible how would you pass the database handle from the authentication handler to the perl program? 2) Allow the perl program to return DECLINED or AUTH_REQUIRED to Apache. How would you do this? Thanks, John Russell
Re: Apache::ASP problems with Global, global.asa, 'use lib' and @INC
[EMAIL PROTECTED] wrote: The problem is that I specify a dirname for the Global perl var on my httpd.conf and Apache::ASP fails to push it on @INC. This problem is circumvented if I create a global.asa file (even an empty one) in the directory I specify for the Global var. If I do this then the path is correctly pushed onto @INC. It took me a while to discover the global.asa trick. I think this is a bug because global.asa should always be optional on ASP apps. Good point. In my latest dev release 2.05, Global is added to @INC during every script compilation, just for that compilation. Other problem I found is that pushing another path onto @INC by way of "use lib $new_path;" doesn't work properly. The "use lib" is executed but it only modifies @INC the first time the script is executed, and is then ignored on succesive invocations of the same script on the same httpd process. Right, this is the way modperl works. If you want @INC to stay a certain way, you should modify it prefork in the parent. Even then, I'm not sure it'll stay that way, test it out! Let me know if you want my latest dev release for Apache::ASP. Its very stable. I'm glad to see a fellow Cardinal working with modperl, class '97 myself. --Joshua
Connection Pooling / TP Monitor
First let me say that I'm aware that this topic comes up with some frequency on the mod_perl and DBI-users list. I am aware of posts like this one: http:[EMAIL PROTECTED] which argue against the necessity of pooling. However, I am also aware of a _major_ ISP that implements their email system using a _major_ RDBMS that has had problems that are best solved via connection pooling. Essentially, the time it takes them to search through all the cached connections is nearly as long as the time it is taking to read/write to the database. Although, I'm not implementing email as this ISP is, I think that scalability in my case may definitely run into similar roadblocks. I am interested in hearing from anyone that has tried to implement true connection pooling either within Apache or as an external process. I'm particularly interested in hearing about implementations that could be made to work or are done using Perl and DBI/DBD. I am mostly interested in things that are Open Source or licensed like Perl itself. I am aware of a project called Gnu Transaction Server (GTS), but it doesn't seem like this is quite ready for prime time at the moment or is even under active development. I've seen posts that hint at using shared memory and IPC to implement this within Apache as well as posts that hint at possibilities of implementing this using DBI::Proxy. I basically want to do what the big TP monitors (Tuxedo/Encina/CICS) do with respect to condensing connections to a database, but I'm not in need of features like two-phase commit, cross database joins, heterogeneous database environment, etc. incorporated in these products. Even if you'd simply be interested in working on such a project, I'd like to hear from you. If you think such a project is plain stupid, I'd also be interested in hearing from you (but be gentle!). If you already have something sort of working along these lines, I'd DEFINITELY be interested in hearing from you! -- Jeff Horn
Re: Connection Pooling / TP Monitor
On Tue, Oct 24, 2000 at 03:09:47PM -0500, Jeff Horn wrote: I basically want to do what the big TP monitors (Tuxedo/Encina/CICS) do with respect to condensing connections to a database, but I'm not in need of features like two-phase commit, cross database joins, heterogeneous database environment, etc. incorporated in these products. I think there's lots more mileage to be had from developing DBI::ProxyServer further. Tim. p.s. Jeff, please keep me CC'd on any dialogue. Thanks.
