Webware for Python

> I upgraded to Py 2.0b2 (on Windows) and tested WebKit. No problems.
> (Remember 0.4 had a couple API issues like bind() and connect()).

I just downloaded 0.4 and, sure enough, I'm having problems with connect().
I'm running Win 2000 and Py 2.0b2.  Is there a newer version (>0.4) that
I can get?  Or is there another way to fix the problem?

Traceback (most recent call last):
  File ".\CGIAdaptor.py", line 77, in main
    s.connect(host, port)
  File "<string>", line 1, in connect
TypeError: connect requires exactly 1 argument; 2 given

[Wed Oct 04 10:57:35 2000] [error] WebKitCGIAdaptor: Error while responding
to request (unknown) Python exception: Traceback (most recent call last):
File ".\CGIAdaptor.py", line 77, in main s.connect(host, port) File "", line
1, in connect TypeError: connect requires exactly 1 argument; 2 given

The CVS version has fixed this. I just tested it with Py 2.0b2 yesterday. I 
plan on cutting a 0.4.1 release tonight or tomorrow, pending more feedback 
from testers. I think these are your options:

* Hold out for 0.4.1.

* Use CVS to access the latest in-dev version.

Info on Webware's CVS is at https://sourceforge.net/cvs/?group_id=4866
Info on CVS in general is at http://www.cvshome.org

* Tweak "s.connect(host, port)" to "s.connect((host, port))" and whatever 
other anomalies you find. There are only a few.

-Chuck


At 11:02 AM 10/4/00 -0400, Jeff Johnson wrote:
> > I upgraded to Py 2.0b2 (on Windows) and tested WebKit. No problems.
> > (Remember 0.4 had a couple API issues like bind() and connect()).
>
>I just downloaded 0.4 and, sure enough, I'm having problems with connect().
>I'm running Win 2000 and Py 2.0b2.  Is there a newer version (>0.4) that
>I can get?  Or is there another way to fix the problem?
>
>Traceback (most recent call last):
>   File ".\CGIAdaptor.py", line 77, in main
>     s.connect(host, port)
>   File "<string>", line 1, in connect
>TypeError: connect requires exactly 1 argument; 2 given
>
>[Wed Oct 04 10:57:35 2000] [error] WebKitCGIAdaptor: Error while responding
>to request (unknown) Python exception: Traceback (most recent call last):
>File ".\CGIAdaptor.py", line 77, in main s.connect(host, port) File "", line
>1, in connect TypeError: connect requires exactly 1 argument; 2 given

I fixed the problem by changing CGIAdaptor.py line 77 from:
		s.connect(host, port)
to:
		s.connect((host, port))

Next problem, default URL doesn't work:
I bring up "http://localhost/webkit/webkit.py" and get the error:
OSError: [Errno 2] No such file or directory: 'Examples\\webkit\\webkit.py'

This directory doesn't exist.
To get around this, I go to "http://localhost/webkit/webkit.py/Welcome.py".

Also, in the notes for Windows users it says that an EXE file must be made.
This doesn't appear to be true (at least for Win 2000).  I was playing with
WebWare 0.3 a few weeks ago and unfortunately don't remember everything 
(if anything) I did to get ".py" to work.

Otherwise it seems to run great so far!  Thanks!


-----Original Message-----
From: webware-discuss-admin@...
[mailto:webware-discuss-admin@... Behalf Of Jeff
Johnson
Sent: Wednesday, October 04, 2000 11:03 AM
To: 'Chuck Esterbrook'; webware-discuss@...
Subject: RE: [Webware-discuss] Update


> I upgraded to Py 2.0b2 (on Windows) and tested WebKit. No problems.
> (Remember 0.4 had a couple API issues like bind() and connect()).

I just downloaded 0.4 and, sure enough, I'm having problems with connect().
I'm running Win 2000 and Py 2.0b2.  Is there a newer version (>0.4) that
I can get?  Or is there another way to fix the problem?

Try changing it to
s.connect((host,port))

I read that Python 1.5.x accepted two arguments for the connect method even
though it wasn't documented, but they took that out in 2.0

Chris

On Wed, Oct 04, 2000 at 11:02:39AM -0400, Jeff Johnson wrote:
> > I upgraded to Py 2.0b2 (on Windows) and tested WebKit. No problems.
> > (Remember 0.4 had a couple API issues like bind() and connect()).
> 
> I just downloaded 0.4 and, sure enough, I'm having problems with connect().
> I'm running Win 2000 and Py 2.0b2.  Is there a newer version (>0.4) that
> I can get?  Or is there another way to fix the problem?
> 
> Traceback (most recent call last):
>   File ".\CGIAdaptor.py", line 77, in main
>     s.connect(host, port)
>   File "<string>", line 1, in connect
> TypeError: connect requires exactly 1 argument; 2 given
> 
> [Wed Oct 04 10:57:35 2000] [error] WebKitCGIAdaptor: Error while responding
> to request (unknown) Python exception: Traceback (most recent call last):
> File ".\CGIAdaptor.py", line 77, in main s.connect(host, port) File "", line
> 1, in connect TypeError: connect requires exactly 1 argument; 2 given
> 
> _______________________________________________
> Webware-discuss mailing list
> Webware-discuss@...
> http://lists.sourceforge.net/mailman/listinfo/webware-discuss

Jeff Johnson wrote:

> Also, in the notes for Windows users it says that an EXE file must be made.
> This doesn't appear to be true (at least for Win 2000).  I was playing with
> WebWare 0.3 a few weeks ago and unfortunately don't remember everything
> (if anything) I did to get ".py" to work.

The comment about having to make an EXE only applies to Internet Information
Server, not to Apache.  Which web server are you talking about?

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

At 11:33 AM 10/4/00 -0400, Jeff Johnson wrote:
>I fixed the problem by changing CGIAdaptor.py line 77 from:
>                 s.connect(host, port)
>to:
>                 s.connect((host, port))
>
>Next problem, default URL doesn't work:
>I bring up "http://localhost/webkit/webkit.py" and get the error:
>OSError: [Errno 2] No such file or directory: 'Examples\\webkit\\webkit.py'
>
>This directory doesn't exist.
>To get around this, I go to "http://localhost/webkit/webkit.py/Welcome.py".

What if you do something in between and put an extra slash on the end:

http://localhost/webkit/webkit.py/


>Also, in the notes for Windows users it says that an EXE file must be made.
>This doesn't appear to be true (at least for Win 2000).  I was playing with
>WebWare 0.3 a few weeks ago and unfortunately don't remember everything
>(if anything) I did to get ".py" to work.
>
>Otherwise it seems to run great so far!  Thanks!

What web server are you using and what flavor of Windows? (although web 
server is probably the important factor)

If you do remember how you go the .py to work (or even a .cgi), let us know 
and we'll update the Installation Guide.

-Chuck

Sorry for not being clear.  I'm running IIS 5.0.

I think all I had to do to get IIS to run .py scripts was add a line in the
GUI:
Default Web Site > Properties > Home Directory > Configuration > App
Mappings > Add

.py		C:\Python20\python.exe %s %s		(all)




-----Original Message-----
From: Geoff Talvola [mailto:gtalvola@...]
Sent: Wednesday, October 04, 2000 11:45 AM
To: Jeff Johnson
Cc: webware-discuss@...
Subject: Re: [Webware-discuss] Update


Jeff Johnson wrote:

> Also, in the notes for Windows users it says that an EXE file must be
made.
> This doesn't appear to be true (at least for Win 2000).  I was playing
with
> WebWare 0.3 a few weeks ago and unfortunately don't remember everything
> (if anything) I did to get ".py" to work.

The comment about having to make an EXE only applies to Internet Information
Server, not to Apache.  Which web server are you talking about?

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

Sorry for flooding the mailing list with my newbie questions :)

> What if you do something in between and put an extra slash on the end:
> http://localhost/webkit/webkit.py/

That worked!  Is the behavior without the slash expected or can it be
'fixed'?

> What web server are you using and what flavor of Windows? (although web
> server is probably the important factor)
> If you do remember how you go the .py to work (or even a .cgi), let us
know
> and we'll update the Installation Guide.

I just sent out this info in a response to a different email :)


While I'm sending emails:
So far I do all my web sites in Cold Fusion/SQL Server 7/Windows.
Everything else I do in Python.  I am tired of Cold Fusion not having OO but
it's great for spitting out database queries.  Any opinions on using WebWare
to replace Cold Fusion?

> I think all I had to do to get IIS to run .py scripts was add a line in
the GUI:
> Default Web Site > Properties > Home Directory > Configuration > App
Mappings > Add
> .py		C:\Python20\python.exe %s %s		(all)

BTW, this also makes .py files execute from anywhere in Windows 2000 just by
clicking them or typing in "foo.py" at the command prompt!  It's much better
than the old days of typing "python foo.py" all the time or having to make
.bat files.

Jeff Johnson wrote:

> I think all I had to do to get IIS to run .py scripts was add a line in the
> GUI:
> Default Web Site > Properties > Home Directory > Configuration > App Mappings
> > Add
> .py           C:\Python20\python.exe %s %s            (all)

I _was_ able to do this to get IIS to run Python scripts if the Python script
was the last path element of the url, such as:

http://localhost/testcgi.py?foo=1

but I couldn't get additional path components after the script name to work --
i.e. the following would give me a 404 error:

http://localhost/testcgi.py/bar?foo=1

And then as soon as I switched to using an EXE version of testcgi, it worked.
This capability is needed for WebKit, so I couldn't get WebKit to work without
converting the adapter to an EXE.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

Jeff Johnson wrote:

> So far I do all my web sites in Cold Fusion/SQL Server 7/Windows.
> Everything else I do in Python.  I am tired of Cold Fusion not having OO but
> it's great for spitting out database queries.  Any opinions on using WebWare
> to replace Cold Fusion?

I don't have any Cold Fusion experience, but I can certainly say that WebWare
works great for database queries on Windows against SQL Server 7 using ADO
because I'm doing it.  There are a couple of tricks involved to get ADO to work,
but fortunately for you, I've already figured them out :-)  If you're
interested, I can send out the details.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

I would love that! I tried to get ADO to work a few weeks ago but other
projects took priority.  Any help about using ADO from Python would be
greatly appreciated.

Once I figure out a little more about WebWare, I'll try to figure out if I'm
able to use .py instead of .exe for the cgiwrapper.  Right now it shows me
pages but I don't know if it really works correctly.

-----Original Message-----
From: Geoff Talvola [mailto:gtalvola@...]
Sent: Wednesday, October 04, 2000 12:55 PM
To: Jeff Johnson
Cc: 'Chuck Esterbrook'; webware-discuss@...
Subject: Re: [Webware-discuss] Update


Jeff Johnson wrote:

> So far I do all my web sites in Cold Fusion/SQL Server 7/Windows.
> Everything else I do in Python.  I am tired of Cold Fusion not having OO
but
> it's great for spitting out database queries.  Any opinions on using
WebWare
> to replace Cold Fusion?

I don't have any Cold Fusion experience, but I can certainly say that
WebWare
works great for database queries on Windows against SQL Server 7 using ADO
because I'm doing it.  There are a couple of tricks involved to get ADO to
work,
but fortunately for you, I've already figured them out :-)  If you're
interested, I can send out the details.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

Jeff Johnson wrote:

> I would love that! I tried to get ADO to work a few weeks ago but other
> projects took priority.  Any help about using ADO from Python would be
> greatly appreciated.

First of all, I recommend getting the "Python Programming on Win32" book by Mark
Hammond and Andy Robinson.  I've found it to be immensely useful.

In order to use any COM objects from a multithreaded application such as WebKit,
you have to do some COM initialization magic.  The easiest way to do this is to
create a subdirectory underneath your WebWare directory called Win32Kit.  Place
the attached file __init__.py into that directory.

You can now magically use COM objects from your WebKit servlets.

You'll want to install MDAC 2.5 which is downloadable from Microsoft -- this
gives you the latest version of ADO with drivers for SQL Server and other
databases.

Run the COM Makepy utility inside of PythonWin on "Microsoft ActiveX Data
Objects 2.5 Library."

Create an ODBC System Data Source for your SQL Server.  This can be done in the
Windows Control Panel.  The example code below assumes you called it MyDatabase.

Now you're all set -- you can use ADO from your servlets.  It's not hard to just
use the ADO objects by themselves, but I've written some helper classes that
make it easier.  It's called DatabaseMixin.py -- you can just put it in the same
directory as your servlets if you want.

I recommend installing the mxDateTime package -- it makes time manipulation much
easier.  DatabaseMixin.py assumes you have it installed.

Now, you can write servlets like the following:

from Page import Page
from DatabaseMixin import DatabaseMixin
from WebUtils.WebFuncs import HTMLEncode

class ChooseCustomer(Page, DatabaseMixin):
    def writeBody(self):
        self.writeln('<H4>Choose a Customer to work with:</H4>')
        rs = self.recordset('SELECT CustomerID, CustomerName FROM '
                            'Customers ORDER BY CustomerName')
        for record in rs:
            self.writeln('<br><a href="ChooseReport?CustomerID=%d">%s</a>' %
                         (record.CustomerID, HTMLEncode(record.CustomerName)))


That's about it.  Give it a try, and let me know if you have problems,
questions, comments, suggestions, improvements, etc.  I've glossed over some
details here in the interest of brevity, but I'd be happy to answer any
questions.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

At 12:06 PM 10/4/00 -0400, Jeff Johnson wrote:
>Sorry for flooding the mailing list with my newbie questions :)
>
> > What if you do something in between and put an extra slash on the end:
> > http://localhost/webkit/webkit.py/
>
>That worked!  Is the behavior without the slash expected or can it be
>'fixed'?

No, it's supposed to work without the slash as well. I just tried with 
Apache 1.3 + Win98 2E + IE 5.0 and it worked without the slash (using 
WebKit.cgi). I assume this is either an IIS specific problem (like we rely 
on an evironment variable that's treated differently in IIS) or .py vs. 
.cgi problem. Probably the former.

Geoff, can you do an: http://localhost/WebKit.exe  ?



> > What web server are you using and what flavor of Windows? (although web
> > server is probably the important factor)
> > If you do remember how you go the .py to work (or even a .cgi), let us
>know
> > and we'll update the Installation Guide.
>
>I just sent out this info in a response to a different email :)

I'll incorporate this in the Install Guide. Thank you for your first 
contribution to Webware.  :-)

-Chuck

At 12:44 PM 10/4/00 -0400, Geoff Talvola wrote:
>Jeff Johnson wrote:
>
> > I think all I had to do to get IIS to run .py scripts was add a line in the
> > GUI:
> > Default Web Site > Properties > Home Directory > Configuration > App 
> Mappings
> > > Add
> > .py           C:\Python20\python.exe %s %s            (all)
>
>I _was_ able to do this to get IIS to run Python scripts if the Python script
>was the last path element of the url, such as:
>
>http://localhost/testcgi.py?foo=1
>
>but I couldn't get additional path components after the script name to work --
>i.e. the following would give me a 404 error:
>
>http://localhost/testcgi.py/bar?foo=1
>
>And then as soon as I switched to using an EXE version of testcgi, it worked.
>This capability is needed for WebKit, so I couldn't get WebKit to work 
>without converting the adapter to an EXE.


Jeff, any comment? Once you switched to .py were you able to use examples 
like http://localhost/WebKit.py/Examples/Colors.py?

-Chuck

Chuck Esterbrook wrote:

> No, it's supposed to work without the slash as well. I just tried with
> Apache 1.3 + Win98 2E + IE 5.0 and it worked without the slash (using
> WebKit.cgi). I assume this is either an IIS specific problem (like we rely
> on an evironment variable that's treated differently in IIS) or .py vs.
> .cgi problem. Probably the former.
>
> Geoff, can you do an: http://localhost/WebKit.exe  ?

Yes, I can do https://localhost/WebKit/WebKit.exe (since I have it configured
to require https and it's in a subdirectory called WebKit).

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...

http://localhost/webkit/WebKit.py/Examples/Colors.py  works

http://localhost/webkit/WebKit.py/Examples/Colors.py?foo=1  works  (doesn't
give a 404 but I have no idea if foo=1 is accessable).

I'll try to make an exe later and see if resolves the problem I was having
with http://localhost/webkit/WebKit.py.

I think I also ran that command a few weeks back:
cscript adsutil.vbs SET W3SVC/1/AllowPathInfoForScriptMappings 1




-----Original Message-----
From: Chuck Esterbrook [mailto:echuck@...]
Sent: Wednesday, October 04, 2000 6:02 PM
To: Geoff Talvola; Jeff Johnson
Cc: webware-discuss@...
Subject: Re: [Webware-discuss] Update


At 12:44 PM 10/4/00 -0400, Geoff Talvola wrote:
>Jeff Johnson wrote:
>
> > I think all I had to do to get IIS to run .py scripts was add a line in
the
> > GUI:
> > Default Web Site > Properties > Home Directory > Configuration > App
> Mappings
> > > Add
> > .py           C:\Python20\python.exe %s %s            (all)
>
>I _was_ able to do this to get IIS to run Python scripts if the Python
script
>was the last path element of the url, such as:
>
>http://localhost/testcgi.py?foo=1
>
>but I couldn't get additional path components after the script name to
work --
>i.e. the following would give me a 404 error:
>
>http://localhost/testcgi.py/bar?foo=1
>
>And then as soon as I switched to using an EXE version of testcgi, it
worked.
>This capability is needed for WebKit, so I couldn't get WebKit to work
>without converting the adapter to an EXE.


Jeff, any comment? Once you switched to .py were you able to use examples
like http://localhost/WebKit.py/Examples/Colors.py?

-Chuck

I need to pay more attention... I'm running IIS 4.0 on NT 4.0, and you're
running IIS 5.0 on Win2000.  So they must have fixed the behavior of cgi
scripts in IIS 5.0/Win2000.  Chuck, you should make a note of this difference
in the IIS install section.

--


- Geoff Talvola
  Parlance Corporation
  gtalvola@...