Hi I have been playing with trying to get voicemail.conf from DB, I am using cvs-head, but when I start asterisk, it dies a horrible death, because it cant load any voicemil setting. I looked at my mysql logs to see what query was being sent, and I get SELECT category, var_name, var_val, cat_metric FROM voicemail_users WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id; which is in no way related to the table I created following the example on the wiki. Is there another table format , I have +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+----------------+ | uniqueid | int(11) | | PRI | NULL | auto_increment | | customer_id | int(11) | | | 0 | | | context | varchar(50) | | | | | | mailbox | int(5) | | MUL | 0 | | | password | varchar(4) | | | 0 | | | fullname | varchar(50) | | | | | | email | varchar(50) | | | | | | pager | varchar(50) | | | | | | stamp | timestamp(14) | YES | | NULL | | +-------------+---------------+------+-----+---------+----------------+ tks Iqbal
In my opinion.. using voicemail from DB is not good for "scaling up" scenarios... in particular if you need to provide HA of five nine... 99.999% The cluster database (well in particular MYSQL puts everything in RAM)... so as the user base grows.. so does RAM requirement... Ta Senad asterisk-users-bounces@lists.digium.com wrote:> Hi > > I have been playing with trying to get voicemail.conf from DB, I am > using cvs-head, but when I start asterisk, it dies a horrible death, > because it cant load any voicemil setting. > > I looked at my mysql logs to see what query was being sent, and I get > > SELECT category, var_name, var_val, cat_metric FROM voicemail_users > WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, > cat_metric desc, var_metric asc, category, var_name, var_val, id; > > which is in no way related to the table I created following the > example on the wiki. > > Is there another table format , I have > > +-------------+---------------+------+-----+---------+----------------+ >> Field | Type | Null | Key | Default | Extra | > +-------------+---------------+------+-----+---------+----------------+ >> uniqueid | int(11) | | PRI | NULL | auto_increment | >> customer_id | int(11) | | | 0 | | >> context | varchar(50) | | | | | >> mailbox | int(5) | | MUL | 0 | | >> password | varchar(4) | | | 0 | | >> fullname | varchar(50) | | | | | >> email | varchar(50) | | | | | >> pager | varchar(50) | | | | | >> stamp | timestamp(14) | YES | | NULL | | > +-------------+---------------+------+-----+---------+----------------+ > > > tks > Iqbal > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
Hi tks for the feedback, the admintool i cant use, because users create/add themselves to the system themselves, could be 100 or 1000+ users. Hence I could get my script which create user/pass details in myqsql to call the voicemail script to create the physical path on the server, but appending 1000+ lines to voicemail.conf doesnt seem like a good idea, and then reloading each time. I looked at the realtime feature in asterisk and it looked good, I want to store the voicemail on the server itself, (wish i could change the dir struture though, rather than have one ../context/voicemail etc I would want it split like a mbox mail directory structure for large scalabilty---but thats another story-new thread), and the mapping , user/pass details for each user pull from the DB. Iqbal On 5/16/2005, "Senad J" <senad@bicom.us> wrote:>asterisk-users-bounces@lists.digium.com wrote: >> but the other choice is to keep editing the voicemail.conf file, >> everytime I add a new user, which again is not really scalable. > >Using an administration interface of some kind will solve this issue. >> >> I dont wish to store the voicemail in the DB, just the conf file >> itself, mysql will easily in a clusered scenario support 100K+ >> entries. >> > >Fine... >> What setup would you recommend > >Do do what? > >Senad >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > >
asterisk-users-bounces@lists.digium.com wrote:> Hi > > tks for the feedback, the admintool i cant use, because users > create/add themselves to the system themselves, could be 100 or 1000+ > users. Hence I could get my script which create user/pass details in > myqsql to call the voicemail script to create the physical path on > the server, but appending 1000+ lines to voicemail.conf doesnt seem > like a good idea, and then reloading each time. > I looked at the realtime feature in asterisk and it looked good,yap... it sounds promissing> want to store the voicemail on the server itself, (wish i could > change the dir struture though, rather than have one > ../context/voicemail etc I would want it split like a mbox mail > directory structure for large scalabilty---but thats another > story-new thread),Why not use GFS or similar for this purpose. Since GFS it is global/cluster file system you can expand it, it is fully posix complient etc. and you do not need to worry about creating ../context/voicemail. and the mapping , user/pass details for each user> pull from the DB. > > Iqbal > > On 5/16/2005, "Senad J" <senad@bicom.us> wrote: > >> asterisk-users-bounces@lists.digium.com wrote: >>> but the other choice is to keep editing the voicemail.conf file, >>> everytime I add a new user, which again is not really scalable. >> >> Using an administration interface of some kind will solve this issue. >>> >>> I dont wish to store the voicemail in the DB, just the conf file >>> itself, mysql will easily in a clusered scenario support 100K+ >>> entries. >>> >> >> Fine... >>> What setup would you recommend >> >> Do do what? >> >> Senad >> _______________________________________________ >> Asterisk-Users mailing list >> Asterisk-Users@lists.digium.com >> http://lists.digium.com/mailman/listinfo/asterisk-users >> To UNSUBSCRIBE or update options visit: >> http://lists.digium.com/mailman/listinfo/asterisk-users >> >> > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users