Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] cdr_custom outout to serial port


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
asterisk at coltect.no...
Guest





PostPosted: Sat Apr 12, 2008 2:12 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

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" <peder at networkoblivion.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 1:37 PM
Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall


Quote:
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:
Quote:
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
Quote:

Back to top
asterisk at coltect.no...
Guest





PostPosted: Sat Apr 12, 2008 5:53 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

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" <asterisk at coltect.no-ip.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 5:12 PM
Subject: [asterisk-users] cdr_custom outout to serial port


Quote:
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" <peder at networkoblivion.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 1:37 PM
Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall


Quote:
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:
Quote:
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
Quote:
Quote:
Quote:
the endpoint so I do not know how that is affecting the packet flow.
On
Quote:
Quote:
Quote:
my other servers I can always see the public IP of the endpoint.




------------------------------------------------------------------------
Quote:
Quote:

_______________________________________________
-- 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
Quote:

Back to top
zoachien at securax.org
Guest





PostPosted: Sat Apr 12, 2008 6:36 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

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:
Quote:
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" <asterisk at coltect.no-ip.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 5:12 PM
Subject: [asterisk-users] cdr_custom outout to serial port



Quote:
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" <peder at networkoblivion.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 1:37 PM
Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall



Quote:
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:

Quote:
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

Quote:
Quote:
Quote:
the endpoint so I do not know how that is affecting the packet flow.

On

Quote:
Quote:
Quote:
my other servers I can always see the public IP of the endpoint.




------------------------------------------------------------------------

Quote:
Quote:
_______________________________________________
-- 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
Back to top
asterisk at coltect.no...
Guest





PostPosted: Sat Apr 12, 2008 7:22 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

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" <zoachien at securax.org>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 9:36 PM
Subject: Re: [asterisk-users] cdr_custom outout to serial port
Quote:

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:
Quote:
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
Quote:
Quote:
will work fine, unless someone has a better way.

Cheers,
Col


----- Original Message -----
From: "Col Ferguson" <asterisk at coltect.no-ip.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 5:12 PM
Subject: [asterisk-users] cdr_custom outout to serial port



Quote:
Hello,
I have a system in a motel that needs call billing data output through
its
Quote:
Quote:
Quote:
serial port so the existing motel management software can collect the
call
Quote:
Quote:
Quote:
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" <peder at networkoblivion.com>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Sent: Saturday, April 12, 2008 1:37 PM
Subject: Re: [asterisk-users] NAT issue with Fortinet Firewall



Quote:
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
Quote:
Quote:
Quote:
Quote:
ver 3.0 or newer, it does NAT so that you don't need to have nat=yes
on
Quote:
Quote:
Quote:
Quote:
*. 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
Quote:
Quote:
Quote:
Quote:
they work flawlessly too. I've seen a lot of people saying "fixup
sip"
Quote:
Quote:
Quote:
Quote:
breaks phones, but not that I have seen. I just let the PIX do nat
and
Quote:
Quote:
Quote:
Quote:
it works fine.

Carlos Chavez wrote:

Quote:
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

Quote:
Quote:
Quote:
the endpoint so I do not know how that is affecting the packet flow.

On

Quote:
Quote:
Quote:
my other servers I can always see the public IP of the endpoint.





Quote:
------------------------------------------------------------------------
Quote:

Quote:
Quote:
_______________________________________________
-- 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


--
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
Quote:

Back to top
tilghman at mail.jeffa...
Guest





PostPosted: Sat Apr 12, 2008 8:46 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

On Saturday 12 April 2008 07:22:46 Col Ferguson wrote:
Quote:
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
Back to top
aklists at mixdown.ca
Guest





PostPosted: Sat Apr 12, 2008 9:21 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

On April 12, 2008 03:12:31 am Col Ferguson wrote:
Quote:
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
Quote:
/dev/ttyS1" output, so some level of translation would be required.

-A.
Back to top
tzafrir.cohen at xorco...
Guest





PostPosted: Sat Apr 12, 2008 9:48 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

On Sat, Apr 12, 2008 at 10:21:40AM -0400, Andrew Kohlsmith (lists) wrote:
Quote:
On April 12, 2008 03:12:31 am Col Ferguson wrote:
Quote:
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
Quote:
/dev/ttyS1" output, so some level of translation would be required.

What about cdr_shell ?

--
Tzafrir Cohen
icq#16849755 jabber:tzafrir.cohen at xorcom.com
+972-50-7952406 mailto:tzafrir.cohen at xorcom.com
http://www.xorcom.com iax:guest at local.xorcom.com/tzafrir
Back to top
support at drdos.info
Guest





PostPosted: Sat Apr 12, 2008 10:01 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

Andrew Kohlsmith (lists) wrote:
Quote:
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."
Back to top
philipp.kempgen at amo...
Guest





PostPosted: Sat Apr 12, 2008 10:30 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

Doug Lytle schrieb:
Quote:
Andrew Kohlsmith (lists) wrote:
Quote:
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 ... Wink

Regards,
Philipp Kempgen
Back to top
c.savinovich at itntel...
Guest





PostPosted: Sat Apr 12, 2008 10:34 pm    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

Quote:
Quote:
Quote:
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
Back to top
c.savinovich at itntel...
Guest





PostPosted: Mon Apr 14, 2008 6:06 am    Post subject: [asterisk-users] cdr_custom outout to serial port Reply with quote

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

C. Savinovich

Quote:
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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services