FastAGI_log question

[roshisa]

Hi All,

I've got the following output by "screen-r ASTfastlog":

SERVER LOGGING ON: LEVEL-4 FILE-/var/log/astguiclient/FastAGIchildLOG.2009-06-28
2009/06/28-16:15:02 VDfastAGI (type Net::Server::PreFork) starting! pid(7982)
Binding to TCP port 4577 on host *
Setting gid to "0 0"
DBD::mysql::db do failed: Duplicate entry '1246195817.10' for key 'PRIMARY' at /usr/share/astguiclient/FastAGI_log.pl line 477, <STDIN> line 21.

Should I be concerned with it or no? I've checked the entry in call_log table and there is only one row for uniqueid that has this value.

My setup is as follows:

1. Server1 - Asterisk and Vicidial - two lan adapters:
- eth0 - x.x.x.x - phones register here
- eth1 - y.y.y.3 - interface for connection to the DB server, FTP server
Server1 runs Slackware 12.2 i386 SMP

2. Server2 - Apache and MySQL - two lan adapters:
- eth0 - z.z.z.z - for Agent loggins and RECORDINGS view
- eth1 - y.y.y.2 - MySQL and FTP daemon listen for connections from y.y.y.3
Server2 runs Slackware 12.2 i386 SMP

Here is my astguiclient.conf:
# 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 => /usr/local/apache2/htdocs
PATHsounds => /var/lib/asterisk/sounds
PATHmonitor => /var/spool/asterisk/monitor
PATHDONEmonitor => /var/spool/asterisk/monitorDONE

# The IP address of this machine
VARserver_ip => x.x.x.x

# Database connection information
VARDB_server => y.y.y.2
VARDB_database => asterisk
VARDB_user => cron
VARDB_pass => some_pass
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.4

# FTP recording archive connection information
VARFTP_host => y.y.y.2
VARFTP_user => cron
VARFTP_pass => some_pass2
VARFTP_port => 21
VARFTP_dir => RECORDINGS
VARHTTP_path => z.z.z.z

# REPORT server connection information
VARREPORT_host => y.y.y.2
VARREPORT_user => cron
VARREPORT_pass => some_pass2
VARREPORT_port => 21
VARREPORT_dir => REPORTS

# Settings for FastAGI logging server
VARfastagi_log_min_servers => 3
VARfastagi_log_max_servers => 16
VARfastagi_log_min_spare_servers => 2
VARfastagi_log_max_spare_servers => 8
VARfastagi_log_max_requests => 1000
VARfastagi_log_checkfordead => 30
VARfastagi_log_checkforwait => 60

Have I done it right or I've missed something?

[mflorell]

No, you shouldn't be that concerned, there are some places in ViciDial where duplicate rows are attempted to be inserted due to the inconsistent natire of how agents treat the agent interface(like closing their web browser in the middle of a call) so this kind of stuff is normal.

In SVN trunk we have removed even more of thesecases so this should happen less in future versions.