Page 1 of 1

Gardo : my.conf setting in GoautoDial

PostPosted: Fri Mar 23, 2012 4:05 am
by gmcust3
Somehow , my calls get STOPS and after doing some research I found that Mysql and Asterisk are NOT being able to syn properly.

I got an advice to change setting of my.cnf and increase few values.

But when I see ,my.cnf file under etc folder, I don't find any thing to change.

How to do it ?

Gardo, Can u advice plz ?

PostPosted: Fri Mar 23, 2012 4:06 am
by gmcust3
I get this Error in ASTERISK CLI before calls get stop :

ING[29909]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-af0d,2

Code: Select all

ING[29909]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-af0d,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30500]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-4c2a,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15]     -- SIP/Sip7-00000725 answered Local/8600062@default-cc57,1
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30459]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-b8b6,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15]   == Spawn extension (default, 8600062, 1) exited non-zero on 'Local/8600062@default-ec27,2'
[Mar 23 13:22:15]     -- Executing [h@default:1] DeadAGI("Local/8600062@default-ec27,2", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0---------------") in new stack
[Mar 23 13:22:15]     -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----0--------------- completed, returning 0
[Mar 23 13:22:15]     -- Executing [h@default:1] DeadAGI("Local/8600062@default-ec27,1", "agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----26-----3") in new stack
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15]     -- AGI Script agi://127.0.0.1:4577/call_log--HVcauses--PRI-----NODEBUG-----16-----ANSWER-----26-----3 completed, returning 0
[Mar 23 13:22:15]   == Spawn extension (default, 7161263312270, 2) exited non-zero on 'Local/8600062@default-ec27,1'
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[29772]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-92a4,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30233]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-4f85,2
[Mar 23 13:22:15] WARNING[30648]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-a595,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-6c42,2
[Mar 23 13:22:15] WARNING[30691]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@default-7afe,2
[Mar 23 13:22:15] WARNING[30603]: channel.c:985 __ast_queue_frame: Exceptionally long voice queue length queuing to Local/8600062@default-17e5,2
[Mar 23 13:22:15] WARNING[30680]: app_meetme.c:2463 conf_run: Unable to write frame to channel Local/8600062@de

PostPosted: Fri Mar 23, 2012 5:03 am
by gmcust3
I see


Code: Select all

# add extra parameters for mysql conf
cat > /etc/my.cnf << EOF
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-name-resolve
skip-host-cache
max_connections=200

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

EOF

Re: Gardo : my.conf setting in GoautoDial

PostPosted: Sun Mar 25, 2012 4:36 pm
by gardo
How did you find out that Asterisk and Mysql were not able to sync properly? What do you mean by not able to sync properly?

gmcust3 wrote:Somehow , my calls get STOPS and after doing some research I found that Mysql and Asterisk are NOT being able to syn properly.

I got an advice to change setting of my.cnf and increase few values.

But when I see ,my.cnf file under etc folder, I don't find any thing to change.

How to do it ?

Gardo, Can u advice plz ?

PostPosted: Sun Mar 25, 2012 9:56 pm
by gmcust3
In one of the forum posting .. someone also faced the same problem ... also when I restart mysql.. calls get start... but I have to ask my agents to log off and login..

U can also see

http://goautodial.org/boards/3/topics/356

PostPosted: Mon Mar 26, 2012 6:48 pm
by gardo
I'd go for Wilper's advice from: http://goautodial.org/boards/3/topics/356. Most probably your calls didn't terminate properly or the sessions got stuck somewhere clogging vicidial_xfer_log table.

Monitoring you asterisk CLI logs,Server logs and Mysql logs will give you an idea where to find the cause of the issue.
You can also check the stability of RTP connection/network connection between your Dialer and your carrier or sip switch.