[Erp5-users] Many ERP5 site instances in one zope

[Jean-Paul Smets]

We do not recommend to use multiple erp5 instances within the same zope, 
although it is technically possible. The reason is that
	- it has some limitations (related to compromise between performance and 
flexibility in the dynamic accessor generation system)
	- it is not the best for security if one wants to creates compartments 
between two ZODB databases

There are just a few cases where it might be useful (ex. creating multiple 
instances of exactly the same ERP5 applicative environment).

Our recommendation is to use multiple zope instances within the same host.

Regards,

JPS.

Le Mercredi 7 Juin 2006 16:14, Łukasz Nowak a écrit :
> Hello,
>
> Rafael Monnerat napisa³(a):
> >> mysql> create database custom;
> >> mysql> grant all privileges on custom.* to custom;
> >
> > USE :
> >
> > mysql> create database custom;
> > mysql> grant all on custom.* to custom at localhost;
> >
> >> And entered 'custom custom' in db connection strings. While adding
> >> ERP5 Site, I've got such error message:
> >
> > AND:
> >
> > Try use 'custom at localhost custom ' as db connection.
>
> Same problem. While using 'test' as name for db & user all works
> perfect. Tried:
> After: create database custom;
>
> grant all on custom.* to custom at localhost;
> grant all on custom.* to custom@'%';
>
> Combined with:
>
> 'custom custom'
> 'custom at localhost custom'
> 'custom at 127.0.0.1 custom'
> 'custom at 192.168.0.204 custom'
>
> /var/log/mysqld/mysqlmanager.log do not provide any useful information
> about that issue. Where should I look for more info on my system (I'm
> little unfamiliar with MDK, debian-zealot ;) ).
>
> # lsof -ni4 | egrep ^COMMAND\|^mysql
> COMMAND     PID   USER   FD   TYPE   DEVICE SIZE NODE NAME
> mysqlmana 17586  mysql    0u  IPv4 24025914       TCP 192.168.0.204:2273
> (LISTEN)
>
> Bye,
> Luke
>
> PS. That's VPS (linux-vserver.org) which do not have 127.0.0.1 IP, but
> it do not work even while connecting via its IP addr.

-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
Nexedi: Consulting and Development of Libre / Open Source Software
http://www.nexedi.com
ERP5: Libre/ Open Source ERP Software for small and medium companies
http://www.erp5.org
Rentalinux: Desktop Linux Server
http://www.rentalinux.com