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 »
