Re: [asterisk-users] MYSQL problem and configuration

[Karim H]

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 
-q12");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

[asterisk-users] MYSQL problem and configuration

[Jari-Pekka Lehtinen]

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