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
neededif(!defined('STDIN')){
define('STDIN',fopen('php://stdin','r'));}if(!defined('STDOUT')){
define('STDOUT',fopen('php://stdout','w'));}if(!defined('STDERR')){
define('STDERR',fopen('php://stderr','w'));}#retrieve
all AGI variables from Asteriskwhile(!feof(STDIN)){
$temp=trim(fgets(STDIN,4096));
if(($temp=="")||($temp=="\n")) { break; }
$s=split(":",$temp);
$name=str_replace("agi_","",$s[0]);
$agi[$name]=trim($s[1]);}return $agi;}function checkresult($res){ trim($res);
if(preg_match('/^200/',$res)) {
if(!preg_match('/result=(-?\d+)/',$res,$matches)) {
fwrite(STDERR,"FAIL ($res)\n"); fflush(STDERR);
return0; } else { fwrite(STDERR,"PASS
(".$matches[1].")\n"); fflush(STDERR);
return $matches[1]; } } else { fwrite(STDERR,"FAIL
(unexpected result '$res')\n"); fflush(STDERR);
return -1; }}$agivar = init();$hostname= 'xxxx';
$database= 'xxxxx';
$username= 'xxxxx';
$password= 'xxxx';
$dbprotect = mysql_pconnect($hostname, $username, $password) or
trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database, $dbprotect);$result = mysql_query("SELECT * FROM
user_table WHERE user_age>12");while($entry =
mysql_fetch_array($result)) {fwrite(STERR, "Name : $entry['name'],
Age: $entry['age'] \n");fflush(STDOUT);$result =
trim(fgets(STDIN,4096));checkresult($result);}?>It will return things on the
asterisk CLI.... You can adapt this example for youI don't know if it help
but it shows a way to do...Kheraud> From: jp at speakplease.com> To:
asterisk-users at lists.digium.com> Date: Fri, 24 Aug 2007 12:56:55 +0300>
Subject: [asterisk-users] MYSQL problem and configuration> > Greetings
everyone> > I've set up a call recording system on debian 4.0 with
asterisk and mysql db> for handling user information (accessible over the net
for users). My> asterisk is running on one machine and the mysql on another.
The connection> is over lan. Now I have a problem and a question.> > My
problem is:> When mysql_real_connect doesn't get connection to the mysql
server asterisk> pretty much freezes and doesn't let any info go in or
out, even the CLI> freezes. I've seen a bug report on this but no
solution(?)> Although this might be a bug with asterisk when I have the
connection set to> a hosted mysql server (company that hosts our website
during the testing> period) the connection works fine so I've come to
conclusion that the> problem might be the mysql and/or debian configuration I
have. SO...> > My question is:> How should I configure mysql (and
debian box) for asterisk connections?> > Best regards> Jari-Pekka
Lehtinen> > > _______________________________________________>
--Bandwidth and Colocation Provided by http://www.api-digital.com--> >
asterisk-users mailing list> To UNSUBSCRIBE or update options visit:>
http://lists.digium.com/mailman/listinfo/asterisk-users
_________________________________________________________________
Le blog Messenger de Michel, candidat de la Nouvelle Star : analyse, news,
coulisses? A d?couvrir !
http://michel-nouvelle-star2007.spaces.live.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070824/ce3c99dc/attachment.htm
