[rt-users] Sphinx and RT
Yavor Marinov
ymarinov at neterra.net
Mon Feb 17 09:20:28 EST 2014
Hi,
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:
CentOS 6
MySQL 5.1.73 (grabbed from repos, beside that i downloaded the source
version of this MySQL in order to compile the sphinx lib)
Sphinx 2.1.5 (from their official website)
RT 4.2.2
So, from the source directory of Sphinx, i copied the "mysqlse" content
to the source tree of the mysql. *Only* compiled MySQL (without install)
- installed the Sphinx lib, and everything went smooth. Currently this
is the result from MySQL engines:
mysql> select * from mysql.plugin;
+--------+--------------+
| name | dl |
+--------+--------------+
| sphinx | ha_sphinx.so |
+--------+--------------+
1 row in set (0.00 sec)
mysql>
It's loaded, Sphinx is working:
[root at rtmig ymarinov]# ps xa|grep search
7162 ? S 0:00 /usr/bin/searchd --config
/etc/sphinx/sphinx.conf
7163 ? Sl 0:05 /usr/bin/searchd --config
/etc/sphinx/sphinx.conf
8103 pts/0 S+ 0:00 grep search
[root at rtmig ymarinov]#
At this point, everything looks find, but once i try to run
*rt-setup-fulltext-index*, i got the following error:
[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)
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.
No matter, what user or password i'm using - this is the error i'm getting.
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140217/a91b52e1/attachment.htm>
More information about the rt-users
mailing list