Mailman 3 July 2007 - Twisted-web

Problem with twisted web and adbapi
by Søren Bach Christiansen July 21, 2007

July 21, 2007

Hi all I am a new user to the Twisted framework so this might be a trivial question, but here goes.. Im trying to use the Web module and adbapi module to create a (rest) webservice but I am having problems using the adbapi. As fare as I could figure out, the runInteraction call spawns a new thread and executes the sql in that, and the render_GET handler is then returning right away -bummer. I need the adbapi for its db pool but dont need it to be "blocking" so that I can return the result of the db interaction as xml. Hope you guys can help me out or give me some pointers if I am doing this the wrong way. Regards Søren ----- Code ---- from twisted.web import server from twisted.internet import reactor from twisted.enterprise import adbapi from xml.dom.minidom import Document class Simple(Resource): isLeaf=True def __init__(self,opt): Resource.__init__(self) self.opt=opt def render_GET(self,request): doc=Document() self.opt.dbpool.runInteraction(self._getUserList,doc) print "returning result" return doc.toprettyxml(indent=" ") def _getUserList(self,txn,doc): txn.execute("SELECT UserName FROM User ") res = txn.fetchall() if (res): for row in res: print row usr=doc.createElement("user") usr.setAttribute("name","%s" % (row[0] )) class options: pass if __name__ == '__main__': options.dbpool= adbapi.ConnectionPool("MySQLdb", host='localhost',db='TrackingPresentation', user='web', passwd='tingogsager') site = server.Site(Simple(options)) reactor.listenTCP(8888,site) reactor.run() ------ Code ------

3 5

simple guard question
by Phil Mayers July 20, 2007

July 20, 2007

How does one get the username for a given request? Bearing in mind that a guard sessions username may have been gathered via an HTML form and not be present on subsequent requests.

4 6

Send large files via POST, SOAP, XML-RPC, etc.
by Daniel de la Cuesta July 18, 2007

July 18, 2007

1 0

Using twisted.protocols.sip
by Nicholas Milkovits July 16, 2007

July 16, 2007

Hi, I've been working with osip and eXosip for a few weeks now but I would like to be able to prototype features for UACs and UASs a bit faster. Is there any decent examples (tutorials, implementations, etc.) of using the twisted sip protocol implementation? I've read through the API docs but it always helps to take a look at a simple example to figure out what is needed. Thanks in advance, Nick Milkovits

1 0

Cannot redirect to a SessionWrapper-wrapped page (example code included)
by kgi July 16, 2007

July 16, 2007

Hi all. I've got the following setup on a nevow site (actually, it's an Athena site, but I suspect that's incidental): - I want the initial visit to the root to be redirected to a named location on the same site (that is, http://foo.com/ => http://foo.com/bar); - I want the named location to present a login page using guard.SessionWrapper and twisted.cred; - Once authenticated, the application proper is available at the name location. At the moment, I've got the following situtation: - Publishing the DummyPage() at the root works. - Publishing the LivePage() without the SessionWrapper at the root works[1]. - Publishing the LivePage with the SessionWrapper at the root works. - Redirecting to the DummyPage() works. - Redirecting to the LivePage without the SessionWrapper works. - However, redirecting to the LivePage with the SessionWrapper seems to get into some sort of loop. [1] Where "publishing at the root" means, "passing the resource to appserver.NevowSite()" on line 157-ish The cred and guard stuff is more or less lifted from nevow/examples/guarded.py Specifically, Firefox 2.0.0.3 (at least, that's what it reports; it's the latest version on Ubuntu Feisty) says: """ The page isn't redirecting properly Firefox has detected that the server is redirecting the request for this address in a way that will never complete. * This problem can sometimes be caused by disabling or refusing to accept cookies. """ (It is set up to accept all cookies). Internet Explorer 6 (ies4linux) simply says that the site is unavailable, but I can see from the server side logs that it is hitting the server multiple times, in the same way as FF. The server prints out something like this (I'm editing, because it's quite verbose): "GET / HTTP/1.1" "GET /foopage HTTP/1.1" "GET /foopage/__session_key__ae8692cb175716b50ba92a316f586f97 HTTP/1.1" "GET /foopage?__start_session__=1 HTTP/1.1" "GET /foopage/__session_key__9237e1a6dcd263df40dc3f6357167474?__start_session__=1 HTTP/1.1" "GET /foopage?__start_session__=1 HTTP/1.1" "GET /foopage/__session_key__6e06ee432ba04231e1b1e887d024f04c?__start_session__=1 HTTP/1.1" ... [repeated about 10 times in total] ... [delay] expired session ae8692cb175716b50ba92a316f586f97 expired session 9237e1a6dcd263df40dc3f6357167474 [repeated about 10 times in total] I've attached a single-file example of the problem. Can anyone spot what I'm doing wrong? Regards, Ricky

2 2

mysql connect raise error although reconnect=true
by Andrey July 15, 2007

July 15, 2007

hello i have an xmlrpc daemon running and uses mysql for authorization. I noticed that the connection will timeout after a period of time. After investigated in the api, i found the cp_reconnect switch adbapi.ConnectionPool(DB_DRIVER,cp_reconnect=True, **DB_ARGS) however, my problem is, although the deamon will reconnect to mysql, it did raise an error and turn down the first login attempt before automatically reconnect the timeouted connection I wonder if this is normal and this switch is intented to raise error before reconnect? thanks Andrey k.

2 1

Re: Nevow tutorials
by Jim Crowell July 13, 2007

July 13, 2007

> Message: 1 > Date: Fri, 13 Jul 2007 15:32:39 +0300 > From: kgi <iacovou(a)gmail.com> > Subject: Re: [Twisted-web] Chatola broken / bug in Athena? > > Glyph, I thought I'd mention that I spent a few hours yesterday and today > creating a few new introductory Nevow pages on trac: > Very nice. Just one thing: in tutorials 3 & later, how about passing the name to the SubPage and rendering it? -Jim C.

2 1

Chatola broken / bug in Athena?
by Dav Clark July 13, 2007

July 13, 2007

I've looked a lot at chatola, and it's been a really good learning experience. But, chatola, as shipped is broke - at least on firefox 2 on OS X. The problem occurs because athena is not correctly escaping quotes in the filled stan templates. So, if any of your messages contain single quotes, you get a javascript error. Also - any use of the change nick or change topic automatically includes single quotes into a message string, and thus breaks when interpreted as javascript. A stupid simple fix is to simply change the %r interpolation on lines 90 and 98 of chatola.py to something like %s: self.content(changer, 'changed the topic to %r.' % (topic, ))) becomes self.content(changer, 'changed the topic to %s.' % (topic, ))) or even self.content(changer, 'changed the topic to "%s"' % (topic, ))) Now at least, you're not breaking automatically whenver changing topic or nickname. And then I could write custom code to properly escape the quotes in the stan template. But this violates some cental ideas that at least some of you have - namely that you don't want the application developer escaping quotes. And I assume if I do this, it could easily break in the future. I can explain in greater detail, but am throwing this out as is so that it's not too long to read ;) I can also send a code snippet if you don't want to use the chatola code. Dav Clark 917-544-8408 Dav Clark 917-544-8408

5 4

Use nevow:pattern and nevow:attr to render a list of options.
by Daniel de la Cuesta July 12, 2007

July 12, 2007

6 8

Live DataGrid example?
by Daryl Herzmann July 12, 2007

July 12, 2007

Greetings, I've got a twisted app that collects weather observations from various TCP streams and maintains a crude dictionary of most recent observations from the sensor network. I would like to present this information on an AJAX web page and have it update as new observations are received. Are there any twisted examples of doing something like this? TIA, daryl

4 3