VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
vincent.delporte at bi...
Guest
|
 Posted: Wed Jan 16, 2008 11:02 am Post subject: [asterisk-users] Can DB() use SQLite instead of BerkeleyDB? |
 |
|
Hello
Before I bother calling a PHP script through AGI just to read a number
and rewrite the CID name... I was wondering if Asterisk could be
configured so that DB() uses a SQL server instead of the usual
BerkeleyDB?
============
;rewrite CIDNAME if found in DB
exten => cid,1,Set(CALLERIDNAME=${IF($["${CALLERID(name)}"=""]?<No CID
name>:${CALLERID(name)})})
exten =>
cid,n,Set(CALLERIDNAME=${IF($["${DB(cidname/${CALLERIDNUM})}"=""]?${CALLERIDNAME}:${DB(cidname/${CALLERIDNUM})})})
============
Thank you. |
|
| Back to top |
|
 |
tilghman at mail.jeffa...
Guest
|
| Posted: Wed Jan 16, 2008 1:10 pm Post subject: [asterisk-users] Can DB() use SQLite instead of BerkeleyDB? |
|
|
On Wednesday 16 January 2008 10:02:12 Vincent wrote:
| Quote: | Before I bother calling a PHP script through AGI just to read a number
and rewrite the CID name... I was wondering if Asterisk could be
configured so that DB() uses a SQL server instead of the usual
BerkeleyDB?
|
No, it cannot. You could use func_odbc to formulate your own queries,
though.
--
Tilghman |
|
| Back to top |
|
|
vincent.delporte at bi...
Guest
|
| Posted: Wed Jan 16, 2008 5:22 pm Post subject: [asterisk-users] Can DB() use SQLite instead of BerkeleyDB? |
|
|
On Wed, 16 Jan 2008 12:10:35 -0600, Tilghman Lesher
<tilghman at mail.jeffandtilghman.com> wrote:
| Quote: | No, it cannot. You could use func_odbc to formulate your own queries,
though.
|
Thanks. I don't like ODBC, but if it's stable and not a pain to
install/use, that could be the solution.
Otherwise, there's a new solution to use MySQL:
http://www.voip-info.org/wiki/view/Asterisk+cmd+MYSQL |
|
| Back to top |
|
|
tilghman at mail.jeffa...
Guest
|
| Posted: Wed Jan 16, 2008 9:23 pm Post subject: [asterisk-users] Can DB() use SQLite instead of BerkeleyDB? |
|
|
On Wednesday 16 January 2008 16:22:10 Vincent wrote:
| Quote: | On Wed, 16 Jan 2008 12:10:35 -0600, Tilghman Lesher
<tilghman at mail.jeffandtilghman.com> wrote:
| Quote: | No, it cannot. You could use func_odbc to formulate your own queries,
though.
|
Thanks. I don't like ODBC, but if it's stable and not a pain to
install/use, that could be the solution.
|
It's not a pain, other than the multiple configuration files. In fact,
it's really quite versatile, especially given that ODBC drivers exist for
virtually every database out there.
That's nothing new. It's been there since pre-1.0.
--
Tilghman |
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
