Re: [asterisk-users] Realtime ERROR

2014-09-25 Thread Andrew Colin
Hi Rainer,

 

I am using roundrobin

 

From: Rainer Piper [mailto:rainer.pi...@soho-piper.de] 
Sent: Thursday, September 25, 2014 6:21 PM
To: Andrew Colin; Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] Realtime ERROR

 

Am 25.09.2014 um 16:24 schrieb Andrew Colin:

Hi Guys,

 

I have recently moved my database servers to a different database cluster
that runs on haproxy.

Every minute or so I get the following error in asterisk

 

MySQL RealTime: Ping failed (2006).  Trying an explicit reconnect

 

The strange thing is if I do realtime mysql status

It shows as connected just the timer resets.

 

Any idea why this is occurring?

 





Hi Andrew,

what balancing algorithm you use in haproxy.cfg  ?
balance source
balance roundrobin
or
balance leastconn



-- 
Rainer Piper 
Integration engineer 
Koeslinstr. 56 
53123 BONN 
GERMANY 
Phone:   +49 228 97167161 
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test) 
XMPP: rai...@xmpp.soho-piper.de

  _  

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4765 / Virus Database: 4025/8267 - Release Date: 09/24/14

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Realtime ERROR

2014-09-25 Thread Rainer Piper

Am 25.09.2014 um 16:24 schrieb Andrew Colin:


Hi Guys,

I have recently moved my database servers to a different database 
cluster that runs on haproxy.


Every minute or so I get the following error in asterisk

MySQL RealTime: Ping failed (2006).  Trying an explicit reconnect

The strange thing is if I do realtime mysql status

It shows as connected just the timer resets.

Any idea why this is occurring?




Hi Andrew,

what balancing algorithm you use in haproxy.cfg  ?
balance source
balance roundrobin
or
balance leastconn


--
*Rainer Piper*
Integration engineer
Koeslinstr. 56
53123 BONN
GERMANY
Phone: +49 228 97167161 
P2P: sip:rai...@sip.soho-piper.de:5072 (pjsip-test)
XMPP: rai...@xmpp.soho-piper.de
-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] Realtime ERROR

2014-09-25 Thread Andrew Colin
Hi Guys,

 

I have recently moved my database servers to a different database cluster
that runs on haproxy.

Every minute or so I get the following error in asterisk

 

MySQL RealTime: Ping failed (2006).  Trying an explicit reconnect

 

The strange thing is if I do realtime mysql status

It shows as connected just the timer resets.

 

Any idea why this is occurring?

 

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] Realtime error - PgSQL with 1.6 beta 5

2008-03-09 Thread Christian Svensson
Hello.

I'm testing the new Asterisk 1.6 beta 5. I'm using realtime to store
extensions and sip users.
When a user logs on, everything works fine - calls are also fine. But I keep
getting these in the console:

[Mar  9 16:31:58] WARNING[10284]: res_config_pgsql.c:195 realtime_pgsql:
PostgreSQL RealTime: Could not find any rows in table sip_users.

Full log: http://rafb.net/p/LO7DEM95.html

I think this part is a bit wierd:
Query: SELECT * FROM sip_users WHERE name = ''

Is this a bug or a known problem? I don't know where to even begin looking.
Again, everything seems to be in working order - it's just an annoyance.

Greetings,
-- 
Christian Svensson
Command Systems
___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

[asterisk-users] Realtime Error 1045

2006-12-05 Thread Andrew Joakimsen

Is there anything special that needs to be done? I am trying realtime
voicemail and no matter how I set it up, be it a user in mysql or through
host access rights with no username/password all I get is err 1045 which is
access denied. I have all the mysql stuff installed and it writes to the cdr
fine.
___
--Bandwidth and Colocation provided by Easynews.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users