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

[mbsip]

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
>