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

[mbsip]

João,

Thanks for hint, because i don't know how the db fetched data could be
used with voicemail.
I am about to ready it carefully :P

Thanks,
Maciej

2010/2/13 João Mesquita <jmesquita at freeswitch.org>:
> 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
>
>
> _______________________________________________
> 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
>
>