[Serusers] Location table issues

Michael Shuler mike at bwsys.net
Sun Sep 26 23:37:42 CEST 2004 

Ahhh grasshopper, you see the master plan :)

That is about the only part that hasn't been finished yet and is what I am
working on now unless I have to stop and take care of the SER location
issue.. Hopefully one of the SER developers will take care of that so I can
finish my work on the Asterisk patches.

Actually what I am building is a system that would not only handle the VM
files but ANY audio files including music on hold, announcements, etc.

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

Michael Shuler, C.E.O.
BitWise Communications, Inc. (CLEC) And BitWise Systems, Inc. (ISP)
682 High Point Lane
East Peoria, IL 61611
Office: (217) 585-0357
Cell: (309) 657-6365
Fax: (309) 213-3500
E-Mail: mike at bwsys.net
Customer Service: (877) 976-0711 

> -----Original Message-----
> From: Java Rockx [mailto:javarockx at yahoo.com] 
> Sent: Sunday, September 26, 2004 4:28 PM
> To: Michael Shuler; serusers at lists.iptel.org
> Subject: RE: [Serusers] Location table issues
> 
> 
> This is really great news for me! Thanks.
> 
> One more question. Do these patches let Asterisk store 
> recorded voice mail
> messages in MySQL or are they still stored under 
> /var/spool/asterisk/voicemail?
> 
> The reason I ask is the former allows for an asterisk server 
> to go offline and
> not affect the customers ability to get their messages.
> 
> Regards,
> Paul
> 
> --- Michael Shuler <mike at bwsys.net> wrote:
> 
> > Oh yeah, one more REALLY important feature.  It allows you 
> to have a cluster
> > of Asterisk servers all run off a live common config.  No 
> more having to
> > mess around with NFS or trying to sync config files :)  
> Mark Spencer has
> > said he plans on putting this patch in Asterisk 1.1 or 1.2 
> but since 1.0.0
> > JUST came out you can bet it will be a while.
> > 
> > ----------------------------------------
> > 
> > Michael Shuler, C.E.O.
> > BitWise Communications, Inc. (CLEC) And BitWise Systems, Inc. (ISP)
> > 682 High Point Lane
> > East Peoria, IL 61611
> > Office: (217) 585-0357
> > Cell: (309) 657-6365
> > Fax: (309) 213-3500
> > E-Mail: mike at bwsys.net
> > Customer Service: (877) 976-0711 
> > 
> > > -----Original Message-----
> > > From: serusers-bounces at lists.iptel.org 
> > > [mailto:serusers-bounces at lists.iptel.org] On Behalf Of Michael Shuler
> > > Sent: Sunday, September 26, 2004 2:35 PM
> > > To: 'Java Rockx'; serusers at lists.iptel.org
> > > Subject: RE: [Serusers] Location table issues
> > > 
> > > 
> > > Yup, that's exactly what they do.  We put the full LERG in 
> > > there which is
> > > about 350,000 routes and it doesn't even bother it thanks to 
> > > MySQL's ability
> > > to search records lightning fast.  
> > > 
> > > We also use it to provision our customers and their routing 
> > > live via some
> > > PHP scripts which simply write to the MySQL tables 
> > > appropriately.  No more
> > > restarting or reloading Asterisk :)
> > > 
> > > ----------------------------------------
> > > 
> > > Michael Shuler, C.E.O.
> > > BitWise Communications, Inc. (CLEC) And BitWise Systems, 
> Inc. (ISP)
> > > 682 High Point Lane
> > > East Peoria, IL 61611
> > > Office: (217) 585-0357
> > > Cell: (309) 657-6365
> > > Fax: (309) 213-3500
> > > E-Mail: mike at bwsys.net
> > > Customer Service: (877) 976-0711 
> > > 
> > > > -----Original Message-----
> > > > From: Java Rockx [mailto:javarockx at yahoo.com] 
> > > > Sent: Sunday, September 26, 2004 2:21 PM
> > > > To: Michael Shuler; serusers at lists.iptel.org
> > > > Subject: RE: [Serusers] Location table issues
> > > > 
> > > > 
> > > > Michael,
> > > > 
> > > > I think your idea for a db_mode 3 is a good idea especially 
> > > > considering that
> > > > I'll soon be in the same position as you with respect to ser.
> > > > 
> > > > On an Asterisk note you mentioned patches at
> > > > http://svn.asteriskdocs.org/res_data/. Do these patches allow 
> > > > Asterisk to store
> > > > user and server configuration data in a MySQL database rather 
> > > > than in .conf
> > > > files? If not, could you elaborate a bit on what these 
> > > > patches fix or features
> > > > that they provide?
> > > > 
> > > > Best Regards,
> > > > Paul
> > > > 
> > > > --- Michael Shuler <mike at bwsys.net> wrote:
> > > > 
> > > > > I figured that's what people would say :( thanks though.
> > > > > 
> > > > > I thought of that but the problem is that it takes up to 
> > > > the max time of my
> > > > > longest REGISTER client timer before its back in sync with 
> > > > the one that runs
> > > > > off the DB.  It would be nice if there was a 3rd option i.e.
> > > > > modparam("usrloc", "db_mode", 3) that would make it read 
> > > > only at startup to
> > > > > "seed" the memory database.  The reason I need this is 
> > > > because I have a few
> > > > > SER servers behind a Foundry ServerIron XL layer 4 switch.  
> > > > When I bring the
> > > > > failed server back online the Foundry automatically 
> > > > recognizes that port
> > > > > 5060 is alive again and immediately starts sending it 
> > > > traffic.  If the RAM
> > > > > based location table hasn't been fully populated by the 
> > > > time this happens
> > > > > then we have a bunch of failed calls until it syncs up 
> > > > which in my case is
> > > > > up to 5 min.  I can get around this manually by removing it 
> > > > from the cluster
> > > > > config in the Foundry but that takes away from the 
> > > > automation of the whole
> > > > > thing.
> > > > > 
> > > > > Andrei/Jiri, what do you guys think of adding that as an 
> > > > option?  It seems
> > > > > to me that it would be the most logical way to go about 
> > > > doing it and should
> > > > > be very easy to do since all it is combining parts of mode 
> > > > 0 and 1/2.  I
> > > > > have little experience doing any programming in SER 
> > > > otherwise I would just
> > > > > write it and submit it as a patch.  Most of my time gets 
> > > > sucked up into
> > > > > Asterisk patches (see http://svn.asteriskdocs.org/res_data/ 
> > > > for MySQL
> > > > > dynamic config files, this is a must for carriers... Well 
> > > > at least for me :)
> > > > > ), but if you 2 don't have time or don't think its worth 
> > > > while then I guess
> > > > > I will have find time.  Please let me know what you guys 
> > > > think of this as
> > > > > soon as you get a chance.
> > > > > 
> > > > > ----------------------------------------
> > > > > 
> > > > > Michael Shuler, C.E.O.
> > > > > BitWise Communications, Inc. (CLEC) And BitWise Systems, 
> > > Inc. (ISP)
> > > > > 682 High Point Lane
> > > > > East Peoria, IL 61611
> > > > > Office: (217) 585-0357
> > > > > Cell: (309) 657-6365
> > > > > Fax: (309) 213-3500
> > > > > E-Mail: mike at bwsys.net
> > > > > Customer Service: (877) 976-0711 
> > > > > 
> > > > > 
> > > > > 
> > > > > > -----Original Message-----
> > > > > > From: Maxim Sobolev [mailto:sobomax at portaone.com] 
> > > > > > Sent: Sunday, September 26, 2004 3:28 AM
> > > > > > To: Michael Shuler
> > > > > > Cc: serusers at lists.iptel.org
> > > > > > Subject: Re: [Serusers] Location table issues
> > > > > > 
> > > > > > 
> > > > > > Michael Shuler wrote:
> > > > > > 
> > > > > > > Let's say I have 2 SER servers (ser1 and ser2).  
> Both save 
> > > > > > to the same MySQL
> > > > > > > location table and both use t_replicate to let each other 
> > > > > > know about new
> > > > > > > REGISTER's.  Lets say ser1 gets a REGISTER from a client 
> > > > > > and then calls
> > > > > > > t_replicate to send it over to ser2 and both call 
> > > > > > save("location").  Doesn't
> > > > > > > that cause ser1 and ser2 to write the same record 
> at about 
> > > > > > the same time to
> > > > > > > MySQL?  Is there any way to prevent doubling the 
> number of 
> > > > > > database writes?
> > > > > > 
> > > > > > You can configure one of the ser's to do not use database 
> > > > at all for 
> > > > > > storing contacts, which will do what you want - 
> contacts will 
> > > > > > be saved 
> > > > > > by the another ser, while t_replicate() will ensure that 
> > > > both of them 
> > > > > > have a whole set at any moment of time.
> > > > > > 
> > > > > > -Maxim
> > > > > > 
> > > > > > > 
> > > > > > > Does anyone know what the replicate column is for in the 
> > > > > > location table?
> > > > > > > 
> > > > > > > ----------------------------------------
> > > > > > > 
> > > > > > > Michael Shuler, C.E.O.
> > > > > > > BitWise Communications, Inc. (CLEC) And BitWise 
> > > > Systems, Inc. (ISP)
> > > > > > > 682 High Point Lane
> > > > > > > East Peoria, IL 61611
> > > > > > > Office: (217) 585-0357
> > > > > > > Cell: (309) 657-6365
> > > > > > > Fax: (309) 213-3500
> > > > > > > E-Mail: mike at bwsys.net
> > > > > > > Customer Service: (877) 976-0711 
> > > > > > > 
> > > > > > > _______________________________________________
> > > > > > > Serusers mailing list
> > > > > > > serusers at lists.iptel.org
> > > > > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > > > > > 
> > > > > > > 
> > > > > > 
> > > > > 
> > > > > _______________________________________________
> > > > > Serusers mailing list
> > > > > serusers at lists.iptel.org
> > > > > http://lists.iptel.org/mailman/listinfo/serusers
> > 
> === message truncated ===
> 
> 
> 
> 		
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
>

More information about the sr-users mailing list