DBD::mysql and libmysqlclient.so.10

2001-11-29 Thread Ryan Thompson
Hi everybody, I hope I'm asking this on the right forum... But this question involves several different packages :-) On a FreeBSD 4.4 system, I am trying to use DBD::mysql (in my library, I have use Mysql) with mod_perl 1.26. However, when running under mod_perl (and ONLY when running under

Re: Doing Authorization using mod_perl from a programmers perspective

2001-11-29 Thread Richard L. Goerwitz III
Jon Robison wrote: Someone please tell me if I am wrong - does the USER_AGENT field get some kind of special serial number from the browser, or is it just a version identified? Best example - large company with 1000 PC's, all with same Netscape installed. How then does the

[ANNOUNCE] OpenInteract 1.35

2001-11-29 Thread Chris Winters
A new version (1.35) of OpenInteract has been released to CPAN. OpenInteract is an extensible web application server built on Apache, mod_perl, the Template Toolkit and SPOPS object persistence. This is a substantial upgrade, with two new packages, support for the INI-style server configuration

Re: DBD::mysql and libmysqlclient.so.10

2001-11-29 Thread Ged Haywood
Hi there, On Thu, 29 Nov 2001, Ryan Thompson wrote: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object libmysqlclient.so.10 not found at /usr/libdata/perl/5.00503/Dynaloader.pm line 169. libmysqlclient.so.10 DOES

RE: Why libperl.so?

2001-11-29 Thread William Rusch
Even if you compile perl in statically it needs it. I'm not sure if this is a bug or a prerequisite for any mod-perl/apache install that uses mod_so even if its not the perl module. I do know however that building the perl dynamic libraries will solve your problem without forcing you to compile

RE: :mysql and libmysqlclient.so.10

2001-11-29 Thread William Rusch
Usually when I see an error like this i suspect the ld_library_path needs to be set to include the missing dynamic library. Try setting it to include your mysql/lib folder if this could be the problem. -Original Message- From: Ryan Thompson [mailto:[EMAIL PROTECTED]] Sent: Thursday,

Re: DBD::mysql and libmysqlclient.so.10

2001-11-29 Thread Ryan Thompson
Ged Haywood wrote to Ryan Thompson: Hi there, On Thu, 29 Nov 2001, Ryan Thompson wrote: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object libmysqlclient.so.10 not found at

RE: :mysql and libmysqlclient.so.10

2001-11-29 Thread Ryan Thompson
William Rusch wrote to Ryan Thompson and [EMAIL PROTECTED]: Ryan Thompson wrote: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object libmysqlclient.so.10 not found at /usr/libdata/perl/5.00503/Dynaloader.pm line

RE: :mysql and libmysqlclient.so.10

2001-11-29 Thread William Rusch
I use oracle and with DBI I had a similiar problem. although I could run all the oracle client software without having to set this variable i had to set it when i connected through dbi,however this happened with standard cgi's as well. I usually set it in my connection subroutine ie..

RE: :mysql and libmysqlclient.so.10

2001-11-29 Thread Wilt, Paul
Don't you need to add a PerlPassEnv LD_LIBRARY_PATH for this to work? Paul E Wilt Principal Software Engineer

Installing mod_perl 1.26 on solaris 2.7

2001-11-29 Thread James G Smith
I have the 1.26 tarball untar'd and run the following command: % find . -name Request.pm -print It prints nothing. Is there supposed to be an Apache/Request.pm file somewhere? Apache complains that it can't find it on startup (I'm trying to use HTML::Mason). -- James Smith [EMAIL PROTECTED],

Re: Installing mod_perl 1.26 on solaris 2.7

2001-11-29 Thread Chris Winters
* James G Smith ([EMAIL PROTECTED]) [011129 14:11]: I have the 1.26 tarball untar'd and run the following command: % find . -name Request.pm -print It prints nothing. Is there supposed to be an Apache/Request.pm file somewhere? Apache complains that it can't find it on startup (I'm

Re: Installing mod_perl 1.26 on solaris 2.7

2001-11-29 Thread Jim Smith
On Thu, Nov 29, 2001 at 02:30:26PM -0500, Chris Winters wrote: * James G Smith ([EMAIL PROTECTED]) [011129 14:11]: I have the 1.26 tarball untar'd and run the following command: % find . -name Request.pm -print It prints nothing. Is there supposed to be an Apache/Request.pm file

Perl and Microsoft Excel?

2001-11-29 Thread Ian
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 In the wide and wonderful world of Microsoft and Linux, I'm in the need of an interesting soloution. I'm presenting this to the list because I've ran out of good ideas. The campus phone system has a 911 database that is in Microsoft Excel format,

Files problem, pulling my dam hair out

2001-11-29 Thread Chuck Carson
I have the following config: apache 1.3.22 with perl 1.26 built statically I want to use perl to dynamically generate html pages, so I have .pl files under DOCUMENT_ROOT. I have this config: Alias /perl /usr/local/apache/cgi-bin Directory /usr/local/apache/cgi-bin SetHandler

Re: Perl and Microsoft Excel?

2001-11-29 Thread Tom Servo
There's probably a far better answer to this than I can give, but if not, an interim solution might be having whoever maintains these Excel files save them as .csv files. Excel can do that, and while you lose all the fancy formatting, it just dumps them in a comma seperated list, then you can

Re: [OT] Perl and Microsoft Excel?

2001-11-29 Thread Ken Y. Clark
On Thu, 29 Nov 2001, Tom Servo wrote: Date: Thu, 29 Nov 2001 14:37:34 -0800 (PST) From: Tom Servo [EMAIL PROTECTED] To: Ian [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Perl and Microsoft Excel? There's probably a far better answer to this than I can give, but if not, an interim

Re: Perl and Microsoft Excel?

2001-11-29 Thread John Whitnack
Ian, I have never used it, but I have heard that Spreadsheet::ParseExcel is good at getting Excel file into a Perl script. If you every need to go the other way (Perl-Excel) i have used (and highly recommend) Spreadsheet::WriteExcel. Both of these can be found on CPAN. Ian wrote: The campus

Re: Perl and Microsoft Excel?

2001-11-29 Thread Mark Fowler
On Thu, 29 Nov 2001, Tom Servo wrote: Hopefully someone else knows of a CPAN module to work with Excel files, though... Spreadsheet::ParseExcel and Spreadsheet::WriteExcel? Both have ::Simple versions too. I've used them in the past and it's Worked For Me (tm) Later. Mark. -- s'' Mark

RE: Perl and Microsoft Excel?

2001-11-29 Thread Charles Day
If you couldn't convince the bosses to db this, you could use .cvs (tab delimited) instead of .xls, ftp it to your webserver every (cron) and have perl parse it out. People love their xls and access files don't they:) How about dumping the data into MS-SQL and have your db write the .xls file

OT: Re: Perl and Microsoft Excel?

2001-11-29 Thread ___cliff rayman___
fyi - this is off topic since it does not have anything to do with mod_perl in particular. you should really ask on: news://comp.lang.perl.modules or one of the other newsgroups: news://comp.lang.perl.moderated news://comp.lang.perl.misc or on this helpful website: http://www.perlmonks.org/

Re: Perl and Microsoft Excel?

2001-11-29 Thread David Kaufman
Tom Servo [EMAIL PROTECTED] wrote: On Thu, 29 Nov 2001, Ian wrote: The campus phone system has a 911 database that is in Microsoft Excel format, and they want to be able to take that information, and show it on a webpage, either via a search form, or in one big table. The problem is,

Re: Perl and Microsoft Excel?

2001-11-29 Thread Robin Berjon
On Thursday 29 November 2001 23:31, Ian wrote: In the wide and wonderful world of Microsoft and Linux, I'm in the need of an interesting soloution. The campus phone system has a 911 database that is in Microsoft Excel format, and they want to be able to take that information, and show it on

Re: Perl and Microsoft Excel?

2001-11-29 Thread Medi Montaseri
Two suggestions: One: drop the excel idea right now or you'll find out its not the right solution at a later time. Use LDAP instead. Then right a CGI (as you really don't need Mod-Perl) for all kinds of queries and an admin view for a maintainer to maintain it. Two: ask your spreadsheet

RE: Files problem, pulling my dam hair out

2001-11-29 Thread Chuck Carson
Where would this go? In the Directory section of the Files section? -Chuck -Original Message- From: Knox, Laurie A, NPONS [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 3:17 PM To: Chuck Carson; [EMAIL PROTECTED] Subject: RE: Files problem, pulling my dam hair out

RE: Files problem, pulling my dam hair out

2001-11-29 Thread Knox, Laurie A, NPONS
I have this in a Location, according to Apache you can have it in Directory and VirtualHost as well. (You could try it under Files, Apache will let you know if it doesn't like it :-) ). Laurie -Original Message- From: Chuck Carson [mailto:[EMAIL PROTECTED]] Sent: Thursday,

RE: Files problem, pulling my dam hair out

2001-11-29 Thread Chuck Carson
This is not working for me. Any chance you can mail your config? Also, is your mod_perl a DSO or bult statically. I have done this on at least 100 other servers in my time. What am I missing this time? Thanks, Chuck -Original Message- From: tom poe [mailto:[EMAIL PROTECTED]] Sent:

RE: Files problem, pulling my dam hair out

2001-11-29 Thread Kyle Oppenheim
Are you setting the content-type header correctly? You can add the correct content type a number of ways: - Adding DefaultType text/html to your httpd.conf - Using the AddType directive in httpd.conf to single out .pl files - Add .pl files to your mime types config file (pointed to by

Re: Files problem, pulling my dam hair out

2001-11-29 Thread Stas Bekman
Chuck Carson wrote: I have the following config: apache 1.3.22 with perl 1.26 built statically I want to use perl to dynamically generate html pages, so I have .pl files under DOCUMENT_ROOT. I have this config: Alias /perl /usr/local/apache/cgi-bin Directory

RE: :mysql and libmysqlclient.so.10

2001-11-29 Thread Ryan Thompson
William Rusch wrote to Ryan Thompson: I use oracle and with DBI I had a similiar problem. although I could run all the oracle client software without having to set this variable i had to set it when i connected through dbi,however this happened with standard cgi's as well. I usually set

SOLVED: DBD::mysql and libmysqlclient.so.10

2001-11-29 Thread Ryan Thompson
Ryan Thompson wrote to William Rusch: I HAVEN'T yet striven to recompile mod_perl, but I suspect that may be where I am headed next. mod_perl is compiled as a DSO, with APXS. OK, I figured it out myself this time. :-) I had tried to re-make mod_perl, which itself didn't solve the problem.