[otrs] Re: No Error in Debugger but Error in Apache

Mabuhay! I just want to share what i did to solve my DBD::Pg's error in Apache. So to some people with same cases as mine with machine FreeBSD-4.4, Apache-1.3.26, Postgresql-7.1 and recieves the following error when the script index.pl is run by the Apache server (note: /your/otrs/cgi-bin/index.pl has no error when ./ executed). I've been stucked into this problem for two days. Now, its okay! Software error: install_driver(Pg) failed: [Thu Sep 19 16:52:18 2002] index.pl: [Thu Sep 19 16:52:18 2002] index.pl: Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/Pg/Pg.so' for module DBD::Pg: Shared object "libpq.so.2" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. [Thu Sep 19 16:52:18 2002] index.pl: [Thu Sep 19 16:52:18 2002] index.pl: [Thu Sep 19 16:52:18 2002] index.pl: [Thu Sep 19 16:52:18 2002] index.pl: at (eval 124) line 3 Perhaps a required shared library or dll isn't installed where expected at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 67 To solve this problem, you can tell the Apache httpd.conf to include the environmental variable LD_LIBRARY_PATH= /usr/local/pgsql/lib. Put this line to httpd.conf and then restart: SetEnv LD_LIBRARY_PATH /usr/local/pgsql/lib Thanks Martin for your help and to all OTRS fan out there. Maraming Salamat Po! -Edwin ---------------------------------------------------------------------------- -------------------------------------- The essential thing is not the triumph but the struggle; The important thing is not to have conquered but to have fought well. Edwin D. Viñas http://www.geocities.com/edwin_vinas Science Research Specialist II Philippine Research Education and Government Information Network ---------------------------------------------------------------------------- -------------------------------------- ----- Original Message ----- From: "OTRS Team" To: "Edwin D.Viñas" Sent: Thursday, September 19, 2002 11:26 PM Subject: [Ticket#: 2002091910000891] Re: Re: No Error in Debugger but Error [...]

Mabuhay Edwin,

Edwin D. Viñas schrieb:

...

...

Can you try "cd /to/your/otrs/bin/cgi-bin/", "./index.pl" did you get html

...

output? Or the error message?

I got the correct HTML message. I know it working fine in the command line. No error.

...

Try "cd /to/your/otrs/bin/", "bin/CheckDB.pl" did you get "It looks

Ok!"?

Yah! I looks OK! noc# ./CheckDB.pl It looks Ok!noc#

...

What programs do you us on your machine with DBD::Pg?

Im using a netflow script called FlowSQL - a perl script. It is working. I remember same error when libpq.so is not found before i made FlowSQL script worked. I suspect the environmental variable is not found by the apache user when DBD::Pg is run. Am i correct?

Yeah. If the perl programmes are working on the command line but not with the apache, then it could be. ;-)

Do you remember what you have changed for FlowSQL? If it's just an environment variable, put this into your apache startup script.

The startup (start/stop) script is normally a shell script. If you put something like:

[...] export YOURVARIABLE="/path/to/success" [...]

And the httpd should have this YOURVARIABLE on the next startup.

Is it working now? :-)

PS0: I never have used BSD. But one time I install it. :))

PS1: If it's possible to get a shell account on this machine, then I can help. (Just in case)

...

...

...

Edwin

Martin

-- OTRS Team Mailbox - Manage your communication! Web: http://otrs.org/ - Lists: http://lists.otrs.org/