astlinux-users — AstLinux Users Mailing List

Re: [Astlinux-users] Network connectivity and DNS issues

[Michael K. <mic...@ip...>]

Thanks Lonnie

I will give Monit a try and let you know how I go. 
I will only turn on for some sites.

Regards
Michael Knill

On 9/2/18, 2:49 am, "Lonnie Abelbeck" <li...@lo...> wrote:

    Michael,
    
    > So my questions are:
    > 1) What frequency of registrations or SIP OPTIONS are actually required to keep the firewall translation is place
    
    Depends on the network hardware in the path and the shortest firewall UDP TTL setting, AstLinux defaults to a 180 second UDP TTL for netfilter.ip_conntrack_udp_timeout_stream states.
    
    By default, in sip.conf, qualifyfreq=60 which sends SIP OPTIONS every 60 seconds.  This should work for most situations.
    
    But, it seems in your situation the transient case with network issues can cause problems.  Possibly setting qualify to something large like 64000 ms, qualify=64000 would enable the qualify feature but would not normally fail. Possibly mixed with qualifyfreq=30 .  Warning, I have never tested or tried this.
    
    
    > 2) Would it be feasible for Monit to check 'sip show peers' that if a trunk peer has a Host IP Address but is a Status of UNKNOWN then do a 'module reload chan_sip.so' and report it?
    
    Personally I don't use Monit, but in theory it may be possible.
    
    Lonnie
    
    
    
    On Feb 8, 2018, at 12:54 AM, Michael Knill <mic...@ip...> wrote:
    
    > Sorry all I am dredging up this thread again. Thanks Lonnie for the info below.
    > Although my main provider uses an IP Address based trunk which makes this problem go away, I have some providers that require registration via a DNS name.
    > I have now activated dnsmgr which is good in that it will update the IP Address on the peer so it can reregister, HOWEVER the OPTIONS pings will not start up again if down after a reboot.
    > I can turn off SIP OPTIONS (qualify=no) and put in a specific firewall rule I suppose but I would still rather have qualify=yes
    > 
    > So my questions are:
    > 1) What frequency of registrations or SIP OPTIONS are actually required to keep the firewall translation is place
    > 2) Would it be feasible for Monit to check 'sip show peers' that if a trunk peer has a Host IP Address but is a Status of UNKNOWN then do a 'module reload chan_sip.so' and report it?
    > 
    > Thanks all.
    > 
    > Regards
    > Michael Knill
    > 
    > On 13/1/18, 6:38 am, "Michael Knill" <mic...@ip...> wrote:
    > 
    >    Thanks Lonnie
    > 
    >    I have confirmed with my main provider that their IP Address will likely never change to I will be putting the IP Address in sip.conf so I don't even need to set a static host.
    >    I do like to know the reachability of my trunks so I will keep the OPTIONS pings going.
    > 
    >    Thanks so much again for your help. 
    > 
    >    Regards
    >    Michael Knill
    > 
    >    On 13/1/18, 2:42 am, "Lonnie Abelbeck" <li...@lo...> wrote:
    > 
    >        Hi Michael,
    > 
    >        The easiest way to always make sure a DNS name resolves is to define static IP addresses in:
    > 
    >        Network tab -> Network Services: -> DNS Forwarder & DHCP Server: { Configure DNS Hosts }
    > 
    >        There you can statically define DNS host names without requiring any changes to your Asterisk configuration. Of course if your SIP provider makes changes you will have to reconfigure the DNS IP's like a bunny.
    > 
    > 
    >        Another approach, or in tandem, is to not depend on OPTIONS pings (qualify=yes) to keep firewall ports open, instead (qualify=no) use very specific (secure) firewall rules for inbound SIP calls.
    > 
    > 
    >        To be clear, it is not recommended to do either of the above as a general practice, but you do what you have to do.
    > 
    >        Lonnie
    > 
    > 
    >        On Jan 11, 2018, at 10:50 PM, Michael Knill <mic...@ip...> wrote:
    > 
    >> Hi Group
    >> 
    >> I have started a new thread although this is a continuation of my intermittent issues with sip trunks not coming back after a network outage.
    >> After some testing in the lab I have realised that most of these problems are related to DNS resolution.
    >> 
    >> Basically I am using sip domain names for all my providers so DNS resolution is necessary. What I have found is that if for some reason DNS resolution is not possible (e.g. network is down), if the system is rebooted or Asterisk loses the resolved address, it no longer sends the OPTIONS pings as it cant find the address obviously.
    >> Yes that makes sense however the problem arises when the network is restored, Asterisk is completely unaware and therefore makes no attempt in resolving the address.
    >> I believe this is what is causing my intermittent issues which is easily resolved by doing an Asterisk Reload when network connectivity is restored. I have also enabled the Asterisk dnsmgr which does not fix the problem. I suspect that if it couldn't initially resolve it then it gives up totally.
    >> 
    >> So what is the fix. Here are some of my options:
    >> 	• Don't use DNS but just use the IP Address instead. This will most certainly resolve the issue but is it the best way? Something in the Hosts file maybe?
    >> 	• Perform sip monitoring using the SIP Monitor script or Monit. If the SIP URL is resolvable but the status is UNKNOWN then issue a module reload of chan_sip
    >> 	• Something else
    >> 
    >> PS the SIP Monitor does not seem to work for me. It only sends me an email when the system is rebooted.
    >> Thanks all.
    >> 
    >> Regards
    >> Michael Knill
    >> ------------------------------------------------------------------------------
    >> Check out the vibrant tech community on one of the world's most
    >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
    >> Astlinux-users mailing list
    >> Ast...@li...
    >> https://lists.sourceforge.net/lists/listinfo/astlinux-users
    >> 
    >> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    > 
    >        ------------------------------------------------------------------------------
    >        Check out the vibrant tech community on one of the world's most
    >        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    >        _______________________________________________
    >        Astlinux-users mailing list
    >        Ast...@li...
    >        https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    >        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    > 
    >    ------------------------------------------------------------------------------
    >    Check out the vibrant tech community on one of the world's most
    >    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    >    _______________________________________________
    >    Astlinux-users mailing list
    >    Ast...@li...
    >    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    >    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    > _______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] Network connectivity and DNS issues

[Lonnie A. <li...@lo...>]

Michael,

> So my questions are:
> 1) What frequency of registrations or SIP OPTIONS are actually required to keep the firewall translation is place

Depends on the network hardware in the path and the shortest firewall UDP TTL setting, AstLinux defaults to a 180 second UDP TTL for netfilter.ip_conntrack_udp_timeout_stream states.

By default, in sip.conf, qualifyfreq=60 which sends SIP OPTIONS every 60 seconds.  This should work for most situations.

But, it seems in your situation the transient case with network issues can cause problems.  Possibly setting qualify to something large like 64000 ms, qualify=64000 would enable the qualify feature but would not normally fail. Possibly mixed with qualifyfreq=30 .  Warning, I have never tested or tried this.


> 2) Would it be feasible for Monit to check 'sip show peers' that if a trunk peer has a Host IP Address but is a Status of UNKNOWN then do a 'module reload chan_sip.so' and report it?

Personally I don't use Monit, but in theory it may be possible.

Lonnie



On Feb 8, 2018, at 12:54 AM, Michael Knill <mic...@ip...> wrote:

> Sorry all I am dredging up this thread again. Thanks Lonnie for the info below.
> Although my main provider uses an IP Address based trunk which makes this problem go away, I have some providers that require registration via a DNS name.
> I have now activated dnsmgr which is good in that it will update the IP Address on the peer so it can reregister, HOWEVER the OPTIONS pings will not start up again if down after a reboot.
> I can turn off SIP OPTIONS (qualify=no) and put in a specific firewall rule I suppose but I would still rather have qualify=yes
> 
> So my questions are:
> 1) What frequency of registrations or SIP OPTIONS are actually required to keep the firewall translation is place
> 2) Would it be feasible for Monit to check 'sip show peers' that if a trunk peer has a Host IP Address but is a Status of UNKNOWN then do a 'module reload chan_sip.so' and report it?
> 
> Thanks all.
> 
> Regards
> Michael Knill
> 
> On 13/1/18, 6:38 am, "Michael Knill" <mic...@ip...> wrote:
> 
>    Thanks Lonnie
> 
>    I have confirmed with my main provider that their IP Address will likely never change to I will be putting the IP Address in sip.conf so I don't even need to set a static host.
>    I do like to know the reachability of my trunks so I will keep the OPTIONS pings going.
> 
>    Thanks so much again for your help. 
> 
>    Regards
>    Michael Knill
> 
>    On 13/1/18, 2:42 am, "Lonnie Abelbeck" <li...@lo...> wrote:
> 
>        Hi Michael,
> 
>        The easiest way to always make sure a DNS name resolves is to define static IP addresses in:
> 
>        Network tab -> Network Services: -> DNS Forwarder & DHCP Server: { Configure DNS Hosts }
> 
>        There you can statically define DNS host names without requiring any changes to your Asterisk configuration. Of course if your SIP provider makes changes you will have to reconfigure the DNS IP's like a bunny.
> 
> 
>        Another approach, or in tandem, is to not depend on OPTIONS pings (qualify=yes) to keep firewall ports open, instead (qualify=no) use very specific (secure) firewall rules for inbound SIP calls.
> 
> 
>        To be clear, it is not recommended to do either of the above as a general practice, but you do what you have to do.
> 
>        Lonnie
> 
> 
>        On Jan 11, 2018, at 10:50 PM, Michael Knill <mic...@ip...> wrote:
> 
>> Hi Group
>> 
>> I have started a new thread although this is a continuation of my intermittent issues with sip trunks not coming back after a network outage.
>> After some testing in the lab I have realised that most of these problems are related to DNS resolution.
>> 
>> Basically I am using sip domain names for all my providers so DNS resolution is necessary. What I have found is that if for some reason DNS resolution is not possible (e.g. network is down), if the system is rebooted or Asterisk loses the resolved address, it no longer sends the OPTIONS pings as it cant find the address obviously.
>> Yes that makes sense however the problem arises when the network is restored, Asterisk is completely unaware and therefore makes no attempt in resolving the address.
>> I believe this is what is causing my intermittent issues which is easily resolved by doing an Asterisk Reload when network connectivity is restored. I have also enabled the Asterisk dnsmgr which does not fix the problem. I suspect that if it couldn't initially resolve it then it gives up totally.
>> 
>> So what is the fix. Here are some of my options:
>> 	• Don't use DNS but just use the IP Address instead. This will most certainly resolve the issue but is it the best way? Something in the Hosts file maybe?
>> 	• Perform sip monitoring using the SIP Monitor script or Monit. If the SIP URL is resolvable but the status is UNKNOWN then issue a module reload of chan_sip
>> 	• Something else
>> 
>> PS the SIP Monitor does not seem to work for me. It only sends me an email when the system is rebooted.
>> Thanks all.
>> 
>> Regards
>> Michael Knill
>> ------------------------------------------------------------------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
>> Astlinux-users mailing list
>> Ast...@li...
>> https://lists.sourceforge.net/lists/listinfo/astlinux-users
>> 
>> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
> 
> 
>        ------------------------------------------------------------------------------
>        Check out the vibrant tech community on one of the world's most
>        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>        _______________________________________________
>        Astlinux-users mailing list
>        Ast...@li...
>        https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
> 
> 
>    ------------------------------------------------------------------------------
>    Check out the vibrant tech community on one of the world's most
>    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>    _______________________________________________
>    Astlinux-users mailing list
>    Ast...@li...
>    https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] Network connectivity and DNS issues

[Michael K. <mic...@ip...>]

Sorry all I am dredging up this thread again. Thanks Lonnie for the info below.
Although my main provider uses an IP Address based trunk which makes this problem go away, I have some providers that require registration via a DNS name.
I have now activated dnsmgr which is good in that it will update the IP Address on the peer so it can reregister, HOWEVER the OPTIONS pings will not start up again if down after a reboot.
I can turn off SIP OPTIONS (qualify=no) and put in a specific firewall rule I suppose but I would still rather have qualify=yes

So my questions are:
1) What frequency of registrations or SIP OPTIONS are actually required to keep the firewall translation is place
2) Would it be feasible for Monit to check 'sip show peers' that if a trunk peer has a Host IP Address but is a Status of UNKNOWN then do a 'module reload chan_sip.so' and report it?

Thanks all.

Regards
Michael Knill

On 13/1/18, 6:38 am, "Michael Knill" <mic...@ip...> wrote:

    Thanks Lonnie
    
    I have confirmed with my main provider that their IP Address will likely never change to I will be putting the IP Address in sip.conf so I don't even need to set a static host.
    I do like to know the reachability of my trunks so I will keep the OPTIONS pings going.
    
    Thanks so much again for your help. 
    
    Regards
    Michael Knill
    
    On 13/1/18, 2:42 am, "Lonnie Abelbeck" <li...@lo...> wrote:
    
        Hi Michael,
        
        The easiest way to always make sure a DNS name resolves is to define static IP addresses in:
        
        Network tab -> Network Services: -> DNS Forwarder & DHCP Server: { Configure DNS Hosts }
        
        There you can statically define DNS host names without requiring any changes to your Asterisk configuration. Of course if your SIP provider makes changes you will have to reconfigure the DNS IP's like a bunny.
        
        
        Another approach, or in tandem, is to not depend on OPTIONS pings (qualify=yes) to keep firewall ports open, instead (qualify=no) use very specific (secure) firewall rules for inbound SIP calls.
        
        
        To be clear, it is not recommended to do either of the above as a general practice, but you do what you have to do.
        
        Lonnie
        
        
        On Jan 11, 2018, at 10:50 PM, Michael Knill <mic...@ip...> wrote:
        
        > Hi Group
        >  
        > I have started a new thread although this is a continuation of my intermittent issues with sip trunks not coming back after a network outage.
        > After some testing in the lab I have realised that most of these problems are related to DNS resolution.
        >  
        > Basically I am using sip domain names for all my providers so DNS resolution is necessary. What I have found is that if for some reason DNS resolution is not possible (e.g. network is down), if the system is rebooted or Asterisk loses the resolved address, it no longer sends the OPTIONS pings as it cant find the address obviously.
        > Yes that makes sense however the problem arises when the network is restored, Asterisk is completely unaware and therefore makes no attempt in resolving the address.
        > I believe this is what is causing my intermittent issues which is easily resolved by doing an Asterisk Reload when network connectivity is restored. I have also enabled the Asterisk dnsmgr which does not fix the problem. I suspect that if it couldn't initially resolve it then it gives up totally.
        >  
        > So what is the fix. Here are some of my options:
        > 	• Don't use DNS but just use the IP Address instead. This will most certainly resolve the issue but is it the best way? Something in the Hosts file maybe?
        > 	• Perform sip monitoring using the SIP Monitor script or Monit. If the SIP URL is resolvable but the status is UNKNOWN then issue a module reload of chan_sip
        > 	• Something else
        >  
        > PS the SIP Monitor does not seem to work for me. It only sends me an email when the system is rebooted.
        > Thanks all.
        >  
        > Regards
        > Michael Knill
        > ------------------------------------------------------------------------------
        > Check out the vibrant tech community on one of the world's most
        > engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
        > Astlinux-users mailing list
        > Ast...@li...
        > https://lists.sourceforge.net/lists/listinfo/astlinux-users
        > 
        > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
        
        
        ------------------------------------------------------------------------------
        Check out the vibrant tech community on one of the world's most
        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        _______________________________________________
        Astlinux-users mailing list
        Ast...@li...
        https://lists.sourceforge.net/lists/listinfo/astlinux-users
        
        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
        
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] 2016 Hardware recommendations - SOLVED

[Michael K. <mic...@ip...>]

Hi Graham

I run Alix boards with 256Mb RAM and I have to turn off as much as I can using 1.2.10. 512Mb should be fine though.
I recommend the APU for any new boxes.

Regards
Michael Knill
From: "Graham S. Jarvis" <gsj...@pt...>
Reply-To: AstLinux List <Ast...@li...>
Date: Monday, 5 February 2018 at 9:24 pm
To: AstLinux List <Ast...@li...>
Subject: Re: [Astlinux-users] 2016 Hardware recommendations - SOLVED


Hmmmm - embarrassing....

I'm pretty sure that this wasn't on http://www.astlinux-project.org/ when I looked this morning....

IMPORTANT NOTICE:
AstLinux 1.2.10 was the last supported version for "net5501" and "alix" board types. A custom build can still be used to generate 'run' images for "net5501" and "alix" board types.


Sorry about that !

-Graham-


-------- Forwarded Message --------
Subject:

Re: [Astlinux-users] 2016 Hardware recommendations

Date:

Mon, 5 Feb 2018 09:55:40 +0100

From:

Graham S. Jarvis <gsj...@pt...><mailto:gsj...@pt...>

To:

Michael Knill <mic...@ip...><mailto:mic...@ip...>



Hello everybody,

excuse me reactivating this old thread but I wanted to turn the question around:

If "one" had a few Soekris NET5501-70 (note 5501) boxes in place and all in pbx-only mode (with only ssh and iax ports open)...

What would be the highest Astlinux version that you would run on these?
And which version of Asterisk?

By the way - In North Africa not everything is, or has to be, up-to-date.

All suggestions gratefully received,

Thanks,

-Graham-



Michael Knill wrote on 14/02/16 21:07:

Thanks Michael



I might look into the NF9HG-2930. Case looks good too but might be hard to source locally.



Regards

Michael Knill









On 14 Feb 2016, at 9:34 PM, Michael Keuter <li...@mk...><mailto:li...@mk...> wrote:





Am 14.02.2016 um 10:38 schrieb Michael Knill <mic...@ip...><mailto:mic...@ip...>:



I use an APU for my smaller sites and the Jetway NF9HQL-525 for larger sites. I would love to find a slimline case for it actually!



Regards

Michael Knill

Michael,



I use this for larger sites now (Intel NICs), there is also a link to the Akasa Cypher thin case, which I use (should also work for the NF9HQL):



http://doc.astlinux.org/userdoc:board_jetway_nf9hg-2930



On 12 Feb 2016, at 7:52 AM, Lonnie Abelbeck <li...@lo...><mailto:li...@lo...> wrote:



On Feb 11, 2016, at 1:29 PM, Michael Keuter <li...@mk...><mailto:li...@mk...> wrote:



Am 11.02.2016 um 20:24 schrieb David Kerr <da...@ke...><mailto:da...@ke...>:



The astlinux.org homepage has a list of supported hardware.  Personally I use a PC Engines APU (http://doc.astlinux.org/userdoc:board_pcengines_apu) and it is working very well.  It is about as low cost and low power as you can get.   Lonnie likes some of the Intel Atom boards and may have specific recommendation too.



David



On Thu, Feb 11, 2016 at 11:30 AM, Paul Jochum <pj...@gm...><mailto:pj...@gm...> wrote:

Hi All:



Just wanted to see what astlinux users are recommending for hardware at this time.  I am looking at replacing my old (ok, very old), Soekris Net4801.  This is for home use, really just 1 SIP line, and the lower the power needed, the better.  Thanks in advance for your time and effort.



Best Regards,

Paul

+1 for the PC Engines APU1, it is the cheapest of all recent boards (at least here in Germany).



Michael

I will add that the PC Engines APU2 "apu2c2" http://pcengines.ch/apu2c2.htm *should* be a good choice later this year after the BIOS is feature complete.  Same price as the APU1 but with Intel i211AT NIC's.  We have not tested it yet.



Another good choice is the Jetway NF9HG-2930 mini-itx board

http://doc.astlinux.org/userdoc:board_jetway_nf9hg-2930



Currently that board seems hard to find, but I'm sure Jetway is making more.  Of course you would have to add a case, memory and SSD.



As David mentioned at http://doc.astlinux.org/userdoc:documentation -> "Generic x86 Boards and Appliances" we have quite a few choices that we have tested.



Most all the modern boards will consume less than 10 W and be supercomputer-like compared to your net4801. :-)



Lonnie

Michael



http://www.mksolutions.info









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

Site24x7 APM Insight: Get Deep Visibility into Application Performance

APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month

Monitor end-to-end web transactions and take corrective actions now

Troubleshoot faster and improve end-user experience. Signup Now!

http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140

_______________________________________________

Astlinux-users mailing list

Ast...@li...<mailto:Ast...@li...>

https://lists.sourceforge.net/lists/listinfo/astlinux-users



Donations to support AstLinux are graciously accepted via PayPal to pa...@kr...<mailto:pa...@kr...>.





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

Site24x7 APM Insight: Get Deep Visibility into Application Performance

APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month

Monitor end-to-end web transactions and take corrective actions now

Troubleshoot faster and improve end-user experience. Signup Now!

http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140

_______________________________________________

Astlinux-users mailing list

Ast...@li...<mailto:Ast...@li...>

https://lists.sourceforge.net/lists/listinfo/astlinux-users



Donations to support AstLinux are graciously accepted via PayPal to pa...@kr...<mailto:pa...@kr...>.

Re: [Astlinux-users] 2016 Hardware recommendations - SOLVED

[Graham S. J. <gsj...@pt...>]

Hmmmm - embarrassing....

I'm pretty sure that this wasn't on http://www.astlinux-project.org/ when I 
looked this morning....

*IMPORTANT NOTICE:*
AstLinux 1.2.10 was the last supported version for "net5501" and "alix" board 
types. A custom build can still be used to generate 'run' images for "net5501" 
and "alix" board types.

Sorry about that !

-Graham-



-------- Forwarded Message --------
Subject: 	Re: [Astlinux-users] 2016 Hardware recommendations
Date: 	Mon, 5 Feb 2018 09:55:40 +0100
From: 	Graham S. Jarvis <gsj...@pt...>
To: 	Michael Knill <mic...@ip...>



Hello everybody,

excuse me reactivating this old thread but I wanted to turn the question around:

If "one" had a few Soekris NET5501-70 (note 5501) boxes in place and all in 
pbx-only mode (with only ssh and iax ports open)...

What would be the highest Astlinux version that you would run on these?
And which version of Asterisk?

By the way - In North Africa not everything is, or has to be, up-to-date.

All suggestions gratefully received,

Thanks,

-Graham-



Michael Knill wrote on 14/02/16 21:07:
> Thanks Michael
>
> I might look into the NF9HG-2930. Case looks good too but might be hard to source locally.
>
> Regards
> Michael Knill
>
>
>
>
> On 14 Feb 2016, at 9:34 PM, Michael Keuter<li...@mk...>  wrote:
>
>
> Am 14.02.2016 um 10:38 schrieb Michael Knill<mic...@ip...>:
>
>> I use an APU for my smaller sites and the Jetway NF9HQL-525 for larger sites. I would love to find a slimline case for it actually!
>>
>> Regards
>> Michael Knill
> Michael,
>
> I use this for larger sites now (Intel NICs), there is also a link to the Akasa Cypher thin case, which I use (should also work for the NF9HQL):
>
> http://doc.astlinux.org/userdoc:board_jetway_nf9hg-2930
>
>> On 12 Feb 2016, at 7:52 AM, Lonnie Abelbeck<li...@lo...>  wrote:
>>
>> On Feb 11, 2016, at 1:29 PM, Michael Keuter<li...@mk...>  wrote:
>>
>>> Am 11.02.2016 um 20:24 schrieb David Kerr<da...@ke...>:
>>>
>>>> The astlinux.org homepage has a list of supported hardware.  Personally I use a PC Engines APU (http://doc.astlinux.org/userdoc:board_pcengines_apu) and it is working very well.  It is about as low cost and low power as you can get.   Lonnie likes some of the Intel Atom boards and may have specific recommendation too.
>>>>
>>>> David
>>>>
>>>> On Thu, Feb 11, 2016 at 11:30 AM, Paul Jochum<pj...@gm...>  wrote:
>>>> Hi All:
>>>>
>>>> Just wanted to see what astlinux users are recommending for hardware at this time.  I am looking at replacing my old (ok, very old), Soekris Net4801.  This is for home use, really just 1 SIP line, and the lower the power needed, the better.  Thanks in advance for your time and effort.
>>>>
>>>> Best Regards,
>>>> Paul
>>> +1 for the PC Engines APU1, it is the cheapest of all recent boards (at least here in Germany).
>>>
>>> Michael
>> I will add that the PC Engines APU2 "apu2c2"http://pcengines.ch/apu2c2.htm  *should* be a good choice later this year after the BIOS is feature complete.  Same price as the APU1 but with Intel i211AT NIC's.  We have not tested it yet.
>>
>> Another good choice is the Jetway NF9HG-2930 mini-itx board
>> http://doc.astlinux.org/userdoc:board_jetway_nf9hg-2930
>>
>> Currently that board seems hard to find, but I'm sure Jetway is making more.  Of course you would have to add a case, memory and SSD.
>>
>> As David mentioned athttp://doc.astlinux.org/userdoc:documentation  -> "Generic x86 Boards and Appliances" we have quite a few choices that we have tested.
>>
>> Most all the modern boards will consume less than 10 W and be supercomputer-like compared to your net4801. :-)
>>
>> Lonnie
> Michael
>
> http://www.mksolutions.info
>
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
>
> Donations to support AstLinux are graciously accepted via PayPal top...@kr....
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
>
> Donations to support AstLinux are graciously accepted via PayPal top...@kr....
>

Re: [Astlinux-users] SIP Monitor

[Michael K. <mic...@ip...>]

Wow embarrassing I missed that one. I should have looked at the script.
Thanks so much.

Regards
Michael Knill
On 3/2/18, 9:32 am, "Lonnie Abelbeck" <li...@lo...> wrote:

    Michael,
    
    I personally have used this feature for many years.
    
    It may not be clear, but "Trunks" is for SIP servers you register to, "sip show registry" ...
    
    Monitor SIP Trunks: _______
    (MONITOR_ASTERISK_SIP_TRUNKS)
    
    and "Peers" are for peers "sip show peers" with qualify=yes
    
    Monitor SIP Peers: ________
    (MONITOR_ASTERISK_SIP_PEERS)
    
    Possibly you are defining "Trunks" instead of "Peers" ?
    
    I agree the documentation on this is weak.
    
    Lonnie
    
    PS, from the "/usr/sbin/asterisk-sip-monitor" script comments:
    
    # Example: "sip show registry"
    # chiv1.voippath.com:5060       xxxx    135 Registered      Sat, 21 May 2011 10:21:11
    # inbound18.bigtel.net:5060     xxxx     45 Registered      Sat, 21 May 2011 10:22:42
    #
    # MONITOR_ASTERISK_SIP_TRUNKS="chiv1.voippath.com inbound18.bigtel.net"
    #
    
    # Example: "sip show peers"
    # voippath/homer-simpson    64.x.x.xx                 5060     OK (67 ms)
    # bigtel-inbound/homer1     64.x.x.xx                 5060     Unmonitored
    # bigtel-outbound/homer1    64.x.x.xx                 5060     OK (42 ms)
    #
    # MONITOR_ASTERISK_SIP_PEERS="voippath bigtel-outbound"
    #
    
    
    
    
    On Feb 2, 2018, at 2:15 PM, Michael Knill <mic...@ip...> wrote:
    
    > Hi Group
    >  
    > I cant seem to get the SIP Monitor working. The only time it ever sends me an email is when the box is power reset (which is actually quite handy).
    > I basically want to know when my trunk is UNREACHABLE or UNKNOWN and I don't want heaps of emails e.g. tell me once when its down and don't tell me its down again until it has transitioned from OK.
    > Will SIP Monitor do this? Monit maybe? Any other recommendations?
    >  
    > Regards
    > Michael Knill
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    

Re: [Astlinux-users] SIP Monitor

[Lonnie A. <li...@lo...>]

Michael,

I personally have used this feature for many years.

It may not be clear, but "Trunks" is for SIP servers you register to, "sip show registry" ...

Monitor SIP Trunks: _______
(MONITOR_ASTERISK_SIP_TRUNKS)

and "Peers" are for peers "sip show peers" with qualify=yes

Monitor SIP Peers: ________
(MONITOR_ASTERISK_SIP_PEERS)

Possibly you are defining "Trunks" instead of "Peers" ?

I agree the documentation on this is weak.

Lonnie

PS, from the "/usr/sbin/asterisk-sip-monitor" script comments:

# Example: "sip show registry"
# chiv1.voippath.com:5060       xxxx    135 Registered      Sat, 21 May 2011 10:21:11
# inbound18.bigtel.net:5060     xxxx     45 Registered      Sat, 21 May 2011 10:22:42
#
# MONITOR_ASTERISK_SIP_TRUNKS="chiv1.voippath.com inbound18.bigtel.net"
#

# Example: "sip show peers"
# voippath/homer-simpson    64.x.x.xx                 5060     OK (67 ms)
# bigtel-inbound/homer1     64.x.x.xx                 5060     Unmonitored
# bigtel-outbound/homer1    64.x.x.xx                 5060     OK (42 ms)
#
# MONITOR_ASTERISK_SIP_PEERS="voippath bigtel-outbound"
#




On Feb 2, 2018, at 2:15 PM, Michael Knill <mic...@ip...> wrote:

> Hi Group
>  
> I cant seem to get the SIP Monitor working. The only time it ever sends me an email is when the box is power reset (which is actually quite handy).
> I basically want to know when my trunk is UNREACHABLE or UNKNOWN and I don't want heaps of emails e.g. tell me once when its down and don't tell me its down again until it has transitioned from OK.
> Will SIP Monitor do this? Monit maybe? Any other recommendations?
>  
> Regards
> Michael Knill
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] SIP Monitor

[Michael K. <mic...@ip...>]

Thanks Michael

Yes all my trunks have this!

Regards
Michael Knill
From: Michael Keuter <li...@mk...>
Reply-To: AstLinux List <ast...@li...>
Date: Saturday, 3 February 2018 at 7:24 am
To: AstLinux List <ast...@li...>
Subject: Re: [Astlinux-users] SIP Monitor

Hi Michael,

The SIP monitor only works for peers with qualify=yes.

Sent from a mobile device.

Michael Keuter

Am 02.02.2018 um 21:15 schrieb Michael Knill <mic...@ip...<mailto:mic...@ip...>>:
Hi Group

I cant seem to get the SIP Monitor working. The only time it ever sends me an email is when the box is power reset (which is actually quite handy).
I basically want to know when my trunk is UNREACHABLE or UNKNOWN and I don't want heaps of emails e.g. tell me once when its down and don't tell me its down again until it has transitioned from OK.
Will SIP Monitor do this? Monit maybe? Any other recommendations?

Regards
Michael Knill
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org<http://Slashdot.org>! http://sdm.link/slashdot
_______________________________________________
Astlinux-users mailing list
Ast...@li...<mailto:Ast...@li...>
https://lists.sourceforge.net/lists/listinfo/astlinux-users

Donations to support AstLinux are graciously accepted via PayPal to pa...@kr...<mailto:pa...@kr...>.

Re: [Astlinux-users] SIP Monitor

[Michael K. <li...@mk...>]

Hi Michael,

The SIP monitor only works for peers with qualify=yes.

Sent from a mobile device.

Michael Keuter

> Am 02.02.2018 um 21:15 schrieb Michael Knill <mic...@ip...>:
> 
> Hi Group
>  
> I cant seem to get the SIP Monitor working. The only time it ever sends me an email is when the box is power reset (which is actually quite handy).
> I basically want to know when my trunk is UNREACHABLE or UNKNOWN and I don't want heaps of emails e.g. tell me once when its down and don't tell me its down again until it has transitioned from OK.
> Will SIP Monitor do this? Monit maybe? Any other recommendations?
>  
> Regards
> Michael Knill
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

[Astlinux-users] SIP Monitor

[Michael K. <mic...@ip...>]

Hi Group

I cant seem to get the SIP Monitor working. The only time it ever sends me an email is when the box is power reset (which is actually quite handy).
I basically want to know when my trunk is UNREACHABLE or UNKNOWN and I don't want heaps of emails e.g. tell me once when its down and don't tell me its down again until it has transitioned from OK.
Will SIP Monitor do this? Monit maybe? Any other recommendations?

Regards
Michael Knill

Re: [Astlinux-users] Runnix confusion

[John N. <jn...@co...>]

Thanks Lonnie for clearing all of that up at least in my mind

I am somewhat unclear about the various HP TC models, and which has what, but am pleased to learn that the system tab options protect from something that won't work.

John  Novack

Lonnie Abelbeck wrote:
> Hi John,
>
> The docs are correct, but from my googling the HP T5720 contains an "AMD Geode NX 1500" CPU which appears to support "Physical address extensions" (PAE).
>
> When you try to perform a System tab -> "RUNNIX Bootloader Upgrade:" the /proc/cpuinfo "flags" entries are checked for ' pae ', only if ' pae ' does-not-exist are you restricted to Runnix 4.
>
> The fact that your HP T5720 boots with runnix-0.5.2 means it supports PAE.
>
> As long as the /proc/cpuinfo "flags" entries report PAE properly (I have never seen a problem) it is always safe to perform System tab -> "RUNNIX Bootloader Upgrade:" and you will get the proper Runnix version.
>
> Lonnie
>
>
> On Jan 28, 2018, at 12:30 PM, John Novack <jn...@co...> wrote:
>
>> Well, really in my head, not Runnux
>> The docs mention that Runnix version 5 isn't for older Non-PAE HP thin clients
>> So, on a HP T5720, from the web interface I did a Runnix upgrade and with the current version of Asterisk 13 on a reboot it now says Runnix 5.2 is current
>> Has there been a change that the documentation has yet to reflect?
>>
>> John Novack
>>
>>   
>> -- 
>>
>> Dog is my Co-pilot
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
>
> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
>
>

-- 

Dog is my Co-pilot

Re: [Astlinux-users] Runnix confusion

[Lonnie A. <li...@lo...>]

Hi John,

The docs are correct, but from my googling the HP T5720 contains an "AMD Geode NX 1500" CPU which appears to support "Physical address extensions" (PAE).

When you try to perform a System tab -> "RUNNIX Bootloader Upgrade:" the /proc/cpuinfo "flags" entries are checked for ' pae ', only if ' pae ' does-not-exist are you restricted to Runnix 4.

The fact that your HP T5720 boots with runnix-0.5.2 means it supports PAE.

As long as the /proc/cpuinfo "flags" entries report PAE properly (I have never seen a problem) it is always safe to perform System tab -> "RUNNIX Bootloader Upgrade:" and you will get the proper Runnix version.

Lonnie


On Jan 28, 2018, at 12:30 PM, John Novack <jn...@co...> wrote:

> Well, really in my head, not Runnux
> The docs mention that Runnix version 5 isn't for older Non-PAE HP thin clients
> So, on a HP T5720, from the web interface I did a Runnix upgrade and with the current version of Asterisk 13 on a reboot it now says Runnix 5.2 is current
> Has there been a change that the documentation has yet to reflect? 
> 
> John Novack
> 
>  
> -- 
> 
> Dog is my Co-pilot

[Astlinux-users] Runnix confusion

[John N. <jn...@co...>]

Well, really in my head, not Runnux
The docs mention that Runnix version 5 isn't for older Non-PAE HP thin clients
So, on a HP T5720, from the web interface I did a Runnix upgrade and with the current version of Asterisk 13 on a reboot it now says Runnix 5.2 is current
Has there been a change that the documentation has yet to reflect?

John Novack

-- 

Dog is my Co-pilot

[Astlinux-users] Announcing AstLinux Release: 1.3.2

[Lonnie A. <li...@lo...>]

Announcing AstLinux Release: 1.3.2

More Info: AstLinux Project
http://www.astlinux-project.org/

AstLinux 1.3.2 Highlights:
• Asterisk Versions: 11.25.3, 13.18.5
• Upgrade to Linux Kernel 3.16.51, including the RUNNIX bootloader
• Added WireGuard VPN support, an extremely simple yet fast and modern VPN
• Command "acme-client" adds --deploy-hook "custom" which executes the script "/mnt/kd/acme-deploy-custom.script"
• New command "empty" with similar functionality to "expect", allows scripting interactive sessions
• Web Interface enhancements and package upgrades providing important security and bug fixes

Full ChangeLog:
https://raw.githubusercontent.com/astlinux-project/astlinux/1.3.2/docs/ChangeLog.txt

All users are encouraged to upgrade.

AstLinux Team

Re: [Astlinux-users] Spectre / Meltdown

[Dan R. <da...@ry...>]

Hi Lonnie,

Thanks for the kind words.  The pleasure is mine!  

The only untrusted user of my AstLinux box is me.  But I'm not allowed to add executable binaries so we're probably OK.   

As always, I appreciate your insight.  

Dan
On Mon, Jan 22, 2018 at 11:04 AM, Lonnie Abelbeck  wrote:
Hi Dan,  Always a pleasure to hear from you ...

This topic has been under private discussion within the AstLinux team ... I won't speak for others but I will share my personal thoughts.

The Cisco folks offer this nice Summary ...
--
Cisco: CPU Side-Channel Information Disclosure Vulnerabilities

"To exploit any of these vulnerabilities, an attacker must be able to run crafted code on an affected device. Although the underlying CPU and operating system combination in a product may be affected by these vulnerabilities, the majority of Cisco products are closed systems that do not allow customers to run custom code on the device, and thus are not vulnerable. There is no vector to exploit them."

https://tools.cisco.com/security/center/content/CiscoSecurityAdvisory/cisco-sa-20180104-cpusidechannel (https://tools.cisco.com/security/center/content/CiscoSecurityAdvisory/cisco-sa-20180104-cpusidechannel)
--

AstLinux is the same sort of fixed-code device (appliance) ... "There is no vector to exploit them (the vulnerabilities)."

Let's assume you do not allow untrusted users adding executable binaries to your AstLinux box :-)

My opinion, keep your AstLinux network stack as locked down as possible, only enable services you need, use a VPN for remote management, and keep up with the latest AstLinux security fixes we offer.

Lonnie

On Jan 22, 2018, at 5:34 AM, Dan Ryson  wrote:

Hi,

Considering the prominence of Spectre and Meltdown discussions in the trade press, I must ask:  What is the prevailing advice for those (like me) who are running Internet-facing AstLinux systems on Intel hardware?

Thanks,

Dan

Re: [Astlinux-users] Spectre / Meltdown

[Lonnie A. <li...@lo...>]

Hi Dan,  Always a pleasure to hear from you ...

This topic has been under private discussion within the AstLinux team ... I won't speak for others but I will share my personal thoughts.

The Cisco folks offer this nice Summary ...
--
Cisco: CPU Side-Channel Information Disclosure Vulnerabilities

"To exploit any of these vulnerabilities, an attacker must be able to run crafted code on an affected device. Although the underlying CPU and operating system combination in a product may be affected by these vulnerabilities, the majority of Cisco products are closed systems that do not allow customers to run custom code on the device, and thus are not vulnerable. There is no vector to exploit them."

https://tools.cisco.com/security/center/content/CiscoSecurityAdvisory/cisco-sa-20180104-cpusidechannel
--

AstLinux is the same sort of fixed-code device (appliance) ... "There is no vector to exploit them (the vulnerabilities)."

Let's assume you do not allow untrusted users adding executable binaries to your AstLinux box :-)

My opinion, keep your AstLinux network stack as locked down as possible, only enable services you need, use a VPN for remote management, and keep up with the latest AstLinux security fixes we offer.

Lonnie


On Jan 22, 2018, at 5:34 AM, Dan Ryson <da...@ry...> wrote:

> Hi,
> 
> Considering the prominence of Spectre and Meltdown discussions in the trade press, I must ask:  What is the prevailing advice for those (like me) who are running Internet-facing AstLinux systems on Intel hardware?
> 
> Thanks,
> 
> Dan

[Astlinux-users] Spectre / Meltdown

[Dan R. <da...@ry...>]

Hi,
Considering the prominence of Spectre and Meltdown discussions in the trade press, I must ask:  What is the prevailing advice for those (like me) who are running Internet-facing AstLinux systems on Intel hardware?

Thanks,

Dan

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <mic...@ip...>]

Hmm Web server may be an issue?

Regards
Michael Knill
On 20/1/18, 3:52 pm, "Michael Knill" <mic...@ip...> wrote:

    Thanks Michael. That would be great.
    
    Im considering doing a custom build and installing the Asternic Server directly on box.
    Can you see any immediate issues with doing this?
    
    Regards
    Michael Knill
    
    On 18/1/18, 9:18 am, "Michael Keuter" <li...@mk...> wrote:
    
        
        
        Sent from a mobile device.
        
        Michael Keuter
        
        > Am 17.01.2018 um 21:58 schrieb Michael Knill <mic...@ip...>:
        > 
        > Whoops sorry MySQL module in the custom build.
        > PS I just did a Web Chat to the Asternic guys and it appears that you can set up everything on a separate server and just log your CDR to the database on that separate server.
        > I looked at CDR-Stats and it seemed a bit basic to me!
        > 
        > Regards
        > Michael Knill
        > On 18/1/18, 7:09 am, "Michael Knill" <mic...@ip...> wrote:
        > 
        >    Thanks Michael
        > 
        >    Do you need a local mysql client for Asterisk to log CDR to a remote mysql database?
        >    Couldn't it just do it natively?
        
        Yes, you need a local MySQL client.
        I have somewhere a tutorial, I look it up tomorrow.
        
        > 
        >    Regards
        >    Michael Knill
        >    On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mk...> wrote:
        > 
        > 
        >> Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
        >> 
        >> Just resurrecting this topic.
        >> So do I have ANY options for CDR Analysis on Astlinux?
        >> I have a potential customer that I don't think I can win without it (
        >> It doesn't need to be anything special but Im loathed to start developing something myself.
        >> 
        >> Thanks
        >> Mike 
        >> 
        >> Regards
        >> Michael Knill
        > 
        >        Hello Michael,
        > 
        >        as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
        >        I used that years ago for testing with the old Areski CDR Stats (v1).
        > 
        >        Then you could either export the raw CDR csv data or write custom views for the SQLite database.
        > 
        >        Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
        >        If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
        >        I made a little recherche and there are some build options to reduce the binary file size of the Go app.
        > 
        >> On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
        >> 
        >>   Sent from a mobile device.
        >> 
        >>   Michael Keuter
        >> 
        >>> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
        >>> 
        >>> Hi Michael. Yes it certainly would be great to have this working.
        >>> It looks like Asternic is OnBox only?
        >> 
        >>   Maybe the easiest is to ask Nicolas directly ...
        >> 
        >>> Regards
        >>> Michael Knill
        >>> -----Original Message-----
        >>> From: Michael Keuter <li...@mk...>
        >>> Reply-To: AstLinux List <ast...@li...>
        >>> Date: Sunday, 7 January 2018 at 9:59 pm
        >>> To: AstLinux List <ast...@li...>
        >>> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
        >>> 
        >>>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
        >>>> 
        >>>> Hi Group
        >>>> 
        >>>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
        >>>> Here are my current options:
        >>>>  • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
        >>>>  • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
        >>>>  • Some other option?
        >>>> 
        >>>> I would love to hear what others are doing in this space.
        >>>> 
        >>>> Regards
        >>>> Michael Knill
        >>> 
        >>> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
        >>> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
        >>> 
        >>> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
        >>> 
        >>> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
        >>> 
        >>> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
        >>> 
        >>> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
        >>> 
        >>> https://github.com/cdr-stats/cdr-pusher
        >>> 
        >>> BTW: Go 1.9 is already included in BR2 :-).
        >>> 
        >>> Michael
        >>> 
        >>> http://www.mksolutions.info
        >>> 
        >>> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
        > 
        >        Michael
        > 
        >        http://www.mksolutions.info
        > 
        > 
        > 
        > 
        >        ------------------------------------------------------------------------------
        >        Check out the vibrant tech community on one of the world's most
        >        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        >        _______________________________________________
        >        Astlinux-users mailing list
        >        Ast...@li...
        >        https://lists.sourceforge.net/lists/listinfo/astlinux-users
        > 
        >        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
        > 
        >    ------------------------------------------------------------------------------
        >    Check out the vibrant tech community on one of the world's most
        >    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        >    _______________________________________________
        >    Astlinux-users mailing list
        >    Ast...@li...
        >    https://lists.sourceforge.net/lists/listinfo/astlinux-users
        > 
        >    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
        > 
        > ------------------------------------------------------------------------------
        > Check out the vibrant tech community on one of the world's most
        > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        > _______________________________________________
        > Astlinux-users mailing list
        > Ast...@li...
        > https://lists.sourceforge.net/lists/listinfo/astlinux-users
        > 
        > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
        
        
        ------------------------------------------------------------------------------
        Check out the vibrant tech community on one of the world's most
        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        _______________________________________________
        Astlinux-users mailing list
        Ast...@li...
        https://lists.sourceforge.net/lists/listinfo/astlinux-users
        
        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <mic...@ip...>]

Thanks Michael. That would be great.

Im considering doing a custom build and installing the Asternic Server directly on box.
Can you see any immediate issues with doing this?

Regards
Michael Knill

On 18/1/18, 9:18 am, "Michael Keuter" <li...@mk...> wrote:

    
    
    Sent from a mobile device.
    
    Michael Keuter
    
    > Am 17.01.2018 um 21:58 schrieb Michael Knill <mic...@ip...>:
    > 
    > Whoops sorry MySQL module in the custom build.
    > PS I just did a Web Chat to the Asternic guys and it appears that you can set up everything on a separate server and just log your CDR to the database on that separate server.
    > I looked at CDR-Stats and it seemed a bit basic to me!
    > 
    > Regards
    > Michael Knill
    > On 18/1/18, 7:09 am, "Michael Knill" <mic...@ip...> wrote:
    > 
    >    Thanks Michael
    > 
    >    Do you need a local mysql client for Asterisk to log CDR to a remote mysql database?
    >    Couldn't it just do it natively?
    
    Yes, you need a local MySQL client.
    I have somewhere a tutorial, I look it up tomorrow.
    
    > 
    >    Regards
    >    Michael Knill
    >    On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mk...> wrote:
    > 
    > 
    >> Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
    >> 
    >> Just resurrecting this topic.
    >> So do I have ANY options for CDR Analysis on Astlinux?
    >> I have a potential customer that I don't think I can win without it (
    >> It doesn't need to be anything special but Im loathed to start developing something myself.
    >> 
    >> Thanks
    >> Mike 
    >> 
    >> Regards
    >> Michael Knill
    > 
    >        Hello Michael,
    > 
    >        as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
    >        I used that years ago for testing with the old Areski CDR Stats (v1).
    > 
    >        Then you could either export the raw CDR csv data or write custom views for the SQLite database.
    > 
    >        Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
    >        If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
    >        I made a little recherche and there are some build options to reduce the binary file size of the Go app.
    > 
    >> On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
    >> 
    >>   Sent from a mobile device.
    >> 
    >>   Michael Keuter
    >> 
    >>> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
    >>> 
    >>> Hi Michael. Yes it certainly would be great to have this working.
    >>> It looks like Asternic is OnBox only?
    >> 
    >>   Maybe the easiest is to ask Nicolas directly ...
    >> 
    >>> Regards
    >>> Michael Knill
    >>> -----Original Message-----
    >>> From: Michael Keuter <li...@mk...>
    >>> Reply-To: AstLinux List <ast...@li...>
    >>> Date: Sunday, 7 January 2018 at 9:59 pm
    >>> To: AstLinux List <ast...@li...>
    >>> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
    >>> 
    >>>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
    >>>> 
    >>>> Hi Group
    >>>> 
    >>>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
    >>>> Here are my current options:
    >>>>  • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
    >>>>  • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
    >>>>  • Some other option?
    >>>> 
    >>>> I would love to hear what others are doing in this space.
    >>>> 
    >>>> Regards
    >>>> Michael Knill
    >>> 
    >>> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
    >>> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
    >>> 
    >>> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
    >>> 
    >>> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
    >>> 
    >>> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
    >>> 
    >>> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
    >>> 
    >>> https://github.com/cdr-stats/cdr-pusher
    >>> 
    >>> BTW: Go 1.9 is already included in BR2 :-).
    >>> 
    >>> Michael
    >>> 
    >>> http://www.mksolutions.info
    >>> 
    >>> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
    > 
    >        Michael
    > 
    >        http://www.mksolutions.info
    > 
    > 
    > 
    > 
    >        ------------------------------------------------------------------------------
    >        Check out the vibrant tech community on one of the world's most
    >        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    >        _______________________________________________
    >        Astlinux-users mailing list
    >        Ast...@li...
    >        https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    >        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    >    ------------------------------------------------------------------------------
    >    Check out the vibrant tech community on one of the world's most
    >    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    >    _______________________________________________
    >    Astlinux-users mailing list
    >    Ast...@li...
    >    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    >    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    > _______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <li...@mk...>]

Sent from a mobile device.

Michael Keuter

> Am 17.01.2018 um 21:58 schrieb Michael Knill <mic...@ip...>:
> 
> Whoops sorry MySQL module in the custom build.
> PS I just did a Web Chat to the Asternic guys and it appears that you can set up everything on a separate server and just log your CDR to the database on that separate server.
> I looked at CDR-Stats and it seemed a bit basic to me!
> 
> Regards
> Michael Knill
> On 18/1/18, 7:09 am, "Michael Knill" <mic...@ip...> wrote:
> 
>    Thanks Michael
> 
>    Do you need a local mysql client for Asterisk to log CDR to a remote mysql database?
>    Couldn't it just do it natively?

Yes, you need a local MySQL client.
I have somewhere a tutorial, I look it up tomorrow.

> 
>    Regards
>    Michael Knill
>    On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mk...> wrote:
> 
> 
>> Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
>> 
>> Just resurrecting this topic.
>> So do I have ANY options for CDR Analysis on Astlinux?
>> I have a potential customer that I don't think I can win without it (
>> It doesn't need to be anything special but Im loathed to start developing something myself.
>> 
>> Thanks
>> Mike 
>> 
>> Regards
>> Michael Knill
> 
>        Hello Michael,
> 
>        as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
>        I used that years ago for testing with the old Areski CDR Stats (v1).
> 
>        Then you could either export the raw CDR csv data or write custom views for the SQLite database.
> 
>        Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
>        If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
>        I made a little recherche and there are some build options to reduce the binary file size of the Go app.
> 
>> On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
>> 
>>   Sent from a mobile device.
>> 
>>   Michael Keuter
>> 
>>> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
>>> 
>>> Hi Michael. Yes it certainly would be great to have this working.
>>> It looks like Asternic is OnBox only?
>> 
>>   Maybe the easiest is to ask Nicolas directly ...
>> 
>>> Regards
>>> Michael Knill
>>> -----Original Message-----
>>> From: Michael Keuter <li...@mk...>
>>> Reply-To: AstLinux List <ast...@li...>
>>> Date: Sunday, 7 January 2018 at 9:59 pm
>>> To: AstLinux List <ast...@li...>
>>> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
>>> 
>>>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
>>>> 
>>>> Hi Group
>>>> 
>>>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
>>>> Here are my current options:
>>>>  • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
>>>>  • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
>>>>  • Some other option?
>>>> 
>>>> I would love to hear what others are doing in this space.
>>>> 
>>>> Regards
>>>> Michael Knill
>>> 
>>> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
>>> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
>>> 
>>> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
>>> 
>>> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
>>> 
>>> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
>>> 
>>> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
>>> 
>>> https://github.com/cdr-stats/cdr-pusher
>>> 
>>> BTW: Go 1.9 is already included in BR2 :-).
>>> 
>>> Michael
>>> 
>>> http://www.mksolutions.info
>>> 
>>> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
> 
>        Michael
> 
>        http://www.mksolutions.info
> 
> 
> 
> 
>        ------------------------------------------------------------------------------
>        Check out the vibrant tech community on one of the world's most
>        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>        _______________________________________________
>        Astlinux-users mailing list
>        Ast...@li...
>        https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
> 
>    ------------------------------------------------------------------------------
>    Check out the vibrant tech community on one of the world's most
>    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>    _______________________________________________
>    Astlinux-users mailing list
>    Ast...@li...
>    https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
>    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Astlinux-users mailing list
> Ast...@li...
> https://lists.sourceforge.net/lists/listinfo/astlinux-users
> 
> Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <mic...@ip...>]

Whoops sorry MySQL module in the custom build.
PS I just did a Web Chat to the Asternic guys and it appears that you can set up everything on a separate server and just log your CDR to the database on that separate server.
I looked at CDR-Stats and it seemed a bit basic to me!

Regards
Michael Knill
On 18/1/18, 7:09 am, "Michael Knill" <mic...@ip...> wrote:

    Thanks Michael
    
    Do you need a local mysql client for Asterisk to log CDR to a remote mysql database?
    Couldn't it just do it natively?
    
    Regards
    Michael Knill
    On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mk...> wrote:
    
        
        > Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
        > 
        > Just resurrecting this topic.
        > So do I have ANY options for CDR Analysis on Astlinux?
        > I have a potential customer that I don't think I can win without it (
        > It doesn't need to be anything special but Im loathed to start developing something myself.
        > 
        > Thanks
        > Mike 
        > 
        > Regards
        > Michael Knill
        
        Hello Michael,
        
        as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
        I used that years ago for testing with the old Areski CDR Stats (v1).
        
        Then you could either export the raw CDR csv data or write custom views for the SQLite database.
        
        Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
        If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
        I made a little recherche and there are some build options to reduce the binary file size of the Go app.
        
        > On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
        > 
        >    Sent from a mobile device.
        > 
        >    Michael Keuter
        > 
        >> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
        >> 
        >> Hi Michael. Yes it certainly would be great to have this working.
        >> It looks like Asternic is OnBox only?
        > 
        >    Maybe the easiest is to ask Nicolas directly ...
        > 
        >> Regards
        >> Michael Knill
        >> -----Original Message-----
        >> From: Michael Keuter <li...@mk...>
        >> Reply-To: AstLinux List <ast...@li...>
        >> Date: Sunday, 7 January 2018 at 9:59 pm
        >> To: AstLinux List <ast...@li...>
        >> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
        >> 
        >>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
        >>> 
        >>> Hi Group
        >>> 
        >>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
        >>> Here are my current options:
        >>>   • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
        >>>   • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
        >>>   • Some other option?
        >>> 
        >>> I would love to hear what others are doing in this space.
        >>> 
        >>> Regards
        >>> Michael Knill
        >> 
        >> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
        >> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
        >> 
        >> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
        >> 
        >> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
        >> 
        >> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
        >> 
        >> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
        >> 
        >> https://github.com/cdr-stats/cdr-pusher
        >> 
        >> BTW: Go 1.9 is already included in BR2 :-).
        >> 
        >> Michael
        >> 
        >> http://www.mksolutions.info
        >> 
        >> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
        
        Michael
        
        http://www.mksolutions.info
        
        
        
        
        ------------------------------------------------------------------------------
        Check out the vibrant tech community on one of the world's most
        engaging tech sites, Slashdot.org! http://sdm.link/slashdot
        _______________________________________________
        Astlinux-users mailing list
        Ast...@li...
        https://lists.sourceforge.net/lists/listinfo/astlinux-users
        
        Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <mic...@ip...>]

Thanks Michael

Do you need a local mysql client for Asterisk to log CDR to a remote mysql database?
Couldn't it just do it natively?

Regards
Michael Knill
On 17/1/18, 9:53 pm, "Michael Keuter" <li...@mk...> wrote:

    
    > Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
    > 
    > Just resurrecting this topic.
    > So do I have ANY options for CDR Analysis on Astlinux?
    > I have a potential customer that I don't think I can win without it (
    > It doesn't need to be anything special but Im loathed to start developing something myself.
    > 
    > Thanks
    > Mike 
    > 
    > Regards
    > Michael Knill
    
    Hello Michael,
    
    as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
    I used that years ago for testing with the old Areski CDR Stats (v1).
    
    Then you could either export the raw CDR csv data or write custom views for the SQLite database.
    
    Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
    If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
    I made a little recherche and there are some build options to reduce the binary file size of the Go app.
    
    > On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
    > 
    >    Sent from a mobile device.
    > 
    >    Michael Keuter
    > 
    >> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
    >> 
    >> Hi Michael. Yes it certainly would be great to have this working.
    >> It looks like Asternic is OnBox only?
    > 
    >    Maybe the easiest is to ask Nicolas directly ...
    > 
    >> Regards
    >> Michael Knill
    >> -----Original Message-----
    >> From: Michael Keuter <li...@mk...>
    >> Reply-To: AstLinux List <ast...@li...>
    >> Date: Sunday, 7 January 2018 at 9:59 pm
    >> To: AstLinux List <ast...@li...>
    >> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
    >> 
    >>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
    >>> 
    >>> Hi Group
    >>> 
    >>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
    >>> Here are my current options:
    >>>   • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
    >>>   • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
    >>>   • Some other option?
    >>> 
    >>> I would love to hear what others are doing in this space.
    >>> 
    >>> Regards
    >>> Michael Knill
    >> 
    >> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
    >> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
    >> 
    >> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
    >> 
    >> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
    >> 
    >> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
    >> 
    >> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
    >> 
    >> https://github.com/cdr-stats/cdr-pusher
    >> 
    >> BTW: Go 1.9 is already included in BR2 :-).
    >> 
    >> Michael
    >> 
    >> http://www.mksolutions.info
    >> 
    >> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
    
    Michael
    
    http://www.mksolutions.info
    
    
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <li...@mk...>]

> Am 17.01.2018 um 11:06 schrieb Michael Knill <mic...@ip...>:
> 
> Just resurrecting this topic.
> So do I have ANY options for CDR Analysis on Astlinux?
> I have a potential customer that I don't think I can win without it (
> It doesn't need to be anything special but Im loathed to start developing something myself.
> 
> Thanks
> Mike 
> 
> Regards
> Michael Knill

Hello Michael,

as I said another option would be logging to an external MySQL database. You need to custom build the (quite old) MySQL client for AstLinux.
I used that years ago for testing with the old Areski CDR Stats (v1).

Then you could either export the raw CDR csv data or write custom views for the SQLite database.

Have you tried "CDR Stats" (or the demo) already? Is that the right tool?
If so we could include the CDR pusher Go app for "CDR Stats" as package for custom builds (I am also are voting for that, cause I also have some existing customers who would like that).
I made a little recherche and there are some build options to reduce the binary file size of the Go app.

> On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:
> 
>    Sent from a mobile device.
> 
>    Michael Keuter
> 
>> Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
>> 
>> Hi Michael. Yes it certainly would be great to have this working.
>> It looks like Asternic is OnBox only?
> 
>    Maybe the easiest is to ask Nicolas directly ...
> 
>> Regards
>> Michael Knill
>> -----Original Message-----
>> From: Michael Keuter <li...@mk...>
>> Reply-To: AstLinux List <ast...@li...>
>> Date: Sunday, 7 January 2018 at 9:59 pm
>> To: AstLinux List <ast...@li...>
>> Subject: Re: [Astlinux-users] CDR Reporting and Analysis
>> 
>>> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
>>> 
>>> Hi Group
>>> 
>>> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
>>> Here are my current options:
>>>   • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
>>>   • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
>>>   • Some other option?
>>> 
>>> I would love to hear what others are doing in this space.
>>> 
>>> Regards
>>> Michael Knill
>> 
>> Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
>> But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
>> 
>> I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
>> 
>> http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
>> 
>> The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
>> 
>> Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
>> 
>> https://github.com/cdr-stats/cdr-pusher
>> 
>> BTW: Go 1.9 is already included in BR2 :-).
>> 
>> Michael
>> 
>> http://www.mksolutions.info
>> 
>> PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/

Michael

http://www.mksolutions.info

Re: [Astlinux-users] CDR Reporting and Analysis

[Michael K. <mic...@ip...>]

Just resurrecting this topic.
So do I have ANY options for CDR Analysis on Astlinux?
I have a potential customer that I don't think I can win without it (
It doesn't need to be anything special but Im loathed to start developing something myself.

Thanks
Mike 

Regards
Michael Knill
On 8/1/18, 10:26 am, "Michael Keuter" <li...@mk...> wrote:

    
    
    Sent from a mobile device.
    
    Michael Keuter
    
    > Am 08.01.2018 um 00:12 schrieb Michael Knill <mic...@ip...>:
    > 
    > Hi Michael. Yes it certainly would be great to have this working.
    > It looks like Asternic is OnBox only?
    
    Maybe the easiest is to ask Nicolas directly ...
    
    > Regards
    > Michael Knill
    > -----Original Message-----
    > From: Michael Keuter <li...@mk...>
    > Reply-To: AstLinux List <ast...@li...>
    > Date: Sunday, 7 January 2018 at 9:59 pm
    > To: AstLinux List <ast...@li...>
    > Subject: Re: [Astlinux-users] CDR Reporting and Analysis
    > 
    >> Am 06.01.2018 um 01:57 schrieb Michael Knill <mic...@ip...>:
    >> 
    >> Hi Group
    >> 
    >> Im getting a number of requests from my customers for this and Im not quite sure which way to go.
    >> Here are my current options:
    >>    • Roll my own on Astlinux – Certainly the best option but also the most time consuming and potentially costly
    >>    • Use an external application e.g. CDR Stats – I am concerned about the integration requirements to Astlinux. Is anyone using this?
    >>    • Some other option?
    >> 
    >> I would love to hear what others are doing in this space.
    >> 
    >> Regards
    >> Michael Knill
    > 
    > Years ago I used the old (Areski) Asterisk-Stat (the predesessor of the current CDR Stats), with a MySQL connector (custom build was needed).
    > But at that time the GUI was quite barebone and nothing for my customers :-), so I used it only for my own testing.
    > 
    > I looked at the "new" CDR Stats 3.x a while a ago. But it needs the "CDR Pusher" application which is Go based:
    > 
    > http://docs.cdr-stats.org/en/latest/installation/configure-asterisk.html
    > 
    > The good thing is, it is free and it supports more than one Asterisk server. I would be interested as well in CDR Stats (installed on a VM or so).
    > 
    > Maybe there are other ways to e.g. rsync the CDR SQLite database regularly, to include Go or rewrite the Go script in a language AstLinux supports.
    > 
    > https://github.com/cdr-stats/cdr-pusher
    > 
    > BTW: Go 1.9 is already included in BR2 :-).
    > 
    > Michael
    > 
    > http://www.mksolutions.info
    > 
    > PS: There is also another commercial CDR application from Nicolas Gaudino (the FOP2 guy): http://www.asternic.net/cdrreports/
    > 
    > 
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    > _______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    > 
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    > _______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....

Re: [Astlinux-users] Network connectivity and DNS issues

[Michael K. <mic...@ip...>]

Thanks Lonnie

I have confirmed with my main provider that their IP Address will likely never change to I will be putting the IP Address in sip.conf so I don't even need to set a static host.
I do like to know the reachability of my trunks so I will keep the OPTIONS pings going.

Thanks so much again for your help. 

Regards
Michael Knill

On 13/1/18, 2:42 am, "Lonnie Abelbeck" <li...@lo...> wrote:

    Hi Michael,
    
    The easiest way to always make sure a DNS name resolves is to define static IP addresses in:
    
    Network tab -> Network Services: -> DNS Forwarder & DHCP Server: { Configure DNS Hosts }
    
    There you can statically define DNS host names without requiring any changes to your Asterisk configuration. Of course if your SIP provider makes changes you will have to reconfigure the DNS IP's like a bunny.
    
    
    Another approach, or in tandem, is to not depend on OPTIONS pings (qualify=yes) to keep firewall ports open, instead (qualify=no) use very specific (secure) firewall rules for inbound SIP calls.
    
    
    To be clear, it is not recommended to do either of the above as a general practice, but you do what you have to do.
    
    Lonnie
    
    
    On Jan 11, 2018, at 10:50 PM, Michael Knill <mic...@ip...> wrote:
    
    > Hi Group
    >  
    > I have started a new thread although this is a continuation of my intermittent issues with sip trunks not coming back after a network outage.
    > After some testing in the lab I have realised that most of these problems are related to DNS resolution.
    >  
    > Basically I am using sip domain names for all my providers so DNS resolution is necessary. What I have found is that if for some reason DNS resolution is not possible (e.g. network is down), if the system is rebooted or Asterisk loses the resolved address, it no longer sends the OPTIONS pings as it cant find the address obviously.
    > Yes that makes sense however the problem arises when the network is restored, Asterisk is completely unaware and therefore makes no attempt in resolving the address.
    > I believe this is what is causing my intermittent issues which is easily resolved by doing an Asterisk Reload when network connectivity is restored. I have also enabled the Asterisk dnsmgr which does not fix the problem. I suspect that if it couldn't initially resolve it then it gives up totally.
    >  
    > So what is the fix. Here are some of my options:
    > 	• Don't use DNS but just use the IP Address instead. This will most certainly resolve the issue but is it the best way? Something in the Hosts file maybe?
    > 	• Perform sip monitoring using the SIP Monitor script or Monit. If the SIP URL is resolvable but the status is UNKNOWN then issue a module reload of chan_sip
    > 	• Something else
    >  
    > PS the SIP Monitor does not seem to work for me. It only sends me an email when the system is rebooted.
    > Thanks all.
    >  
    > Regards
    > Michael Knill
    > ------------------------------------------------------------------------------
    > Check out the vibrant tech community on one of the world's most
    > engaging tech sites, Slashdot.org! http://sdm.link/slashdot_______________________________________________
    > Astlinux-users mailing list
    > Ast...@li...
    > https://lists.sourceforge.net/lists/listinfo/astlinux-users
    > 
    > Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....
    
    
    ------------------------------------------------------------------------------
    Check out the vibrant tech community on one of the world's most
    engaging tech sites, Slashdot.org! http://sdm.link/slashdot
    _______________________________________________
    Astlinux-users mailing list
    Ast...@li...
    https://lists.sourceforge.net/lists/listinfo/astlinux-users
    
    Donations to support AstLinux are graciously accepted via PayPal to pa...@kr....