RE: Bugs 5.6.0 modperl use?
We are running 5.6 on 2 production servers with mod_perl 1.23 and 1.24, Apache 1.3.12, Apache::DBI, DBD::Sybase (to MSSQL), and DBD::mysql. One box is Linux. The other is Solaris 2.7. So far no issues other than "depreciated" notices on some modules, and our own programming errors. Serving ~6M dynamic page views per month between the two boxes. They both seem quite stable now that our own bugs are ironed out... ;-) -Original Message- From: Jeff Stuart [mailto:[EMAIL PROTECTED]] Sent: Friday, May 26, 2000 12:37 AM To: Jim Winstead; Modperl Mailing List Cc: [EMAIL PROTECTED] Subject: RE: Bugs 5.6.0 modperl use? Ok, follow up question if I may. :) Are any of you using it with DBI and DBD::mysql? I see on the Mason list that people are using it with HTML::Mason so that module is safe. :) Looks like I'm gonna have to pull out that old Linux box and do a test on it. :) -- Jeff (FurBall) WebOverdrive Newbie Tech Board http://www.topniche.com/tech/ [EMAIL PROTECTED] -Original Message- From: Jim Winstead [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 25, 2000 10:46 PM To: Modperl Mailing List Subject: Re: Bugs 5.6.0 modperl use? On May 25, Jeff Stuart wrote: That's a GOOD question. Is there anyone at the moment using perl 5.6.0 in production? Is it ready for production yet? We have one site in production with it, and a number of others going into production soon. We've been using is exclusively in our development environment for all new development since shortly after 5.6.0 came out. It has been rock-solid for us. (The basic setup is Apache 1.3.12, mod_perl 1.24, perl 5.6.0, and FreeBSD 3.4.) Jim
Want to work at a Game company?
INTERNET DEVELOPER If you like the idea of working with unique, talented people and wearing jeans and a t-shirt to work, you're just the person we're looking for. Origin is a long-standing leader in the PC-gaming industry, and an acclaimed pioneer in the online gaming genre. We create Virtual Worlds that set the standard for interactive entertainment. We're currently searching for an Internet Developer to assist in the creation and maintenance of Internet applications and to support the creation of programming that will be compelling and interactive, enticing people to enter and explore our worlds with a focus on building and strengthening our relationships with the visitor/user-community. Additionally, to assist in high-level coding during HTML production/implementation and identify new advanced programming technologies for web site development. Qualified candidates should have: QUALIFICATIONS: · Proficient with Perl and SQL. · Experience with Internet tools. · Must be able to write and implement JavaScript and HTML. · Must understand SQL and demonstrate query writing ability. · Must possess an understanding of server administration. · Computer science degree or 2-3 years Internet programming experience desired. · The ability to multi-task in a fast paced environment, thrive in a team atmosphere and effectively work with all levels of mgmt. Located in the scenic hills of Northwest Austin, we offer a unique and casual work environment along with competitive salaries and a comprehensive benefits package. Origin offers challenging projects, excellent opportunities for advancement, and the freedom to be as creative as you can possibly be. At our facility, you will find an on-site fitness-center, café, free video games, pets and more. For immediate consideration, please send resume and salary requirements to: Origin Systems-Human Resources, 5918 W. Courtyard Drive, Austin, TX 78730 or fax to 512-346-7905 or email [EMAIL PROTECTED] No phone calls please. We are an equal Opportunity Employer.
RE: Want to work at a Game company?
This was the default posting from HR. I should have thrown in the mod_perl requirement when sending to this list. All of our Perl is mod_perl, but HR didn't want to scare anyone away who might have been a good Perl programmer, but had never used mod_perl before (if it's possible to be good without using it). I know that most people on this list already have good jobs that they love, so maybe it isn't the best place to find someone. I am hoping to support any members of our community who feel like they could have more fun at work. I apologize for the spam. -Original Message- From: Jason Bodnar [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 18, 2000 12:00 PM To: Buddy Lee Haystack Cc: [EMAIL PROTECTED]; Graf, Chris Subject:Re: Want to work at a Game company? Yes it is. Doug has always encouraged mod_perl related jobs to be posted to this list. On 18-May-2000 Buddy Lee Haystack wrote: Is this the proper forum for this posting? "Graf, Chris" wrote: INTERNET DEVELOPER If you like the idea of working with unique, talented people and wearing jeans and a t-shirt to work, you're just the person we're looking for. Origin is a long-standing leader in the PC-gaming industry, and an acclaimed pioneer in the online gaming genre. We create Virtual Worlds that set the standard for interactive entertainment. We're currently searching for an Internet Developer to assist in the creation and maintenance of Internet applications and to support the creation of programming that will be compelling and interactive, enticing people to enter and explore our worlds with a focus on building and strengthening our relationships with the visitor/user-community. Additionally, to assist in high-level coding during HTML production/implementation and identify new advanced programming technologies for web site development. Qualified candidates should have: QUALIFICATIONS: · Proficient with Perl and SQL. · Experience with Internet tools. · Must be able to write and implement JavaScript and HTML. · Must understand SQL and demonstrate query writing ability. · Must possess an understanding of server administration. · Computer science degree or 2-3 years Internet programming experience desired. · The ability to multi-task in a fast paced environment, thrive in a team atmosphere and effectively work with all levels of mgmt. Located in the scenic hills of Northwest Austin, we offer a unique and casual work environment along with competitive salaries and a comprehensive benefits package. Origin offers challenging projects, excellent opportunities for advancement, and the freedom to be as creative as you can possibly be. At our facility, you will find an on-site fitness-center, café, free video games, pets and more. For immediate consideration, please send resume and salary requirements to: Origin Systems-Human Resources, 5918 W. Courtyard Drive, Austin, TX 78730 or fax to 512-346-7905 or email [EMAIL PROTECTED] No phone calls please. We are an equal Opportunity Employer. -- Jason Bodnar + [EMAIL PROTECTED] + Tivoli Systems Lisa: Remember, Dad. The handle of the Big Dipper points to the North Star. Homer: That's nice, Lisa, but we're not in astronomy class. We're in the woods. The Call of the Simpsons
RE: newbie question - require
Check the mod_perl guide for the usage of require() and do(). You probably
want to use do() instead of require().
Chris
-Original Message-
From: Brett Lee [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 7:56 AM
To: [EMAIL PROTECTED]
Subject: newbie question - require
In moving from CGI.pm to mod_perl, I ran across the common error with
functions that exist in scripts pulled in with 'require'.
Mod_perl_traps.html had the solution. Similarly, am using ('require')
another file which holds all the hash tables (countries, states, etc.)
that my scripts need to reference. It appeared to work fine in CGI.pm,
but with mod_perl, the info in the hash tables seems to be found "every
other refresh" (which has me stumped).
Would anyone be able to suggest a solution or reading material on this?
Thanks in advance.
-Brett
Apache::DBI with Sybase - What's wrong?
It seems that once processes start getting reused, I wind up with a ton of DB error messages in my error_log. They seem to start like this: ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect Then a whole host of these start popping up: DBD::Sybase::db ping failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called at an illegal time. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an illegal time. What is happening on the user end at this time - 500s? Any insight would be incredibly helpful at this point. Thanks Chris
RE: Apache::DBI with Sybase - What's wrong?
Thanks Michael. If anyone can explain a little better what Apache::DBI and mod_perl are doing, or should be doing at this point, that may be helpful. I have been testing a little more and found that no errors will appear unless I am actually doing something with the connections. If I just initiate the persistent connections the first time the scripts run, and never touch them, they appear to stay alive (or at least restart properly) without generating errors. If I do queries against the connections, they will start to generate these errors starting about 15 mins after Apache startup (with about 100-150 httpd processes running at any given time). The errors will become more and more frequent after they start, which leads me to believe that when the connection goes bad in an httpd process, it doesn't correct itself. I also have two other Apache::DBI connections to a MySQL server running in the same connect sub which never have a problem. Here is the exact complete error log in sequence from the time I started Apache until I shut it down. The first error appeared about 15 mins after restart. The rest happened within about a minute after the first one. --- Apache startup ct_cmd_alloc failed at /home/httpd/uoboards/cgi-bin/w3t.pm line 1322. DBD::Sybase::st execute failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50) Message String: ct_cmd_alloc(): user api layer: external error: The connection has been marked dead. ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect DBD::Sybase::db ping failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called at an illegal time. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an illegal time. DBD::Sybase::db ping failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called at an illegal time. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an illegal time. DBD::Sybase::db ping failed: OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_cancel(CONN,ALL): user api layer: external error: There is a usage error. This routine has been called at an illegal time. OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (60) Message String: ct_close(FORCE): user api layer: external error: There is a usage error. This routine has been called at an illegal --- shutdown occurs here syb_db_disconnect(): ct_con_drop() failed syb_db_disconnect(): ct_con_drop() faile Thanks It seems that once processes start getting reused, I wind up with a ton of DB error messages in my error_log. They seem to start like this: ct_cmd_alloc failed at /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Sybase.pm line 159. DBD::Sybase::db ping failed: OpenClient message: LAYER = (5) ORIGIN = (3) SEVERITY = (5) NUMBER = (6) Message String: ct_cancel(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect I'm not familiar with Apache::DBI, so I don't know exactly in what situation it calls ping()... In this case it looks like ping fails (ie the connection to the server has been killed) but the sequence of calls that follow is incorrect. What is happening on the user end at this time - 500s? Any insight would be incredibly helpful at this point. I think there's a good chance of 500s, but maybe not. It's possible that these are internal warnings, and that the initial failed ping() causes a database reconnect and
