Gossamer Forum
Home : Products : Links 2.0 : Customization :

msql version ..problem..

Quote Reply
msql version ..problem..
I am links menia... Korean.
my data is 2000 over.
so i tried msql version.
msql install is successed by book.
but
sql.cfg , nph-build.cgi, search.cgi
are very difficult for me,(setting)
step by step install msql version is not here.

Please tell me!
˘şerror message search.cgi
Error including libraries: Can't locate Msql.pm in @INC (@INC contains: /usr/local/Hughes/lib /home/httpd/html/search3 /usr/lib/perl5/i386-linux/5.00404 /usr/lib/perl5 /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at /home/httpd/html/search3/admin/sql.cfg line 39.
BEGIN failed--compilation aborted at /home/httpd/html/search3/admin/sql.cfg line 39.

Make sure they exist, permissions are set properly, and paths are set correctly.

˘şmy sql.cfg setting....
# Whether or not to even use SQL.
$use_sql = 1;
# Load SQL Libaries..
if ($use_sql) {
use lib '/usr/local/Hughes/lib'; # include for mSQL versi
use Msql;
}
# Name of host machine.
$sql_host = 'localhost';
# Name of database.
$sql_database = 'database';
# Name of table to hold link information.
$sql_search = 'search';

# Fields which are integers and should not be quoted.. Defaults to the ID and
# the number of Hits..
%sql_noquote = (0 => 1, 8 => 1);

# SQL Fields to search over
@sql_search_fields = qw!Title URL Description!;
# SQL to create the table.
$sql_create_search = qq!
CREATE TABLE $sql_search (
ID INT,
Title CHAR(255),
URL CHAR(255),
AddDate CHAR(12),
Category CHAR(255),
Description CHAR(1000),
Contact_Name CHAR(50),
Contact_Email CHAR(50),
Hits INT,
isNew CHAR(3),
isPopular CHAR(3)
)
!;

Quote Reply
Re: msql version ..problem.. In reply to
Your problem is the missing Msql.pm module for your version of Perl.

Get that module for perl and it should work properly.

John
Quote Reply
Re: msql version ..problem.. In reply to
where can i get it (Msql.pm module)?

please tell me!

thanks.
Quote Reply
Re: msql version ..problem.. In reply to
where can i get msql.pm ?
and
who can i install this?
i am straner to msql and server.

thank you.
Quote Reply
Re: msql version ..problem.. In reply to
Try MySQL instead -- that's what I use.

You can download MySQL and its perl module at:

http://www.mysql.com/download.html

Hope that helps.

John
Quote Reply
Re: msql version ..problem.. In reply to
You can get the modules at:

http://www.perl.com/...odules/by-module/DBD

and look for the latest Msql-Mysql driver (it contains both DBI interface as well as Msql).

Cheers,

Alex