MultiServer Problem

[wasdak]

Hi Matt,

I have problem with my multiserver vicidial, below is the logs.


:/var/log/astguiclient# tail -f action_process.2009-09-07
2009-09-07 21:05:03|LISTENER DEAD STOPPING PROGRAM... ATTEMPTING TO START keepalive SCRIPT||
2009-09-07 21:05:03|CLOSING DB CONNECTION||
2009-09-07 21:06:02|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
2009-09-07 21:06:04|LISTENER DEAD STOPPING PROGRAM... ATTEMPTING TO START keepalive SCRIPT||
2009-09-07 21:06:04|LISTENER DEAD STOPPING PROGRAM... ATTEMPTING TO START keepalive SCRIPT||
2009-09-07 21:06:04|CLOSING DB CONNECTION||
2009-09-07 21:07:02|LOGGED INTO MYSQL SERVER ON 1 CONNECTION||
2009-09-07 21:07:04|LISTENER DEAD STOPPING PROGRAM... ATTEMPTING TO START keepalive SCRIPT||
2009-09-07 21:07:05|LISTENER DEAD STOPPING PROGRAM... ATTEMPTING TO START keepalive SCRIPT||
2009-09-07 21:07:05|CLOSING DB CONNECTION||

[mflorell]

admin.php version and build?

How many servers?

What do you have running on each server?

[wasdak]

VERSION: 2.0.5-173
BUILD: 90320-0424

server1= apache / mysql

server2= asterisk

[mflorell]

And which of those servers is this output from?

astguiclient.conf?

[wasdak]

Hi Matt,

the output from the asterisk server.

# astguiclient.conf - configuration elements for the astguiclient package
# this is the astguiclient configuration file
# all comments will be lost if you run install.pl again

# Paths used by astGUIclient
PATHhome => /usr/share/astguiclient
PATHlogs => /var/log/astguiclient
PATHagi => /var/lib/asterisk/agi-bin
PATHweb => /var/www
PATHsounds => /var/lib/asterisk/sounds
PATHmonitor => /var/spool/asterisk/monitor
PATHDONEmonitor => /var/spool/asterisk/monitorDONE

# The IP address of this machine
VARserver_ip => 192.168.1.1

# Database connection information
VARDB_server => 192.168.1.3
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => 1234
VARDB_port => 3306

# Alpha-Numeric list of the astGUIclient processes to be kept running
# (value should be listing of characters with no spaces: 1234568)
# X - NO KEEPALIVE PROCESSES (use only if you want none to be keepalive)
# 1 - AST_update
# 2 - AST_send_listen
# 3 - AST_VDauto_dial
# 4 - AST_VDremote_agents
# 5 - AST_VDadapt (If multi-server system, this must only be on one server)
# 6 - FastAGI_log
# 7 - AST_VDauto_dial_FILL (only for multi-server, this must only be on one server)
# 8 - ip_relay (used for blind agent monitoring)
# 9 - Timeclock auto logout
VARactive_keepalives => 1234568

# Asterisk version VICIDIAL is installed for
VARasterisk_version => 1.2

[mflorell]

What happens when you run this on the Asterisk server:

/usr/share/astguiclient/AST_update.pl --debugX

[wasdak]

Its already fix Matt thanks for the response:

THIS IS THE OUTPUT OF DEBUG

|UPDATE server_updater set last_update='2009-09-08 4:28:55' where server_ip='192.168.1.1'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769997
*|EMPTY CHANNELS: 3|1|Privilege: Command

|DELETE FROM live_sip_channels where server_ip='192.168.1.1'|

|DELETE FROM live_channels where server_ip='192.168.1.1'|

|SELECT channel,extension FROM live_channels where server_ip = '192.168.1.1'|

|UPDATE server_updater set last_update='2009-09-08 4:28:56' where server_ip='192.168.1.1'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769996
*|EMPTY CHANNELS: 4|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.1.1'|

|UPDATE server_updater set last_update='2009-09-08 4:28:56' where server_ip='192.168.1.1'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769995
*|EMPTY CHANNELS: 5|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.1.1'|

|UPDATE server_updater set last_update='2009-09-08 4:28:57' where server_ip='192.168.1.1'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769994
*|EMPTY CHANNELS: 6|1|Privilege: Command

|SELECT channel,extension FROM live_channels where server_ip = '192.168.1.1'|

|UPDATE server_updater set last_update='2009-09-08 4:28:57' where server_ip='192.168.1.1'|
0|Response: Follows
1|Privilege: Command
concise: -1 loop: 5769993
*|EMPTY CHANNELS: 7|1|Privilege: Command

[ronaldmedina74]

hello, Can u please tell me how did u solve the problem ? and waht cause the problem ?

[wasdak]

I fix the problem by fixing the NTP