The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
Pages: 1
Hello Friends,
I recently shifted my ASS and ASPro site to Single server and I like to use Sphinx for both sites. So what .conf file I should have. I means I have to create 2 .conf file like 1.conf and 2.conf Or I have to but both configuration in same file sphinx.conf
Offline
One config with the two configuration blocks. One for Adult Script Pro and one for Adult Search Script. For both scripts in SPHINX.txt you have the exact config block that you need to add.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
can you give small example how to add both configuration in one file.
Offline
source adultsearchscript
{
type = mysql
sql_host = localhost
sql_user = mpclips
sql_pass = mpclips
sql_db = mpclips
sql_sock = /var/lib/mysql/mysql.sock
sql_port = 3306
sql_query_pre = SET NAMES utf8
sql_query_range = SELECT MIN(video_id),MAX(video_id) FROM video
sql_range_step = 1000
sql_query = \
SELECT v.video_id, v.source_id, v.title, v.add_time, v.rating, \
v.total_views, v.duration, v.orientation, v.video_id AS video, \
GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \
FROM video AS v \
LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) \
WHERE v.video_id >= $start AND v.video_id <= $end \
AND v.status = 1 \
GROUP BY v.video_id
sql_attr_uint = video
sql_attr_uint = total_views
sql_attr_uint = source_id
sql_attr_uint = orientation
sql_attr_uint = duration
sql_attr_float = rating
sql_attr_timestamp = add_time
sql_query_info = SELECT video_id, add_time FROM video WHERE video_id=$id
}
index adultsearchscript
{
source = adultsearchscript
path = /var/lib/sphinx/adultsearchscript
charset_type = utf-8
min_prefix_len = 3
enable_star = 1
morphology = stem_en
}
source videos
{
type = mysql
sql_host = localhost
sql_user = asp
sql_pass = asp
sql_db = asp_b4
sql_sock = /var/run/mysqld/mysqld.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 video, \
GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \
FROM video AS v \
LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) \
AND v.status = 1 \
GROUP BY v.video_id
sql_attr_uint = video
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 categories FROM query; SELECT video_id, cat_id FROM video_category
sql_query_info = SELECT video_id, add_date FROM video WHERE video_id=$id
}
index videos
{
source = videos
path = /var/lib/sphinxsearch/data/videos
charset_type = utf-8
min_prefix_len = 3
enable_star = 1
}
indexer
{
mem_limit = 128M
}
searchd
{
listen = 127.0.0.1:9312
log = /var/log/sphinx/searchd.log
query_log = /var/log/sphinx/query.log
read_timeout = 5
max_children = 30
pid_file = /var/run/sphinx/searchd.pid
max_matches = 100000
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
workers = threads # for RT to work
binlog_path = /var/lib/sphinx/
}Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Hey adrian ,
i have add all my ass sites and work perfect. i add asp site and show that indexed but in search on site not show any result.
any suggestion to fix that?
Offline
Adrian I have send you email and I didn't get reply.
thanks
Offline
there might be code issue you added for ass. If you can post demo code not with original mysql login. I can help You. As in latest sphinx some lines have to be deleted from above given code
Offline
Pages: 1