Re: UdmSearch: Continual Indexer Error - (#2002)
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)
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)
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]