vicidial.org

Hello,

I am looking for anyone who could help me out with this error:

DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_VDremote_agents.pl line 406

AST_VDremote_agent causes the CPU to spike to 90-100% as it loops.

I am using the latest SVN trunk for astguiclient.
asterisk 1.2.19
Ubuntu 8.04.

Mysql server and client 5.0.51b

Thank you.

Try downloading this script and run it with the --debugX flag and see if it will do that same thing, I've streamlined the count(*) statements and added debug output.

sorry, here's the URL:
http://www.eflo.net/downloads/AST_VDremote_agents.txt

(you will need to save it as ".pl")

This is the output:

DBD::mysql::st fetchrow_array failed: fetch() without execute() at AST_VDremote_agents.pl line 568

Thanks.

Actually this output looks more like what you want:

-----DEBUGGING -----


----- SUPER-DUPER DEBUGGING -----

TIME DEBUG: |1|1| GMT: 11:13
DBI connect('asterisk:172.20.100.7:3306','cron',...) failed: Can't connect to MySQL server on '172.20.100.7' (111) at AST_VDremote_agents2.pl line 151
Couldn't connect to database: Can't connect to MySQL server on '172.20.100.7' (111) at AST_VDremote_agents2.pl line 151.

Edit: forget it i was using the wrong client version.

just uploaded a new version to the same address. Please try it again.

Well, I think the problem had to do with the database. I installed MySQL server using apt-get. Once I removed it and compiled it maually I was able to make calls with out that problem. When I attach to ASTVDremote it gives me:

no command line options set

Is this what it is supposed to say?

Also, if this question was asked before I am sorry for repeating it. What would be your recommendation for the "Number of Lines" for a remote agent that has 4 full PRI T1s and has the web server and database on separate servers?

Thank you very much.

I'm glad the system is working ofr you now. As for the recommendation, what is the hardware being used?

Each server is a Dell PE R200 with 4 gigs of ram and a 2.66ghz Zeon quad core.

Would 50 lines assigned to I remote agent be too much?

What kind of dialing are you doing?

What is your maximum dial ratio set to?

What kind of dialing are you doing?
My dialing campaign dials a group of numbers and leaves one message if an answering machine is detected and separate message if it is answered by a human.

What is your maximum dial ratio set to?
Where is the dial ratio set? is it "Max VICIDIAL Trunks:"?

max dial level is in the campaign modification screen.

I have "Maximum Adapt Dial Level" set to 4, Number of lines in "REMOTE AGENTS MODIFIED" set to 20, and I have "Max VICIDIAL Trunks" set to 92.

I was just wondering if I should increase my number of lines in "REMOTE AGENTS MODIFIED" to increase the amount of calls per hour.

If you are doing live agents with this then those settings should be fine. If you are doing a messaging campaign then you should set the Campaign dial ratio to 1 and the dial method to RATIO.