Paolo,
You gave me a hope because it looks you tried it recently and it's
very similar to my environment. (Is your OS Windows 7, XP, or Windows
Server ??)
My environment:
OS: Windows 7 SP1 - 32bit
Python: 2.7.2
Apache: httpd-2.2.21-win32-x86-openssl-0.9.8r.msi
mod_wsgi: mod_wsgi-win32-ap22py27-3.3.so
pyodbc: pyodbc-2.1.11.win32-py2.7.exe
pywin32: pywin32-216.win32-py2.7.exe
I was keep thinking what makes the difference. I know you use Uniform
Server but
the version of apache included is the same as mine. So it should be
the same.
Only possible difference is an apache config, The below is the part of
httpd.conf let me know if you find anything wrong. It's running fine
except pyodbc cannot make connection to mssql/db2 under wsgi but it
does connect under Rocket server and console.
=================================
NameVirtualHost *:80
<VirtualHost *:80>
DocumentRoot "C:/web2py/applications"
ServerName ochba-183
<Directory "C:/web2py">
Order allow,deny
Deny from all
</Directory>
<Location "/">
Order deny,allow
Allow from all
</Location>
<LocationMatch "^(/[\w_]*/static/.*)">
Order Allow,Deny
Allow from all
</LocationMatch>
WSGIScriptAlias / "C:/web2py/wsgihandler.py"
</VirtualHost>
NameVirtualHost *:443
<VirtualHost *:443>
DocumentRoot "C:/web2py/applications"
ServerName ochiba-183
<Directory "C:/web2py">
Order allow,deny
Deny from all
</Directory>
<Location "/">
Order deny,allow
Allow from all
</Location>
<LocationMatch "^(/[\w_]*/static/.*)">
Order Allow,Deny
Allow from all
</LocationMatch>
WSGIScriptAlias / "C:/web2py/wsgihandler.py"
SSLEngine On
SSLCertificateFile conf/server.crt
SSLCertificateKeyFile conf/server.key
</VirtualHost>
============================
On Oct 6, 6:47 pm, Paolo Caruccio <paolo.carucci...@gmail.com> wrote:
> The following istructions have been adapted
> fromhttp://jdoe.asidev.com/2009/02/26/configure-web2py-to-run-behind-apac...
> for my dev enviroment Windows + Apache + mod_wsgi.
> I succesfully tested connection to db2 express from IMB through
> pyodbc. Maybe it could help you.
> I premise that I'm not a programmer and computer development is an
> hobby for me, so my support will be very poor.
> Below enviroment has been used for development only, not in
> production.
>
> PREREQUISITES: python 2.7 installed on Windows
>
> STEP A - webserver preparation [http://sourceforge.net/projects/
> miniserver/files/Uniform%20Server/7.1.11-Orion/]
> a1 - download and install uniformserver;
> a2 - after installation, access to the server administrator panel and
> "SECURE" all entries in the "Server Security" page;
> a3 - generate a new SSL certificate by "Tools > Server Key & Cert Gen"
> link on right sidebar;
> a4 - create a certificate signed by our CA using UniServer_CA_1.0
> plugin [http://sourceforge.net/projects/miniserver/files/Plugins/
> UniServer_CA/];
> a5 - replace the files created in the a3 step in X:\UniServer\usr\local
> \apache2\conf folder ( X is the drive where uniformserver has been
> installed );
> a6 - install new certificate in Trusted Certification Authorities.
> Usually I put ca.crt file in main folder of my website, start the
> server, and by browser go tohttp://localhost/ca.crt
> ( replace localhost with website name to simulate real situation )
> and install the certificate following browser instructions;
> a7 - start the server and check that https pages are accessible
> without certificate errors.
> Notes: when upgrade the server simply copy in their folders on the new
> server the SSL files created in the previous version of the server
>
> STEP B - mod_wsgi [http://code.google.com/p/modwsgi/wiki/
> DownloadTheSoftware?tm=2]
> b1 - download Windows binary selecting the correct one for the version
> of Python and Apache that is being used ( I use mod_wsgi-win32-
> ap22py27-3.3.so - Apache 2.2 / Python 2.7 );
> b2 - stop UniServer, rename downloaded file in "mod_wsgi.so" and put
> it in X:\UniServer\usr\local\apache2\modules folder ( X is the drive
> where uniformserver has been installed );
> b3 - add to X:\UniServer\usr\local\apache2\conf\httpd.conf file
> following row: "LoadModule wsgi_module modules/mod_wsgi.so"( without
> quotation marks );
> b4 - restart UniServer and check that mod_wsgi is succesfully
> installed.
> Notes: when upgrade the server repeat the step B
>
> STEP C - web2py (for sure you know where download it)
> c1 - download web2py source code and unzip it in X:\UniServer\www
> folder ( X is the drive where uniformserver has been installed );
> c2 - stop UniServer, start web2py server in standard way by double
> clicking X:\UniServer\www\web2py\web2py.py in order that it create its
> own files (don't change default settings);
> c3 - stop web2py server and check that in web2py folder there are
> "options_std.py" e "parameters_8000.py";
> c4 - open options_std.py and make sure of row "password = '<recycle>'"
> is present;
> c5 - create following symlinks (only in windows7 by "mklink" command
> or using "Symlink Creator" [http://code.google.com/p/symlinker/
> downloads/list]):
> 1) options_std.py -> options.py
> 2) parameters_8000.py -> parameters_80.py
> 3) parameters_8000.py -> parameters_443.py
> Notes: in windowsXP copy files listed above on the left and rename
> them with the names on the right.
> When upgrade web2py, rename or delete previous web2py folder, but
> in the latter case make sure of backup your web2py apps.
>
> STEP D - apache vhost file
> d1 - stop UniServer, create a new "vhost_web2py.conf" file in X:
> \UniServer\usr\local\apache2\conf folder ( X is the drive where
> uniformserver has been installed ) with following content :
>
> ##########VIRTUAL HOST SETUP##########
> # WEB2PY.LOCALHOST
> <VirtualHost ****LIP****:80>
> ServerName ****SVN****:80
> DocumentRoot ****DIR****/www/web2py
> WSGIScriptAlias /
> ****DIR****/www/web2py/wsgihandler.py
> ServerAdmin ****EMAIL****
> # static files do not need WSGI
> <LocationMatch "^(/[\w_]*/static/.*)">
> Order Allow,Deny
> Allow from all
> </LocationMatch>
> # everything else goes to web2py via wsgi
> <Location "/">
> Order deny,allow
> Allow from all
> </Location>
> # Log. Can be disabled
> LogFormat "%h %l %u %t \"%r\" %>s %b" common
> LogLevel notice
> CustomLog ****DIR****/tmp/web2py.access.log common
> ErrorLog ****DIR****/tmp/web2py.error.log
> </VirtualHost>
>
> #------------------------------------------------------------
> <VirtualHost ****LIP****:443>
> ServerName ****SVN****:443
> ServerAdmin ****EMAIL****
> DocumentRoot ****DIR****/www/web2py
> WSGIScriptAlias /
> ****DIR****/www/web2py/wsgihandler.py
> # static files do not need WSGI
> <LocationMatch "^(/[\w_]*/static/.*)">
> Order Allow,Deny
> Allow from all
> </LocationMatch>
> <Location "/">
> Order deny,allow
> Allow from all
> </Location>
> <Directory "****DIR****/www/web2py">
> Order allow,deny
> Deny from all
> </Directory>
> LogFormat "%h %l %u %t \"%r\" %>s %b" common
> LogLevel notice
> CustomLog ****DIR****/tmp/web2py.access.log common
> ErrorLog ****DIR****/tmp/web2py.error.log
> SSLEngine on
> SSLProtocol -all +TLSv1 +SSLv3
> SSLCipherSuite
> HIGH:MEDIUM:!aNULL:+SHA1:+MD5:+HIGH:+MEDIUM
> SSLCertificateFile
> ****DIR****/usr/local/apache2/conf/ssl.crt/
> web2py.crt
> SSLCertificateKeyFile
> ****DIR****/usr/local/apache2/conf/ssl.key/
> web2py.key
> SetEnvIf User-Agent ".*MSIE.*" \
> nokeepalive ssl-unclean-shutdown \
> downgrade-1.0 force-response-1.0
> </VirtualHost>
> ##########END VIRTUAL HOST SETUP##########
>
> IMPORTANT NOTES:
> replace in above code
> ****LIP**** with real IP i.e. 192.168.1.114 for LAN or
> 208.67.220.222 for WAN
> ****SVN**** with your server name i.e. web2py.localhost
> ****DIR**** with X:/UniServer ( X is the drive where
> uniformserver
> has been installed )
> ****EMAIL**** with your email i.e. ad...@smtp.net
> modify paths in line with your preferences
>
> d2 - at the end of X:\UniServer\usr\local\apache2\conf\httpd.conf file
> add "Include conf/vhost_web2py.conf";
> d3 - create, like in step A, the SSL certificate and key for the
> servername (i.e. web2py.localhost). Note that SSL permits only one
> certificate for each IP;
> d4 - open "%WINDOWS%\system32\drivers\etc\hosts" file and add the
> alias "127.0.0.1 web2py.localhost". Replace server's IP to 127.0.0.1
> and access to web2py from not localhost;
> d5 - start UniServer, now you can access to web2py inserting
> "web2py.localhost" in address bar of your browser.
> Notes: when upgrade UniServer, repeat only d2 and copy the old files
> in the upgraded server.
>
> Final notes related to pyodbc (attention!only connection and basic
> insert tested):
> - pyodbc ( pyodbc-2.1.11.win32-py2.7.exe ) installed
> - driver odbc activated in windows control panel
> - DAL connection string = 'db2://
> DSN=databasename;UID=userid;PWD=password'
>
> Ciao.
>
> On 4 Ott, 17:51, Omi Chiba <ochib...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Is anybody running web2py with this configuration ? If so, can you
> > share the instruction and/or apache configuration ?
>
> > web2py dirctory: C:\web2py
> > App:http://localhost:8000/welcome
>
> > Currently, my web2py site is running on
>
> > - Ubuntu + Apache + wsgi
> > - Windows + Apache + wsgi
>
> > but because of the issues below, I cannot use pyodbc to connect
> > msssql. So I was forced to use mysql.
>
> > pyodbc
>
> > Issue (Linux)http://code.google.com/p/pyodbc/issues/detail?id=169
> > Issue (Windows) http://code.google.com/p/pyodbc/issues/detail?id=126&q=wsgi
