Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Mod_Perl and LinksSQL

Quote Reply
Mod_Perl and LinksSQL
This is a little technical .... but I am having problems getting LinksSQL to run under mod_perl.

I've checked the installed packages on my server and one package that is 'not' installed is:-

p5-Apache-DBI-0.87

It only has a small description, but mentions 'persistent connections' etc. Do I need to install this file?

Secondly, my host states that I can activate mod_perl by using a .htaccess file in the directory where I want to run mod_perl. The example quoted is as follows:-

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

I note in the instructions that Alex sends out with Links that there is a PerlRequire command - I've tried using this by editing my virtualhosts .conf file for Apache but when I restart the server I get an error.

I 'suspect' the problem is the missing package .... but I am sure someone knows more than me about this.

Thanks,


Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory
Quote Reply
Re: Mod_Perl and LinksSQL In reply to
Hi,

If you are using mod_perl, you should install Apache::DBI (provides persistent database connections).

Also, you will get better performance if you install Links SQL as described in README.mod_perl rather then using .htaccess. What happens is when you add:

use lib '/full/path/to/admin';
use Links::mod_perl;

in your perl startup file, it will preload all Links SQL modules and scripts into memory, making it much quicker.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Mod_Perl and LinksSQL In reply to
Thanks Alex:

I tried to install that package, however was not able to ... and my webhost does not appear to offer much help.

Thanks,

Clint.

--------------------------
http://www.AffiliatesDirectory.com - Affiliate Programs Directory