AST_VDremote_agents.pl Error

[xCape]

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.

[mflorell]

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.

[mflorell]

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

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

[xCape]

This is the output:

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

Thanks.

[xCape]

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.

[mflorell]

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

[xCape]

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.

[mflorell]

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

[xCape]

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

[xCape]

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

[mflorell]

What kind of dialing are you doing?

What is your maximum dial ratio set to?

[xCape]

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:"?

[mflorell]

max dial level is in the campaign modification screen.

[xCape]

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.

[mflorell]

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.