Installing and configuring sphinx engine and MySQL Database

[ghost]

Hello everyone, I have CentOS 6 VPS and I installed OpenBay using remote database. Since i got a lot of troubles with that database i decided to run my own database, but problem is I'm unable to set it up. So, can someone give me complete tutorial/instructions how to install sphinx and configure database.

Thank You.

[nexusrain]

Hold on man, see my complete installation guide thread. I think I got it working with mysql (took me 4 days of searching and testing..) and I'll add that part on how to setup mysql tomorrow (IF it's working, I'm doing the final test now). Sphinx engine guide will come too as soon as I got it working by myself.

[ghost]

I already saw your guide, i dont know if you noticed, but not all torrents are working on OpenBay hosted database. Only torrents that have .torrent file download are working. Thank You :)

[src386]

I'm trying to write a howto but I cannot make it work with mysql/sphinx. So I'm interested if someone succeded.

[ghost]

Yes, same here.

[nexusrain]

@Laceratus Oh, no, I didn't noticed that yet.. @src386 That's what I'm doing, but had no success with mysql this far. Fckin sht..

[kunalandroid]

This can help you. Also import sql file located in "protected/data".

[aaruni96]

@kunalandroid importing the file is the whole damned problem. The sql file in protected/data is just the schema, with 8 or so torrents. The main dump is a CSV file, and importing that is a huge, unsolved PITA.

[src386]

@kunalandroid : already done. I even tried to import the dump from openbay-db (which is really small, I can't believe there is the whole tpb history). Nothing to do

[nexusrain]

So, guys. Fuck dat shit, here you go:

http://torcache.net/torrent/30A7A1B67117218BE82977F9F5A9C91EAA7DA40F.torrent

The DB as SQL dump. You can easily import it into MySQL.

Pls seed nicely, I've already multiple servers running which are seeding @ full speed...

[aaruni96]

@src386 : openbay-db ?? Where you get that from ?

[devnurko]

remember to raise max_allowed_packet in my.cnf for nexusrain's SQL dump, the default is 16M.

[tehp]

@nexusrain thank you sir.

[src386]

@aaruni96 : openbay-db-dump https://github.com/isohuntto/openbay-db-dump

[src386]

It could be a good idea to open a room on IRC or Jabber, then work together step by step to make it work.

[kunalandroid]

@src386 You are correct. It's a good Idea to open a room on IRC.

[aaruni96]

Except is someone is going to keep this git updated with what's going on in IRC, I'm against it. I won't be able to participate in real time discussions.

[kunalandroid]

@aaruni96 I will keep this git updated.

[nexusrain]

Alright guys, I finally updated my guide with how to host the database on your own server! Here's the link again: https://www.bitforce.io/hacking/howto-setup-openbay-on-debian-ubuntu-with-nginx-1-6-2/