Zope

Installation

apt-get install zope python-zmysqldb 

On cherche une version de ZMySQLDA qui soit packagée

• http://packages.debian.org/cgi-bin/search_packages.pl?searchon=names&subword=1&version=all&release=all&keywords=zope-mysqlda&sourceid=mozilla-search

Le paquet n'existe pour l'instant ni en testing ni en unstable et la version stable dépend de python2.2, nous installons donc manuellement la version experimental

wget http://ftp.de.debian.org/debian/pool/main/z/zope-mysqlda/zope-mysqlda_2.0.9~b3-3_all.deb  
dpkg -i zope-mysqlda_2.0.9~b3-3_all.deb 

Chercher le nouveau produit

dzhandle list-products|grep -i sql 
=> product ZMySQLDA ZMySQLDA zope-mysqlda 2.0.9~b3-3 /usr/share/zope/Products/ZMySQLDA None 

et l'ajoutez à l'instance <myinst>:

dzhandle add-product <myinst> ZMySQLDA      
/etc/init.d/zope2.9 restart

Commentaires :
creer une nouvelle instance

makeinstance <nom_de_la_nouvelle_instance_zope> --python=/lien/vers/python/

executable sont dans /usr/bin/mysql ou python ou python2.4 ou ..

Les produits zope sont a installer dans /var/lib/zope2.9/instance/<myinst>/Products ou /var/lib/zop../lib/python/Products/

e.g. : FSCounter

cd /var/lib/zope2.9/instance/zope/Products
wget http://www.zope.org/Members/bowerymarc/FScounter/default/FSCounter12.tgz
tar xvzf FSCounter12.tgz
chown -R zope:zope ./FSCounter
/etc/init.d/zope2.9 restart

e.g. : Photo

apt-get install zope-photo zope-extfile zope-testcase python-imaging python-imaging-sane python-imaging-doc python-imaging-doc-pdf python-imaging-tk python-imaging imagemagick
cd /var/lib/zope2.9/instance/<instance_name>/Products/
wget http://www.zope.org/Members/rbickers/Photo/Photo/Photo-1.2.4.tgz
tar xvzf Photo-1.2.4.tgz
chown -R zope:zope ./Photo-1.2.4
dzhandle add-product zope Photo

e.g. : PHParser

cd /var/lib/zope2.9/instance/zope/Products
wget http://www.zope.org/Members/hewei/PHParser/1.1.5/PHParser-1.1.5.tar.gz
tar xvzf PHParser-1.1.5.tar.gz
chown -R zope:zope ./PHParser
/etc/init.d/zope2.9 restart

---

To get the country from the visitor on a zope page: First import the database on your MySQL db as <db_name>.csv as descibed here Add a Python Script in zope (e.g. geoip):

from Products.PythonScripts.standard import html_quote
request = container.REQUEST
RESPONSE =  request.RESPONSE
ip = context.REQUEST.REMOTE_ADDR
line = string.split(ip,'.')
ip0 = line[0]
ip1 = line[1]
ip2 = line[2]
ip3 = line[3]
ipnum = int(ip0) * 16777216 + int(ip1) * 65536 + int(ip2) * 256 + int(ip3) * 1
print ipnum
return printed

Add a Z Mysql Method (e.g. select_GeoIP) with as Arguments ipnum

SELECT cn 
from <db_name>.csv 
where start < <dtml-sqlvar ipnum type="string"> and end > <dtml-sqlvar ipnum type="string">

In a DTML Method, test :

<dtml-in expr="select_GeoIPs(ipnum=geoip())">Hoo, you are from <dtml-var cn>, Welcome !</dtml-in>