similar to: Reporting Errors & Mysql

I've been trying to get a basic 5 question IVR survey working in an AGI script, and am having trouble with the SQL portion not updating the table. When I take out all the AGI references, and run just the perl script, the table updates with no problem(DBname,username,password have been substituted in this example for the actual values): #!/usr/bin/perl # # use DBI; $DATETIME =

Hi, We have a "simple" AGI script that provides some IVR functionality. It connects to a MySQL database in order to create a call record and capture IVR data. During the IVR process, we need to store the time the call started, so basically we INSERT a new MySQL row with callstart = NOW(), uniqueid = AGI(agi_uniqueid). As the user selects different options, we update the row to reflect

Hello,I am new to asterisk but i have vbeen scriptinh PHP SQL and webLanguages for a long time.I can Give you a solution but using php AGI:extensions.con-----> AGI(connect.agi);/var/lib/asterisk/agi-bin/connect.agi :#!/usr/bin/php -q<?phpset_time_limit(0);ob_implicit_flush();error_reporting(0);//Initialisation des entr?e-sortiefunction init() {#create file handles if

thanks Billy. I replaced print "STREAM FILE $filename \"\"\n"; with print "EXEC PLAYBACK $filename \n"; and it worked fine. Interestingly when I did print "STREAM FILE beep \"\"\n"; within the script, it worked. If I wasnt a newbie to asterisk I wouldve thought this to be strange. >From: "William Piper"

Hello Everyone! I've hit a bit of a roadblock and I am hoping that someone might point me in the right direction. I am using Asterisk 1.2.4 - I do not have the option of updating it, please do not waste your time telling me to =) I am using PERL AGI scripts to maintain an "active calls count" field for each phone in a mysql database table, for example (not actual code, just trying

Hello Everyone! I've hit a bit of a roadblock and I am hoping that someone might point me in the right direction. I am using Asterisk 1.2.4 - I do not have the option of updating it, please do not waste your time telling me to =) I am using PERL AGI scripts to maintain an "active calls count" field for each phone in a mysql database table, for example (not actual code, just trying

Hey, Is there any way to share?MySQL?connection between different agi's.Actually when call comes to asterisk box it executes various agi scripts sequentially. Each script checks various values by making a new?MySQL?connection and then execute query and then disconnects.? So,?Ideally?there should be one connection, and it should be reused between each agi and when a call is over it should be

I installed asterisk, astguiclient, php and mysql. but when i dialled one number to another number my asterisk server give the following error: > /var/lib/asterisk/agi-bin/agi-VDAD_ALL_inbound.agi > install_driver(mysql) failed: Can't load > '/usr/lib/perl5/site_perl/5.8.8/i486-linux-thread-multi/auto/DBD/mysql/mysql.so' > for module DBD::mysql: libmysqlclient.so.15:

I try to change something in ASTCC, but I am now totally blind, .... I hang on one line now. I changed: vpbx:/var/lib/asterisk/agi-bin # diff astcc-original.agi astcc.agi 22c22 < # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${EXTEN}) --- > # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${TARIFF},${EXTEN}) 35c35 < # exten =>

Ok so I updated my rails to version 1.1 and now all of a sudden I keep getting the dreaded "Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM ..." I''ve read all the stuff on the net, but none of it is working. I tried installing the mysql.so like suggested here: http://wiki.rubyonrails.org/rails/pages/HowToUseMySQLRubyBindingsOnWin32/ That sort

I can?t see cdrs for calls completed with astcc app, this is the log in asterisk console: DBD::mysql::db do failed: Unknown column 'callstart' in 'field list' at /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 31. -- AGI Script astcc.agi completed, returning 0 cdrs table exist but I am not sure why is empty and why was not created properly, any idea? --

Curious to know if anyone's created something similar to the following, if so and you'd care to share an AGI or dialplan, much appreciated. I will be eventually write a script to answer the nTH call. (if I can't find it (why reinvent wheels). Looking to do some testing sending anywhere between 50-200 calls to a machine. I'd like a Snom/Polycom/whatever to pick up after the nTh

I was looking for a (http socket module / mysql module) not using AGI(perl/php/shell) for asterisk in order to do intensive database / web server interactions as needed without performance to much overhead. Is there a real benefit in using : "Asterisk cmd MYSQL" app_addon_sql_mysql , I see it require perl DBD so it is not using Mysql C API, then there must be an instance of the perl

Boy, am I stuck... I'm officially ready to toss Asterisk out the window. I have to admit it isn't necessarily all the fault of Asterisk either. It just seems that every option I turn to suddenly ends in failure. I don't know if it's me that's bitten of more than I can chew with this project, or maybe Asterisk just isn't mature enough yet. Nothing complicated really....

I'm making changes to an Asterisk IVR designed by someone else. The application uses both func_odbc.conf and php agi to access an external MySQL database. In the php routines, I would like to use the persistent connection that is established in the dialplan, rather than creating a new connection each time they run. How can I do this? In res_odbc.conf, the context "asterisk"

Hello i have the following field (text string) in a MySQL database : "${KNUMMER} ${phone_number_to} ${phone_number_from} ${CHANNEL:4}" I read this string form the database and want to have the dialplan variables to be replaced with the correct content. How can I do this ? Currently this is not working. The variable ${PARAMS} contains the exact string of the database field : my

Hi all, I have the below peace of my AGI script...the problem here is that I cannot fetch the extension value to inside the script and assign it to another variable...I highlighted it in red #!/usr/bin/perl #use DBD::mysql; use DBI; use DBD::mysql; use Asterisk::AGI; ############################ #To read asterisk variable values. $AGI = new Asterisk::AGI; my %input = $AGI->ReadParse();

exten => auth_dial,1,DigitTimeout,5 exten => auth_dial,2,ResponseTimeout,15 exten => auth_dial,3,Read(dialed,IVR/en_enter_destination,0) exten => auth_dial,4,agi(call_start.php|${dialed}) exten => auth_dial,5,dial(SIP/${dialed}@146.82.15.241) I'm trying to get What they dialed put into the PHP script. How do I get the contents of this variable in the php script?

Hi all. Just to update list and increase the "souls-save" database. The patch solved the problem. Now I have an asterisk-1.2.0-beta1 with asterisk-perl-0.08 and mysql-server-3.23.58-16.FC2.1 machine working fine with ASTCC and "inuse" flag. The link of the patch is: http://bugs.digium.com/view.php?id=5400 Best regards to all you in the list. Ricardo Poppi.

What would it do if you exten => h,1,ResetCDR(w) exten => h,2,NoCDR() exten => h,3,DEADAGI(get-unqiueid.php) I have not tried it but in theory it should write the first CDR and then kill the write of the second NO ANSWER CDR. Let me know if it works for you as I may need to do it on some of my h exten code as well. Bryant ---------------------------------------- From: