[Freeswitch-users] mod_python fetching data from mysql for VM

[João Mesquita]

Maciej,

Take a look at the xml_hooks we have on mod_python. Might do the trick for
you.

http://svn.freeswitch.org/svn/freeswitch/trunk/src/mod/languages/mod_python/python_example.py

JM


On Sat, Feb 13, 2010 at 6:59 PM, mbsip <mbsip at gazeta.pl> wrote:

> There is a lack of connection between fatched data and voicemail and I
> dont know how to achieve it.
>
> Thx,
> Maciej.
>
>
> 2010/2/13 mbsip <mbsip at gazeta.pl>:
> > Thx for prompt reply.
> >
> > The main task is to be able to use Mysql db in conjunction with VM
> > (but not only voicemail_msgs, voicemail_prefs).
> >
> > Lets imagine sb is calling 1000 and wants to record the message.
> > According to mod_voicemail settings message should be sent to some
> > email address.
> > But the information about user 1000 and his settings like email
> > address, passwd, quota should be fetched from Mysql db, not from
> > directory/default/1000.xml.
> > That's why I am using <action application="python" data="test"/> in my
> > dialplan to work with python script which in turn should do the magic.
> > The script should be able to gather all necessery data about user 1000
> > (like email address in shown example) and use them in VM.
> >
> > So the problem is how to modify the script to force voicemail app to
> > use data from DB.
> > Currently  session.execute("voicemail", "default ${domain} " +
> > the_dest) is still using .xml files.
> >
> > Thx,
> > Maciej.
> >
> >
> > 2010/2/13 Michael Jerris <mike at jerris.com>:
> >> Can you describe what your trying to accomplish, I don't understand what
> the goal is.  What feature are you looking for that does not already exist
> in mod_voiceamil.
> >>
> >> Mike
> >>
> >> On Feb 13, 2010, at 3:03 PM, mbsip wrote:
> >>
> >>> Hello,
> >>>
> >>> I am trying to use mod_python to fetch data from Mysql db (through
> >>> ODBC) and execute voicemail application.
> >>> Below a part of my script:
> >>>
> >>> db=MySQLdb.connect("localhost","root","","test")
> >>>       Cursor=db.cursor()
> >>>       sql = "SELECT email FROM VM WHERE called_num=%s" % the_dest
> >>>       Cursor.execute(sql)
> >>>       while (1):
> >>>               Results = Cursor.fetchone()
> >>>               if Results == None:
> >>>                       break
> >>>               consoleLog("debug", "Found email " + Results[0] +"\n")
> >>>               the_recipient = Results[0]
> >>>       db.close()
> >>>
> >>> Now i have email address corresponding with called number. The
> >>> question is how to use it for voicemail application?
> >>> So it also means how to omit all /directory/default/....xml, where
> >>> there are all VM parameters set and use fetched data.
> >>>
> >>>       session.answer()
> >>>       session.execute("voicemail", "default ${domain} " + the_dest)
> >>>
> >>> Is this possible or should I start all VM app in python from the
> scratch?
> >>
> >>
> >> _______________________________________________
> >> FreeSWITCH-users mailing list
> >> FreeSWITCH-users at lists.freeswitch.org
> >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> >> UNSUBSCRIBE:
> http://lists.freeswitch.org/mailman/options/freeswitch-users
> >> http://www.freeswitch.org
> >>
> >
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100213/6bcb289f/attachment-0002.html