<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
I'm almost desperate - after spending 2 days trying to implement the
fulltext search in RT 4.2.2 i'm still at the point, where i can't
find proper information regarding my issue. Here is my setup:<br>
<br>
CentOS 6 <br>
MySQL 5.1.73 (grabbed from repos, beside that i downloaded the
source version of this MySQL in order to compile the sphinx lib)<br>
Sphinx 2.1.5 (from their official website)<br>
RT 4.2.2<br>
<br>
So, from the source directory of Sphinx, i copied the "mysqlse"
content to the source tree of the mysql. <b>Only</b> compiled MySQL
(without install) - installed the Sphinx lib, and everything went
smooth. Currently this is the result from MySQL engines:<br>
<br>
mysql> select * from mysql.plugin;<br>
+--------+--------------+<br>
| name | dl |<br>
+--------+--------------+<br>
| sphinx | ha_sphinx.so |<br>
+--------+--------------+<br>
1 row in set (0.00 sec)<br>
<br>
mysql> <br>
<br>
It's loaded, Sphinx is working:<br>
<br>
[root@rtmig ymarinov]# ps xa|grep search<br>
7162 ? S 0:00 /usr/bin/searchd --config
/etc/sphinx/sphinx.conf<br>
7163 ? Sl 0:05 /usr/bin/searchd --config
/etc/sphinx/sphinx.conf<br>
8103 pts/0 S+ 0:00 grep search<br>
[root@rtmig ymarinov]# <br>
<br>
At this point, everything looks find, but once i try to run <b>rt-setup-fulltext-index</b>,
i got the following error:<br>
<br>
[7409] [Mon Feb 17 13:09:33 2014] [critical]: DBI
connect('dbname=rt4;host=localhost','root',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) at ./rt-setup-fulltext-index line
581. (/opt/rt4/sbin/../lib/RT.pm:393)<br>
DBI connect('dbname=rt4;host=localhost','root',...) failed: Can't
connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111) at ./rt-setup-fulltext-index line
581.<br>
<br>
No matter, what user or password i'm using - this is the error i'm
getting. <br>
Point me something to look for, please. Can I just use the "CREATE
TABLE" which is in this script, or there is something else which
have to be done?<br>
<br>
BR.<br>
<br>
<br>
<br>
</body>
</html>