Hi, I am trying to write a cgi program which would be executed on browser with Apache server installed.
The program would make a connection to a database using cx_Oracle module and display results on page. The code is working fine on the command line but when executing it on the browser i get the famouse "Premature end of script headers" error. I went ahead and found the problem occuring exactly when the code is asking for a connection to the database. I am attaching the program for reference. Let me know if there is anything I need to make changes to apache or any other way to overcome this issue. #!/apollo/bin/env -e TestDatabaseTraceDashboard python import cgi import sys, os #import cgitb;cgitb.enable() #os.environ[ 'ORACLE_HOME' ] = '/opt/app/oracle/product/10.2.0.2/ client' #if os.environ.has_key( 'LD_LIBRARY_PATH' ): # ld_library_path = os.environ[ 'LD_LIBRARY_PATH' ] # os.environ[ 'LD_LIBRARY_PATH' ] = '%s/lib:%s' % ( os.environ[ 'ORACLE_HOME' ], ld_library_path ) #os.environ['BRAZIL_CONFIG']="--root=/apollo/env/ TestDatabaseTraceDashboard --user=oracle" try: import cx_Oracle import cx_Oracle_Amazon except ImportError, e: # sys.stdout.write( "Import error: %s" % ( e ) ) #sys.argv[0] = '/opt/app/oracle/admin/scripts/monitor-manager' def test_dbconnect(): connection=cx_Oracle.Connection('suvidhak_admin','database','dcrno1') cur=connection.cursor() cur.execute('select shipment_id from pending_customer_shipments where rownum < 10') return cur cursor = test_dbconnect() def generate_output(): print '<html><body></body></html>' generate_output() Thanks, Raja. -- http://mail.python.org/mailman/listinfo/python-list