HELP! broken pipe error in agi script

cha_aries90
Joined: Wed 10 of Feb, 2010

HELP! broken pipe error in agi script

Posted:Wed 10 of Feb, 2010 (03:38 UTC)
Hello good day,

I am new to agi scripting. I am doing a project on asterisk 1.6 and sugarcrm integration. I want to access the sugarCRM database through AGI, i tried using the script below but it seems there's a problem in accessing the sugarCRM.. please help, any ideas why this doesn't work?

phpscript,php

#!/usr/bin/php -q
<?php
session_start();
set_time_limit(30);
require('phpagi.php');
error_reporting(E_ALL);
$agi = new AGI();
$agi->answer();
$callernumber = $agi->request["agi_callerid"];
$callername = $agi->request["agi_calleridname"];
$agi->say_digits($callernumber);
$agi->verbose("****************************mysql start***************************************",1);

$openDB = mysql_connect("http://localhost","root","")or die('Cannot connect to database!!!');
mysql_select_db("sugarcrm", $openDB);
$agi->verbose("****************************mysql start22222***************************************",1);
?>

extensions.conf
exten => 3000,1,AGI(phpscript.php)
exten => 3000,2,Dial(SIP/3000,30)
exten => 3000,n,Hangup

output in cli
phpscript.php: AGI Request:
phpscript.php: Array
phpscript.php: (
phpscript.php: [agi_request] => phpscript.php
phpscript.php: [agi_channel] => SIP/3001-00000009
phpscript.php: [agi_language] => en
phpscript.php: [agi_type] => SIP
phpscript.php: [agi_uniqueid] => 1265770344.9
phpscript.php: [agi_version] => 1.6.0.20
phpscript.php: [agi_callerid] => 3001
phpscript.php: [agi_calleridname] => cha
phpscript.php: [agi_callingpres] => 0
phpscript.php: [agi_callingani2] => 0
phpscript.php: [agi_callington] => 0
phpscript.php: [agi_callingtns] => 0
phpscript.php: [agi_dnid] => 3000
phpscript.php: [agi_rdnis] => unknown
phpscript.php: [agi_context] => incoming
phpscript.php: [agi_extension] => 3000
phpscript.php: [agi_priority] => 1
phpscript.php: [agi_enhanced] => 0.0
phpscript.php: [agi_accountcode] =>
phpscript.php: [agi_threadid] => -1226949776
phpscript.php: )I>
phpscript.php:
phpscript.php: PHPAGI internal configuration:
phpscript.php: Array
phpscript.php: (
phpscript.php: [phpagi] => Array
phpscript.php: (
phpscript.php: [debug] => 1
phpscript.php: [error_handler] => 1
phpscript.php: [admin] => admin@myserver.host.com
phpscript.php: [hostname] => localhost.localdomain
phpscript.php: [tempdir] => /var/spool/asterisk/tmp
phpscript.php: )
phpscript.php: LI>
phpscript.php: [asmanager] => Array
phpscript.php: (
phpscript.php: [server] => localhost
phpscript.php: [port] => 5038
phpscript.php: [username] => root@localhost.localdomain
phpscript.php: [secret] => password
phpscript.php: )
phpscript.php:
phpscript.php: [fastagi] => Array
phpscript.php: (
phpscript.php: [setuid] => 1
phpscript.php: [basedir] => /var/lib/asterisk/agi-bin/
phpscript.php: )
phpscript.php:
phpscript.php: [festival] => Array
phpscript.php: (
phpscript.php: [text2wave] => /usr/bin/text2wave
phpscript.php: )
phpscript.php:
phpscript.php: [cepstral] => Array
phpscript.php: (
phpscript.php: [swift] => /usr/local/bin/swift
phpscript.php: [voice] => Allison-8kHz
phpscript.php: )
phpscript.php:
phpscript.php: )
phpscript.php:
[Feb 10 10:52:25] NOTICE[3870]: channel.c:2941 __ast_read: Dropping incompatible voice frame on SIP/3001-00000009 of format ulaw since our native format has changed to 0x2 (gsm)
phpscript.php: ****************************mysql start***************************************
[Feb 10 10:52:27] ERROR[3870]: utils.c:1019 ast_carefulwrite: write() returned error: Broken pipe
[Feb 10 10:52:27] ERROR[3870]: utils.c:1019 ast_carefulwrite: write() returned error: Broken pipe


can anyone please help?
i am using asterisk 1.6.0.20


thanks