The line(s)

if ($use_sql) { use lib '/u/local/msql2/perl'; use Msql; }

Is cuzzing Links SQL from not working properly on build links. I know for one reason is I don't have msql on my webhost. How do i change it for Mysql?

Links SQL does not function in MiniSQL2 (msql), only in MySQL, MSSQL and Oracle.

-=-=-=-=-=-=-=-=-
Janio Le
-=-=-=-=-=-=-=-=

MySQL is the default installation.

You need to set up the "hostname" field during install or setup.

That points to the name of your datbasse server. But, you must also have the DBI::DBD module installed, so you can make your connections. If the test program ran, then the installation should proceed.


PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

didn't you people read thet code? it said msql. READ FOR GOODNESS SAKES. how do i change it work right?

I don't think I like your attitude.

Where is this line:


if ($use_sql) { use lib '/u/local/msql2/perl'; use Msql; }


I've installed every alpha, and every beta, as well as every 1.xx release multiple times. I have two copies of the beta5 working, and I have never had a "mSQL" problem.

Before you cop an attitude, do your best to explain what is going on. Apparantly no one understood you, and no one else has hit this problem.

It was assumed from this posting, YOU were trying to run mSQL, and on second read, it still looks like that.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

Nothing needs changing for use with MySQL as it is already setup to use it.

Maybe you didnt install correctly.

...was there any need in being so rude?

Paul Wilson.
(Dont blame me if I'm wrong!)

 
I know it doesn't with with MiniSQL. Hows do i change it to mysql manually? Its very frustrating when people keep saying it won't work dozens of times but doesn't tell you how to make it work. I asked in the beginning to tell me how to change it to mysql to make it work.

doctorperl,

It also doesn't help when you keep posting the same message without giving people any additional information to work with !!!

Links SQL is setup to work with MySQL as standard, so unless you've modified the scripts in some way it should work OK right from the start, however, everyone has a slightly different server/software setup and different levels of experience, so sometimes they need help, but you've got to provide people with a bit more information, such as any error messages that you get when trying to install/use it; at what stage of the install did it go wrong; have you ever had it working; did it work and then stop working; do you have MySQL installed on your server; ... etc. Error messages, and reports of 'weird' behavour, can often help more experienced links users in trying to diagnose what may be wrong with your setup.

Now, lets start again, and work through how far you've got with your install and what might possibly be wrong;

1. Have you installed all of the files/directories and set the permissions correctly?
2. Can you run the links admin script?
3. If you are getting error messages, what do they say?

Alternatively (and this is specific to MySQL database/table access) have a look at the files in ../Admin/defs/ - at the top of each .def file you'll see a section like this:

$db_name = '';
$db_host = 'localhost';
$db_driver = 'mysql';
$db_user = '';
$db_pass = '';

For $db_name = '';, you'll need to put the NAME of your MySQL DATABASE on your server
For $db_user = '';, you'll need to put your USER NAME (commonly your login user name)
For $db_pass = '';, you'll need to put your PASSWORD (commonly your login password)

I hope this helps, but if it doesn't try posting again with more detailed information and let us know how far you've got with the installation.

We can't help you unless you give us something to go on ....

All the best
Shaun

Ok. What are you people not getting?

if ($use_sql) { # In the sql.cfg file
use lib '/u/local/msql2/perl';
use Msql; }

how do i change it work with MySQL?
It simple question and require simple answer. Let me repeat it, How do you change those line to work with mysql? As they stand now, it doesn't work with it. You don't need any bloody error msges or server settings, Just answer the question.

Well your bloody simple question, that requires a bloody simple answer, also required a bloody simple bit of info that you didn't give before ...

# In the sql.cfg file

Where is this in the Links files?


All the best
Shaun

Shaun,

It's not worth it. He doesn't get it. I asked where that line was before. I just did a case insensitive search of my harddrive files (23 installations of Links SQL, 5 different release versions) and I didn't get one hit on 'msql'.

Links SQL never worked with msql, and the only reference to msql was in the 1.x docs where it said it didn't work with it.

No point dealing with people like this. It only gets you upset, and wastes your time (as evidenced by the length of your posts). If he was serious, he'd have provided more, and appropriate, information. It sounds like he's trying to get some other product working, not Links.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

Pugdog,

You're right ...

All the best
Shaun

Are you sure you are at the right forum at the right website on the right planet?

Paul Wilson.
(Dont blame me if I'm wrong!)

All of the help received on the forums is done gratis from people who are busy running their own websites, there are many forums and they can only spend a limited amount of time with questions. There are a lot of questions from many people. Edit your Doctorperl profile to except private messages and maybe some one can give you some one on one help and walk you through some of these problems.

Ok guys, I wouldn't normally do this, but this guy has been rude beyond belief, and has sent me a few emails that have been very rude.

Anyway, here is the file he sent me, with some nasty digs:

I leave it to you readers to answer him, as any answers I give will be just downright unforgiving :)

But... just in case you need a hint... the date on the file is correct.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

ok

LOL.....am I missing something......

WFT is sql.cfg.....

Looks like his Links2 and LinksSQL copies had a little baby....



Paul Wilson.
(Dont blame me if I'm wrong!)

No, it was an attempt way back to get links 1.1 to use an SQL table. _NOT_ Links SQL 1.1x, but Links 1.1 ... the one before Links 2.0 flat-file.

No wonder no one ever heard of it. We are now in 2001... the year of HAL.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://pugdog.com/FAQ

LOL....

Whats he still doing with a copy of it then?..(who knows)

Paul Wilson.
(Dont blame me if I'm wrong!)

I think he means this
read it.... it said something about msql





#!/usr/bin/perl
#
# -------------
# Links
# -------------
# Links Manager (SQL Version)
#
# File: sql.cfg
# Description: Optional SQL setup variables
# Author: Alex Krohn
# Email: alex@gossamer-threads.com
# Web: http://www.gossamer-threads.com/
# Version: 1.1
#
# COPYRIGHT NOTICE:
#
# Copyright 1997 Gossamer Threads Inc. All Rights Reserved.
#
# This program is being distributed as shareware. It may be used and
# modified free of charge for personal, academic, government or non-profit
# use, so long as this copyright notice and the header above remain intact.
# Any commercial use should be registered. Please also send me an email,
# and let me know where you are using this script. By using this program
# you agree to indemnify Gossamer Threads Inc. from any liability.
#
# Selling the code for this program without prior written consent is
# expressly forbidden. Obtain written permission before redistributing this
# program over the Internet or in any other medium. In all cases
# copyright and header must remain intact.
#
# Please check the README file for full details on registration.
# =====================================================================

# Whether or not to even use SQL.
$use_sql = 1;
# Load SQL Libaries..
if ($use_sql) {
use lib '/u/local/msql2/perl'; # include for mSQL version 2+
use Msql;
}
# Name of host machine.
$sql_host = 'host';
# 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)
)
!;

Um this thread is like 3 months old and has long since ended, why bring it back to the top?

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/