Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

#26 2011-06-11 02:31:57

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

I tried and its a mess, can you just install, i just want it finished and done

Offline

#27 2011-06-11 08:23:24

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Did you tell you're hosting what i wrote to you in my last email reply? (i didnt check my emails yet, just woke up)


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#28 2011-06-12 18:42:04

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

ok thanks sphinx working after your install, except one question: it returns all words in titles but if i search for 'hentai' and i have a 100 hentai videos in hentai category, it only returns the videos with 'hentai' in title, and not the full scope of hentai videos i have in category

Last edited by asko (2011-06-12 18:47:06)

Offline

#29 2011-06-12 19:14:48

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

It searches in Title and Tags.
If some of your Hentai videos do not have Hentai in title or tag they can't be found.


sgt-halfsize-banner.jpg

Offline

#30 2011-06-13 15:13:41

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

How can i add this 'tag' when i mass upload?
Otherwise am i supposed to do it?
one by one in admin panel video tabs?

Offline

#31 2011-06-13 15:27:46

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

How do you mass import ? CSV, XML(RSS), Embed ?


sgt-halfsize-banner.jpg

Offline

#32 2011-06-13 15:53:51

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

admin panel>Video>Add>MassEmbed

I do not see a tag option, it has category, but it does not put a tag on it,
maybe They could add this as a new option in next version,
otherwise all i see having to to do it one by one in video >manage, if adding tags works there for search results.

Last edited by asko (2011-06-13 16:08:31)

Offline

#33 2011-06-13 16:17:53

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Never used mass embedding, but i think if the site from which you are embedding has tags, they should be imported. Which site is it ?


sgt-halfsize-banner.jpg

Offline

#34 2011-06-13 22:07:19

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

None of it works, i tried them all, the whole mass embed option is not working at all.
Maybe symtab has an idea why

Last edited by asko (2011-06-13 22:51:45)

Offline

#35 2011-06-14 07:51:43

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Please open a new topic if you chance the subject/question. The mass embedders work (i just tested on my box), probably not all because the they change from time to time, but i can fix any that dont work. Are any videos added? Without thumbs, with thumbs? Is there a database entry created?


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#36 2011-06-14 17:00:16

asko
Member
Registered: 2011-05-11
Posts: 138

Re: [HOWTO] Install Sphinx for Adult Script Pro

? opened new thread

Last edited by asko (2011-06-14 21:54:48)

Offline

#37 2011-06-14 17:50:10

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Uhm this is a smarty error. ASP uses no smarty...... porn2.com and some tgp ......


sgt-halfsize-banner.jpg

Offline

#38 2011-07-11 13:44:15

thiva7
Member
Registered: 2011-04-30
Posts: 996

Re: [HOWTO] Install Sphinx for Adult Script Pro

Coscast wrote:

This is what they want:

source videos
{
        type        = mysql
    sql_host    = localhost
    sql_user    = mysql-username
    sql_pass    = mysql-password
    sql_db      = mysql-database
    sql_sock    = /var/lib/mysqld/mysqld.sock (this depends on your server)
    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, \
         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           = 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 (this depends on your distribution)
        charset_type    = utf-8
        min_prefix_len  = 3
        enable_star     = 1
}

searchd
{
        port            = 3312
        log                     = /var/log/sphinxsearch/searchd.log (this depends on your distribution)
        query_log       = /var/log/sphinxsearch/query.log (this depends on your distribution)
        pid_file        = /var/log/sphinxsearch/searchd.pid (this depends on your distribution)
}

This works 100%, did an install today.

is not work me to....

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'...
FATAL: failed to open /var/lib/sphinxsearch/data/videos (this depends on your distribution).spl: No such file or directory, will not index. Try --rotate option.
root@server1 [~]# indexer --all --rotate --/etc/sphinx/sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

FATAL: no readable config file (looked in /usr/local/etc/sphinx.conf, ./sphinx.conf)

Offline

#39 2011-07-11 14:15:30

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

Hmm, I am not able to find anything on my website, but sphinx seems to be started and working:

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

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
collected 297 docs, 0.0 MB
collected 533 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 297 docs, 46103 bytes
total 0.029 sec, 1560697 bytes/sec, 10054.16 docs/sec
total 3 reads, 0.000 sec, 61.3 kb/call avg, 0.0 msec/call avg
total 9 writes, 0.000 sec, 51.9 kb/call avg, 0.1 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=18143).

Do I have to set anything in the ACP (except the Sphinx (complex) search)?

Offline

#40 2011-07-11 14:20:51

thiva7
Member
Registered: 2011-04-30
Posts: 996

Re: [HOWTO] Install Sphinx for Adult Script Pro

no

in /etc/sphinx/sphinx.conf i have this line

source videos
{
        type        = mysql
    sql_host    = localhost
    sql_user    = thiva77_user
    sql_pass    = 123456
    sql_db      = thiva77_my-database
    sql_sock    = /var/lib/mysqld/mysqld.sock (this depends on your server)
    sql_port    = 9306 

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, \
         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           = 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 (this depends on your distribution)
        charset_type    = utf-8
        min_prefix_len  = 3
        enable_star     = 1
}

searchd
{
        port            = 9306
        log                     = /var/log/sphinxsearch/searchd.log (this depends on your distribution)
        query_log       = /var/log/sphinxsearch/query.log (this depends on your distribution)
        pid_file        = /var/log/sphinxsearch/searchd.pid (this depends on your distribution)
}

Offline

#41 2011-07-12 10:44:59

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

Do I also have to change anything in the adultscriptpro? as my sphinx is running fine with that configuration.

Offline

#42 2011-07-12 11:19:48

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

You dont have to change anything. The search (if set to complex in admin) should work out of the box. If it doesnt, i'll check your server later today (i have access, if it didnt change since yesterday).


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#43 2011-07-12 12:49:32

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

Thank you very much, again! I did disable the sphinx search (until you can fix it as there are some active users).

Offline

#44 2011-07-14 01:00:20

danito
Member
Registered: 2011-07-14
Posts: 2

Re: [HOWTO] Install Sphinx for Adult Script Pro

Hey Guys! I bought ASPro a couple of weeks ago and I just got around installing Sphinx. I just spent a couple of hours having fun figuring out why it didn't return results. Symptoms are no error message in ASPro and no logged queries in Sphinx. Turns out that on CentOS, the version installed by yum is old and is not compatible with the (newer) version that ASPro expects. You can either install the most recent Sphinx version OR go the lazy route (which I did). Simply do:

cd /path/to/your/domain (if you're not already at the root of your domain)
cd libraries/sphinxapi
mv sphinxapi.php sphinxapi.php.orig
cp /usr/share/doc/libsphinxclient-0.9.8.1/sphinxapi.php .

That's it. As far as I can tell it works just as good at the one provided with ASPro.

If your Sphinx-provided sphinxapi.php is located somewhere else, you can find it:
find / -name sphinxapi.php -ls

Have fun!
Dan

Offline

#45 2011-07-14 10:03:42

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

Hmm, there is no sphinxapi anywhere.

@symtab any news about this?

Offline

#46 2011-07-14 22:11:19

danito
Member
Registered: 2011-07-14
Posts: 2

Re: [HOWTO] Install Sphinx for Adult Script Pro

@Sebo1992 : Forgot to add you need to 'yum install libsphinxclient' . By installing this you'll get the matching sphinxapi.php (which will be installed in /usr/share/doc/libsphinxclient-0.9.8.1/).

Offline

#47 2011-07-15 09:44:57

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

@sebo1992: i dont have anything new about this problem, it works for me perfectly on CentOS. Will check your server today and see what i can do.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#48 2011-07-15 10:27:45

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

danito wrote:

@Sebo1992 : Forgot to add you need to 'yum install libsphinxclient' . By installing this you'll get the matching sphinxapi.php (which will be installed in /usr/share/doc/libsphinxclient-0.9.8.1/).

Tried that but unfortunately it's not working.

@symtab Thank you!

Offline

#49 2011-07-15 18:52:39

symtab
Administrator
Registered: 2010-08-23
Posts: 7,323
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

I apologise for the delay. I can install sphinx for you tomorrow sad


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - PopAds

Offline

#50 2011-07-15 19:25:33

sebo1992
Member
Registered: 2011-07-04
Posts: 40

Re: [HOWTO] Install Sphinx for Adult Script Pro

symtab wrote:

I apologise for the delay. I can install sphinx for you tomorrow sad

Sure, not a problem. Thank you! smile

Offline

Board footer

Powered by FluxBB