[asterisk-users] Authorize & Microsoft SQL

[Steve Wofford]

There is nothing that ties asterisk and MS SQL together. MS SQL is just
a database and many Windows base PBX use MS SQL to store CDR amongst
many other things. What you do w/ the SQL data is up to you and can do
anything really.

 

Can you provide some more information on how this data is go get to the
asterisk system? Your asterisk system will need a SQL connection. I am
sure there are client libraries for Linux to allow a client to connect
to the SQL db. Once you have this connection you can call SQL for
authentication using a simple SQL query. You can pass back the results
and asterisk can process from there. I am only guessing here, but this
is going to be a programming/scripting job. I doubt there is any
software that does specifically what you ask.

 

I do tons of Microsoft SQL work so if you can define your requirements
and existing infrastructure I am sure we can help point you in the right
direction.

 

Steve Wofford

www.uctrlit.com

P.(949)743-0233 Ext. 200

 

From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Gregory
Malsack
Sent: Thursday, December 18, 2008 19:37
To: asterisk-users at lists.digium.com
Subject: [asterisk-users] Authorize & Microsoft SQL

 

Hello Everyone,

 

I have an installation where the client has a Microsoft SQL database
that holds all of their case information. They would like the asterisk
system to require users to enter a valid case number when making an
outgoing call. I'm seeing some documentation regarding people using
Microsoft SQL for CDR storage, however nothing regarding validating
authentication using a Microsoft SQL database.

 

Anyone have any suggestions?

 

Thanks,

Greg

 

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.552 / Virus Database: 270.9.19/1853 - Release Date:
12/17/2008 8:31 AM

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20081218/f80f45be/attachment.htm