Phibee Network Operation Center
2009-Oct-31 18:44 UTC
[asterisk-users] Asterisk, Realtime and specify MySQL Table Name ?
Hi actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. I read on the wiki: ==================================================Database Config put the following in res_mysql.conf [general] dbhost = 127.0.0.1 dbname = asterisk dbuser = myuser dbpass = mypass dbport = 3306 Values in sip.conf or iax.conf like in older versions of * are no longer used. Database Table Lets create the table we need: NOTE: You can use any table name you wish, just make sure the table name matches what you have the family name bound to. ================================================== But i don't see where i put the Table Name ? (if i don't want use sip_buddies) and he have a sample of Table Structure, can i add a new champs for my personnal software without problems ? Thanks jerome
Samuel Nair
2009-Nov-01 08:20 UTC
[asterisk-users] Asterisk, Realtime and specify MySQL Table Name ?
You can set it up in extconfig.conf: iaxusers => mysql,asterisk,iaxusers iaxpeers => mysql,asterisk,iaxusers sipusers => mysql,asterisk,sipusers sippeers => mysql,asterisk,sipusers voicemail => mysql,asterisk,voicemail extensions => mysql,asterisk,extensions queues => mysql,asterisk,queues queue_members => mysql,asterisk,queue_members meetme => mysql,asterisk,meetme sam!! Phibee Network Operation Center wrote:> Hi > > actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. > > I read on the wiki: > > ==================================================> Database Config > put the following in res_mysql.conf > > [general] > dbhost = 127.0.0.1 > dbname = asterisk > dbuser = myuser > dbpass = mypass > dbport = 3306 > > Values in sip.conf or iax.conf like in older versions of * are no longer > used. > > > Database Table > Lets create the table we need: > > NOTE: You can use any table name you wish, just make sure the table name > matches what you have the family name bound to. > > ==================================================> > > But i don't see where i put the Table Name ? (if i don't want use > sip_buddies) > > and he have a sample of Table Structure, can i add a new champs for my > personnal > software without problems ? > > Thanks > jerome > > > _______________________________________________ > -- 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 > >
Phibee Network Operation Center
2009-Nov-01 08:39 UTC
[asterisk-users] Asterisk, Realtime and specify MySQL Table Name ?
Hi ok i have understand ;=) bye Phibee Network Operation Center a ?crit :> Hi > > actually, i test a new Asterisk Server and i want add Mysql Realtime SIP. > > I read on the wiki: > > ==================================================> Database Config > put the following in res_mysql.conf > > [general] > dbhost = 127.0.0.1 > dbname = asterisk > dbuser = myuser > dbpass = mypass > dbport = 3306 > > Values in sip.conf or iax.conf like in older versions of * are no longer > used. > > > Database Table > Lets create the table we need: > > NOTE: You can use any table name you wish, just make sure the table name > matches what you have the family name bound to. > > ==================================================> > > But i don't see where i put the Table Name ? (if i don't want use > sip_buddies) > > and he have a sample of Table Structure, can i add a new champs for my > personnal > software without problems ? > > Thanks > jerome > > > _______________________________________________ > -- 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 > > >