Re: UdmSearch: Continual Indexer Error - (#2002)

2000-10-16 Thread Alexander Barkov

   Hi!

You use old MySQL libraries from previous installation with new daemon.
Compile UdmSearch with new MySQL libraries.


Tom Leitch wrote:
 
 Hi there,
 
 I'm having a continual problem with UdmSearch mainly in the fact that the
 Indexer refuses to connect to MySQL. The problem seems to be that it tries
 to connect via  '/var/lib/mysql/mysql.sock' when the sock file is found in
 '/tmp'. There have been previous installs of MySQL, but UdmSearch doesn't
 appear to want to find the correct location. Is there any way in which I can
 force the location ?
 
 I'm using the latest build of Udm, and I installed it with MP3 support and
 news extensions.
__
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]




Re: UdmSearch: Continual Indexer Error - (#2002)

2000-10-16 Thread Sergey Kartashoff

Hi!

Monday, October 16, 2000, 2:25:06 PM, you wrote:

TL I'm having a continual problem with UdmSearch mainly in the fact that the
TL Indexer refuses to connect to MySQL. The problem seems to be that it tries
TL to connect via  '/var/lib/mysql/mysql.sock' when the sock file is found in
TL '/tmp'. There have been previous installs of MySQL, but UdmSearch doesn't
TL appear to want to find the correct location. Is there any way in which I can
TL force the location ?

To force connect by TCP/IP, and not by unix local sochet you should
use your valid server hostname, not localhost. Or you can explicitly
set the right path to socket by using 'socket' mysqld variable. And
the last answer how to solve the problem is to check permissions for
your socket. It must be accesible for those user, which running your
httd daemon. For example default old redhat mysql rpms are installing
the socket into /var/lib/mysql directory. But that catalog have
permissions rwx-- with mysql owner, so user web or nobody has no
access to this socket.

-- 
Regards, Sergey aka gluke.


__
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]




Re: UdmSearch: Continual Indexer Error - (#2002)

2000-10-16 Thread Alexander Barkov

Hi! 

If you want use extended new indexing, you have to download Perl
front-end
from our site. It has alternative "url" table definition.

Or you may install without using --enable-news-extensions configure
parameter.



Tom Leitch wrote:
 
 Hey,
 
 thanks guys for that - I think I have fixed it now - although I do get
 another error when I try to run the indexer. I'm not sure whether this has
 been reported or not yet, but this is what I get -
 
 ./indexer
 Indexer[861]: indexer from UdmSearch v.3.1.6/MySQL started with
 '/usr/local/udmsearch/etc/indexer.conf'
 Indexer[861]: [1] Error: '#1054: Unknown column 'msg_id' in 'field list''
 
 I'm pretty sure it has to do with the msg_id column in the URL table
 (create.txt) not being there...
 
 cheers
 
 tom
 [EMAIL PROTECTED]
 
 
  To force connect by TCP/IP, and not by unix local sochet you should
  use your valid server hostname, not localhost. Or you can explicitly
  set the right path to socket by using 'socket' mysqld variable. And
  the last answer how to solve the problem is to check permissions for
  your socket. It must be accesible for those user, which running your
  httd daemon. For example default old redhat mysql rpms are installing
  the socket into /var/lib/mysql directory. But that catalog have
  permissions rwx-- with mysql owner, so user web or nobody has no
  access to this socket.
__
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]