[Asterisk-Dev] MeetMe MySQL Patch - Testers Needed

[Matthew Boehm]

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-dev/attachments/20041005/9a6a3b49/mysql-meetme.obj