Multi-Tenant with MySQL or Postgress - Working?

2015-05-20 Thread FGomez
Hi All, I wanted to know if anyone has Multi-tenant running in production (or dev) with more then 3 tenants/clients with PostgreSql or mySql DBs? With v13.07 or v14.12 ( I believe the domain on the script is only available with the 'ant create-tenant' on v14.12 only). Thanks you for the feedb

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-20 Thread Arun Patidar
Hi Fernando, Multi-tenant functionality supports all DBs like Postgres, Mysql and Derby. Also 'domain-name' with create-tenant target introduced in v14.12. Thanks & Regards --- Arun Patidar Manager,Enterprise Software Development HotWax Media www.hotwaxsystems.com On Thursday 21 May 2015 08:

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-20 Thread Pierre Smits
Hi Fernando. Multi-tenancy has been around since prior r12.x. And is working with both PostgreSQL and MySQL. Best regards, Pierre Smits *ORRTIZ.COM * Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Th

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-21 Thread Jacques Le Roux
More accurately multi-tenancy has been introduced in trunk in February 2010 and has been continuously improved since. It works with all the DBMSs you can fiund in the EntityEngine.xml file. The number of tenants depends on the material resources, not the code. It's not a solution to scale above t

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-21 Thread FGomez
Jacques, Pierre and Arum Thanks for the technical answer. I agreed with the advantages of a DB per Tenant and the scalability of the HW infrastructure underneath . Hence the maintenance and support issues. I test with v14.12 and advise. Regards, Fernando Le 2015-05-21 03:09, Jacques Le R

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-21 Thread Todd Thorner
Thanks, Fernando, I look forward to overcoming a bit more of my ignorance by way of e-following your progress. On 15-05-21 08:20 AM, FGomez wrote: > Jacques, Pierre and Arum > > Thanks for the technical answer. > > I agreed with the advantages of a DB per Tenant and the scalability of > the HW

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-23 Thread FGomez
Hi all Not able to make multitenant working on postgres (nor on mysql). There are several errors and The script 'create-tenant' hangs at the following line: [java] 2015-05-23 23:05:55,222 |main |ContainerLoader |I| Starting container dataload-container [java] 2015-05-23 23:05:

Re: Multi-Tenant with MySQL or Postgress - Working?

2015-05-25 Thread Arun Patidar
Hi Fernando, In your attached log file, there is an error as : /org.ofbiz.base.config.GenericConfigException: File Resource not found: E:/DEV/ofbiz.14.12/framework/entity/fieldtype/fieldtypepostnew.xml/ Use postgres settings instead of postnew in entityengine since postnew does not support i