[HOWTO] Install Sphinx for Adult Script Pro

thiva7 · 2013-02-13 14:25:43

i just fix that problem:

i get this :

root@server1 [~]# indexer --all --config /etc/sphinx/sphinx.conf
Sphinx 2.0.6-id64-release (r3473)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'celebvideos'...
collected 1222 docs, 0.3 MB
collected 1232 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.2 Mhits, 100.0% done
total 1222 docs, 338909 bytes
total 0.210 sec, 1608101 bytes/sec, 5798.31 docs/sec
total 3680 reads, 0.009 sec, 0.3 kb/call avg, 0.0 msec/call avg
total 12 writes, 0.005 sec, 210.4 kb/call avg, 0.4 msec/call avg
root@server1 [~]#
root@server1 [~]# !/bin/bash
/bin/bash
root@server1 [~]# /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf
Sphinx 2.0.6-id64-release (r3473)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'celebvideos'...
collected 1222 docs, 0.3 MB
collected 1232 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.2 Mhits, 100.0% done
total 1222 docs, 338909 bytes
total 0.233 sec, 1451567 bytes/sec, 5233.89 docs/sec
total 3680 reads, 0.012 sec, 0.3 kb/call avg, 0.0 msec/call avg
total 12 writes, 0.006 sec, 210.4 kb/call avg, 0.5 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=25728).

i change complex from admin panel and search and related NOT work

this is my config file:

source celebvideos
{
    type        = mysql
    sql_host    = localhost
    sql_user    = user
    sql_pass    = pass
    sql_db      = database
    sql_sock    =  /var/lib/mysql/mysql.sock
    sql_port    = 3306

    sql_query_pre   = SET NAMES utf8
    sql_query       = \
    SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \
         v.rating, v.total_views, v.duration, v.video_id AS celebvideo, \
         GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS celebtags \
    FROM celebvideo AS v \
    LEFT JOIN celebvideo_tags AS t ON (t.video_id = v.video_id) \
    AND v.status = 1 \
    GROUP BY v.video_id

    sql_attr_uint       = celebvideo
    sql_attr_uint       = mobile
    sql_attr_uint       = total_views
    sql_attr_float      = duration
    sql_attr_float      = rating
    sql_attr_timestamp  = add_time
    sql_attr_multi      = uint celebcategories FROM query; SELECT video_id, cat_id FROM celebvideo_category
    sql_query_info      = SELECT video_id, add_date FROM celebvideo WHERE video_id=$id
}

index celebvideos
{
    source          = celebvideos
    path            = /var/lib/sphinx/data/videos
    charset_type    = utf-8
    min_prefix_len  = 3
    enable_star     = 1
}

searchd
{
    port        = 3312
    log         = /var/log/sphinx/searchd.log
    query_log   = /var/log/sphinx/query.log
    pid_file    = /var/log/sphinx/searchd.pid
}

Last edited by thiva7 (2013-02-13 15:03:11)

symtab · 2013-02-13 20:23:55

You cant change the index and source name. It needs to be videos.

thiva7 · 2013-02-13 20:48:25

ok i change it search is work....related NO!! why?? what is wrong?

source videos
{
    type        = mysql
    sql_host    = localhost
    sql_user    = user
    sql_pass    = pas
    sql_db      = db
    sql_sock    =  /var/lib/mysql/mysql.sock
    sql_port    = 3306

    sql_query_pre   = SET NAMES utf8
    sql_query       = \
    SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \
         v.rating, v.total_views, v.duration, v.video_id AS celebvideo, \
         GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS celebtags \
    FROM celebvideo AS v \
    LEFT JOIN celebvideo_tags AS t ON (t.video_id = v.video_id) \
    AND v.status = 1 \
    GROUP BY v.video_id

    sql_attr_uint       = celebvideo
    sql_attr_uint       = mobile
    sql_attr_uint       = total_views
    sql_attr_float      = duration
    sql_attr_float      = rating
    sql_attr_timestamp  = add_time
    sql_attr_multi      = uint celebcategories FROM query; SELECT video_id, cat_id FROM celebvideo_category
    sql_query_info      = SELECT video_id, add_date FROM celebvideo WHERE video_id=$id
}

index videos
{
    source          = videos
    path            = /var/lib/sphinx/data/videos
    charset_type    = utf-8
    min_prefix_len  = 3
    enable_star     = 1
}

searchd
{
    port        = 3312
    log         = /var/log/sphinx/searchd.log
    query_log   = /var/log/sphinx/query.log
    pid_file    = /var/log/sphinx/searchd.pid
}

symtab · 2013-02-14 07:51:30

This: v.rating, v.total_views, v.duration, v.video_id AS celebvideo you've changed this....

thiva7 · 2013-03-07 19:14:37

hi adrian

i get this result :

root@server1 [~]# indexer --all --config /etc/sphinx/sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
collected 1755 docs, 0.4 MB
collected 1780 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.3 Mhits, 100.0% done
total 1755 docs, 374793 bytes
total 0.239 sec, 1564335 bytes/sec, 7325.13 docs/sec
total 3 reads, 0.002 sec, 444.6 kb/call avg, 0.9 msec/call avg
total 10 writes, 0.004 sec, 328.9 kb/call avg, 0.4 msec/call avg
root@server1 [~]# !/bin/bash
/bin/bash
root@server1 [~]# /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
collected 1755 docs, 0.4 MB
collected 1780 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.3 Mhits, 100.0% done
total 1755 docs, 374793 bytes
total 0.232 sec, 1611569 bytes/sec, 7546.30 docs/sec
total 3 reads, 0.001 sec, 444.6 kb/call avg, 0.6 msec/call avg
total 10 writes, 0.008 sec, 328.9 kb/call avg, 0.8 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=24075).

but in search result when i use complex with "allysa milano " i get 2 video result with simple i get all.

what can be wrong|?

symtab · 2013-03-08 11:50:02

Are you using special characters? (utf8 for titles?)

thiva7 · 2013-03-08 13:02:45

symtab wrote:

Are you using special characters? (utf8 for titles?)

i dont know...i just uploading via ftp !! that all

discuss4u · 2013-03-10 08:22:42

I have installed sphinx successfully (I think)

But it can only search English keywords. When I type Chinese in the search box and search, it gives zero results.

symtab · 2013-03-11 15:48:45

It does not work with chinese keywords. You can add UTF8, but it still wont work correctly (or at least i was not able to make it work correctly yet). You can read this article: http://www.ivinco.com/blog/using-sphinx … documents/

discuss4u · 2013-03-11 16:48:10

Thanks symtab, I will take some time to read it. But do you mean that I should use simple search? It seems that it does not work correctly either.

thiva7 · 2013-07-10 15:23:08

Adrian i have installed but is not get results for new videos ..

i mean if yesterday i had upload video and i run in ssh this comand : /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf

will show this video....but if i upload new video today and NOT run this command will not get result with the new video.
How i can make it to automaticaly get every new video?

Thank you

symtab · 2015-08-04 13:44:20

Fixed AND/WHERE bug in sphinx.conf

Adult Script Pro Community Forums

#76 2013-02-13 14:25:43

Re: [HOWTO] Install Sphinx for Adult Script Pro

#77 2013-02-13 20:23:55

Re: [HOWTO] Install Sphinx for Adult Script Pro

#78 2013-02-13 20:48:25

Re: [HOWTO] Install Sphinx for Adult Script Pro

#79 2013-02-14 07:51:30

Re: [HOWTO] Install Sphinx for Adult Script Pro

#80 2013-03-07 19:14:37

Re: [HOWTO] Install Sphinx for Adult Script Pro

#81 2013-03-08 11:50:02

Re: [HOWTO] Install Sphinx for Adult Script Pro

#82 2013-03-08 13:02:45

Re: [HOWTO] Install Sphinx for Adult Script Pro

#83 2013-03-10 08:22:42

Re: [HOWTO] Install Sphinx for Adult Script Pro

#84 2013-03-11 15:48:45

Re: [HOWTO] Install Sphinx for Adult Script Pro

#85 2013-03-11 16:48:10

Re: [HOWTO] Install Sphinx for Adult Script Pro

#86 2013-07-10 15:23:08

Re: [HOWTO] Install Sphinx for Adult Script Pro

#87 2015-08-04 13:44:20

Re: [HOWTO] Install Sphinx for Adult Script Pro

Board footer