asterisk users - Dec 2004 - Tie web application to VOIP

I want to tie my web application (built using .NET + MS SQL Server)
into a VOIP service so that users can call each other.  I want them to
interface with my application's username system.

On the receiving user's end, he can either receive the call using a
VOIP phone, or windows application (like skype).

I would use Skype's API, but it appears I need to use their username
system, and not my own.

My question is, what software/hardware solutions would I need to do
this?  Any suggestions/feedback would be greatly appreciated.

Btw, I was told that Asterisk + SER would do the trick.  However, I'm
a newbie to the world of VOIP.  If someone can give me some
tips/hints, it would be great.

Any particular reason you want to do it in .NET and MS SQL?  I personally
would write applications in something a bit more portable.  Just curious.

And I wouldn't use skype for anything, but then again, I am a bit
anti-skype as well.

-mishehu
> I want to tie my web application (built using .NET + MS SQL Server)
> into a VOIP service so that users can call each other.  I want them to
> interface with my application's username system.
>
> On the receiving user's end, he can either receive the call using a
> VOIP phone, or windows application (like skype).
>
> I would use Skype's API, but it appears I need to use their username
> system, and not my own.
>
> My question is, what software/hardware solutions would I need to do
> this?  Any suggestions/feedback would be greatly appreciated.
>
> Btw, I was told that Asterisk + SER would do the trick.  However, I'm
> a newbie to the world of VOIP.  If someone can give me some
> tips/hints, it would be great.
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
> !DSPAM:41cc921930314968028340!
>
>

> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-
> bounces@lists.digium.com] On Behalf Of Steven Critchfield
> Sent: Friday, December 24, 2004 9:38 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: RE: [Asterisk-Users] Tie web application to VOIP
> 
> On Fri, 2004-12-24 at 20:17 -0600, Michael Giagnocavo wrote:
> > >Any particular reason you want to do it in .NET and MS SQL?  I
> personally
> > >would write applications in something a bit more portable.  Just
> curious.
> >
> > MS SQL 2005 Express is probably the best free DB out there? And I
run
> lots
> > of Mono code just fine...
> 
> Thats highly debateable as you have a insane prerequisite of running
> windows first. So you start with an insecure crap software as the
base.
> How can you have anything that is really worth the time of running
when
> it is first built on top of crap?
> 
> --
> Steven Critchfield <critch@basesys.com>
> 
Steven,

Just a quick reminder, MS SQL on Windows is hands down the best
performing transact SQL database on the planet, and Oracle on Windows is
a close #2. Some might argue that Oracle is #1 and MS is #2. Anyone that
argues any Linux SQL db even comes close in performance better provide
some evidence to back their argument. The asp.net SQL database providers
for MS SQL and Oracle SQL are highly optimized direct socket interfaces
to the SQL server. (no odbc crap!) You would be hard pressed to build a
faster web app than asp.net talking to MS or Oracle SQL servers with the
native .net provider.

It will not surprise me a bit to see the better of the asterisk web
front ends on MS platforms, primarily because the larger companies that
might use * in the future already use MS SQL and Oracle for their
customer databases.

Don't get me wrong, I have nothing against UNIX/Linux, I just know that
both windows and Linux have their place in the world.

Hi, 
> -----Original Message-----
> I want to tie my web application (built using .NET + MS SQL Server)
> into a VOIP service so that users can call each other.  I want them to
> interface with my application's username system.
> 
> On the receiving user's end, he can either receive the call using a
> VOIP phone, or windows application (like skype).
> 
> I would use Skype's API, but it appears I need to use their username
> system, and not my own.
> 
> My question is, what software/hardware solutions would I need to do
> this?  Any suggestions/feedback would be greatly appreciated.
> 
> Btw, I was told that Asterisk + SER would do the trick.  However, I'm
> a newbie to the world of VOIP.  If someone can give me some
> tips/hints, it would be great.
Okay, lets cut it out with all the database and OS flamewars.

In general, and almost entirely independent of what database you are using,
you could do the following:

Have a linux machine with your VoIP setup (Asterisk would be my choice of
the moment) and create a cronjob on there that will check if the database
has modified entries (i.e. through the ODBC layer). If so, you create
(partial) configuration files that suit your needs and reload the asterisk
machine.

Only issue is: You will need to have cleartext passwords in your database. I
am aware this is a bad design issue, but the only workaround I can come up
with is not acceptable to me: If you can enforce md5 authentication on all
your users, you'd have enough with the md5 hash in the database.

Florian

> >Steven,
> >
> >Just a quick reminder, MS SQL on Windows is hands down the best
> >performing transact SQL database on the planet, and Oracle on Windows
is
> >a close #2. Some might argue that Oracle is #1 and MS is #2. Anyone
that
> >argues any Linux SQL db even comes close in performance better
provide
> >some evidence to back their argument.
> >
> I think I would cite Oracle. They say their database runs much better
on
> Linux than on Windows. If Oracle on Windows is arguably better than MS
> SQL, Oracle on linux must be a hands down winner.
Actually, Oracle just posted a claim that they are the world record
holder, but they did so using 12 AMD Opterons, interestingly enough the
last time they boasted about performance it was on Intel CPUs. Maybe it
is AMD that is the real winner...

http://www.oracle.com/solutions/performance_scalability/tpch1tb_hplinux_
1004.html
> The last time I used MS SQL was about 5 years ago, but it was hands
down
> the biggest heap of crap in the database world back then. I guess it
has
> improved, but if you think its the best out there I guess you haven't
> tried very much stuff.
5 years ago, must have been SQL 6.5 or 7.0, and yes, it has improved, in
fact for a number of years SQL 2000 was 2x faster than Oracle on any
platform.
> > The asp.net SQL database providers
> >for MS SQL and Oracle SQL are highly optimized direct socket
interfaces
> >to the SQL server. (no odbc crap!)
> >
> I think you've been drinking the Koolade.
Actually, I prefer scotch, but then again, I am the one that defends
windows, so what do I know. Maybe SAP, PeopleSoft, Siebel, and most
other Enterprise software vendors are drunken idiots too. I make a
living implementing these solutions, and I would love to see a Linux
alternative, but to date it does not exist. Oracle on Linux is nice, but
sure is a bitch integrating the security with Windows desktops.
 
Now that we are completely off topic, lets get back to what this was
about in the first place, The person that started this thread was asking
about the possibility of using ASP.net/SQL as a front end to *. Very
possible, and an added benefit would be you might be able to use a
single database for your user interface, accounting, * and SER configs,
marketing, billing, etc since MS SQL is supported by more applications
than any other database on earth.

This is the direction we are moving towards, and it does look promising.

Any suggestions for a Linux based accounting and CRM package?

Damon

>Just a quick reminder, MS SQL on Windows is hands down the best
>performing transact SQL database on the planet, and Oracle on Windows is
>a close #2. Some might argue that Oracle is #1 and MS is #2. Anyone that
Does Oracle have a decent-featured free version of their db software? That
was my original point, and where MS SQL 2005 is quite in the lead (limited
only to 1GB of RAM, 4GB DB, and 1 CPU).

-Michael

They have a free version coming out that raises the limit to 8 gig I 
believe.



Gary
> Does Oracle have a decent-featured free version of their db software? That
> was my original point, and where MS SQL 2005 is quite in the lead (limited
> only to 1GB of RAM, 4GB DB, and 1 CPU).
>
> -Michael
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>

----- Original Message ----- 
From: "K J" <drpr0ctologist@gmail.com>
To: <asterisk-users@lists.digium.com>
Sent: Friday, December 24, 2004 10:06 PM
Subject: [Asterisk-Users] Tie web application to VOIP

> I want to tie my web application (built using .NET + MS SQL Server)
> into a VOIP service so that users can call each other.  I want them to
> interface with my application's username system.
> 
> On the receiving user's end, he can either receive the call using a
> VOIP phone, or windows application (like skype).
> 
> I would use Skype's API, but it appears I need to use their username
> system, and not my own.
> 
> My question is, what software/hardware solutions would I need to do
> this?  Any suggestions/feedback would be greatly appreciated.
> 
> Btw, I was told that Asterisk + SER would do the trick.  However, I'm
> a newbie to the world of VOIP.  If someone can give me some
> tips/hints, it would be great.
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>