Jeremy McNamara
2004-Oct-05 11:43 UTC
[Asterisk-Users] MeetMe MySQL Patch - Testers Needed
Matthew Boehm wrote:> This patch will allow app_meetme to dynamically lookup conference numbers > and pins > in a database (MySQL). This allows for easy creation of web-based > conference administration.Why does MeetMee need to be bloated with administration tasks? MeetMe is a conferencing application, let it conference. If you want to pull authentication out of a DB, write an app that does exactly that. Jeremy McNamara
The author of CBMysql mentioned in his readme that it would be better if MeetMe read everything directly from the database. I was bored so I put this together in a few hours. This patch will allow app_meetme to dynamically lookup conference numbers and pins in a database (MySQL). This allows for easy creation of web-based conference administration. INSTRUCTIONS: Apply the patch. Create a new table using the below schema. Alter /etc/asterisk/meetme.conf to add the new options: [general] dbhost=192.168.5.5 dbuser=asterisk dbpass=asterisk dbport=3306 dbname=asterisk The table name is a #define in the app_meetme.c source. Change if you wish. Add some conferences to the table. Samples are provided below. # # Table structure for table `conference_rooms` # CREATE TABLE `conference_rooms` ( `conference_room` int(11) NOT NULL default '0', `conference_pin` int(11) default '0', UNIQUE KEY `conference_room` (`conference_room`) ) TYPE=MyISAM; # # Dumping sample data for table `conference_rooms` # INSERT INTO `conference_rooms` VALUES (12345, 9938); INSERT INTO `conference_rooms` VALUES (67890, 9938); INSERT INTO `conference_rooms` VALUES (1701, NULL); Testers needed! Comments suggestions are welcome. Please send off list as to not clutter it. Thanks, Matthew -------------- next part -------------- A non-text attachment was scrubbed... Name: mysql-meetme.patch Type: application/octet-stream Size: 8625 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20041005/9a6a3b49/mysql-meetme.obj