Re: [EMAIL PROTECTED] perl and mysql issue

2006-12-13 Thread Issac Goldstand
You *could* use the SetEnv directive in httpd.conf to set Apache's environment variables. However, there's a better solution: I'm not sure how it works on Solaris, but on Linux, you can edit the file /etc/ld.so.conf and add /usr/local/mysql/lib/mysql to it. Once it's added run /sbin/ldconfig (op

Re: [EMAIL PROTECTED] perl and mysql issue

2006-12-13 Thread Jim Goh
Issac, Thanks for your quick reply. This installation are all new in my server. I can run the script as any user as long as I set the LD_LIBRARY_PATH to /usr/local/mysql/lib/mysql path, w/o this LD set, i got same error as show up on the web site. So I am not sure how to set the LD

Re: [EMAIL PROTECTED] perl and mysql issue

2006-12-13 Thread Issac Goldstand
It looks like your MySQL client library isn't installed properly, or else require some special odd permissions. Did you recently change anything in your server MySQL setup? Can you run the Perl script on the server as the same user Apache runs as? Finally, just to be absolutely sure - when you say

[EMAIL PROTECTED] perl and mysql issue

2006-12-13 Thread Jim Goh
Hi, I have perl 5.6.1 and mysql 5.0.24 installed and the following perl script works fine from command line, but not working when I run from the IE browser: #!/usr/local/bin/perl use DBI; use CGI qw(:standard); use CGI::Carp 'fatalsToBrowser'; use strict; print header; print st