Does openbay hosted installation work at all?

[wacgyver]

I cant seem to get this working. 1st i want to setup Openbay without db locally, just to make it simple and verify i can actually get it to work. This is supposed to be a matter of copying files to the hosting folder, give the sufficient permissions on the files and folders, open the installer page, type a name for the page and hit deploy. Then as far as i understand it should be up & running, not hosting anything, but simply act as a front end UI for a search being relayed to isohunt servers. And this process should take less than an hour. Am i fundamentally misunderstanding something here?

[wacgyver]

I have seen it describes similar to this earlier.. For instance here is a video showing a simple setup .. unsure if it may be hoax, but why should it need to be any more complicated really?
https://www.youtube.com/watch?v=FQTdgi9tOTA

I have tried to put the files in several ways, but it does not work any way. The site is being set up when i hit deploy, but the search does not work.

Instead i get this message
"Not Found

The requested URL /src/www/search was not found on this server.

Apache/2.4.10 (Ubuntu) Server at 10.0.0.101 Port 80"

What am i doing wrong here... Please someone help if you have any idea.

[wacgyver]

It seems nobody are getting this right ... look at
http://www.openbay.se/
.. does not work

What the hell, this hosted solution should really be super simple to set up. Have they made it stupidly complicated or what the hell is going on here

[wacgyver]

And for the record ive been trying to set this up on 2x virtual machines in Virtualbox, hosted on Win7. The network adaptes are set up as bridge, ie they get an ip directly from the physical router in the network, and everything else seems to work just fine. Just not Openbay. Enlighten me ..

[TPBT-OFFICIAL]

https://tpbt.org works perfectly fine (my website) i setup my own database and my own sphinx daemon and it works "perfecly" (sometimes very slow cuz of the ammout of traffic every once in a while is insane)
I also setup my own public database if you are interested in using it!

[iShariefi]

Check my site in a subdomain..
http://infernalsoft.company/infernalbay
Had it in this stage more than a month ago and waiting for a solution for setting up sphinx and everything else on a C panel ever since. Can you help me do that?

[TPBT-OFFICIAL]

@iShariefi Do you have direct root access to the server? Also if you can't be bothered you can also use my public database i created.

[iShariefi]

Yes, I do have root access. Can you please suggest which solution will be best for me as I'm an iOS developer and my Web Development knowledge is minimal...

[TPBT-OFFICIAL]

If you have a good enough server you can easily setup sphinx daemon with a few commands, also if you need a database you can use this one https://tpbt.org/torrent/13134188/Openbay-FULL-DATABASE-SQL-FORMATE (download it and import it to mysql) also what operating system is your server on?

[iShariefi]

Actually till now, I've done everything on Cpanel through Filezilla, so obviously its a linux server and I'm on a mac running on Yosemite. Please bear my ignorance in this, this is my 1st php project...

[TPBT-OFFICIAL]

@iShariefi Yes but is it CentOS or Ubuntu or Debian or anything else?

[iShariefi]

Actually I'm planning to get a non-US hosting within a couple of days because this website is hosted on godaddy n as soon as i've a i upload the db, I guess they'll ban my account and I tried to find out the OS, but no luck...
From your previous comments, now I know that it works. So now i'll be getting the hosting tonight.. 😊

[TheChiefCoC]

openbay does work but the installtion manual is highly faulty . it took us time to figure out a workin one : http://tpb.ifilescloud.com

[wacgyver]

@TheChiefCoC
Humm seems to work great! Is there any way you could make a short and functional manual for setting up a remote hosted openbay (simplest setup, no db, ill try that later when the first one works)?
Id really appreciate i a lot if you could. And id share it with everyone of course

[wacgyver]

Fyi i get the "Not Found
The requested URL /src/www/search was not found on this server.
Apache/2.4.10 (Ubuntu) Server at 10.0.0.101 Port 80"
whatever i do. Also when using www as the root folder and protected stored one level up. All permissions given (777). What the hell is my problem .... i think i just need a little clue.. must be some little thing i havent thaught about. Does it need anything like DNS or static ip or anything like that? Or .. why would it... how could it possibly be made to need anything except open port from the ISP and a working internet connection ... i dont get it. Besides, such a problem should not yield the error im getting.. I think. Does it not seem to indicate a local problem?

[ghost]

@wacgyver what are your vps/dedi specs ?
I could help install it for you, email me ekoice at gmail dot com

ofcourse, I need root access to your vps/dedi.
cheers.

p.s. and yes, i got a working copy for a dude asking me to setup it at https://thehiddenbay.net/
using clean db with rss updater, so the torrents are freshly crawled from kickass.

[wacgyver]

Ok! Ill call you later :) Mail i mean. Thanks a lot, i really appreciate that. I did get it running on one machine, with Ubuntu. I had to change AllowOverride from None to All
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted

Allthough my debian box come up with internal error when i changed that setting. I still dont know why, tried several times, no type or any
thing like that. Maybe a double setting somewhere, but not sure..

And i want to set up my own hosting now that this worked

[wacgyver]

adress for the working one. Remote hosted, not local db or search
http://mypiratebay.ddns.net/

[wacgyver]

After success with remote db setup of Openbay, im now trying to set ip up with local sphinxsearch and db. I have made a new db in mysql called "mpb" and configured sphinxsearch. I was getting 404 when searching, (strangely, when searching for only 1 letter, i dont get an error but neither does it list any torrents).
So i turned on debugging in the \protected\config\debug.php
and now im getting this error:

CDbException

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)

/var/www/protected/extensions/ESphinxQL/ESphinxQL.php(297)
...... and a lot more stuff, but the key point i think is
failed to open the DB connection

I can telnet to localhost port 3306, and the sql user and pwd is valid. I have also tried to put in sql root pwd in config.php

Id greatly appreciate the helpful people in here! Ill try and return the favor as i learn

[TPBT-OFFICIAL]

@wacgyver can you please share your sphinx config?

[wacgyver]

@TPBT-OFFICIAL
Yes here it is! (sphinx conf)
http://pastebin.com/pc6Dz160

[TPBT-OFFICIAL]

You should change:

index opb_common {
docinfo = extern
charset_type = utf-8
charset_table = 0..9, A..Z->a..z, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F

TO:

index opb_common {
source = opbtorrents
path = /var/lib/sphinxsearch/data/opb_common
docinfo = extern
charset_type = utf-8
charset_table = 0..9, A..Z->a..z, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F

The error your getting is not mysql is actually sphinx but sphinx connections work like mysql.

Then run "indexer --all" (turn Sphinx off first) and paste it on pastebin what it shows when you do that.
After you run it turn sphinx on again and check if its working, if its not give me the log that shows when you try to run "indexer --all"

[wacgyver]

@TPBT-OFFICIAL Thanks for helping! I tried to follow your guide here but i still get the same error when trying to search or browse.
http://pastebin.com/QKkP98bB

[wacgyver]

@TPBT-OFFICIAL It seems i got an error when starting sphinx again. But im not allways getting that error, only sometimes .. Here i didnt get it. But searching still does not work.

root@tpbdebian:/etc/sphinxsearch# /etc/init.d/sphinxsearch stop
Stopping sphinxsearch: sphinxsearch.
root@tpbdebian:/etc/sphinxsearch# /etc/init.d/sphinxsearch restart
Restarting sphinxsearch: Sphinx 2.0.4-release (r3135)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
WARNING: compat_sphinxql_magics=1 is deprecated; please update your application and config
WARNING: preopen_indexes=1 has no effect with seamless_rotate=0
listening on all interfaces, port=3312
listening on all interfaces, port=9306
precaching index 'opb_common'
precaching index 'opbtorrents'
precached 2 indexes in 0.013 sec
sphinxsearch.
root@tpbdebian:/etc/sphinxsearch#

[wacgyver]

should there be a file called opb_common only? I have no such file, but i have a lot of files starting with that:

root@tpbdebian:/etc/sphinxsearch# ls /var/lib/sphinxsearch/data/opb_common/
ls: cannot access /var/lib/sphinxsearch/data/opb_common/: No such file or directory
root@tpbdebian:/etc/sphinxsearch# ls /var/lib/sphinxsearch/data
opb_common.spa opb_common.spk opbtorrents2.spa opbtorrents2.spk
opb_common.spd opb_common.spm opbtorrents2.spd opbtorrents2.spm
opb_common.sph opb_common.spp opbtorrents2.sph opbtorrents2.spp
opb_common.spi opb_common.sps opbtorrents2.spi opbtorrents2.sps
root@tpbdebian:/etc/sphinxsearch#

[TheChiefCoC]

@wacgyver download the latest version of sphinxsearch from : http://sphinxsearch.com/downloads/release/

[TheChiefCoC]

There isn't a way to apt-get it , but you can download it by : wget (link here)
And then run the command : dpkg -i (name of file).deb

[wacgyver]

I have uninstalled sphinxsearch 204 and installed 227 from the deb package i got from http://sphinxsearch.com/downloads/release/

I think this says that i have version 227 ?
http://pastebin.com/QCartaZx

any used the config changes i got from @TPBT-OFFICIAL earlier in this thread.

Anyway, im still getting the same error message as i got before:
CDbException

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)

[wacgyver]

@TheChiefCoC I can give you root access if you wouldnt mind helping me out here. But at the same time id really like to see for myself what the problem is in order to learn more.
Could we both connect to the box at the same time so that i can look at what you do ?
We could both login via ssh and one of us create a 'screen', and the other one connects to the screen (screen supports multipe connections at the same time)

[wacgyver]

@TheChiefCoC Can i PM you the address and password? Or maybe mail ? What was your mail again?

[wacgyver]

Is this a problem? My sphinx is configured to this port

root@tpbdebian:/etc/apache2# telnet 127.0.0.1 9306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused
root@tpbdebian:/etc/apache2#

../sphinxsearch/sphinx.conf
searchd {
listen = 3312
listen = 9306:mysql41
listen = 9306

[wacgyver]

My sphinxsearch is not running. It doesent say anything suspicious when restarting the service, but it seems to terminate right away.

root@tpbdebian:/etc/apache2# service sphinxsearch stop
Stopping sphinxsearch: already stopped.
root@tpbdebian:/etc/apache2# service sphinxsearch start
Starting sphinxsearch: Sphinx 2.2.7-id64-release (r4883)
Copyright (c) 2001-2015, Andrew Aksyonoff
Copyright (c) 2008-2015, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinxsearch/sphinx.conf'...
WARNING: preopen_indexes=1 has no effect with seamless_rotate=0
listening on all interfaces, port=3312
listening on all interfaces, port=9306
precaching index 'opb_common'
precaching index 'opbtorrents'
precached 2 indexes in 0.026 sec
ERROR.
root@tpbdebian:/etc/apache2# service sphinxsearch stop
Stopping sphinxsearch: already stopped.
root@tpbdebian:/etc/apache2#

[wacgyver]

root@tpbdebian:/etc/apache2# ps -aux | grep -i sphinx
warning: bad ps syntax, perhaps a bogus '-'?
See http://gitorious.org/procps/procps/blobs/master/Documentation/FAQ
root 31872 0.0 0.1 3556 812 pts/1 S+ 09:57 0:00 grep -i sphinx
root@tpbdebian:/etc/apache2#

[wacgyver]

using config file '/etc/sphinxsearch/sphinx.conf'...
WARNING: preopen_indexes=1 has no effect with seamless_rotate=0
listening on all interfaces, port=3312
listening on all interfaces, port=9306
precaching index 'opb_common'
precaching index 'opbtorrents'
precached 2 indexes in 0.033 sec
ERROR.
root@tpbdebian:/etc/apache2#

[wacgyver]

I think that error in the end is my main problem. I read in this thread
#2 (comment)
that youre supposed to have to import the database first.. but i dont get that, since there is 5 torrents in the db allready. Shoudnt that work? Im not interested in importing a lot of data before it works with the 5 torrent testing db that it ships with

[TPBT-OFFICIAL]

@wacgyver no that database is fine i once got that error on my ubuntu server but i never got it fixed i ended up just installing it in CentOS as it was much simpler with no problems for me.

[ghost]

@TPBT-OFFICIAL where can i get the whole DB tpb ? looks like https://tpbt.org/torrent/13134188/Openbay-FULL-DATABASE-SQL-FORMATE is down atm.

thanks