Paolo, I finished the setting and access http://ochiba-183(My PC Name) but it shows the default index.php under www and not web2py.
>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. I wasn't sure this part, so I just add "127.0.0.1 ochiba-183" to my hosts. Do you know what I'm doing wrong ? The following is my vhost_web2py.conf which is included by httpd.conf. ##########VIRTUAL HOST SETUP########## # WEB2PY.LOCALHOST <VirtualHost 10.30.6.122:80> ServerName ochiba-183:80 DocumentRoot F:/UniServer/www/web2py WSGIScriptAlias / F:/UniServer/www/web2py/wsgihandler.py ServerAdmin ad...@gmail.com # 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 F:/UniServer/tmp/web2py.access.log common ErrorLog F:/UniServer/tmp/web2py.error.log </VirtualHost> #------------------------------------------------------------ <VirtualHost 10.30.6.122:443> ServerName ochiba-183:443 ServerAdmin ad...@gmail.com DocumentRoot F:/UniServer/www/web2py WSGIScriptAlias / F:/UniServer/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 "F:/UniServer/www/web2py"> Order allow,deny Deny from all </Directory> LogFormat "%h %l %u %t \"%r\" %>s %b" common LogLevel notice CustomLog F:/UniServer/tmp/web2py.access.log common ErrorLog F:/UniServer/tmp/web2py.error.log SSLEngine on SSLProtocol -all +TLSv1 +SSLv3 SSLCipherSuite HIGH:MEDIUM:!aNULL:+SHA1:+MD5:+HIGH:+MEDIUM SSLCertificateFile F:/UniServer/usr/local/apache2/conf/ssl.crt/ server.crt SSLCertificateKeyFile F:/UniServer/usr/local/apache2/conf/ssl.key/ server.key SetEnvIf User-Agent ".*MSIE.*" \ #nokeepalive ssl-unclean-shutdown \ #downgrade-1.0 force-response-1.0 </VirtualHost> ##########END VIRTUAL HOST SETUP########## On Oct 9, 10:33 am, Omi Chiba <ochib...@gmail.com> wrote: > Paolo, > > Thank you again. > > >so it's simple compare it with your, downloading uniform server (that > >is portable and install less) > > I will try uniform server next monday and tuesday, then update the > result here. > > On Oct 9, 2:46 am, Paolo Caruccio <paolo.carucci...@gmail.com> wrote: > > > > > > > > > My enviroment > > windows7 64 bit > > Apache/2.2.21 (Win32) DAV/2 mod_ssl/2.2.21 OpenSSL/1.0.0e mod_wsgi/3.3 > > Python/2.7.2 PHP/5.3.8 > > pywin32-216.win32-py2.7 > > pyodbc-2.1.11.win32-py2.7 > > web2py 1.99.2 stable > > db2exc_974_WIN_x86_64 - IBM DB2 Express-C > > > httpd.conf is the same as that one comes with uniform server, I only > > added to it two rows: > > # to load mod_wsgi > > LoadModule wsgi_module modules/mod_wsgi.so > > # vhost_web2py is a separated file (see my previous message for its > > content) > > Include conf/vhost_web2py.conf > > > so it's simple compare it with your, downloading uniform server (that > > is portable and install less) > > > Regarding db2 driver after I installed IBM DB2 Express-C I made the > > following steps: > > > 1) in db2 control center I created a new empty database and named it > > "TEST" alias "TEST" > > 2) activated IBM DB2 ODBC DRIVER : > > 2a) in win7 control panel > administrative tools > Data Sources > > (ODBC) > > 2b) in opened window > tab "User DSN" > "Add" button > > 2c) in new popup window select "IBM DB2 ODBC DRIVER" > "End" button > > 2d) in next window > > 2d1) Data Name Source = "TEST" > > 2d2) Database alias = "TEST" > > 2d3) Pressed OK button > > > In web2py I created a new simple application and connected to database > > through the string: > > > db = DAL('db2://DSN=TEST;UID=userid;PWD=password') > > > where userid and password are the same as accessing to IBM DB2 Express- > > C. > > > At the end I succesfully registered a new user, so all worked fine for > > me. > > > Ciao. > > Paolo > > > On 7 Ott, 21:31, Omi Chiba <ochib...@gmail.com> wrote: > > > > 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 > > > > ... > > read more »