Ok, so I figured out that on ServerB for sphinx.conf, i had to add
sql_port = 6432 to the end of source base { } before the last bracket
(thought the order shouldnt really matter. Sphinx now seems to connect
fine to the remote server. Yeah for more undocumented settings! =P
On 2013-02-27 22:45, Mark Chaney wrote:
Raymond,
Are you able to successfully connect to sphinx on ServerA from
ServerB? When I run the following, you will see what error i get:
indexer --all --rotate
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 'lists'...
ERROR: index 'lists': sql_connect: could not connect to server:
Connection refused
Is the server running on host "seaspray.foobar.com" and accepting
TCP/IP connections on port 5432?
(DSN=pgsql://baruwa:***@seaspray.foobar.com:5432/baruwa).
total 0 docs, 0 bytes
total 0.014 sec, 0 bytes/sec, 0.00 docs/sec
skipping non-plain index 'lists_rt'...
indexing index 'organizations'...
ERROR: index 'organizations': sql_connect: could not connect to
server: Connection refused
Is the server running on host "seaspray.fooba.com" and accepting
TCP/IP connections on port 5432?
(DSN=pgsql://baruwa:***@seaspray.foobar.com:5432/baruwa).
total 0 docs, 0 bytes
...........
What i find odd though is that I know the auth information is
correct, the firewall isn't blocking him and baruwa connects to the
remote db fine for other purposes. The beginning of my sphinx.conf
looks like so on ServerB (serverA is seaspray.foobar.com if it wasn't
obvious):
searchd
{
listen = 127.0.0.1:9312
listen = 127.0.0.1:9306:mysql41
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 = 500
seamless_rotate = 1
preopen_indexes = 0
unlink_old = 1
workers = threads
collation_server = utf8_general_ci
rt_flush_period = 3600
binlog_path = /var/lib/sphinx
}
indexer
{
mem_limit = 128M
}
source base
{
type = pgsql
sql_host = seaspray.foobar.com
sql_user = baruwa
sql_pass = xxxxxxxxxxxxx
sql_db = baruwa
}
On 2013-02-27 20:06, Mark Chaney wrote:
I am getting a bit inconsistent results on releasing emails from the
secondary that went through the primary and for some reason
mailscanner on the primary isnt always starting on boot. No idea on
that one as its saying in the boot.log that its starting ok, but its
not.
On 2013-02-27 19:49, Raymond Norton wrote:
Great to hear! I will see what I can do on my setup with that info.
On Feb 27, 2013, at 7:32 PM, Mark Chaney <[email protected]>
wrote:
Sweet, i got the stats working now. I setup celery.queue in
production.ini as seen below in serverA and ServerB
{"seaspray.foobar.com":{"exchange":"host","exchange_type":"direct","binding_key":"seaspray.foobar.com"},"prowl.foobar.com":{"exchange":"host","exchange_type":"direct","binding_key":"prowl.foobar.com"},"msbackend":{"exchange":"ms","exchange_type":"fanout","binding_key":"mstasks"},"default":{"exchange":"default","binding_key":"default"}}
On 2013-02-27 19:14, Mark Chaney wrote:
Raymond,
So I think 90% of our issues revolve around the celery.queues
setting
in production.ini. I think we have to expand on it to include the
other servers. Im not 100% sure what those settings are supposed
to be
yet, but im pretty confident that its part of our problem with
statuses, etc.
On 2013-02-27 08:50, Raymond Norton wrote:
I will be working on this more today.
On 02/27/2013 08:45 AM, Mark Chaney wrote:
You guys taking a break from working on this issue? =P
Also, I noticed with the baruwa cluster configs for 1.1, there
was a rabbitmq.config file, is this not needed in 2.0 and its
getting those settings from production.ini?
On 2013-02-25 22:12, Mark Chaney wrote:
Where do I get the username/password for the rabbitmq web
interface?
On 2013-02-25 20:11, Jeremy McSpadden wrote:
rabbitmq-plugins enable rabbitmq_management
service rabbitmq-server restart
then login at http://10.10.1.41:15672 poke/play around ;)
-- Jeremy McSpadden
Flux Labs, Inc | http://www.fluxlabs.net [2] | Endless
Solutions
Office : 850-250-5590x101 | Cell : 850-890-2543 | Fax :
850-254-2955
On Feb 25, 2013, at 7:50 PM, Raymond Norton <[email protected]>
wrote:
I'm making some progress. Added the rabbitmq repo and
installed version 3.0.2 on all hosts.
I can now access scanner B stats from A & B, but cannot
access stats for A on either hosts. Looking through configs
again.
In /etc/hosts I have the hostname and fqdn of each box
(10.10.1.41 realy-1.lctn.org [1] relay-1)
Links:
------
[1] http://realy-1.lctn.org/
[2] http://www.fluxlabs.net
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
