Re: [asterisk-users] cdr_custom outout to serial port

2008-04-14 Thread c . savinovich

  No problem.  The program is in Windows. Contact me off line to make
arrangements to send you the installation files.

C. Savinovich

   Long ago, I wrote a nice program that reads CDR output from any
 legacy PBX via the serial port.  Not much in use lately, but I will be
 happy to furbish it with mysql output to anyone who asks.



Yes, please.

What OS does it run under?

Thanks!

Doug



___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


[asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Col Ferguson
Hello,
I have a system in a motel that needs call billing data output through its
serial port so the existing motel management software can collect the call
billing info.
Is there any easy way to redirect the data that goes into the
cdr_custom/Master.csv file to go out the serial port ?

The system is Asterisk 1.4.18.1 on Centos 5.1

Thanks,
Col



- Original Message -
From: Peder @ NetworkOblivion [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Saturday, April 12, 2008 1:37 PM
Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall


 FYI, I have probably 10 Fortinet units with multiple SIP phones behind
 each and all of the phones work flawlessly.  As long as the Fortinet is
 ver 3.0 or newer, it does NAT so that you don't need to have nat=yes on
 *.  No pinholes or static nat or anything, it just works.

 As a side note, I probably have 20+ Cisco PIX's with the same setup and
 they work flawlessly too.  I've seen a lot of people saying fixup sip
 breaks phones, but not that I have seen.  I just let the PIX do nat and
 it works fine.

 Carlos Chavez wrote:
  I have a customer with a Fortinet Firewall that is having stability
  issues with Asterisk and SIP endpoints (PAP2T) outside his network.
 
  The first issue I see is that Asterisk sees all phones as the IP
  address of the Fortinet.  Since the parameter localnet defines the
  local network and that address falls in that range, how will Asterisk
  treat the endpoints?  I have nat=yes for all phones and
  canreinvite=no as well.  The externip parameter is set to the
  outside public IP address.  Still we have calls with one way audio.
 
  This is the first setup with a firewall that rewrites the IP address of
  the endpoint so I do not know how that is affecting the packet flow.  On
  my other servers I can always see the public IP of the endpoint.
 
 
 
  
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users

 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


 --
 No virus found in this incoming message.
 Checked by AVG.
 Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
4/11/2008 4:59 PM




___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Col Ferguson
Hello again,
I can copy the file out the serial port by doing this:

rename Master.csv out1.csv
cat out1.csv  /dev/ttyS0

If I build a script to do this every 10 or 20 seconds via cron I think it
will work fine, unless someone has a better way.

Cheers,
Col


- Original Message -
From: Col Ferguson [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Saturday, April 12, 2008 5:12 PM
Subject: [asterisk-users] cdr_custom outout to serial port


 Hello,
 I have a system in a motel that needs call billing data output through its
 serial port so the existing motel management software can collect the call
 billing info.
 Is there any easy way to redirect the data that goes into the
 cdr_custom/Master.csv file to go out the serial port ?

 The system is Asterisk 1.4.18.1 on Centos 5.1

 Thanks,
 Col



 - Original Message -
 From: Peder @ NetworkOblivion [EMAIL PROTECTED]
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 asterisk-users@lists.digium.com
 Sent: Saturday, April 12, 2008 1:37 PM
 Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall


  FYI, I have probably 10 Fortinet units with multiple SIP phones behind
  each and all of the phones work flawlessly.  As long as the Fortinet is
  ver 3.0 or newer, it does NAT so that you don't need to have nat=yes on
  *.  No pinholes or static nat or anything, it just works.
 
  As a side note, I probably have 20+ Cisco PIX's with the same setup and
  they work flawlessly too.  I've seen a lot of people saying fixup sip
  breaks phones, but not that I have seen.  I just let the PIX do nat and
  it works fine.
 
  Carlos Chavez wrote:
   I have a customer with a Fortinet Firewall that is having stability
   issues with Asterisk and SIP endpoints (PAP2T) outside his network.
  
   The first issue I see is that Asterisk sees all phones as the IP
   address of the Fortinet.  Since the parameter localnet defines the
   local network and that address falls in that range, how will Asterisk
   treat the endpoints?  I have nat=yes for all phones and
   canreinvite=no as well.  The externip parameter is set to the
   outside public IP address.  Still we have calls with one way audio.
  
   This is the first setup with a firewall that rewrites the IP address
of
   the endpoint so I do not know how that is affecting the packet flow.
On
   my other servers I can always see the public IP of the endpoint.
  
  
  
 
 
  
   ___
   -- Bandwidth and Colocation Provided by http://www.api-digital.com --
  
   asterisk-users mailing list
   To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
  --
  No virus found in this incoming message.
  Checked by AVG.
  Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
 4/11/2008 4:59 PM
 
 


 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


 --
 No virus found in this incoming message.
 Checked by AVG.
 Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
4/11/2008 4:59 PM




___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Zoa

How about a tail -f on Master.csv ?
Then you will have everything realtime and you will not need a cronjob.

Zoa


Col Ferguson wrote:
 Hello again,
 I can copy the file out the serial port by doing this:

 rename Master.csv out1.csv
 cat out1.csv  /dev/ttyS0

 If I build a script to do this every 10 or 20 seconds via cron I think it
 will work fine, unless someone has a better way.

 Cheers,
 Col


 - Original Message -
 From: Col Ferguson [EMAIL PROTECTED]
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 asterisk-users@lists.digium.com
 Sent: Saturday, April 12, 2008 5:12 PM
 Subject: [asterisk-users] cdr_custom outout to serial port


   
 Hello,
 I have a system in a motel that needs call billing data output through its
 serial port so the existing motel management software can collect the call
 billing info.
 Is there any easy way to redirect the data that goes into the
 cdr_custom/Master.csv file to go out the serial port ?

 The system is Asterisk 1.4.18.1 on Centos 5.1

 Thanks,
 Col



 - Original Message -
 From: Peder @ NetworkOblivion [EMAIL PROTECTED]
 To: Asterisk Users Mailing List - Non-Commercial Discussion
 asterisk-users@lists.digium.com
 Sent: Saturday, April 12, 2008 1:37 PM
 Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall


 
 FYI, I have probably 10 Fortinet units with multiple SIP phones behind
 each and all of the phones work flawlessly.  As long as the Fortinet is
 ver 3.0 or newer, it does NAT so that you don't need to have nat=yes on
 *.  No pinholes or static nat or anything, it just works.

 As a side note, I probably have 20+ Cisco PIX's with the same setup and
 they work flawlessly too.  I've seen a lot of people saying fixup sip
 breaks phones, but not that I have seen.  I just let the PIX do nat and
 it works fine.

 Carlos Chavez wrote:
   
 I have a customer with a Fortinet Firewall that is having stability
 issues with Asterisk and SIP endpoints (PAP2T) outside his network.

 The first issue I see is that Asterisk sees all phones as the IP
 address of the Fortinet.  Since the parameter localnet defines the
 local network and that address falls in that range, how will Asterisk
 treat the endpoints?  I have nat=yes for all phones and
 canreinvite=no as well.  The externip parameter is set to the
 outside public IP address.  Still we have calls with one way audio.

 This is the first setup with a firewall that rewrites the IP address
 
 of
   
 the endpoint so I do not know how that is affecting the packet flow.
 
 On
   
 my other servers I can always see the public IP of the endpoint.



 
 
 
 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
 
 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


 --
 No virus found in this incoming message.
 Checked by AVG.
 Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
   
 4/11/2008 4:59 PM
 
   
 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users


 --
 No virus found in this incoming message.
 Checked by AVG.
 Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
 
 4/11/2008 4:59 PM
   
 


 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list
 To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
   


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Col Ferguson
Thanks for the idea Zoa.

I've got the cronjob working every minute now using

if [ -f /var/log/asterisk/cdr-custom/Master.csv ]
  then
cd /var/log/asterisk/cdr-custom
mv -f Master.csv out1.csv
cat out1.csv  /dev/ttyS0
fi

Using tail -f would give me the realtime output, but a few questions as a
real linux novice;
What would be the best way to start this up ?
How would I monitor it to make sure it hasn't died, and how to restart ?

Cheers,
Col

- Original Message -
From: Zoa [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Saturday, April 12, 2008 9:36 PM
Subject: Re: [asterisk-users] cdr_custom outout to serial port



 How about a tail -f on Master.csv ?
 Then you will have everything realtime and you will not need a cronjob.

 Zoa


 Col Ferguson wrote:
  Hello again,
  I can copy the file out the serial port by doing this:
 
  rename Master.csv out1.csv
  cat out1.csv  /dev/ttyS0
 
  If I build a script to do this every 10 or 20 seconds via cron I think
it
  will work fine, unless someone has a better way.
 
  Cheers,
  Col
 
 
  - Original Message -
  From: Col Ferguson [EMAIL PROTECTED]
  To: Asterisk Users Mailing List - Non-Commercial Discussion
  asterisk-users@lists.digium.com
  Sent: Saturday, April 12, 2008 5:12 PM
  Subject: [asterisk-users] cdr_custom outout to serial port
 
 
 
  Hello,
  I have a system in a motel that needs call billing data output through
its
  serial port so the existing motel management software can collect the
call
  billing info.
  Is there any easy way to redirect the data that goes into the
  cdr_custom/Master.csv file to go out the serial port ?
 
  The system is Asterisk 1.4.18.1 on Centos 5.1
 
  Thanks,
  Col
 
 
 
  - Original Message -
  From: Peder @ NetworkOblivion [EMAIL PROTECTED]
  To: Asterisk Users Mailing List - Non-Commercial Discussion
  asterisk-users@lists.digium.com
  Sent: Saturday, April 12, 2008 1:37 PM
  Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall
 
 
 
  FYI, I have probably 10 Fortinet units with multiple SIP phones behind
  each and all of the phones work flawlessly.  As long as the Fortinet
is
  ver 3.0 or newer, it does NAT so that you don't need to have nat=yes
on
  *.  No pinholes or static nat or anything, it just works.
 
  As a side note, I probably have 20+ Cisco PIX's with the same setup
and
  they work flawlessly too.  I've seen a lot of people saying fixup
sip
  breaks phones, but not that I have seen.  I just let the PIX do nat
and
  it works fine.
 
  Carlos Chavez wrote:
 
  I have a customer with a Fortinet Firewall that is having stability
  issues with Asterisk and SIP endpoints (PAP2T) outside his network.
 
  The first issue I see is that Asterisk sees all phones as the IP
  address of the Fortinet.  Since the parameter localnet defines the
  local network and that address falls in that range, how will Asterisk
  treat the endpoints?  I have nat=yes for all phones and
  canreinvite=no as well.  The externip parameter is set to the
  outside public IP address.  Still we have calls with one way audio.
 
  This is the first setup with a firewall that rewrites the IP address
 
  of
 
  the endpoint so I do not know how that is affecting the packet flow.
 
  On
 
  my other servers I can always see the public IP of the endpoint.
 
 
 
 

 
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
  --
  No virus found in this incoming message.
  Checked by AVG.
  Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
 
  4/11/2008 4:59 PM
 
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users
 
 
  --
  No virus found in this incoming message.
  Checked by AVG.
  Version: 7.5.519 / Virus Database: 269.22.12/1374 - Release Date:
 
  4/11/2008 4:59 PM
 
 
 
 
  ___
  -- Bandwidth and Colocation Provided by http://www.api-digital.com --
 
  asterisk-users mailing list
  To UNSUBSCRIBE or update options visit:
 http://lists.digium.com/mailman/listinfo/asterisk-users
 


 ___
 -- Bandwidth and Colocation Provided by http://www.api-digital.com --

 asterisk-users mailing list

Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Tilghman Lesher
On Saturday 12 April 2008 07:22:46 Col Ferguson wrote:
 Thanks for the idea Zoa.

 I've got the cronjob working every minute now using

 if [ -f /var/log/asterisk/cdr-custom/Master.csv ]
   then
 cd /var/log/asterisk/cdr-custom
 mv -f Master.csv out1.csv
 cat out1.csv  /dev/ttyS0
 fi

 Using tail -f would give me the realtime output, but a few questions as a
 real linux novice;
 What would be the best way to start this up ?
 How would I monitor it to make sure it hasn't died, and how to restart ?

Best way would be to use inittab, with respawn, if it dies.  Note that on very
recent Linux distributions, such as Ubuntu, /etc/inittab has been replaced
with a directory, /etc/events.d/

-- 
Tilghman

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Andrew Kohlsmith (lists)
On April 12, 2008 03:12:31 am Col Ferguson wrote:
 Hello,
 I have a system in a motel that needs call billing data output through its
 serial port so the existing motel management software can collect the call
 billing info.
 Is there any easy way to redirect the data that goes into the
 cdr_custom/Master.csv file to go out the serial port ?

I've written a few variants of what I call a CDR MUX -- a little application 
that reads CDRs from a legacy system via serial port, reads CDRs from 
Asterisk, combines them and outputs them in a specific format out another 
serial port for some third-party billing system.

Essentially that's what you're asking for, minus the legacy system part.  I 
imagine the billing system isn't interested in a straight tail -f 
 /dev/ttyS1 output, so some level of translation would be required.

-A.



___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Tzafrir Cohen
On Sat, Apr 12, 2008 at 10:21:40AM -0400, Andrew Kohlsmith (lists) wrote:
 On April 12, 2008 03:12:31 am Col Ferguson wrote:
  Hello,
  I have a system in a motel that needs call billing data output through its
  serial port so the existing motel management software can collect the call
  billing info.
  Is there any easy way to redirect the data that goes into the
  cdr_custom/Master.csv file to go out the serial port ?
 
 I've written a few variants of what I call a CDR MUX -- a little 
 application 
 that reads CDRs from a legacy system via serial port, reads CDRs from 
 Asterisk, combines them and outputs them in a specific format out another 
 serial port for some third-party billing system.
 
 Essentially that's what you're asking for, minus the legacy system part.  I 
 imagine the billing system isn't interested in a straight tail -f 
  /dev/ttyS1 output, so some level of translation would be required.

What about cdr_shell ?

-- 
   Tzafrir Cohen
icq#16849755  jabber:[EMAIL PROTECTED]
+972-50-7952406   mailto:[EMAIL PROTECTED]
http://www.xorcom.com  iax:[EMAIL PROTECTED]/tzafrir

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Doug Lytle
Andrew Kohlsmith (lists) wrote:
 I've written a few variants of what I call a CDR MUX -- a little 
 application 
 that reads CDRs from a legacy system via serial port, reads CDRs from 
   


Anything that you can make available?  I'd love to be able to get our 
Definity's CDR into a MySQL database.

Doug


-- 
Ben Franklin quote:

Those who would give up Essential Liberty to purchase a little Temporary 
Safety, deserve neither Liberty nor Safety.


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread Philipp Kempgen
Doug Lytle schrieb:
 Andrew Kohlsmith (lists) wrote:
 I've written a few variants of what I call a CDR MUX -- a little 
 application 
 that reads CDRs from a legacy system via serial port, reads CDRs from 
   
 
 
 Anything that you can make available?  I'd love to be able to get our 
 Definity's CDR into a MySQL database.

What about an inexpensive digital video camera combined with
frame grabber software and OCR ...  ;-)

Regards,
   Philipp Kempgen

___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users


Re: [asterisk-users] cdr_custom outout to serial port

2008-04-12 Thread c . savinovich

Anything that you can make available?  I'd love to be able to get our
Definity's CDR into a MySQL database.

  Long ago, I wrote a nice program that reads CDR output from any legacy
PBX via the serial port.  Not much in use lately, but I will be happy to
furbish it with mysql output to anyone who asks.

C. Savinovich


___
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users