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

[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. What happened, however, was I messed up the order of the
dependencies. I had installed Mysql prior to installing mod_perl,
which, apparently, was the wrong thing to do. I deinstalled Mysql
(thanks to the FreeBSD ports collection ;-) and then did "make
reinstall", which apparently knocked things back to where they 
should be, with mod_perl.

Strange, but true! ;-)

Thanks for the help,
- Ryan

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

RE: :mysql and libmysqlclient.so.10

[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 it in my connection subroutine ie..
> $ENV{'LD_LIBRARY_PATH'} = '/path to library';
> $dbh = DBI->connect(..);
> 
> I use true64 and linux so I'm not even positive that the
> LD_LIBRARY_PATH is the right environment variable for freebsd. But
> if it is, it's worth trying.
> 
> maybe the ld_library_path got altered on the mod_perl
> compilation wouldn't really have a clue beyond that.

Hi William (and everyone else who has replied),

Thanks for the replies. I have tried all of the suggestions that you
and others have recommended (including some ideas of my own). So far,
I'm still stuck at the same place I was when this all started
yesterday ;-)

Here is what I have tried so far, to sum things up:

Running ldconfig -R to make sure libmysqlclient.so.10 is in the list
$ENV{'LD_LIBRARY_PATH'} = '/usr/local/lib/mysql',  or
$ENV{'LD_LIBRARY_PATH'} = '/usr/local/lib/mysql/'
PerlSetEnv  LD_LIBRARY_PATH /usr/local/lib/mysql

Checked library locations, file permissions, configuration, etc from a
working installation on FreeBSD 3.5 with mod_perl 1.25. (No
differences found, except the FreeBSD 3.5 box uses an older version of
libmysqlclient.so).


And then full restart Apache (apachectl stop && apachectl start) after
trying each one of these.

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.

- Ryan

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

Re: problem, pulling my dam hair out

[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
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options +ExecCGI
> 
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options ExecCGI
> 
>  
> Whenever I try and get a perl script from a web browser, it pops up a
> dialog asking to save the damn file. I have tried Netscape 4.79 on NT
> and Unix as well as IE 5.5. I have configured a server in this manner
> probably 100 times, I cannot find what I a missing this particuliar
> time.
>  
>  
> Anyone have any ideas?

let the guide be with you:
http://perl.apache.org/guide/config.html#My_Script_Works_under_mod_cgi_b

PerlSendHeader On
is missing if you use CORE::print() to send headers

_
Stas Bekman JAm_pH  --   Just Another mod_perl Hacker
http://stason.org/  mod_perl Guide   http://perl.apache.org/guide
mailto:[EMAIL PROTECTED]  http://ticketmaster.com http://apacheweek.com
http://singlesheaven.com http://perl.apache.org http://perlmonth.com/

RE: problem, pulling my dam hair out

[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 TypesConfig)
- Set it dynamically from your scripts using $r->content_type('text/html')

- Kyle

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Chuck Carson
> Sent: Thursday, November 29, 2001 2:38 PM
> To: [EMAIL PROTECTED]
> Subject:  problem, pulling my dam hair out
>
>
>
> 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
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options +ExecCGI
> 
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options ExecCGI
> 
>
> Whenever I try and get a perl script from a web browser, it pops up a
> dialog asking to save the damn file. I have tried Netscape 4.79 on NT
> and Unix as well as IE 5.5. I have configured a server in this manner
> probably 100 times, I cannot find what I a missing this particuliar
> time.
>
>
> Anyone have any ideas?
>
> Thanks,
> Chuck
>
>
> Chuck Carson
> Systems Administrator
> [EMAIL PROTECTED] 
> 858.202.4188 Office
> 858.442.0827 Mobile
> 858.623.0460 Fax
>
>
>

RE: problem, pulling my dam hair out

[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: Thursday, November 29, 2001 3:29 PM
To: Chuck Carson; [EMAIL PROTECTED]
Subject: Re:  problem, pulling my dam hair out


On Thursday 29 November 2001 14:37, 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
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options +ExecCGI
> 
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options ExecCGI
> 
>
> Whenever I try and get a perl script from a web browser, it pops up a 
> dialog asking to save the damn file. I have tried Netscape 4.79 on NT 
> and Unix as well as IE 5.5. I have configured a server in this manner 
> probably 100 times, I cannot find what I a missing this particuliar 
> time.
>
>
> Anyone have any ideas?
>
> Thanks,
> Chuck

Hi, Chuck:  For starters, is the line above correct:
> Alias /perl /usr/local/apache/cgi-bin

or should you use:  Alias /perl/   /usr/local/apache/cgi-bin/

The other thing you might check in that area, is a line that says
something 
like:
 AddHandler cgi-script .pl .cgi  

I'm running SuSE7.1, and Apache1.3.14 with a documentRoot of 
/usr/local/httpd/htdocs/

hth   tom

RE: problem, pulling my dam hair out

[Knox, Laurie A, NPONS]

I have this in a , according to Apache you can have
it in  and  as well.
(You could try it under , Apache will let you know if
it doesn't like it :-)   ).

Laurie

-Original Message-
From: Chuck Carson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 6:23 PM
To: Knox, Laurie A, NPONS; [EMAIL PROTECTED]
Subject: RE:  problem, pulling my dam hair out




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:  problem, pulling my dam hair out



The only difference I can see with your setup is the following
additional
line:

AddHandler perl-script .pl

HTH,

Laurie

Laurie Knox
AT&T - NETAC
[EMAIL PROTECTED]


-Original Message-
From: Chuck Carson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 5:38 PM
To: [EMAIL PROTECTED]
Subject:  problem, pulling my dam hair out


 
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

SetHandler perl-script
PerlHandler Apache::Registry
Options +ExecCGI


SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI

 
Whenever I try and get a perl script from a web browser, it pops up a
dialog asking to save the damn file. I have tried Netscape 4.79 on NT
and Unix as well as IE 5.5. I have configured a server in this manner
probably 100 times, I cannot find what I a missing this particuliar
time.
 
 
Anyone have any ideas?
 
Thanks,
Chuck
 
 
Chuck Carson
Systems Administrator
[EMAIL PROTECTED]  
858.202.4188 Office
858.442.0827 Mobile
858.623.0460 Fax
 
 

Re: problem, pulling my dam hair out

[tom poe]

On Thursday 29 November 2001 14:37, 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
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options +ExecCGI
> 
> 
> SetHandler perl-script
> PerlHandler Apache::Registry
> Options ExecCGI
> 
>
> Whenever I try and get a perl script from a web browser, it pops up a
> dialog asking to save the damn file. I have tried Netscape 4.79 on NT
> and Unix as well as IE 5.5. I have configured a server in this manner
> probably 100 times, I cannot find what I a missing this particuliar
> time.
>
>
> Anyone have any ideas?
>
> Thanks,
> Chuck

Hi, Chuck:  For starters, is the line above correct:
> Alias /perl /usr/local/apache/cgi-bin

or should you use:  Alias /perl/   /usr/local/apache/cgi-bin/

The other thing you might check in that area, is a line that says something 
like:
 AddHandler cgi-script .pl .cgi  

I'm running SuSE7.1, and Apache1.3.14 with a documentRoot of 
/usr/local/httpd/htdocs/

hth   tom

RE: problem, pulling my dam hair out

[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:  problem, pulling my dam hair out



The only difference I can see with your setup is the following
additional
line:

AddHandler perl-script .pl

HTH,

Laurie

Laurie Knox
AT&T - NETAC
[EMAIL PROTECTED]


-Original Message-
From: Chuck Carson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 5:38 PM
To: [EMAIL PROTECTED]
Subject:  problem, pulling my dam hair out


 
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

SetHandler perl-script
PerlHandler Apache::Registry
Options +ExecCGI


SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI

 
Whenever I try and get a perl script from a web browser, it pops up a
dialog asking to save the damn file. I have tried Netscape 4.79 on NT
and Unix as well as IE 5.5. I have configured a server in this manner
probably 100 times, I cannot find what I a missing this particuliar
time.
 
 
Anyone have any ideas?
 
Thanks,
Chuck
 
 
Chuck Carson
Systems Administrator
[EMAIL PROTECTED]  
858.202.4188 Office
858.442.0827 Mobile
858.623.0460 Fax
 
 

RE: problem, pulling my dam hair out

[Knox, Laurie A, NPONS]

The only difference I can see with your setup is the following additional
line:

AddHandler perl-script .pl

HTH,

Laurie

Laurie Knox
AT&T - NETAC
[EMAIL PROTECTED]


-Original Message-
From: Chuck Carson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 5:38 PM
To: [EMAIL PROTECTED]
Subject:  problem, pulling my dam hair out


 
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

SetHandler perl-script
PerlHandler Apache::Registry
Options +ExecCGI


SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI

 
Whenever I try and get a perl script from a web browser, it pops up a
dialog asking to save the damn file. I have tried Netscape 4.79 on NT
and Unix as well as IE 5.5. I have configured a server in this manner
probably 100 times, I cannot find what I a missing this particuliar
time.
 
 
Anyone have any ideas?
 
Thanks,
Chuck
 
 
Chuck Carson
Systems Administrator
[EMAIL PROTECTED]  
858.202.4188 Office
858.442.0827 Mobile
858.623.0460 Fax
 
 

Re: Perl and Microsoft Excel?

[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 maintainer to save the sheet in CSV (Comma
Seperated Value) format someplace where a CGI can access it. Say

www:/home/directory/list.csv

Then use Samba and on the maintainer's windows machine have a network
mapped drive, where this file will be saved as, say z:\list.csv, where
z: is mapped to \\www\directory

Then use Text::CSV.pm perl package to access this list.csv

You are donego home now..

PS: you might have to convert the '\r\n' to '\n' as samba does not
change the line break symbols as it moves it from Windows to Unix.

Cheers...

On Thu, 29 Nov 2001, Ian wrote:

>  
> -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, 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, they want to do it dynamically...the web server needs to
> yank it down from a samba share (or ftp), parse it, show it, and
> terminate.  
> 
> I'm really **really** new at anything perl wise...so I haven't the
> foggiest clue as to where I should start.  
> 
> I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
> properly.  Are there any modules for pulling information from an
> excel sheet?  How about modules that keep the overworked admin from
> insanity?
> 
> Ian
> 
> 
> - 
> - From RFC 1925: "(3)  With sufficient thrust, pigs fly just fine.
> However, this is not necessarily a good idea. It is hard to be sure
> where they are going to land, and it could be dangerous sitting under
> them as they fly overhead."
> 
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 7.0.3 for non-commercial use 
> 
> iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q
> 0vwYEFLgdzsz4Dfu98dUJzBy
> =Qs9B
> -END PGP SIGNATURE-
> 
> 

-- 
-
Medi Montaseri   [EMAIL PROTECTED]
Unix Distributed Systems EngineerHTTP://www.CyberShell.com
CyberShell Engineering
-

Re: Perl and Microsoft Excel?

[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 a webpage, either via a search form, or in one big table.  The
> problem is, they want to do it dynamically...the web server needs to
> yank it down from a samba share (or ftp), parse it, show it, and
> terminate.

Another option than those that have been presented here would be to use 
XML::SAXDriver::Excel. It is imho superior to using some of the modules that 
parse Excel directly because it is SAX based. That means that you have a lot 
more power in your hands, and that if your data source move to something else 
(eg CSV, database, etc...) you'll be able to use nearly the same code. 
Furthermore, SAX is a simple, flexible, well-thought out, and well-documented 
API.

-- 
___
Robin Berjon <[EMAIL PROTECTED]> -- CTO
k n o w s c a p e : // venture knowledge agency www.knowscape.com
---
Paranoids are people, too; they have their own problems.  It's easy
to criticize, but if everybody hated you, you'd be paranoid too.

Re: Perl and Microsoft Excel?

[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, they want to do it dynamically...the web server needs to
> > yank it down from a samba share (or ftp), parse it, show it, and
> > terminate.
>
> [...]
> Hopefully someone else knows of a CPAN module to work with Excel files,
> though...

i count at least 5:
http://search.cpan.org/search?mode=module&query=Excel

i haven't used any of them, though.  i've used Spreadsheet::WriteExcel, but
it only *writes* Excel files, it doesn't read them (hence the name).

it looks like
Spreadsheet::ParseExcel
http://search.cpan.org/search?dist=Spreadsheet-ParseExcel

or Spreadsheet::ParseExcel::Simple
http://search.cpan.org/search?dist=Spreadsheet-ParseExcel-Simple

should do what you're looking for

hth,

-dave

OT: Re: Perl and Microsoft Excel?

[___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/

when you ask a question like "are there any modules", think
http://search.cpan.org/

one of the best things about perl, is this site and the well organized
set of modules that exist on it.

a simple search for 'excel' brought up this likely candidate for your use:
http://search.cpan.org/doc/KWITKNR/Spreadsheet-ParseExcel-0.2403/ParseExcel.pm

good luck and enjoy perl!
cliff

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, they want to do it dynamically...the web server needs to
> yank it down from a samba share (or ftp), parse it, show it, and
> terminate.
>
> I'm really **really** new at anything perl wise...so I haven't the
> foggiest clue as to where I should start.
>
> I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
> properly.  Are there any modules for pulling information from an
> excel sheet?  How about modules that keep the overworked admin from
> insanity?

--
___cliff [EMAIL PROTECTED]http://www.genwax.com/

RE: Perl and Microsoft Excel?

[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
every (schedule).  Then you can query your db any way you like from your
website, and they can have their nice little xls file too:)

Charles



-Original Message-
From: Ian [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 5:31 PM
To: [EMAIL PROTECTED]
Subject: Perl and Microsoft Excel?
Sensitivity: Private


 
-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, 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, they want to do it dynamically...the web server needs to
yank it down from a samba share (or ftp), parse it, show it, and
terminate.  

I'm really **really** new at anything perl wise...so I haven't the
foggiest clue as to where I should start.  

I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
properly.  Are there any modules for pulling information from an
excel sheet?  How about modules that keep the overworked admin from
insanity?

Ian


- 
- From RFC 1925: "(3)  With sufficient thrust, pigs fly just fine.
However, this is not necessarily a good idea. It is hard to be sure
where they are going to land, and it could be dangerous sitting under
them as they fly overhead."


-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q
0vwYEFLgdzsz4Dfu98dUJzBy
=Qs9B
-END PGP SIGNATURE-

Re: Perl and Microsoft Excel?

[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 Fowler London.pm   Bath.pm
 http://www.twoshortplanks.com/  [EMAIL PROTECTED]
';use Term'Cap;$t=Tgetent Term'Cap{};print$t->Tputs(cl);for$w(split/  +/
){for(0..30){$|=print$t->Tgoto(cm,$_,$y)." $w";select$k,$k,$k,.03}$y+=2}

Re: Perl and Microsoft Excel?

[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 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, they want to do it dynamically...the web server needs to
> yank it down from a samba share (or ftp), parse it, show it, and
> terminate.
> 

John Whitnack

Re: [OT] Perl and Microsoft Excel?

[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 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 split on commas to get the values out of it.
>
> Hopefully someone else knows of a CPAN module to work with Excel files,
> though...
>
> 
> Brian Nilsen
> [EMAIL PROTECTED]

Here's a sampling:

http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?search=excel&new=Search&filetype=+distribution+name+or+description&join=and&arrange=file&download=auto&stem=no&case=clike&site=ftp.funet.fi&age=

ky

>
> On Thu, 29 Nov 2001, Ian wrote:
>
> >
> > -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, 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, they want to do it dynamically...the web server needs to
> > yank it down from a samba share (or ftp), parse it, show it, and
> > terminate.
> >
> > I'm really **really** new at anything perl wise...so I haven't the
> > foggiest clue as to where I should start.
> >
> > I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
> > properly.  Are there any modules for pulling information from an
> > excel sheet?  How about modules that keep the overworked admin from
> > insanity?
> >
> > Ian
> >
> >
> > - 
> > - From RFC 1925: "(3)  With sufficient thrust, pigs fly just fine.
> > However, this is not necessarily a good idea. It is hard to be sure
> > where they are going to land, and it could be dangerous sitting under
> > them as they fly overhead."
> >
> >
> > -BEGIN PGP SIGNATURE-
> > Version: PGPfreeware 7.0.3 for non-commercial use 
> >
> > iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q
> > 0vwYEFLgdzsz4Dfu98dUJzBy
> > =Qs9B
> > -END PGP SIGNATURE-
> >
> >

Re: Perl and Microsoft Excel?

[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 split on commas to get the values out of it.

Hopefully someone else knows of a CPAN module to work with Excel files,
though...


Brian Nilsen
[EMAIL PROTECTED]

On Thu, 29 Nov 2001, Ian wrote:

>  
> -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, 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, they want to do it dynamically...the web server needs to
> yank it down from a samba share (or ftp), parse it, show it, and
> terminate.  
> 
> I'm really **really** new at anything perl wise...so I haven't the
> foggiest clue as to where I should start.  
> 
> I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
> properly.  Are there any modules for pulling information from an
> excel sheet?  How about modules that keep the overworked admin from
> insanity?
> 
> Ian
> 
> 
> - 
> - From RFC 1925: "(3)  With sufficient thrust, pigs fly just fine.
> However, this is not necessarily a good idea. It is hard to be sure
> where they are going to land, and it could be dangerous sitting under
> them as they fly overhead."
> 
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 7.0.3 for non-commercial use 
> 
> iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q
> 0vwYEFLgdzsz4Dfu98dUJzBy
> =Qs9B
> -END PGP SIGNATURE-
> 
> 

problem, pulling my dam hair out

[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

SetHandler perl-script
PerlHandler Apache::Registry
Options +ExecCGI


SetHandler perl-script
PerlHandler Apache::Registry
Options ExecCGI

 
Whenever I try and get a perl script from a web browser, it pops up a
dialog asking to save the damn file. I have tried Netscape 4.79 on NT
and Unix as well as IE 5.5. I have configured a server in this manner
probably 100 times, I cannot find what I a missing this particuliar
time.
 
 
Anyone have any ideas?
 
Thanks,
Chuck
 
 
Chuck Carson
Systems Administrator
[EMAIL PROTECTED]  
858.202.4188 Office
858.442.0827 Mobile
858.623.0460 Fax
 
 

Perl and Microsoft Excel?

[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, 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, they want to do it dynamically...the web server needs to
yank it down from a samba share (or ftp), parse it, show it, and
terminate.  

I'm really **really** new at anything perl wise...so I haven't the
foggiest clue as to where I should start.  

I've finally gotten Apache/Mod Perl/Mod SSL installed, and working
properly.  Are there any modules for pulling information from an
excel sheet?  How about modules that keep the overworked admin from
insanity?

Ian


- 
- From RFC 1925: "(3)  With sufficient thrust, pigs fly just fine.
However, this is not necessarily a good idea. It is hard to be sure
where they are going to land, and it could be dangerous sitting under
them as they fly overhead."


-BEGIN PGP SIGNATURE-
Version: PGPfreeware 7.0.3 for non-commercial use 

iQA/AwUBPAa3NHRiiq+WL4fKEQKsRACgutpROPjPllax3Nvfat2R7YERlSQAn35Q
0vwYEFLgdzsz4Dfu98dUJzBy
=Qs9B
-END PGP SIGNATURE-

Re: Installing mod_perl 1.26 on solaris 2.7

[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
> > somewhere?  Apache complains that it can't find it on startup (I'm trying
> > to use HTML::Mason).
> 
> Apache::Request is a separate package -- IIRC you can install it from
> CPAN no problem.

I should have known that.  Missed it somewhere or forgot about it :/

Thanks.

--jim

Re: Installing mod_perl 1.26 on solaris 2.7

[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 trying
> to use HTML::Mason).

Apache::Request is a separate package -- IIRC you can install it from
CPAN no problem.

Chris

-- 
Chris Winters ([EMAIL PROTECTED])
Building enterprise-capable snack solutions since 1988.

Installing mod_perl 1.26 on solaris 2.7

[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]>, 979-862-3725
Texas A&M CIS Operating Systems Group, Unix

RE: :mysql and libmysqlclient.so.10

[Wilt, Paul]

Don't you need to add a PerlPassEnv LD_LIBRARY_PATH for this to work?

Paul E Wilt 
Principal Software Engineer



__
XanEdu, Inc. (division of Proquest Information and Learning)
http://www.xanedu.com  mailto:[EMAIL PROTECTED] 
300 North Zeeb Rd  Phone: (734) 302-6545  (800) 218-5971 x6545
Ann Arbor, MI 48106Fax:   (734) 975-6440



__



-Original Message-
From: Ryan Thompson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, November 29, 2001 12:41 PM
To: William Rusch
Cc: [EMAIL PROTECTED]
Subject: RE: :mysql and libmysqlclient.so.10


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 169.
> >
> > libmysqlclient.so.10 DOES exist, and has been successfully
> > configured with ldconfig. And, scripts NOT running under mod_perl
> > can use Mysql without a problem.
>
> 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.

Just to clarify... this library IS configured with ldconfig... so,
unless I'm mistaken (which is quite possible :-), wouldn't setting
LD_LIBRARY_PATH be unnecessary? If I'm wrong, where is the best place
to set LD_LIBRARY_PATH?

# ldconfig -r | grep mysql
search directories: /usr/lib:/usr/lib/compat:/usr/local/lib:
/usr/local/lib/mysql
69:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10

libmysqlclient.so.10 exists in the above location, has all appropriate
permissions, no write bits set on it, or the parent directory, and it
WORKS with the mysql client utilities (or do they link it
statically?).

The same scripts ALSO work in plain CGI directories not using
mod_perl, which is one of the main reasons I'm asking on this list ;-)

Thanks,
- Ryan

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

RE: :mysql and libmysqlclient.so.10

[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..
$ENV{'LD_LIBRARY_PATH'} = '/path to library';
$dbh = DBI->connect(..);

I use true64 and linux so I'm not even positive that the LD_LIBRARY_PATH is
the right environment variable for freebsd. But if it is, it's worth trying.

maybe the ld_library_path got altered on the mod_perl compilation
wouldn't really have a clue beyond that.

-Original Message-
From: Ryan Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 12:41 PM
To: William Rusch
Cc: [EMAIL PROTECTED]
Subject: RE: :mysql and libmysqlclient.so.10


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 169.
> >
> > libmysqlclient.so.10 DOES exist, and has been successfully
> > configured with ldconfig. And, scripts NOT running under mod_perl
> > can use Mysql without a problem.
>
> 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.

Just to clarify... this library IS configured with ldconfig... so,
unless I'm mistaken (which is quite possible :-), wouldn't setting
LD_LIBRARY_PATH be unnecessary? If I'm wrong, where is the best place
to set LD_LIBRARY_PATH?

# ldconfig -r | grep mysql
search directories: /usr/lib:/usr/lib/compat:/usr/local/lib:
/usr/local/lib/mysql
69:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10

libmysqlclient.so.10 exists in the above location, has all appropriate
permissions, no write bits set on it, or the parent directory, and it
WORKS with the mysql client utilities (or do they link it
statically?).

The same scripts ALSO work in plain CGI directories not using
mod_perl, which is one of the main reasons I'm asking on this list ;-)

Thanks,
- Ryan

--
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

RE: :mysql and libmysqlclient.so.10

[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 169.
> >
> > libmysqlclient.so.10 DOES exist, and has been successfully
> > configured with ldconfig. And, scripts NOT running under mod_perl
> > can use Mysql without a problem.
>
> 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.

Just to clarify... this library IS configured with ldconfig... so,
unless I'm mistaken (which is quite possible :-), wouldn't setting
LD_LIBRARY_PATH be unnecessary? If I'm wrong, where is the best place
to set LD_LIBRARY_PATH?

# ldconfig -r | grep mysql
search directories: /usr/lib:/usr/lib/compat:/usr/local/lib:
/usr/local/lib/mysql
69:-lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10

libmysqlclient.so.10 exists in the above location, has all appropriate
permissions, no write bits set on it, or the parent directory, and it
WORKS with the mysql client utilities (or do they link it
statically?).

The same scripts ALSO work in plain CGI directories not using
mod_perl, which is one of the main reasons I'm asking on this list ;-)

Thanks,
- Ryan

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

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

[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 /usr/libdata/perl/5.00503/Dynaloader.pm line 169.
> > 
> > libmysqlclient.so.10 DOES exist, [snip]
> 
> Just a shot in the dark...
> 
> Are you getting any core dumps/segfaults?  

Nope. Nothing is dumping core. In fact, the ONLY error reported in the
Apache logs is the one quoted, above. (Then, of course, there are
several other errors as it goes up the call stack to my script itself,
where it dies, and I get a 500 error in the browser). If the httpd
process dumped core this early, I would expect to see "Document
contained no data".

Thanks,
- Ryan

> If you check the Dynaloader docs I think you'll find that this
> message sometimes appears if the code called by it fails.
> 
> You might be better asking at a DBI list.
> 
> 73,
> Ged.
> 
> 

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

RE: :mysql and libmysqlclient.so.10

[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, November 29, 2001 4:43 AM
To: [EMAIL PROTECTED]
Subject: DBD::mysql and libmysqlclient.so.10



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 mod_perl, it seems), I receive
the following error (lines wrapped, here) in my apache log, and the
execution fails:

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 exist, and has been successfully configured
with ldconfig. And, scripts NOT running under mod_perl can use Mysql
without a problem.

I expect this may be a FAQ, and I swear I've run across this before,
but haven't had any luck grepping my notes.

Help? :-)

Thanks,
- Ryan

--
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America

RE: Why libperl.so?

[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
perl in dynamically.

-Original Message-
From: BeerBong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 12:03 AM
To: William Rusch; mod-perl
Subject: Re: Why libperl.so?


Sorry, it is necessary for mod_perl now ?
I want to compile statically as many modules as I can.
 ---
Sergey "BeerBong" Polyakov
chief of WebZavod (http://www.webzavod.ru)


> try recompiling perl with
> sh Configure -Duseshrplib
>
> this will build the libperl.so file that apache needs
>
> -Original Message-
> From: BeerBong [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 28, 2001 12:31 PM
> To: mod-perl
> Subject: Why libperl.so?
>
>
> Hello!
>
> It may be very stupid problem, but I stuck - hard day.
>
> I installed Perl.
> Perl 5.6.1 with all default options on Debian Linux 2.4.13  - btw, it is a
> another problem, but 4 make test for Perl FAILED lib/dirhand and other, I
> found that kernerl 2.4.x is responsible for it, but didn't find how to
> resolve the problem.
> Also, I decided to renew other soft.
> upgrade kernel to 2.5.16.
> mod_perl 1.5.26 and apache 1.3.22
> String for mod_perl is the same as earlier
> --
> perl Makefile.PL APACHE_SRC=../apache_1.3.22/src \
>  DO_HTTPD=1 USE_APACI=1 PERL_MARK_WHERE=1 EVERYTHING=1
> --
> when make
> --
> ===> src/main
>
cc -c -I.. -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -I../os/unix -I../in
>
clude   -DLINUX=22 -DMOD_PERL -DUSE_PERL_SSI -fno-strict-aliasing -I/usr/loc
> al/include  -DUSE_HSREGEX -DNO_DL_NEEDED -DPERL_MARK_WHERE=1 `../apaci`
> gen_test_char.c
>
cc  -DLINUX=22 -DMOD_PERL -DUSE_PERL_SSI -fno-strict-aliasing -I/usr/local/i
> nclude  -DUSE_HSREGEX -DNO_DL_NEEDED -DPERL_MARK_WHERE=1 `../apaci`   -o
> gen_test_char gen_test_char.o  -lm -lcrypt -rdynamic  -L/usr/local/lib
>
/usr/local/lib/perl5/5.6.1/i686-linux/auto/DynaLoader/DynaLoader.a -L/usr/lo
>
cal/lib/perl5/5.6.1/i686-linux/CORE -lperl -lnsl -ldl -lm -lc -lposix -lcryp
> t -lutil
> ./gen_test_char >test_char.h
> ./gen_test_char: error in loading shared libraries: libperl.so: cannot
open
> shared object file: No such file or directory
> make[4]: *** [test_char.h] Error 127
> --
> Why libperl.so ? I want statically linked mod_perl.
>
> Perl ENV
> --
> Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
>   Platform:
> osname=linux, osvers=2.4.13, archname=i686-linux
> uname='linux warzavod 2.4.13 #1 wed oct 31 18:17:06 samt 2001 i686
> unknown '
> config_args='-d'
> hint=recommended, useposix=true, d_sigaction=define
> usethreads=undef use5005threads=undef useithreads=undef
> usemultiplicity=undef
> useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
>   Compiler:
> cc='cc', ccflags
>
='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFS
> ET_BITS=64',
> optimize='-O2',
> cppflags='-fno-strict-aliasing -I/usr/local/include'
> ccversion='', gccversion='2.95.2 2220 (Debian GNU/Linux)',
> gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=4, usemymalloc=n, prototype=define
>   Linker and Libraries:
> ld='cc', ldflags =' -L/usr/local/lib'
> libpth=/usr/local/lib /lib /usr/lib
> libs=-lnsl -lndbm -ldb -ldl -lm -lc -lposix -lcrypt -lutil
> perllibs=-lnsl -ldl -lm -lc -lposix -lcrypt -lutil
> libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
>   Dynamic Linking:
> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
> cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
>
>
> Characteristics of this binary (from libperl):
>   Compile-time options: USE_LARGE_FILES
>   Built under linux
>   Compiled at Nov 28 2001 11:57:27
>   @INC:
> /usr/local/lib/perl5/5.6.1/i686-linux
> /usr/local/lib/perl5/5.6.1
> /usr/local/lib/perl5/site_perl/5.6.1/i686-linux
> /usr/local/lib/perl5/site_perl/5.6.1
> /usr/local/lib/perl5/site_perl
> .
> --
>
> Thanx in advance...
>
>  ---
> Sergey "BeerBong" Polyakov
> chief of WebZavod (http://www.webzavod.ru)
>
>
>
>

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

[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 exist, [snip]

Just a shot in the dark...

Are you getting any core dumps/segfaults?  If you check the Dynaloader
docs I think you'll find that this message sometimes appears if the code
called by it fails.

You might be better asking at a DBI list.

73,
Ged.

[ANNOUNCE] OpenInteract 1.35

[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 format and many changes to the server
configuration.

The new packages are 'object_activity' and 'base_page'. The first
enables search and display of the object logging activity. The second
replaces the 'static_page' package with support for uploads, aliases,
and (crude but working) URL support.

As always, the many other modifications in this release are listed in
the Changelog (URL below).

URLs:

Download the source (also making the CPAN rounds):

 http://sourceforge.net/project/shownotes.php?release_id=63337

Release notes/changelog (much more detailed than above):

 http://sourceforge.net/project/shownotes.php?release_id=63337

Sourceforge home (mailing lists, CVS, bugs, etc.):

 http://sourceforge.net/projects/openinteract/

Other home:

 http://www.openinteract.org/

Thanks!

Chris

-- 
Chris Winters ([EMAIL PROTECTED])
Building enterprise-capable snack solutions since 1988.

Re: Doing Authorization using mod_perl from a programmers perspective

[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 HTTP_USER_AGENT field deliniate between
> PC's?

I've been out of town and am coming at this thread late.  In case
nobody else has mentioned it, HTTP_USER_AGENT values are 1) non-
unique, and 2) often shared by applications on a single host (true
especially for Microsoft environments).

-- 

Richard Goerwitz   [EMAIL PROTECTED]
tel: 401 438 8978

DBD::mysql and libmysqlclient.so.10

[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 mod_perl, it seems), I receive
the following error (lines wrapped, here) in my apache log, and the
execution fails:

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 exist, and has been successfully configured
with ldconfig. And, scripts NOT running under mod_perl can use Mysql
without a problem.

I expect this may be a FAQ, and I swear I've run across this before,
but haven't had any luck grepping my notes.

Help? :-)

Thanks,
- Ryan

-- 
  Ryan Thompson <[EMAIL PROTECTED]>
  Network Administrator, Accounts

  SaskNow Technologies - http://www.sasknow.com
  #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2

Tel: 306-664-3600   Fax: 306-664-1161   Saskatoon
  Toll-Free: 877-727-5669 (877-SASKNOW) North America