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
