[Asterisk-Dev] ODBC problem

[Federico Alves]

I am facing a weird problem, and I am unable to do a debug on the cdr_ODBC.c
module simply because I don't know the tools to do it with on Linux. The
problem is: the first call logs just fine, but the seconds call gives me
this error:
cdr_odbc: Error in Query -1
       > cdr_odbc: Query FAILED Call not logged!
       > cdr_odbc: Connected to mssql
       > cdr_odbc: Reconnecting to dsn mssql
       > cdr_odbc: Trying Query again!
       > cdr_odbc: Error in Query -1
       > cdr_odbc: Query FAILED Call not logged!

The third call works, the fourth fails, etc. In SQL Server, I don't see
Asterisk login out, so the connection is still open, but I don't see
anything coming down when the call fails. It is not like cdr_odbc.c is
sending a malformed query; it is not sending anything at all. It performs a
new login eventually when the call succeeds.

My questions are: Is there any record of somebody having the same issue?
What tools are there in Linux to Language C visual debugging? Is there
anything like the Microsoft Visual Studio? If not, how do you people develop
and debug?

Yours truly,
Federico 

-----Original Message-----
From: asterisk-dev-admin at lists.digium.com
[mailto:asterisk-dev-admin at lists.digium.com] On Behalf Of
asterisk-dev-request at lists.digium.com
Sent: Sunday, April 11, 2004 1:00 PM
To: asterisk-dev at lists.digium.com
Subject: Asterisk-Dev digest, Vol 1 #563 - 4 msgs

Send Asterisk-Dev mailing list submissions to
	asterisk-dev at lists.digium.com

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.digium.com/mailman/listinfo/asterisk-dev
or, via email, send a message with subject or body 'help' to
	asterisk-dev-request at lists.digium.com

You can reach the person managing the list at
	asterisk-dev-admin at lists.digium.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Asterisk-Dev digest..."


Today's Topics:

   1. RE: Commercial Licensing of Asterisk? (Kevin Walsh)
   2. RE: How many users can one Asterisk server support? (Thomas
=?ISO-8859-1?Q?H=E4ger?=)
   3. Re: How many users can one Asterisk server support? (Olle E.
Johansson)
   4. Re: <<< SPHINX INTEGRATION >>> (Steven Critchfield)

--__--__--

Message: 1
From: "Kevin Walsh" <kevin at cursor.biz>
To: <asterisk-dev at lists.digium.com>
Subject: RE: [Asterisk-Dev] Commercial Licensing of Asterisk?
Date: Sun, 11 Apr 2004 09:25:03 +0100
Reply-To: asterisk-dev at lists.digium.com

Steven Sokol [ssokol at sokol-associates.com] wrote:
> How do you plan to use Asterisk?  The GPL restricts you from selling the
> code, but many people have commercial products that use Asterisk.
>
The GPL doesn't restrict you from selling the code; you can charge
whatever you like.  The GPL simply stipulates that if you distribute
Asterisk in any form then you must provide all of the source code under
the same license.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/


--__--__--

Message: 2
Subject: RE: [Asterisk-Dev] How many users can one Asterisk server support?
From: Thomas =?ISO-8859-1?Q?H=E4ger?= <asterisk-mailing at beronet.com>
To: asterisk-dev at lists.digium.com
Organization: beroNet GmbH
Date: Sun, 11 Apr 2004 10:29:40 +0200
Reply-To: asterisk-dev at lists.digium.com

Hi Oliver,

how i undertood the chan_sip module, there is a possibility to compile
this module with mysql support. This means there is a central mysql user
database where the registrations will also be updated, i think.

For the others: Correct me if i'am wrong :-)

Look at this:
http://www.voip-info.org/tiki-index.php?page=Asterisk%20sip%20mysql%20peers


Best regards,

Thomas.

Am So, den 11.04.2004 schrieb ops at infoserve.net um 6:52:
> Steven,
> 
> Thanks for the response. We have a broadband customer base of 30,000 that
we would like to offer VoIP services. We plan to use dual 3.0Ghz Xenon CPUs
> with 1GB dual DDR 400Mhz RAMs. Each server will have 8 PRIs and connected
at 100Mbps to the outside world. We will support only SIP devices. We think
we can support about 2,000 to 3,000 customers on each server. If that is the
case we will need about 10 Asterisk servers. The question is how do we link
up these servers and allow any user come in on any servers?
> 
> Have anyone tried this?
> 
> Oliver
> 
> 
> ---------- Original Message ----------------------------------
> From: Steven Sokol <ssokol at sokol-associates.com>
> Reply-To: asterisk-dev at lists.digium.com
> Date:  Fri, 09 Apr 2004 10:11:22 -0500
> 
> >Oliver,
> >
> >> 
> >> We are thinking of using the Asterisk platform to provide VoIP service
to
> >> our broadband customers. I have looked buy could not find any
information
> >> on the capacity of the Asterisk server. Suppose I use the fastest Intel
> >> CPUs in the server how many users can I support? 
> >> 
> >
> >Unfortunately, there is not single answer for this question.  It all
depends
> >on what you plan on doing with Asterisk, and how you intend to do it.  It
> >depends on the codecs you are using, the amount of protocol conversion
that
> >is happening, the amount of media processing (voice I/O) that is being
done,
> >the hardware you use, the number of PSTN connections, etc, etc.
> >
> >This is by no means meant to discourage you.  Asterisk is quite powerful
and
> >quite scalable.  Users on the list have reported using Asterisk with 8
PRI
> >spans (184 calls) all simultaneously active with positive results.
> >
> >What do you envision as your "typical" scenario?
> >
> >> Also, is it possible to
> >> run multiple Asterisk servers and somehow link them up in a seemless
> >> manner?
> >
> >Yes.  You can create a "mesh" or fabric of Asterisk systems using IAX2.
> >There are a few caveats.  The default Asterisk build will require you do
> >some work to manage a dial plan across multiple systems.  Also, if you
want
> >to create a central registry for IAX and SIP (and whatever else) so users
> >are not assigned to specific boxes, that also requires some changes or
the
> >use of a front-end proxy (for SIP).
> >
> >Again, this is not meant to discourage in any way.  What you plan to do
has
> >been done and works.
> >
> >-S
> >
> >
> >_______________________________________________
> >Asterisk-Dev mailing list
> >Asterisk-Dev at lists.digium.com
> >http://lists.digium.com/mailman/listinfo/asterisk-dev
> >To UNSUBSCRIBE or update options visit:
> >   http://lists.digium.com/mailman/listinfo/asterisk-dev
> >
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev


--__--__--

Message: 3
Date: Sun, 11 Apr 2004 11:57:16 +0200
From: "Olle E. Johansson" <oej at edvina.net>
Organization: Edvina AB
To: asterisk-dev at lists.digium.com
Subject: Re: [Asterisk-Dev] How many users can one Asterisk server support?
Reply-To: asterisk-dev at lists.digium.com

Steven Sokol wrote:
>>The question is
>>how do we link up these servers and allow any user come in on any servers?
>>
>>Have anyone tried this?
>>
> 
> 
> Unfortunately, Asterisk stores the registration information locally,
rather
> than in some centrally located data store.  In order to use it the way you
> want, you either need to alter it to use a central registry, or assign
> customers to specific servers.
> 
> I think that this is one of the reasons that many SIP service providers
use
> SER on the front end as the SIP proxy, and use Asterisk as a media gateway
> and media processing engine.
> 
> Anybody out there have a better answer?  I didn't scan the bug tracker for
a
> patch that provides central registration.  There may be a patch that
covers
> this issue.  I'll have to look.
MYSQL_FRIENDS store some registration data in a database, but not what is
needed to build a solution like the one you describe. There's been
discussions about it, but I've seen no code.

Use a SIP proxy as a front end, Asterisk as a back end is my advice.

/Olle

--__--__--

Message: 4
Subject: Re: [Asterisk-Dev] <<< SPHINX INTEGRATION >>>
From: Steven Critchfield <critch at basesys.com>
To: asterisk-dev at lists.digium.com
Date: Sun, 11 Apr 2004 09:28:32 -0500
Reply-To: asterisk-dev at lists.digium.com

On Sat, 2004-04-10 at 23:49, Matthew John Darnell wrote:
> > Thought Id just post to see if anyone has had any success with
integrating
> > CMUs SPHINX into Asterisk?
> 
> Does anyone know of a sample SPHINX install where you can upload a file
and
> see the text output?  Some TTS engines offer a demo like this; you type
your
> text in a box and download the .wav file.

Please understand that sphinx is a voice recognition software, not TTS.
-- 
Steven Critchfield <critch at basesys.com>



--__--__--

_______________________________________________
Asterisk-Dev mailing list
Asterisk-Dev at lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-dev


End of Asterisk-Dev Digest