[Freeswitch-users] More troubles with SQLAlchemy and mod_python

[Brian Deacon]

I would love to give back in return for the help you guys have given me,
but I'm not sure what would be valuable.  In terms of what it took to
get my stuff to work correctly, it just came down to Anthony checking in
the code fix.  My other (failed) attempts to work against a differently
compiled Python weren't necessary.  Moreover, it now works with the
python 2.4 I have on that machine as opposed to an "official" 2.5 python
package I was going to replace it with.

So I've updated the part in the wiki about this bug to basically just
say "Fixed in the code now":
http://wiki.freeswitch.org/wiki/Mod_python#ImportError:_.2F...2Fdatetime.so:_undefined_symbol:_PyExc_IOError
and
http://wiki.freeswitch.org/wiki/Mod_python#ImportError:_.2Fusr.2Flib.2F...2Fdatetime.so:_undefinedsymbol:__Py_ZeroStruct

What maybe isn't on the wiki (or at least I didn't see it) is that the
only way I was able to see the error output was to run freeswitch from
gdb.  Would I have seen that log output by bumping up the loglevel from
fs_cli?

But otherwise what I'm doing so far is pretty generic to the other
examples:
<action application="set" data="myvar=python(mypackage.mymodule)" />

And mymodule is just a standard fsapi(session, stream, env, args)

The only "tricky" thing was that the code called from fsapi was calling
out to a postgresql database via sqlalchemy.  But from python's point of
view, there's nothing clever about talking to databases, and from
freeswitch's point of view there's nothing clever about calling a python
module's fsapi function.

I'll poke around and see if there's anything in the mod_python area that
I could improve on, but if you could point out anything worthwhile that
I just accomplished (or rather, that y'all accomplished for me) I'd be
more than happy to document it.  But near as I can tell, all I've really
done is help you guys fix the bug for which I was the loudest
complainer.  :)

Brian 

On Thu, 2009-01-29 at 20:34 -0600, Brian West wrote:
> Can you do some examples and documentation on the wiki about what  
> you're doing to maybe help others?
> 
> /b
> 
> On Jan 29, 2009, at 8:27 PM, Brian Deacon wrote:
> 
> > TA-DA!
> >
> > My python can now not only import the sqlalchemy module, but the  
> > code I
> > had before that was actually doing some database interaction is  
> > working
> > now.
> >
> > Thank you very much for all the help.  It is much appreciated.
> >
> > It sounds like the contents on the wiki with the modules.conf.xml or  
> > the
> > LD workarounds are superceded now.  Should I change the comments on
> > there to reflect that it should now be fixed?
> >
> > Brian
> 
> 
> _______________________________________________
> 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