Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

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

[asterisk-users] How to do not use Asterisk internal DB for SIP register?


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





PostPosted: Mon May 26, 2008 6:55 am    Post subject: [asterisk-users] How to do not use Asterisk internal DB for Reply with quote

Thank you for your reply.

Actually we are developers of billing system for Asterisk. And our clients
use many variations of setup.

To illustrate my question take small client with 1 Asterisk server.

No OpenSER, no other SIP proxy, just plain Asterisk which uses Realtime and
MySQL.

That's very common setup and you tell: "you should be fully reliant on the
external db and not use the Asterisk internal db at all"

So I want to know, how to do that? How to turn off internal Asterisk DB, and
how to tell Asterisk to update "fullcontact" field in DB when user
registers?

Regards,
Mindaugas Kezys
http://www.kolmisoft.com
Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
bounces at lists.digium.com] On Behalf Of Grey Man
Sent: Monday, May 26, 2008 1:15 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

Hi,

I don't fully understand your set up, my understanding is that if you
use realtime with the cache settings off you should be fully reliant
on the external db and not use the Asterisk internal db at all.

However that aside in my case I take the registration traffic
completely away from Asterisk and let my customised SIP Registrar
handle it. The SIP Registrar updates the fullcontact and outboundproxy
fields on the realtime database and that provides Asterisk with all
the info it needs to contact the SIP accounts. It also lets Asterisk
concentrate on media operations which it is very good at and offloads
SIP registrations and NAT keep alives which it is poor at.

Regards,

Greyman.

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

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
mkezys at gmail.com
Guest





PostPosted: Mon May 26, 2008 8:02 am    Post subject: [asterisk-users] How to do not use Asterisk internal DB for Reply with quote

That's what I'm talking about.

Asterisk 1.4.18.1 and 1.4.20.1 are tested on 3 different servers from clean
install (from sources). (1.4.19 does not work with SIP Realtime at all)

Realtime cashing is OFF (sip.conf rtcachefriends = no). But I still can see
(after device registration):

SIP/Registry/106 :
193.138.yyy.xxx:62501:1800:106:sip:106 at 193.138.yyy.xxx:5060

with "database show" command

"sip show peers" shows nothing

and

"fullcontact" in DB is empty.

(BTW - I cleaned DB with "database deltree SIP/Registry" before
registering.)

What's happening? New bug?

Regards,
Mindaugas Kezys
http://www.kolmisoft.com
Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
bounces at lists.digium.com] On Behalf Of Grey Man
Sent: Monday, May 26, 2008 3:28 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

On Mon, May 26, 2008 at 12:55 PM, Mindaugas Kezys <mkezys at gmail.com>
wrote:
Quote:

To illustrate my question take small client with 1 Asterisk server.

No OpenSER, no other SIP proxy, just plain Asterisk which uses
Realtime and
Quote:
MySQL.

That's very common setup and you tell: "you should be fully reliant
on the
Quote:
external db and not use the Asterisk internal db at all"

No in that case I would not say use an external SIP Registrar, it's
not worth the effort for a small set up and Asterisk should be able to
cope. If you turn offall the realtime caching settings that will stop
Asterisk using the internal db and result in it relying exclusively on
the external realtime one.

Quote:
So I want to know, how to do that? How to turn off internal Asterisk
DB, and
Quote:
how to tell Asterisk to update "fullcontact" field in DB when user
registers?

You shouldn't have to do anything except configure realtime and turn
off the realtime caching settings in sip.conf.

Regards,

Greyman.

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

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
mkezys at gmail.com
Guest





PostPosted: Mon May 26, 2008 11:01 am    Post subject: [asterisk-users] How to do not use Asterisk internal DB for Reply with quote

I have fullcontact field in DB - it's empty. It's only filled when
rtcacfriends = yes. Same on 3 servers we tested.

Thank you for good idea about sip prune.

In system with several Asterisk servers it should be done over AMI I guess,
or is here better way to do this?

Best wishes from Lithuania!

Regards,
Mindaugas Kezys
http://www.kolmisoft.com
Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
bounces at lists.digium.com] On Behalf Of Atis Lezdins
Sent: Monday, May 26, 2008 4:27 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

On Mon, May 26, 2008 at 4:02 PM, Mindaugas Kezys <mkezys at gmail.com>
wrote:
Quote:
That's what I'm talking about.

Asterisk 1.4.18.1 and 1.4.20.1 are tested on 3 different servers from
clean
Quote:
install (from sources). (1.4.19 does not work with SIP Realtime at
all)
Quote:

Realtime cashing is OFF (sip.conf rtcachefriends = no). But I still
can see
Quote:
(after device registration):

SIP/Registry/106 :
193.138.yyy.xxx:62501:1800:106:sip:106 at 193.138.yyy.xxx:5060

with "database show" command

"sip show peers" shows nothing

and

"fullcontact" in DB is empty.

(BTW - I cleaned DB with "database deltree SIP/Registry" before
registering.)

What's happening? New bug?

I checked this in sources, and seems that having "fullcontact" in
realtime table should do the trick and write to realtime engine
instead of Berkeley. However my production server also have
"SIP/Registry" entries filled in, but I have fullcontact in RT
populated too.I have "rtcachefriends" enabled, as realtime SIP peers
aren't really identical to static without cache - no call limit, state
in queues, and lot of other troubles.

Btw, rtcachefriends isn't that bad, you just have to issue "sip prune
realtime peer XXX" after each update in database.

Regards,
Atis



Quote:

Regards,
Mindaugas Kezys
http://www.kolmisoft.com


Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-
users-
Quote:
Quote:
bounces at lists.digium.com] On Behalf Of Grey Man
Sent: Monday, May 26, 2008 3:28 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

On Mon, May 26, 2008 at 12:55 PM, Mindaugas Kezys <mkezys at gmail.com>
wrote:
Quote:

To illustrate my question take small client with 1 Asterisk
server.
Quote:
Quote:
Quote:

No OpenSER, no other SIP proxy, just plain Asterisk which uses
Realtime and
Quote:
MySQL.

That's very common setup and you tell: "you should be fully
reliant
Quote:
Quote:
on the
Quote:
external db and not use the Asterisk internal db at all"

No in that case I would not say use an external SIP Registrar, it's
not worth the effort for a small set up and Asterisk should be able
to
Quote:
Quote:
cope. If you turn offall the realtime caching settings that will
stop
Quote:
Quote:
Asterisk using the internal db and result in it relying exclusively
on
Quote:
Quote:
the external realtime one.

Quote:
So I want to know, how to do that? How to turn off internal
Asterisk
Quote:
Quote:
DB, and
Quote:
how to tell Asterisk to update "fullcontact" field in DB when user
registers?

You shouldn't have to do anything except configure realtime and turn
off the realtime caching settings in sip.conf.

Regards,

Greyman.

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

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


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

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




--
Atis Lezdins,
VoIP Project Manager / Developer,
atis at iq-labs.net
Skype: atis.lezdins
Cell Phone: +371 28806004
Cell Phone: +1 800 7300689
Work phone: +1 800 7502835

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

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Back to top
mkezys at gmail.com
Guest





PostPosted: Mon May 26, 2008 3:47 pm    Post subject: [asterisk-users] How to do not use Asterisk internal DB for Reply with quote

I think I will follow your route with "prune". It will help in a long run to
avoid troubles with crippled realtime peers.

Thank you.

Regards,
Mindaugas Kezys
http://www.kolmisoft.com

Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
bounces at lists.digium.com] On Behalf Of Atis Lezdins
Sent: Monday, May 26, 2008 8:01 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

On Mon, May 26, 2008 at 7:01 PM, Mindaugas Kezys <mkezys at gmail.com>
wrote:
Quote:
I have fullcontact field in DB - it's empty. It's only filled when
rtcacfriends = yes. Same on 3 servers we tested.

Thank you for good idea about sip prune.

In system with several Asterisk servers it should be done over AMI I
guess,
Quote:
or is here better way to do this?

Yes, manager action "Command: " does the trick. Works reliably
(supposing you prune only when changing something).

If you are willing to follow this up with feedback - i suggest that
you open a bug.

Greetings from Latvia Smile
Atis

Quote:

Best wishes from Lithuania!

Regards,
Mindaugas Kezys
http://www.kolmisoft.com


Quote:
-----Original Message-----
From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-
users-
Quote:
Quote:
bounces at lists.digium.com] On Behalf Of Atis Lezdins
Sent: Monday, May 26, 2008 4:27 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] How to do not use Asterisk internal DB
for SIP register?

On Mon, May 26, 2008 at 4:02 PM, Mindaugas Kezys <mkezys at gmail.com>
wrote:
Quote:
That's what I'm talking about.

Asterisk 1.4.18.1 and 1.4.20.1 are tested on 3 different servers
from
Quote:
Quote:
clean
Quote:
install (from sources). (1.4.19 does not work with SIP Realtime at
all)
Quote:

Realtime cashing is OFF (sip.conf rtcachefriends = no). But I
still
Quote:
Quote:
can see
Quote:
(after device registration):

SIP/Registry/106 :
193.138.yyy.xxx:62501:1800:106:sip:106 at 193.138.yyy.xxx:5060

with "database show" command

"sip show peers" shows nothing

and

"fullcontact" in DB is empty.

(BTW - I cleaned DB with "database deltree SIP/Registry" before
registering.)

What's happening? New bug?

I checked this in sources, and seems that having "fullcontact" in
realtime table should do the trick and write to realtime engine
instead of Berkeley. However my production server also have
"SIP/Registry" entries filled in, but I have fullcontact in RT
populated too.I have "rtcachefriends" enabled, as realtime SIP peers
aren't really identical to static without cache - no call limit,
state
Quote:
Quote:
in queues, and lot of other troubles.

Btw, rtcachefriends isn't that bad, you just have to issue "sip
prune
Quote:
Quote:
realtime peer XXX" after each update in database.

Regards,
Atis
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

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


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services