Jay,
I just tried the suggested changes... same response.
I tested the script via command-line & it works fine.
[EMAIL PROTECTED] agi-bin]# php test.php
Content-type: text/html
X-Powered-By: PHP/4.3.9
VERBOSE"There have been"
VERBOSE"1 calls made"
[EMAIL PROTECTED] agi-bin]#
The permissions are correct:
-rwxr-xr-x 1 root root 1004 Dec 19 23:42 test.php
Any other thoughts?
Thanks,
bp
On 12/19/06, Jay Milk <[EMAIL PROTECTED]> wrote:
Does the script run from command-line? Without taking a close look at
this, the include statements in the function body of connect_db look
potentially messy.
Also, any output to stdout is interpreted by asterisk as a command, so
those fputs statements would be a problem -- do
fputs($stdout,"VERBOSE \"There have been\"\n");
fputs($stdout,"VERBOSE \"$row_count calls made\"\n");
instead.
William Piper wrote:
> List,
>
> I finally decided to break down & start playing with AGI scripts, but
> for the life of me, I can't figure out what I am doing wrong.
>
> Below is a super simple script to run a query in mysql to see how many
> call records there are for the extension calling in, then print the
> total in the CLI.
>
> This is all I get on the CLI:
> -- Executing AGI("SIP/216-0baa", "test.php") in new stack
> -- Launched AGI Script /var/lib/asterisk/agi-bin/test.php
> -- AGI Script test.php completed, returning 0
> -- Executing Hangup("SIP/216-0baa", "") in new stack
>
>
> Here is the script:
> #!/usr/bin/php -q
> <?php
> ob_implicit_flush(false);
> set_time_limit(6);
> $stdin = fopen("php://stdin","r");
> $stdout = fopen('php://stdout', 'w');
>
> function read() {
> global $stdin, $debug;
> $input = str_replace("\n", "", fgets($stdin, 4096));
> return $input;
> }
> function connect_db() {
> $database="asteriskcdrdb";
> include("./common.php");
> include("./dbconnect.php");
> }
>
> // parse agi headers into array
> while ($env=read()) {
> $env = str_replace("\"","",$env);
> $s = split(": ",$env);
> $agi[str_replace("agi_","",$s[0])] = trim($s[1]);
> if (($env == "") || ($env == "\n")) {
> break;
> }
> }
>
> // main program
> $clid = $agi[callerid];
> connect_db();
>
> $query1 = "SELECT * FROM cdr WHERE dst = '$clid' ";
> $query_result1 = @mysql_query($query1);
> $row_count = mysql_num_rows($query_result1);
> $row1 = @mysql_fetch_array ($query_result1);
>
> fputs($stdout,"There have been\n");
> fputs($stdout,"$row_count calls made\n");
>
> fflush($stdout);
> fclose($stdin);
> fclose($stdout);
> exit;
> ?>
>
> There are no debug errors and the query is going through just fine...
> and yes, I chmod 755.
> Does anyone have a clue what I am doing wrong?
>
> Thanks,
>
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com <http://easynews.com/>
--
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
