Webware for Python

nothing works. any psp page i put inside the directory always comes up 404.

Ian

At 10:57 PM 6/30/2003, you wrote:
>Still trying to figure out why you would be having this problem.  Do any
>of the PSP's work?  For example do the example PSP's work?
>
>Jose
>
>-----Original Message-----
>From: webware-discuss-admin@...
>[mailto:webware-discuss-admin@...] On Behalf Of Ian
>Sent: Thursday, June 26, 2003 1:56 PM
>To: webware-discuss@...
>Subject: RE: [Webware-discuss] still getting 404's
>
>
>What exactly is a context? There is an __init__.py file in the MyContext
>
>directory.
>
>Here is all the info displayed when i run the appserver. And just to
>clear
>up the directory structure a bit:
>
>~merk/public_html is the directory i'm trying to work out of now. Apache
>
>sees it fine as the index.html page loads up correctly. I have an
>index.html and a Hello.psp page in public_html, along with all the extra
>
>directories and files the MakeAppWorking directory script created.
>
>ian
>
>WebKit AppServer 0.8
>part of Webware for Python
>Copyright 1999-2001 by Chuck Esterbrook. All Rights Reserved. WebKit and
>Webware are open source. Please visit:  http://webware.sourceforge.net
>
>Process id is 7749
>Date/time is Thu Jun 26 13:57:19 2003
>
>AutoReload             = 0
>AutoReloadPollInterval = 1
>CheckInterval          = 100
>Host                   = 127.0.0.1
>MaxServerThreads       = 20
>MinServerThreads       = 5
>PlugInDirs             = ['/disk/u/merk/work/Webware']
>PlugIns                = []
>Port                   = 8086
>PrintConfigAtStartUp   = 1
>StartServerThreads     = 10
>Verbose                = 1
>
>ActivityLogColumns              = ['request.remoteAddress',
>'request.method', 'r
>equest.uri', 'response.size', 'servlet.name', 'request.timeStamp',
>'transaction.
>duration', 'transaction.errorOccurred']
>ActivityLogFilename             =
>/disk/u/merk/public_html/Logs/Activity.csv
>AdminPassword                   = XXXXXXXXX
>CacheServletClasses             = 1
>CacheServletInstances           = 1
>ClearPSPCacheOnStart            = 1
>Contexts                        = {'Admin':
>'/disk/u/merk/work/Webware/WebKit/Ad
>min', 'default': 'MyContext', 'Testing':
>'/disk/u/merk/work/Webware/WebKit/Testi
>ng', 'Examples': '/disk/u/merk/work/Webware/WebKit/Examples',
>'MyContext':
>'MyCo
>ntext'}
>Debug                           = {'Sessions': 0}
>DirectoryFile                   = ['index', 'Index', 'main', 'Main']
>DynamicSessionTimeout           = 15
>EmailErrorReportAsAttachment    = 0
>EmailErrors                     = 0
>ErrorEmailHeaders               = {'To': ['-@...'], 'Reply-to':
>'-@...', 'Fr
>om': '-@...', 'Content-type': 'text/html', 'Subject': '[WebKit
>Error]'}
>ErrorEmailServer                = mail.-.com
>ErrorLogFilename                =
>/disk/u/merk/public_html/Logs/Errors.csv
>ErrorMessagesDir                = /disk/u/merk/public_html/ErrorMsgs
>ExtensionCascadeOrder           = ['.py', '.psp', '.html']
>ExtensionsToIgnore              = ['.pyc', '.pyo', '.py~', '.psp~',
>'.html~', '.
>bak', '.tmpl']
>ExtensionsToServe               = []
>ExtraPathInfo                   = 0
>FancyTracebackContext           = 5
>FilesToHide                     = ['.*', '*~', '*.bak', '*.tmpl',
>'*.config', '_
>_init__.*', '*.pyc', '*.pyo']
>FilesToServe                    = []
>IgnoreInvalidSession            = 1
>IncludeFancyTraceback           = 0
>LogActivity                     = 0
>MaxDynamicMemorySessions        = 10000
>MaxValueLengthInExceptionReport = 500
>OldStyleActions                 = 0
>PrintConfigAtStartUp            = 1
>RPCExceptionReturn              = traceback
>ReportRPCExceptionsInWebKit     = 1
>SaveErrorMessages               = 1
>SessionPrefix                   = None
>SessionStore                    = Dynamic
>SessionTimeout                  = 60
>ShowDebugInfoOnErrors           = 1
>UnknownFileTypes                = {'CheckDate': 1, 'Technique':
>'serveContent',
>'CacheContent': 1, 'ReuseServlets': 1}
>UseAutomaticPathSessions        = 0
>UseCascadingExtensions          = 1
>UserErrorMessage                = The site is having technical
>difficulties
>with
>   this page. An error has been logged, and the problem will be fixed as
>soon as p
>ossible. Sorry!
>
>Loading context: Admin at /disk/u/merk/work/Webware/WebKit/Admin
>Loading context: Testing at /disk/u/merk/work/Webware/WebKit/Testing
>Loading context: Examples at /disk/u/merk/work/Webware/WebKit/Examples
>Loading context: MyContext at /disk/u/merk/public_html/MyContext
>
>Current directory: /disk/u/merk/public_html
>Session Sweeper started
>
>Plug-ins list: /disk/u/merk/work/Webware/COMKit,
>/disk/u/merk/work/Webware/Middl
>eKit, /disk/u/merk/work/Webware/MiscUtils,
>/disk/u/merk/work/Webware/PSP,
>/disk/
>u/merk/work/Webware/TaskKit, /disk/u/merk/work/Webware/UserKit,
>/disk/u/merk/wor
>k/Webware/WebUtils
>Loading plug-in: COMKit at /disk/u/merk/work/Webware/COMKit
>      Plug-in /disk/u/merk/work/Webware/COMKit cannot be loaded because:
>      Required op sys is ['nt'], but actual op sys is posix. Loading
>plug-in: MiddleKit at /disk/u/merk/work/Webware/MiddleKit
>Loading context: MKBrowser at
>/disk/u/merk/work/Webware/MiddleKit/WebBrowser
>Loading plug-in: MiscUtils at /disk/u/merk/work/Webware/MiscUtils
>Loading plug-in: PSP at /disk/u/merk/work/Webware/PSP
>Loading context: PSPExamples at /disk/u/merk/work/Webware/PSP/Examples
>Loading plug-in: TaskKit at /disk/u/merk/work/Webware/TaskKit Loading
>plug-in: UserKit at /disk/u/merk/work/Webware/UserKit Loading plug-in:
>WebUtils at /disk/u/merk/work/Webware/WebUtils
>
>Listening on ('127.0.0.1', 8086)
>Creating 10 threads..
>
>At 08:41 AM 6/26/2003, you wrote:
> >Just to be sure could you check your application.conf file to see what
> >contexts are actualy listed, also when you run athe appserver from the
> >command line it displays all sorts of startup info, is the ~merk
> >context loading correctly? If it is not, make sure that you have a
> >__init__.py file in it (all the file needs is a single # in it).  You
> >need the __init__.py for the context to load correctly, I've been
> >bitten by that in the past.
> >
> >Jose
> >
> >-----Original Message-----
> >From: webware-discuss-admin@...
> >[mailto:webware-discuss-admin@...] On Behalf Of Ian
> >Sent: Thursday, June 26, 2003 4:04 AM
> >To: webware-discuss@...
> >Subject: [Webware-discuss] still getting 404's
> >
> >
> >I ran the MakeAppWorkDir.py file and it did its thing.
> >
> >I then ran the Appserver script in that directory and the app server
> >started up.
> >
> >However, every time i try to call a psp page in that directory, the
> >appserver comes back with 404. its not apache's 404 error message but
> >the appserver's 404 error message. The appserver is definitely getting
> >the
> >request:
> >
> >Ready  (0.18 seconds after launch)
> >
> >      1  2003-06-26 04:03:58  /~merk/Hello.psp
> >      1  0.00 secs            /~merk/Hello.psp
> >
> >      2  2003-06-26 04:04:00  /~merk/Hello.psp
> >      2  0.00 secs            /~merk/Hello.psp
> >
> >      3  2003-06-26 04:04:01  /~merk/Hello.psp
> >      3  0.00 secs            /~merk/Hello.psp
> >
> >Any other suggestions?
> >
> >Ian
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: INetU
> >Attention Web Developers & Consultants: Become An INetU Hosting
> >Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
> >Commission! INetU Dedicated Managed Hosting
> >http://www.inetu.net/partner/index.php
> >_______________________________________________
> >Webware-discuss mailing list Webware-discuss@...
> >https://lists.sourceforge.net/lists/listinfo/webware-discuss
> >
> >
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: INetU
> >Attention Web Developers & Consultants: Become An INetU Hosting
> >Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
> >Commission! INetU Dedicated Managed Hosting
> >http://www.inetu.net/partner/index.php
> >_______________________________________________
> >Webware-discuss mailing list
> >Webware-discuss@...
> >https://lists.sourceforge.net/lists/listinfo/webware-discuss
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: INetU
>Attention Web Developers & Consultants: Become An INetU Hosting Partner.
>Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
>INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
>_______________________________________________
>Webware-discuss mailing list Webware-discuss@...
>https://lists.sourceforge.net/lists/listinfo/webware-discuss
>
>
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>_______________________________________________
>Webware-discuss mailing list
>Webware-discuss@...
>https://lists.sourceforge.net/lists/listinfo/webware-discuss

That was already set to 0.

Ian

At 06:06 AM 7/1/2003, you wrote:
>Try setting "ExtraPathInfo" in WebKit/Configs/Application.config to 0.
>
>--Vitaliy
>
>On Tue, 2003-07-01 at 04:03, Ian wrote:
> > nothing works. any psp page i put inside the directory always comes up 404.
> >
> > Ian
> >
> > At 10:57 PM 6/30/2003, you wrote:
> > >Still trying to figure out why you would be having this problem.  Do any
> > >of the PSP's work?  For example do the example PSP's work?
> > >
> > >Jose
> > >
> > >-----Original Message-----
> > >From: webware-discuss-admin@...
> > >[mailto:webware-discuss-admin@...] On Behalf Of Ian
> > >Sent: Thursday, June 26, 2003 1:56 PM
> > >To: webware-discuss@...
> > >Subject: RE: [Webware-discuss] still getting 404's
> > >
> > >
> > >What exactly is a context? There is an __init__.py file in the MyContext
> > >
> > >directory.
> > >
> > >Here is all the info displayed when i run the appserver. And just to
> > >clear
> > >up the directory structure a bit:
> > >
> > >~merk/public_html is the directory i'm trying to work out of now. Apache
> > >
> > >sees it fine as the index.html page loads up correctly. I have an
> > >index.html and a Hello.psp page in public_html, along with all the extra
> > >
> > >directories and files the MakeAppWorking directory script created.
> > >
> > >ian
> > >
> > >WebKit AppServer 0.8
> > >part of Webware for Python
> > >Copyright 1999-2001 by Chuck Esterbrook. All Rights Reserved. WebKit and
> > >Webware are open source. Please visit:  http://webware.sourceforge.net
> > >
> > >Process id is 7749
> > >Date/time is Thu Jun 26 13:57:19 2003
> > >
> > >AutoReload             = 0
> > >AutoReloadPollInterval = 1
> > >CheckInterval          = 100
> > >Host                   = 127.0.0.1
> > >MaxServerThreads       = 20
> > >MinServerThreads       = 5
> > >PlugInDirs             = ['/disk/u/merk/work/Webware']
> > >PlugIns                = []
> > >Port                   = 8086
> > >PrintConfigAtStartUp   = 1
> > >StartServerThreads     = 10
> > >Verbose                = 1
> > >
> > >ActivityLogColumns              = ['request.remoteAddress',
> > >'request.method', 'r
> > >equest.uri', 'response.size', 'servlet.name', 'request.timeStamp',
> > >'transaction.
> > >duration', 'transaction.errorOccurred']
> > >ActivityLogFilename             =
> > >/disk/u/merk/public_html/Logs/Activity.csv
> > >AdminPassword                   = XXXXXXXXX
> > >CacheServletClasses             = 1
> > >CacheServletInstances           = 1
> > >ClearPSPCacheOnStart            = 1
> > >Contexts                        = {'Admin':
> > >'/disk/u/merk/work/Webware/WebKit/Ad
> > >min', 'default': 'MyContext', 'Testing':
> > >'/disk/u/merk/work/Webware/WebKit/Testi
> > >ng', 'Examples': '/disk/u/merk/work/Webware/WebKit/Examples',
> > >'MyContext':
> > >'MyCo
> > >ntext'}
> > >Debug                           = {'Sessions': 0}
> > >DirectoryFile                   = ['index', 'Index', 'main', 'Main']
> > >DynamicSessionTimeout           = 15
> > >EmailErrorReportAsAttachment    = 0
> > >EmailErrors                     = 0
> > >ErrorEmailHeaders               = {'To': ['-@...'], 'Reply-to':
> > >'-@...', 'Fr
> > >om': '-@...', 'Content-type': 'text/html', 'Subject': '[WebKit
> > >Error]'}
> > >ErrorEmailServer                = mail.-.com
> > >ErrorLogFilename                =
> > >/disk/u/merk/public_html/Logs/Errors.csv
> > >ErrorMessagesDir                = /disk/u/merk/public_html/ErrorMsgs
> > >ExtensionCascadeOrder           = ['.py', '.psp', '.html']
> > >ExtensionsToIgnore              = ['.pyc', '.pyo', '.py~', '.psp~',
> > >'.html~', '.
> > >bak', '.tmpl']
> > >ExtensionsToServe               = []
> > >ExtraPathInfo                   = 0
> > >FancyTracebackContext           = 5
> > >FilesToHide                     = ['.*', '*~', '*.bak', '*.tmpl',
> > >'*.config', '_
> > >_init__.*', '*.pyc', '*.pyo']
> > >FilesToServe                    = []
> > >IgnoreInvalidSession            = 1
> > >IncludeFancyTraceback           = 0
> > >LogActivity                     = 0
> > >MaxDynamicMemorySessions        = 10000
> > >MaxValueLengthInExceptionReport = 500
> > >OldStyleActions                 = 0
> > >PrintConfigAtStartUp            = 1
> > >RPCExceptionReturn              = traceback
> > >ReportRPCExceptionsInWebKit     = 1
> > >SaveErrorMessages               = 1
> > >SessionPrefix                   = None
> > >SessionStore                    = Dynamic
> > >SessionTimeout                  = 60
> > >ShowDebugInfoOnErrors           = 1
> > >UnknownFileTypes                = {'CheckDate': 1, 'Technique':
> > >'serveContent',
> > >'CacheContent': 1, 'ReuseServlets': 1}
> > >UseAutomaticPathSessions        = 0
> > >UseCascadingExtensions          = 1
> > >UserErrorMessage                = The site is having technical
> > >difficulties
> > >with
> > >   this page. An error has been logged, and the problem will be fixed as
> > >soon as p
> > >ossible. Sorry!
> > >
> > >Loading context: Admin at /disk/u/merk/work/Webware/WebKit/Admin
> > >Loading context: Testing at /disk/u/merk/work/Webware/WebKit/Testing
> > >Loading context: Examples at /disk/u/merk/work/Webware/WebKit/Examples
> > >Loading context: MyContext at /disk/u/merk/public_html/MyContext
> > >
> > >Current directory: /disk/u/merk/public_html
> > >Session Sweeper started
> > >
> > >Plug-ins list: /disk/u/merk/work/Webware/COMKit,
> > >/disk/u/merk/work/Webware/Middl
> > >eKit, /disk/u/merk/work/Webware/MiscUtils,
> > >/disk/u/merk/work/Webware/PSP,
> > >/disk/
> > >u/merk/work/Webware/TaskKit, /disk/u/merk/work/Webware/UserKit,
> > >/disk/u/merk/wor
> > >k/Webware/WebUtils
> > >Loading plug-in: COMKit at /disk/u/merk/work/Webware/COMKit
> > >      Plug-in /disk/u/merk/work/Webware/COMKit cannot be loaded because:
> > >      Required op sys is ['nt'], but actual op sys is posix. Loading
> > >plug-in: MiddleKit at /disk/u/merk/work/Webware/MiddleKit
> > >Loading context: MKBrowser at
> > >/disk/u/merk/work/Webware/MiddleKit/WebBrowser
> > >Loading plug-in: MiscUtils at /disk/u/merk/work/Webware/MiscUtils
> > >Loading plug-in: PSP at /disk/u/merk/work/Webware/PSP
> > >Loading context: PSPExamples at /disk/u/merk/work/Webware/PSP/Examples
> > >Loading plug-in: TaskKit at /disk/u/merk/work/Webware/TaskKit Loading
> > >plug-in: UserKit at /disk/u/merk/work/Webware/UserKit Loading plug-in:
> > >WebUtils at /disk/u/merk/work/Webware/WebUtils
> > >
> > >Listening on ('127.0.0.1', 8086)
> > >Creating 10 threads..
> > >
> > >At 08:41 AM 6/26/2003, you wrote:
> > > >Just to be sure could you check your application.conf file to see what
> > > >contexts are actualy listed, also when you run athe appserver from the
> > > >command line it displays all sorts of startup info, is the ~merk
> > > >context loading correctly? If it is not, make sure that you have a
> > > >__init__.py file in it (all the file needs is a single # in it).  You
> > > >need the __init__.py for the context to load correctly, I've been
> > > >bitten by that in the past.
> > > >
> > > >Jose
> > > >
> > > >-----Original Message-----
> > > >From: webware-discuss-admin@...
> > > >[mailto:webware-discuss-admin@...] On Behalf Of Ian
> > > >Sent: Thursday, June 26, 2003 4:04 AM
> > > >To: webware-discuss@...
> > > >Subject: [Webware-discuss] still getting 404's
> > > >
> > > >
> > > >I ran the MakeAppWorkDir.py file and it did its thing.
> > > >
> > > >I then ran the Appserver script in that directory and the app server
> > > >started up.
> > > >
> > > >However, every time i try to call a psp page in that directory, the
> > > >appserver comes back with 404. its not apache's 404 error message but
> > > >the appserver's 404 error message. The appserver is definitely getting
> > > >the
> > > >request:
> > > >
> > > >Ready  (0.18 seconds after launch)
> > > >
> > > >      1  2003-06-26 04:03:58  /~merk/Hello.psp
> > > >      1  0.00 secs            /~merk/Hello.psp
> > > >
> > > >      2  2003-06-26 04:04:00  /~merk/Hello.psp
> > > >      2  0.00 secs            /~merk/Hello.psp
> > > >
> > > >      3  2003-06-26 04:04:01  /~merk/Hello.psp
> > > >      3  0.00 secs            /~merk/Hello.psp
> > > >
> > > >Any other suggestions?
> > > >
> > > >Ian
> > > >
> > > >
> > > >
> > > >-------------------------------------------------------
> > > >This SF.Net email is sponsored by: INetU
> > > >Attention Web Developers & Consultants: Become An INetU Hosting
> > > >Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
> > > >Commission! INetU Dedicated Managed Hosting
> > > >http://www.inetu.net/partner/index.php
> > > >_______________________________________________
> > > >Webware-discuss mailing list Webware-discuss@...
> > > >https://lists.sourceforge.net/lists/listinfo/webware-discuss
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >-------------------------------------------------------
> > > >This SF.Net email is sponsored by: INetU
> > > >Attention Web Developers & Consultants: Become An INetU Hosting
> > > >Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly
> > > >Commission! INetU Dedicated Managed Hosting
> > > >http://www.inetu.net/partner/index.php
> > > >_______________________________________________
> > > >Webware-discuss mailing list
> > > >Webware-discuss@...
> > > >https://lists.sourceforge.net/lists/listinfo/webware-discuss
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email is sponsored by: INetU
> > >Attention Web Developers & Consultants: Become An INetU Hosting Partner.
> > >Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission!
> > >INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php
> > >_______________________________________________
> > >Webware-discuss mailing list Webware-discuss@...
> > >https://lists.sourceforge.net/lists/listinfo/webware-discuss
> > >
> > >
> > >
> > >
> > >
> > >-------------------------------------------------------
> > >This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> > >Data Reports, E-commerce, Portals, and Forums are available now.
> > >Download today and enter to win an XBOX or Visual Studio .NET.
> > >http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> > >_______________________________________________
> > >Webware-discuss mailing list
> > >Webware-discuss@...
> > >https://lists.sourceforge.net/lists/listinfo/webware-discuss
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> > Data Reports, E-commerce, Portals, and Forums are available now.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> > _______________________________________________
> > Webware-discuss mailing list
> > Webware-discuss@...
> > https://lists.sourceforge.net/lists/listinfo/webware-discuss
>--
>Vitaliy Fuks
>http://www.quantiva.com/
>phone://609.514.8512/

On Tue, 2003-07-01 at 14:00, Deepak Giridharagopal wrote:
> Well, hopefully it's a simple question. Licensing issues have the habit
> of not being so simple, though. :)
> 
> If I write a servlet that is a subclass of a Webware class, can I GPL or
> LGPL my servlet?

Yes, the license Webware uses (the Python license) is GPL compatible. 
Well, at one point it wasn't, but I would assume that Webware is
distributed under the most current license, which is GPL compatible. 
(If there's an old copy of the Python license with Webware, I suppose
that would need to be fixed).

Webware is intended to be permissively licensed (i.e., BSD- or
MIT-style).

  Ian

On Tue, 2003-07-01 at 13:41, Chris Backas wrote:
> Hello all, 
> 
> I've got a tricky problem in one of my servlets that only seems to occur 
> under moderate->heavy load, and I'm trying to track it down by writing 
> things to the console.  However, because it requires some amount of load to 
> occur, it's extremely difficult, and often impossible, to tell which request 
> is causing which message.  I'm wondering if I can access the request number 
> that webware prints at the start and end of a request (I don't see this in 
> the Request object).  Or, failing that, some alternate way that I can relate 
> messages to a particular request. 

Hmmm... you are right indeed, that number is not made available.  I
suppose that should be changed.  I submitted it as a bug.

For a quicker resolution, you could make your own serial numbers:

import threading
requestIDLock = threading.Lock()
nextRequestID = 1
def makeRequestID():
    requestIDLock.acquire()
    val = nextRequestID
    nextRequestID += 1
    requestIDLock.release()
    return val

Your AOLServer example is the way to go.

I think the confusion is that you use dbPool like a Python module, not a 
Webware specific thing.
In Python Modules are executed and loaded once, no matter how many times 
they are imported.  Due to this simple fact you can create a class or 
varriable in a module and that class will exist once, regardless of how 
many times its called.

So you should create dbPool in a seperate module.
1)  create a module called configuration.py that contains:
from MiscUtils.DBPool import DBPool
from pyPgSQL import PgSQL

# set up the database connection pool
datapool = DBPool(PgSQL, 5, 'localhost::databasename:user:pass')
#The actual syntax of 'localhost::databasename:user:pass' will depend 
upon your database connector

2) When you want to use a connection:
from configuration import datapool
class selCity(SecurePage):

    def writeHTML(self):
        conn = datapool.getConnection()
        c = conn.cursor()
        c.execute('select "CalledCity" from "UniqueCalledCities"')
        rsCity = c.fetchall()
        c.execute('select "CalledState" from "UniqueCalledStates"')
        rsState = c.fetchall()
        c.close()
        conn.close()
          .....

A better way would be to put all of the database work into another 
module and call that from a servlet.

CSData.py:
from configuration import datapool,clientpool

def summaryStats(user):
        summary={}
        conn=datapool.getConnection()
        c=conn.cursor()
        c.execute("Select numrows from numrows")
        r=c.fetchone()
        summary['numrows'] = r.numrows
        c.close()
        return summary


and in your servlet:

import CSData

class servlet....:

    def writeContent(self):
            dataStats=CSData.summaryStats(user)
             self..writeln("Summary: %s" % dataStats)


You should be able to get dbPool working outside of webware.

Write a simple test module that pulls some data out using dbPool and get 
that running furst.  You may need to add the webware directory to your 
pythonpath first
-Aaron
 


Adam Shimali wrote:

>Hello all,
>
>Just like to say first of all how much I love Webware.
>
>
>Well personal confessions out of the way, I'd like to
>ask if anyone can help me get how to use DBPool.
>
>I noticed an earlier post (
>http://sourceforge.net/mailarchive/forum.php?thread_id=2054471&forum_id=3505
>), but I have to admit I didn't really get the
>solution. 
>
>Where should you instantiate a DBPool? Can you
>initialise one for the use of all servlets in your
>application?
>
>For example let's say I'm using WebKit, have a
>SitePage that all my Webware servlets inherit from and
>I have created a number of servlets based on the
>SitePage e.g. Login.py , Main.py, AddItem.py etc. that
>all need to interact with a given database. I gather
>that I could just get my SitePage base class (or even
>the derived servlets if not all of them need database
>access) to just open and hold a connection which
>persists as long as the servlet does. So in the
>example above my application would have an open
>connection for each of the above three servlets. 
>
>Now what if instead of the base or derived servlets
>opening a database connection, I wanted to create a
>pool of connections and then any of the servlets could
>grab a connection from the pool, use it and release
>when done. Where would I create the pool, and how
>would each servlet communicate with it? Do you create
>one in the __init__.py file for the package context? 
>
>I think I'm exposing some deep conceptual confusion
>about the use of a DBPool in Webware. However I think
>that in some sense (probably incorrectly) I'm
>expecting it work like pooled database connections in
>AOLServer. That is, the pool exists within the
>execution environment of the webserver and so any
>"script" executing in that environment can make a call
>to the webserver's API that returns a connection to
>the database, which can be released when done with.
>
>Can something similar be done in Webware using the
>DBPool?
>
>Thanks
>Adam Shimali
>
>__________________________________________________
>Yahoo! Plus - For a better Internet experience
>http://uk.promotions.yahoo.com/yplus/yoffer.html
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>_______________________________________________
>Webware-discuss mailing list
>Webware-discuss@...
>https://lists.sourceforge.net/lists/listinfo/webware-discuss
>  
>


-- 
-Aaron
http://www.MetroNY.com/
"I don't know what's wrong with my television set. I was getting
 C-Span and the Home Shopping Network on the same station.
 I actually bought a congressman."
    - Bruce Baum

Cheers Aaron,
Your excellent explanation makes it all clear now :)

Thanks
Adam 

--- Aaron Held <aaron@...> wrote: > Your
AOLServer example is the way to go.
> 
> I think the confusion is that you use dbPool like a
> Python module, not a 
> Webware specific thing.
> In Python Modules are executed and loaded once, no
> matter how many times 
> they are imported.  Due to this simple fact you can
> create a class or 
> varriable in a module and that class will exist
> once, regardless of how 
> many times its called.
> 
> So you should create dbPool in a seperate module.
> 1)  create a module called configuration.py that
> contains:
> from MiscUtils.DBPool import DBPool
> from pyPgSQL import PgSQL
> 
> # set up the database connection pool
> datapool = DBPool(PgSQL, 5,
> 'localhost::databasename:user:pass')
> #The actual syntax of
> 'localhost::databasename:user:pass' will depend 
> upon your database connector
> 
> 2) When you want to use a connection:
> from configuration import datapool
> class selCity(SecurePage):
> 
>     def writeHTML(self):
>         conn = datapool.getConnection()
>         c = conn.cursor()
>         c.execute('select "CalledCity" from
> "UniqueCalledCities"')
>         rsCity = c.fetchall()
>         c.execute('select "CalledState" from
> "UniqueCalledStates"')
>         rsState = c.fetchall()
>         c.close()
>         conn.close()
>           .....
> 
> A better way would be to put all of the database
> work into another 
> module and call that from a servlet.
> 
> CSData.py:
> from configuration import datapool,clientpool
> 
> def summaryStats(user):
>         summary={}
>         conn=datapool.getConnection()
>         c=conn.cursor()
>         c.execute("Select numrows from numrows")
>         r=c.fetchone()
>         summary['numrows'] = r.numrows
>         c.close()
>         return summary
> 
> 
> and in your servlet:
> 
> import CSData
> 
> class servlet....:
> 
>     def writeContent(self):
>             dataStats=CSData.summaryStats(user)
>              self..writeln("Summary: %s" %
> dataStats)
> 
> 
> You should be able to get dbPool working outside of
> webware.
> 
> Write a simple test module that pulls some data out
> using dbPool and get 
> that running furst.  You may need to add the webware
> directory to your 
> pythonpath first
> -Aaron


__________________________________________________
Yahoo! Plus - For a better Internet experience
http://uk.promotions.yahoo.com/yplus/yoffer.html

At 01:17 AM 7/1/2003, you wrote:
>Ian wrote:
>>here are the various lines in my httpd.conf file relating to webware:
>>LoadModule webkit_module modules/mod_webkit.so
>>AddType txt/psp .psp
>>AddHandler psp-handler .psp
>
>Shouldn't you have something like this in there too?
>
><Location /webware>
>   WKServer localhost 8086
>   SetHandler webkit-handler
></Location>
>
>Nick

I'm pretty sure that in one of the readme files it said that was only 
needed under certain conditions. And in any case, since the appserver IS 
getting the psp requests, i dont think thats the issue, is it? Whenever i 
request a psp page, apache does pass the request to the app server because 
i see it scroll past in the console, and the 404 error is the error message 
from webware, not apache's 404 error message.

Ian

Ian wrote:
> At 01:17 AM 7/1/2003, you wrote:
>> Ian wrote:
>>> here are the various lines in my httpd.conf file relating to
>>> webware: LoadModule webkit_module modules/mod_webkit.so
>>> AddType txt/psp .psp
>>> AddHandler psp-handler .psp
>> 
>> Shouldn't you have something like this in there too?
>> 
>> <Location /webware>
>>   WKServer localhost 8086
>>   SetHandler webkit-handler
>> </Location>
>> 
>> Nick
> 
> I'm pretty sure that in one of the readme files it said that was only
> needed under certain conditions. And in any case, since the appserver
> IS getting the psp requests, i dont think thats the issue, is it?
> Whenever i request a psp page, apache does pass the request to the
> app server because i see it scroll past in the console, and the 404
> error is the error message from webware, not apache's 404 error
> message. 

In my httpd.conf the only Webware-related lines I have are:

LoadModule webkit_module modules/mod_webkit.dll
<Location /WebKit>
	WKServer localhost 8086
	SetHandler webkit-handler
</Location>

I don't have the psp-related lines that you have.

I suggest you try adding these lines to your httpd.conf and see if it helps.

It's important to realize that there are 2 different ways to use PSP.  The
most common way, and the way that I use it, is to have a "context" directory
that is entirely separate from the directory containing your static pages to
be served by Apache.  You use the Location directive with WKServer and
SetHandler as I show above, and you also must edit the Contexts setting in
your Application.config file to include your context directory.  The
advantage of this method is that you can use a combination of PSP's and
Python Servlets.

The other way to use PSP is to simply place PSP pages into the same
directories where you are storing static files to be served by Apache.
That's what the AddType and AddHandler lines are for.  You may still need to
include the WKServer and SetHandler directives even if you're using this
method -- I'm not sure.  The disadvantage of this method is that you can't
use regular Python Servlets -- you can only use PSPs.  (Also, I believe that
there may be a few features of Webware that don't quite work properly using
this method, such as forwarding from one PSP to another.)

- Geoff

You can use regular servlets mixed in with your static pages as long as you change your default webware context to be the same as your main apache context, as well as use an AddType for .py and an Addhandler bakc to your WKServer location, &nbsp;that's what I have done and it everythig works without any problems<br>
Jose<BR><BR><br>
<BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT: blue 2px solid"><BR>-------- Original Message --------<BR>Subject: RE: [Webware-discuss] still getting 404's<BR>From: "Geoffrey Talvola" &lt;gtalvola@...: Tue, July 01, 2003 5:59 am<BR>To: "'Ian'" &lt;webware@...;, webware-discuss@... wrote:<BR>&gt; At 01:17 AM 7/1/2003, you wrote:<BR>&gt;&gt; Ian wrote:<BR>&gt;&gt;&gt; here are the various lines in my httpd.conf file relating to<BR>&gt;&gt;&gt; webware: LoadModule webkit_module modules/mod_webkit.so<BR>&gt;&gt;&gt; AddType txt/psp .psp<BR>&gt;&gt;&gt; AddHandler psp-handler .psp<BR>&gt;&gt; <BR>&gt;&gt; Shouldn't you have something like this in there too?<BR>&gt;&gt; <BR>&gt;&gt; &lt;Location /webware&gt;<BR>&gt;&gt; &nbsp; WKServer localhost 8086<BR>&gt;&gt; &nbsp; SetHandler webkit-handler<BR>&gt;&gt; &lt;/Location&gt;<BR>&gt;&gt; <BR>&gt;&gt; Nick<BR>&gt; <BR>&gt; I'm pretty sure that in one of the readme files it said that was only<BR>&gt; needed under certain conditions. And in any case, since the appserver<BR>&gt; IS getting the psp requests, i dont think thats the issue, is it?<BR>&gt; Whenever i request a psp page, apache does pass the request to the<BR>&gt; app server because i see it scroll past in the console, and the 404<BR>&gt; error is the error message from webware, not apache's 404 error<BR>&gt; message. <BR><BR>In my httpd.conf the only Webware-related lines I have are:<BR><BR>LoadModule webkit_module modules/mod_webkit.dll<BR>&lt;Location /WebKit&gt;<BR>WKServer localhost 8086<BR>SetHandler webkit-handler<BR>&lt;/Location&gt;<BR><BR>I don't have the psp-related lines that you have.<BR><BR>I suggest you try adding these lines to your httpd.conf and see if it helps.<BR><BR>It's important to realize that there are 2 different ways to use PSP. &nbsp;The<BR>most common way, and the way that I use it, is to have a "context" directory<BR>that is entirely separate from the directory containing your static pages to<BR>be served by Apache. &nbsp;You use the Location directive with WKServer and<BR>SetHandler as I show above, and you also must edit the Contexts setting in<BR>your Application.config file to include your context directory. &nbsp;The<BR>advantage of this method is that you can use a combination of PSP's and<BR>Python Servlets.<BR><BR>The other way to use PSP is to simply place PSP pages into the same<BR>directories where you are storing static files to be served by Apache.<BR>That's what the AddType and AddHandler lines are for. &nbsp;You may still need to<BR>include the WKServer and SetHandler directives even if you're using this<BR>method -- I'm not sure. &nbsp;The disadvantage of this method is that you can't<BR>use regular Python Servlets -- you can only use PSPs. &nbsp;(Also, I believe that<BR>there may be a few features of Webware that don't quite work properly using<BR>this method, such as forwarding from one PSP to another.)<BR><BR>- Geoff<BR><BR><BR>-------------------------------------------------------<BR>This SF.Net email sponsored by: Free pre-built ASP.NET sites including<BR>Data Reports, E-commerce, Portals, and Forums are available now.<BR>Download today and enter to win an XBOX or Visual Studio .NET.<BR>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01<BR>_______________________________________________<BR>Webware-discuss mailing list<BR>Webware-discuss@... href="https://lists.sourceforge.net/lists/listinfo/webware-discuss" target="_new">https://lists.sourceforge.net/lists/listinfo/webware-discuss </BLOCKQUOTE>

On Monday, June 30, 2003, at 09:49 PM, Ian Bicking wrote:
> Sorry, I thought someone else might pipe up about it.

Oh, no problem.  It turned out not to be a really serious
problem, but it is annoying. :)

> Anyway, this was at one point commonly caused by path problems
> (sys.path), where a module can be imported more than once.  Imagine a
> path like:

Hm.  The sys.path as reported by the traceback page looks normal; no
duplicates.

> Python doesn't recognize that these are the same module, so there are
> two classes going by the same name.  You might look at the class's
> __module__ attribute to find out more.  It might depend on the way you
> are running the AppServer, environmental variables, etc., which would
> explain why it works in one environment and not another.

Hm.  Okay.  I'll instrument things a bit and see what happens. :)

Thanks!

-- 
Randall Randall <randall@...>
"Not only can money buy happiness,
  it isn't even particularly expensive any more."  -- Spike Jones