Gossamer Forum
Home : Products : DBMan SQL : Discussion :

mod_perl error

Quote Reply
mod_perl error
hi,

can anyone help me setting up DBManSQL under mod perl.

I get always the following error:




[Tue Jan 7 11:02:54 2003] [error] Can't locate DBMan/mod_perl.pm in @INC (@INC contains: /.../.../cgi-bin/.../admin /../.../cgi-bin/.../admin /.../.../cgi-bin/.../admin ../.. /.../.../cgi-bin/.../admin /usr/lib/perl5/5.6.1/i386-linux /.../.../perl5/5.6.1 /.../.../perl5/site_perl/5.6.1/i386-linux /.../.../perl5/site_perl/5.6.1 /.../.../perl5/site_perl/5.6.0/i386-linux /.../.../perl5/site_perl/5.6.0 /.../.../perl5/site_perl /.../.../perl5/vendor_perl/5.6.1/i386-linux /.../.../perl5/vendor_perl/5.6.1 /.../.../perl5/vendor_perl . /.../httpd/ /.../httpd/lib/perl) at /../.../cgi-bin/startup.pl line 11.
Jan 7 11:02:54 httpd: BEGIN failed--compilation aborted at /.../.../cgi-bin/startup.pl line 11.
Jan 7 11:02:54 httpd: Compilation failed in require at (eval 1) line 1.
Jan 7 11:02:54 httpd:
Jan 7 11:02:54 httpd: Syntax error on line 882 of /.../.../.../httpd.conf:
Jan 7 11:02:54 httpd: Can't locate DBMan/mod_perl.pm in @INC (@INC contains: /../.../cgi-bin/.../admin /.../.../cgi-bin/.../admin /.../..../cgi-bin/.../admin ../.. /.../.../cgi-bin/..../admin /.../.../perl5/5.6.1/i386-linux /.../.../perl5/5.6.1 /.../.../perl5/site_perl/5.6.1/i386-linux /.../.../perl5/site_perl/5.6.1 /.../.../perl5/site_perl/5.6.0/i386-linux /.../.../perl5/site_perl/5.6.0 /.../.../perl5/site_perl /usr/lib/perl5/vendor_perl/5.6.1/i386-linux /../.../perl5/vendor_perl/5.6.1 /.../.../perl5/vendor_perl . /.../httpd/ /.../httpd/lib/perl) at /.../.../cgi-bin/startup.pl line 11.
Jan 7 11:02:54 httpd: BEGIN failed--compilation aborted at /.../.../cgi-bin/startup.pl line 11.
Jan 7 11:02:54 httpd: Compilation failed in require at (eval 1) line 1.




I think the problem is, that there is no directory /DBMan/ in the /admin/-directory. In my installation this is called Dbsql. And there is als the mod_perl.pm

( .../admin/Dbsql/mod_perl.pm AND NOT .../admin/DBMan/mod_perl.pm)

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] mod_perl error In reply to
Hi,

Yes, this is a typo in Dbsql README.modperl file. Could you just change the line in your startup.pl from
use DBMan::mod_perl;
to
use Dbsql::mod_perl;

Thanx for the information ,
Cheers,
Jean
Gossamer Threads Inc.
Quote Reply
Re: [jean] mod_perl error In reply to
ohhh...how stupid I was!

I've been looking everywhere but not in startup.pl !

Sometimes the solutions are quite simple!



Thanks for your help!

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [jean] mod_perl error In reply to
now the server is loading everything into mod_perl but I get another error (nothing is working!):



http://www.shop-netz.de/...s&sb=Produktname






A fatal error has occured:
GT::Template::Parser (25754): Unable to locate template file 'Dbsql::Home=HASH(0xa1e259c)' in '/var/www/cgi-bin/dbase/admin/templates/shopnetz' or any inheritance directories at GT::Template::_compile_template line 627.


Please enable debugging in setup for more details. OK

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.




Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] mod_perl error In reply to
The error still occurs, so I'm running DBMan SQL now again NOT in mod_perl?

Any help?

Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.
Quote Reply
Re: [ManuGermany] mod_perl error In reply to
Hi Manu,

Could you just try to preload the template parser module by adding the line below into your mod_perl.pm:

use GT::Template::Parser;

then restart your mod_perl

Cheers,
Jean
Gossamer Threads Inc.
Quote Reply
Re: [ManuGermany] mod_perl error In reply to
It looks like a subroutine is returning a Dbsql::Home object instead of a template name.

Can you turn on debugging to show the stack trace - that may show the caller.
Quote Reply
Re: [jean] mod_perl error In reply to
Hi Jean,

the error still occurs:




A fatal error has occured:


GT::Template::Parser (995): Unable to locate template file 'Dbsql::Home=HASH(0xa164038)' in '/var/www/cgi-bin/xxx/admin/templates/shopnetz' or any inheritance directories at GT::Template::_compile_template line 627.


Please enable debugging in setup for more details.


Stack Trace


======================================

Dbsql (995): GT::Base::error called at /var/www/cgi-bin/xxx/admin/GT/Template/Parser.pm line 99 with arguments

(GT::Template::Parser=HASH(0xa2053bc), CANTFIND, FATAL, Dbsql::Home=HASH(0xa164038), /var/www/cgi-bin/xxx/admin/templates/shopnetz).

Dbsql (995): GT::Template::Parser::parse called at GT::Template::_compile_template line 627 with arguments

(GT::Template::Parser=HASH(0xa2053bc), Dbsql::Home=HASH(0xa164038), HASH(0xa1fcd2c), ).

Dbsql (995): GT::Template::_compile_template called at /var/www/cgi-bin/xxx/admin/GT/Template.pm line 454 with arguments

(GT::Template=HASH(0xa205530), Dbsql::Home=HASH(0xa164038), /var/www/cgi-bin/xxx/admin/templates/shopnetz/compiled/Dbsql::Home=HASH(0xa164038).compiled, 1).

Dbsql (995): GT::Template::load_template called at /var/www/cgi-bin/xxx/admin/GT/Template.pm line 93 with arguments

(GT::Template=HASH(0xa205530), Dbsql::Home=HASH(0xa164038), 1).

Dbsql (995): GT::Template::parse called at /var/www/cgi-bin/xxx/admin/Dbsql/Home.pm line 134 with arguments

(GT::Template, Dbsql::Home=HASH(0xa164038), HASH(0x9fef208), HASH(0xa1fd0b4)).

Dbsql (995): Dbsql::Home::print called at /var/www/cgi-bin/xxx/admin/Dbsql/Home.pm line 94 with arguments

(Dbsql::Home=HASH(0xa164038), Dbsql::Home=HASH(0xa164038), [undef]).

Dbsql (995): Dbsql::Home::process called at /var/www/cgi-bin/xxx/db.cgi line 29 with arguments

(Dbsql::Home=HASH(0xa164038), in, GT::CGI=HASH(0xa1ecabc), sql, GT::SQL=HASH(0xa14a770), cfg, Dbsql::Config=HASH(0xa11d8e0)).

Dbsql (995): Apache::ROOTwww_2eshopnetzgmbh_2ede::cgi_2dbin::xxx::db_2ecgi::main called at /var/www/cgi-bin/xxx/db.cgi line 22 with no arguments.

Dbsql (995): Apache::ROOTwww_2eshopnetzgmbh_2ede::cgi_2dbin::xxx::db_2ecgi::handler called at /usr/lib/perl5/vendor_perl/5.6.1/i386-linux/Apache/Registry.pm line 143 with arguments

(Apache=SCALAR(0xa1605c0)).

Dbsql (995): (eval) called at /usr/lib/perl5/vendor_perl/5.6.1/i386-linux/Apache/Registry.pm line 143 with arguments

(Apache=SCALAR(0xa1605c0)).

Dbsql (995): Apache::Registry::handler called at /dev/null line 0 with arguments

(Apache=SCALAR(0xa1605c0)).

Dbsql (995): (eval) called at /dev/null line 0 with arguments

(Apache=SCALAR(0xa1605c0)).



System Information


======================================

Perl Version: 5.006001

DBMan SQL Version: 2.1.0

DBI.pm Version: 1.35

Mod Perl Version: 1.26

GT::SQL::error = Column Term cannot be left blank.

@INC =

/var/www/cgi-bin/xxx/admin

/home/jagerman/projects/gforum/cgi/admin

/var/www/cgi-bin/xxx/admin

/var/www/cgi-bin/xxx/admin

../..

/var/www/cgi-bin/xxx/admin

/usr/lib/perl5/5.6.1/i386-linux

/usr/lib/perl5/5.6.1

/usr/lib/perl5/site_perl/5.6.1/i386-linux

/usr/lib/perl5/site_perl/5.6.1

/usr/lib/perl5/site_perl/5.6.0

/usr/lib/perl5/site_perl

/usr/lib/perl5/vendor_perl/5.6.1/i386-linux

/usr/lib/perl5/vendor_perl/5.6.1

/usr/lib/perl5/vendor_perl

.

/etc/httpd/

/etc/httpd/lib/perl

CGI INPUT


======================================

col => Markenname

db => Produkte

do => search_results

mh => 15

sb => Produktname

so => ASC

ws => jacke



CGI Cookies


======================================

xxx

ENVIRONMENT


======================================

DOCUMENT_ROOT => /var/www/html

GATEWAY_INTERFACE => CGI-Perl/1.1

HTTP_ACCEPT => */*

HTTP_ACCEPT_ENCODING => gzip, deflate

HTTP_ACCEPT_LANGUAGE => de

HTTP_CONNECTION => Keep-Alive

HTTP_COOKIE => xxx

HTTP_HOST => xxx

HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; DT)

MOD_PERL => mod_perl/1.26

PATH => /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin

PERL_SEND_HEADER => On

QUERY_STRING => do=search_results&db=Produkte&ws=jacke&col=Produktname&col=Markenname&mh=15&sb=Produktname&so=ASC

REMOTE_ADDR => 80.141.84.1

REMOTE_PORT => 4125

REQUEST_METHOD => GET

REQUEST_URI => /cgi-bin/xxx/db.cgi?do=search_results&db=Produkte&ws=jacke&col=Produktname&col=Markenname&mh=15&sb=Produktname&so=ASC

SCRIPT_FILENAME => /var/www/cgi-bin/xxx/db.cgi

SCRIPT_NAME => /cgi-bin/xxx/db.cgi

SERVER_ADDR => xxx

SERVER_ADMIN => root@localhost

SERVER_NAME => www.xxx.de

SERVER_PORT => 80

SERVER_PROTOCOL => HTTP/1.1

SERVER_SIGNATURE =>

Apache/1.3.23 Server at www.xxx.de Port 80




SERVER_SOFTWARE => Apache/1.3.23 (Unix) (Red-Hat/Linux) mod_ssl/2.8.7 OpenSSL/0.9.6b DAV/1.0.3 PHP/4.1.2 mod_perl/1.26


OK


The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log. Apache/1.3.23 Server at www.xxx.de Port 80




My startup.pl is:




use lib '/var/www/cgi-bin/xx1/admin';

use Links::mod_perl;

use lib '/var/www/cgi-bin/xx2/admin';

require GForum::mod_perl;

use lib '/var/www/cgi-bin/xx3/admin';

use GMail::mod_perl;

# use lib '/var/www/cgi-bin/xxx/admin';

# use Dbsql::mod_perl;

1;






Do you know/have an idea (=solution), what the problem is?





Regards,
Manu

Shopping Portal Shop-Netz.de® | Partnerprogramme | Flugreisen & Billigflüge | KESTERMEDIA e.K. | European Affiliate Marketing Forum.

Last edited by:

ManuGermany: Mar 26, 2003, 10:47 AM