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= '';
$database= 'x';
$username= 'x';
$password= '';
$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_age12);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: [EMAIL PROTECTED] To:
asterisk-users@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/___
--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
