[Asterisk-Users] Re: Re: Asterisk on SuSE 9.1?

2004-12-16 Thread Reinhard Max
Hi,

On Tue, 14 Dec 2004 at 09:33, Rick Green wrote:

  (WHy is this?! I've noticed it with every sound card I've ever
 tried, and it infuriates me that I have to deal with feedback from
 the analog loopback in the sound card!  Supposedly these soundards
 are full-duplex, so why are they looped by default, instead of
 keeping the inputs and outputs totally separated!)

maybe because the sound cards are also being used for karaoke.

   ANybody know how to do an alsa.conf or set a mixer to fix this?

Turn down the controller for the mic completely. It only controls how
much from the mic's signal goes through the analog mixer directly to
the speaker or line output, but has usually nothing to do with
capturing.

Then make sure that you have selected the mic as the input for
capturing, and use the input gain controller to adjust the recording
level. Depending on the sound card the mixer might have additional
controls like a switch for a 2nd microphone or a mic boost switch that
might need to be adjusted to get capturing from the mic working
properly.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] RE: Re: Voice in Asterisk with BRI ISDN Anyproperworking configurations yet?

2004-11-19 Thread Reinhard Max
Hi,

On Fri, 19 Nov 2004 at 10:37, Christiaan Brink wrote:

 I have a HFC based ISDN BRI card in a Fedora Core 2 box (2.6.5
 kernel).  I was just wondering, is zaphfc the best way to interface
 this type of card with Asterisk?

you might be able to interface these cards with mISDN as well (I don't
know the current status of that), but zaphfc is certainly a better
choice, because zaptel drivers have much less latency than CAPI.


cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Using AVM C4 with fewer than four lines?

2004-10-28 Thread Reinhard Max
Hi,

On Thu, 28 Oct 2004 at 12:16, Louis van Dompselaar wrote:

 Does anyone know of a way to disable the ports on the C4 that are
 not connected?

I think changing devices=4 to devices=2 in capi.conf should do the
trick. Of course you have to make sure that your ISDN lines are
connected to the two ports that haven't been disabled.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Re: Using AVM C4 with fewer than four lines?

2004-10-28 Thread Reinhard Max
On Thu, 28 Oct 2004 at 14:08, Louis van Dompselaar wrote:

 It's already at devices=2 but that doesn't make a difference.

Sorry, I was looking at the wrong place and drawing the wrong
conclusions ...

 I think chan_capi sees the C4 as one single device with four
 controllers.

A device corresponds to a B-chanel in capi.conf. See the capi.conf
form chan_capi source tarball - it uses devices=2 for BRI lines, and
devices=30 for PRI lines.

So the C4 appears to chan_capi as 4 controllers with 2 devices each.

You need to set up a separate interface section for each controller
that is actually in use, and just skip the rest:

[interfaces]

; The first controller
msn=...
...
controller=1
devices=2

; The second controller
msn=...
...
controller=2
devices=2

 Contr1: 2 B channels total, 2 B channels free.
 Contr2: 2 B channels total, 2 B channels free.
 Contr3: 2 B channels total, 2 B channels free.
 Contr4: 2 B channels total, 2 B channels free.

capi info reports all the CAPI devices that exist in the system, but
that doesn't mean it is really using them all.

If you start Asterisk in verbose mode asterisk -vc , you should see
a warning like this for every unused CAPI controller:

Oct 28 15:41:04 WARNING[1076791936]: chan_capi.c:2786 load_module: Unused contr2

This is what I get on a system with a C2 card where only one of the
two controllers is configured in capi.conf.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: quadBRI ISDN telephone

2004-05-10 Thread Reinhard Max
Pedro,

On Fri, 7 May 2004 at 10:51, Pedro Vela wrote:

 We have a quadBRI in NT mode with bri_cpe_ptmp signalling and when
 connect a ISDN telephone to this nothings happen.
 
 What can I do?

- You have to use the right signalling (bri_net_ptmp)

- The phone has to be connected to the card with a crossed cable

- The phone needs power

There are (at least) three ways to get power to the phone:

 - A power feeding module for the quadBRI cars.
 - A phone that has it's own power suply.
 - A NT1 (it could eveb be a broken one) that is being used as a power
   supply for the BRI link in question.

See section 2.2 in

  http://www.pbx4linux.com/download/doc/PBX4Linux.htm

for details on making a crossover cable for ISDN and using an old NT1
as a power supply.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Trouble compiling chan_capi on Suse 9.0

2004-04-13 Thread Reinhard Max
Hi,

On Mon, 12 Apr 2004 at 19:49, asterisk wrote:

[...]
 chan_capi.c: In function `pipe_frame':
 chan_capi.c:1187: error: too many arguments to function `ast_dsp_process'
 make: *** [chan_capi.o] Error 1

This looks like you are trying to compile chan_capi against a version
of Asterisk (or installed Asterisk headers), that is either too old or
too new, i.e. the two are expecting a different number of arguments to
the ast_dsp_process function.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Convert ISDN Card in NT Mode

2004-03-23 Thread Reinhard Max
Hi,

On Tue, 23 Mar 2004 at 09:35, Ignace CARIA wrote:

 My question is: is it possible to convert the second ISDN card into
 NT-Mode?

yes.

 If yes, which card must I use?

One that is based on the HFC-S chipset. They are available from 
various manufacturers and priced around 30 Euro here in Germany.

 How should I configure it?

You need the zaphfc driver which is part of the bri-stuff package that
can be found here:

http://www.junghanns.net/asterisk/downloads

The most recent version is 0.0.2rc12, but the author told me he soon
will upload a much improved 0.0.2rc13.

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: SoftFAX/spandsp: installing and results on Gentoo/SuSE

2004-03-23 Thread Reinhard Max
Hi,

On Tue, 23 Mar 2004 at 15:36, Diego Ercolani wrote:

 I've found the same unresolved issue with libtiff. I use SuSE 9.0

SuSE Linux 9.0 comes with libtiff-3.5.7 which allows to compile and
run Steve's fax applications just fine with the additional headers
provided by him. So which unresolved issue do you have with it?

cu
Reinhard
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Error compiling zaptel

2004-03-04 Thread Reinhard Max
Hi,

On Thu, 4 Mar 2004 at 11:29, Hans-Henrik Andresen wrote:

 But when compiling zaptel I got this error
 [...]
 zaptel.c:5892: error: parse error before unsigned
 make: *** [zaptel.o] Error 1

 Any help on this ?

you left out the important part of the error log. I guess the compiler
complains about a header file it doesn't find before throwing all
those parse errors.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Zaptel BRI and HFC-S cards

2004-02-18 Thread Reinhard Max
On Tue, 17 Feb 2004 at 21:07, Armand A. Verstappen wrote:

 Note that when using more than one card, the module will segfault
 when unloading:

I also get this with a single HFC-S card when I try to unload the
zaphfc module once it has been used by Asterisk.


cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: HFC-S cards?

2004-02-17 Thread Reinhard Max
Hi,

On Mon, 16 Feb 2004 at 17:22, FastJack wrote:

 anyone knows where to get one of theses cards (or any other based on
 the HFC-S chipset) in germany?

I bought a Longshine LCS-8051 Card recently.
http://www.longshine.de/produkt-ger/modem/8051.htm
It works with i4l and zaphfc.

K+K Computer sells them for EUR 28.59 + shipping.
http://www.kkcomputer.de

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Need to interface to BRIs

2004-02-16 Thread Reinhard Max
Hi,

On Mon, 16 Feb 2004 at 04:10, Jim Archer wrote:

 I would like to interface 4 BRI lines to Asterisk.  I looked at
 Digium's hardware list and, although they have solutions for PRI and
 T1, I didn't see anything for BRI.  I would like to avoid ISDN4Linux
 if possible.  Does anyone know of any hardware suppoted by Asterisk
 I can use for this?

http://www.junghanns.net/asterisk/page17.html

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Mailing list lag again

2004-02-16 Thread Reinhard Max
Hi,

today's BRI thread showed, that the mailing list has a delay of about
an hour again. Is this still due to the Digium relocation, or is
something else going on with the list server?

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: USB headset recommendations

2004-01-23 Thread Reinhard Max
On Thu, 22 Jan 2004 at 23:36, Ken Alker wrote:

 I'd like to get some feedback from users of USB headsets as to what
 they like/dislike about the unit they own (manufacturer/model
 number).

I've got a Labtec Axis 712 stereo USB headset. They also produced it
in a mono version (Axis 711). Both devices have disappeared from the
Labtec homepage, but retailers still seem to have them on stock, e.g.:

http://www.thinkgeek.com/computing/speakers/headsets/5de1

It is supported by ALSA, and by the kernel's native USB audio driver.
Sound quality is great, but the box with the volume and mute buttons
on it is a bit clunky for my taste.

I've had some problems getting it to work on various USB ports based
on VIA chipsets (Intel worked fine), but that doesn't seem to be the
fault of the headset, as other USB devices were having problems on
theese VIA chipsets as well.

 Any advantages/disadvantages to using a USB headset over a regular
 headset slaved off the internal sound card?

And advantage of having the headset separate from the internal sound
card is, that you can use the latter for playing the phone ring sound
which would be too silent if only played on the speakers of the
headset.

 Are you using yours in a call center environment?

No, only for testing so far, but I think it would be OK for a call
center env.

 As an aside, do all USB headphones have built-in sounds cards?

I think so.

 If so, are the built-in cards always full duplex?

I would assume so, as most applications of a hadset require it to
support full duplex. Also, I don't think anybody is still making sound
cards that aren't full duplex these days.


cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Compiling problems with SuSE

2004-01-19 Thread Reinhard Max
On Mon, 19 Jan 2004 at 06:26, Franz Edler wrote:

  From: Dustin Knuttgen on Sunday, January 18, 2004 11:47 PM

  We tried to use SuSE initially and had no luck compiling zaptel on
  either 8.2 or 9.0. We even had Digium take a look. After working
  on it for days we finally switched to Red Hat 9.

 Is there anyone who succeeded in compiling Asterisk with SuSE 8.2 or
 9.0?

I have no problems compiling Asterisk on SuSE, but I've never tried
zaptel.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: compiling problems

2004-01-19 Thread Reinhard Max
Hi Franz,

On Sun, 18 Jan 2004 at 21:47, Franz Edler wrote:

 Now I learned, that I have to provide also the kernel-sources for
 compiling zaptel. I have done that,

have you also copied the running kernel's configuration to the kernel
sources

zcat /proc/config.gz  /usr/src/linux/.config

and executed

make oldconfig
make dep

in /usr/src/linux ? These steps might be needed for compiling external
kernel modules like zaptel.

 but at the end of make install of zaptel I get the following errors
 on unresolved symbols:

 /sbin/depmod -a

If the above doesn't help please run 'depmod -ae' to see the names of
the symbols it can't resolve. Maybe the names can give a hint where to
look next.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] RE: Fax

2004-01-14 Thread Reinhard Max
Hi,

On Tue, 13 Jan 2004 at 21:06, Jason Penton wrote:

 (I have successfully managed to receive faxes thru my isdn card so I
 don't see why I shouldn't be able to send them).

that's interesting, as in my tests it was just the other way around.

I can send faxes through my AVM ISDN card (chan_capi), but when I try
to receive a fax, app_rxfax fails after reporting some carrier
training errors. I've posted the detailed error logs to this list some
weeks ago.

Jason, are you using chan_capi, or chan_modem_i4l to access your ISDN
card?

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: newbie ISDN question

2004-01-14 Thread Reinhard Max
Hi,

On Wed, 14 Jan 2004 at 12:15, Klaus-Peter Junghanns wrote:

 The quadBRI card is EUR 600, excluding VAT.

this looks like a great piece of hardware, but I think it's too
expensive for home users like me who wouldn't really need more than
one or two BRI ports.

So do you have any plans for a singleBRI or doubleBRI version of this
card, or maybe even a variant that comes with a single port
preinstalled and three more ports can be added as needed via
daughterboards like on the TDM400P?

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: newbie ISDN question

2004-01-14 Thread Reinhard Max
Hi,

On Wed, 14 Jan 2004 at 15:11, Klaus-Peter Junghanns wrote:

 Currently i am polishing the driver for the hfc-s pci a chipset,
 which i used in numerous el-cheapo ISDN cards (street price around
 30 EUR).

ah - that's much closer to the home user's typical budget :)

Is there a list of cards that use this chipset somewhere on the 'net?
I've googled for it, but most pages only talk about cards based on
the HFC-S chipset without listing brand and model names.

 This will bring zaptel BRI (and even NT mode) to the home user. :)

Cool, NT mode is exactly what I am looking for :)

Thanks for the great work you are doing to bring Asterisk to the ISDN
world!

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: tunnel iax via gnophone with ssh?

2003-11-20 Thread Reinhard Max
Hi,

On Thu, 20 Nov 2003 at 08:44, Chris Hirsch wrote:

 Anybody have any ideas?

Asterisk uses UDP, but ssh can only forward TCP ports.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: Soft fax (rxfax) 8 byte output problem resolved?

2003-11-13 Thread Reinhard Max
Hi,

On Wed, 12 Nov 2003 at 13:53, David Carr wrote:

 I have read all the mailing list posts regarding rxfax receiving a
 fax and outputing an 8 byte tif file (tif header only). This is the
 problem I can't seem to get past.

I think this is not necessarily a single problem. As I understood
Steve the 8 byte tiff file just means, that there was no fax received,
which can have various reasons.

 Has anyone out there also had this problem and found some workaround
 for it?

I don't have a workaround so far, but I'll try to give as much detail
as possible of what's happening on my installation, in the hope that
it helps Steve to find out what's going wrong.

The Asterisk machine is a K6/333 (too slow?), connected to the
internal ISDN line of a small ISDN PBX (chan_capi). I've tried to
receive faxes from a real fax machine and from a fax modem with no
success. Both devices are connected to analog lines of the PBX.

I run Asterisk in verbose mode, and try sending a Fax from the
modem with sendfax (http://alpha.greenie.net/mgetty).

After some time sendfax prints out the following message and exits:

  sendfax: FAILED to transmit 'f1.g3'.
  Transmission error: +FHNG:20 (Unspecified Transmit Phase B error)

Asterisk's log looks like this:

-- Executing RxFAX(CAPI[contr1/98]/0, /tmp/fax.tif) in new
stack
Changed from phase 0 to 1
Start receiving document
Changed from phase 1 to 4
Sending ident
 CSI: 40 38 37 36 35 34 33 32 31 20 20 20 20 20 20 20 20 20 20 20
20
DIS:
Store and forward Internet fax: no
Real-time Internet fax: no
Preferred octets: 256
Can receive fax
Data signalling rate: V.29
R8x7.7lines/mm and/or 200x200pels/25.4mm OK
2D coding OK
Scan line length: 215mm
Recording length: A4 (297mm)
Receiver's minimum scan line time: 0ms at 3.85 l/mm: T7.7 = T3.85
R8x15.4lines/mm OK
Inch-based resolution preferred: no
Metric-based resolution preferred: no
Minimum scan line time for higher resolutions: T15.4 = T7.7
 DIS: 80 00 c6 f0 80 80 01
HDLC underflow in state 9
Changed from phase 4 to 3
 TSI: 43 20 20 20 20 20 37 39 36 39 36 33 32 20 31 31 39 20 39 34
2b
TSI without final frame tag
Remote fax gave TSI as: +49 911 2369697 
 DCS: 83 00 46 f0 00
DCS with final frame tag
In state 9
DCS:
Store and forward Internet fax: no
Real-time Internet fax: no
Can receive fax
Data signalling rate: V.29, 9600bps
R8x7.7lines/mm and/or 200x200pels/25.4mm OK
Scan line length: 215mm
Recording length: A4 (297mm)
Minimum scan line time: 0ms
Get at V.29
Changed from phase 3 to 5
Fast carrier up
Fast carrier down
Changed from phase 5 to 4
0 bad bits in trainability test
Start rx document - compression 1
Start rx page
 CFR: 84
HDLC underflow in state 5
Post trainability
Changed from phase 4 to 5
Fast carrier up
Fast carrier down
Fast carrier up
Fast carrier down
Fast carrier up
Equalizer state:
 -7 (0.0, 0.0) - 0.0
 -6 (0.0, 0.0) - 0.0
 -5 (0.0, 0.0) - 0.0
 -4 (0.0, 0.0) - 0.0
 -3 (0.0, 0.0) - 0.0
 -2 (   -0.08332,-0.68161) - 0.47154
 -1 (0.66136, 0.74688) - 0.99522
  0 (0.83336, 2.86588) - 8.90777
  1 (0.66136, 0.74688) - 0.99522
  2 (   -0.08332,-0.68161) - 0.47154
  3 (0.0, 0.0) - 0.0
  4 (0.0, 0.0) - 0.0
  5 (0.0, 0.0) - 0.0
  6 (0.0, 0.0) - 0.0
  7 (0.0, 0.0) - 0.0
Equalizer state:
 -7 (0.24872,-0.01973) - 0.06225
 -6 (0.06295,-0.59891) - 0.36265
 -5 (0.04198,-0.41768) - 0.17622
 -4 (0.12922, 0.34088) - 0.13290
 -3 (0.29121, 0.41776) - 0.25932
 -2 (0.05779,-1.18501) - 1.40758
 -1 (0.67094,-0.35069) - 0.57314
  0 (0.60670, 2.23125) - 5.34655
  1 (0.34490, 1.36992) - 1.99564
  2 (   -0.31233, 0.09159) - 0.10594
  3 (   -0.00825, 0.00787) - 0.00013
  4 (0.02226,-0.47177) - 0.22306
  5 (   -0.17953, 0.14528) - 0.05334
  6 (   -0.25318, 0.57800) - 0.39819
  7 (   -0.10465, 0.05659) - 0.01415
Equalizer state:
 -7 (0.10674, 0.25606) - 0.07696
 -6 (   -0.05000,-0.10084) - 0.01267
 -5 (   -0.04246,-0.24755) - 0.06308
 -4 (0.01990, 0.30283) - 0.09210
 -3 (   -0.04673, 0.31177) - 0.09939
 -2 (   -0.20575,-0.84531) - 0.75687
 -1 (0.53295, 0.18096) - 0.31678
  0 (0.84089, 

[Asterisk-Users] Re: OT : For the SQL gurus..

2003-11-11 Thread Reinhard Max
On Mon, 10 Nov 2003 at 10:17, brez wrote:

   SELECT *, length(code)
   FROM a
   WHERE code = '00442085673456'
  OR code = '0044208567345'
  OR code = '004420856734'
  OR code = '00442085673'
  OR code = '0044208567'
  OR code = '004420856'
  OR code = '00442085'
  OR code = '0044208'
  OR code = '004420'
  OR code = '00442'
  OR code = '0044'
   ORDER BY length(code) DESC;
  Again, the first row in the result set is the one you are after.

 can be reduced to:

  SELECT TOP 1 *, length(code)
  FROM a
  WHERE code LIKE '0044%'
  ORDER BY length(code) DESC;

No it can't, because that would bring up everything that starts with
0044 (e.g. 00445678), but we are looking for the longest prefix that
matches a given number.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] OT : For the SQL gurus..

2003-11-10 Thread Reinhard Max
On Mon, 10 Nov 2003 at 09:56, WipeOut wrote:

 If I have a MySQL table with dialing codes and a corresponding
 description (see below) and I want to lookup the best match for a
 phone number.. What would the SQL look like to do it?

I don't know MySQL very well, but maybe you also get an idea of how it
can be done if I describe it in terms of PostgreSQL:

 SELECT DISTINCT *,length(code)
 FROM a
 WHERE '00442085673456' LIKE (code || '%')
 ORDER length(code) DESC;

Now, the first row in the result set contains the longest matching
prefix of the given number that exists in the table, if there is any.

 or would it take more than just SQL to get to the best result?

If MySQL doesn't support using a column as a pattern for the LIKE
operator you might have to make multiple queries and allways strip one
more digit from the end of the number until you find a match.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] Re: [Users] OT : For the SQL gurus..

2003-11-10 Thread Reinhard Max
On Mon, 10 Nov 2003 at 12:33, Reinhard Max wrote:

  SELECT DISTINCT *,length(code)
  FROM a
  WHERE '00442085673456' LIKE (code || '%')
  ORDER length(code) DESC;
^
BY

Oops, that one got lost when I re-formatted the query.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: OT : For the SQL gurus..

2003-11-10 Thread Reinhard Max
On Mon, 10 Nov 2003 at 14:55, Michael Bielicki wrote:

 Just as a tip you could do that with regex functions as well,
 omitting the quite costly length functions ..

Well, regular expressions can be costly as well, and it depends on the
DBMS implementation how costly length() is. If the actual length of a
text or varchar field is being stored anyways, length() can be
implemented in a rather cheap way.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] RE: [Users] Is the X100P a WinModem?

2003-10-23 Thread Reinhard Max
Hi,

On Wed, 22 Oct 2003 at 15:44, Chris Albertson wrote:

 Also do remember that PCI card's config registrs are little endian
 and you will have to mantally byteswap when you read the hex dump.

... or simply use lspci -nv to get the IDs instead of the textual
translations.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] ISDN BRI active adapters with NT mode - any alternatives ?

2003-09-16 Thread Reinhard Max
Hi,

On 15 Sep 2003 at 11:52, Klaus-Peter Junghanns wrote:

 We are working on an alternative, a passive multiport ISDN card that
 supports TE and NT mode with zaptel drivers for asterisk.

this sounds very interesting. Are there any details available yet?


cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] Linux-IAX-Client

2003-06-25 Thread Reinhard Max
On Wed, 25 Jun 2003 at 17:04, Holger Schildt wrote:

 is there another IAX-CLient for Linux beside Gnophone?

There is tkPhone, but it is still beta.
You can download version 0.1 from http://tel.sf.net.

 There is no pop-up-window or any sound that caughts my attention.

This feature doesn't currently exist in tkPhone either, but it should
be only a matter of minutes and 5-10 lines of Tcl code to add it.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] chan_capi with avm c2 only uses one BRI

2003-06-05 Thread Reinhard Max
On Wed, 4 Jun 2003 at 17:09, Michael Labuschke wrote:

 wasn't the capi driver for the avm only for one card per pc ?

That only applies to their passive cards. The c2 is an active card
with two ISDN ports, so it should be able to handle them both at once.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users


[Asterisk-Users] Re: [Users] Proposed IAX2 Name

2003-03-14 Thread Reinhard Max
On 13 Mar 2003 at 13:00, Howard White wrote:

 To our multi-lingual listers - do IAX or TASTE have any non-English
 complications?

In German, Taste means key like in keyboard, not lock and key.
But the word is pronounced differently than the English taste.

cu
Reinhard

___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users