> If Asterisk database can handle large amount of data, I would prefer it
> because of stability and speed. If Asterisk database can't handle that then
> I'll have to use MYSQL (or MSSQL which I prefer because I already store CDR
> to MSSQL).
>
> With internal database I have code like this.
>
> exten => _1XX,1,LookupCIDName
> exten => _1XX,n,Dial(SIP/${EXTEN},30,wt)
>
> How will it look like with mysql? Like this?
>
> exten => s,1,MYSQL(SELECT * FROM whatever)
> exten => s,n,Dial(SIP/${EXTEN},30,wt)
It would look like this:
exten => s,1,MYSQL(Connect dbcxnid HOST USER PASS DB)
exten => s,n,MYSQL(Query resultid ${cbcxnid} SELECT\ \*\ FROM\ whatever)
exten => s,n,MYSQL(Fetch fetchid ${resultid} VAR1\ VAR2\ VAR3\)
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${dbcxnid})
That's a general idea...check the voip-info wiki (asterisk cmd MYSQL)
_______________________________________________
--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
