Return-Path: 
 <user-return-37206-apmail-ofbiz-user-archive=ofbiz.apache.org@ofbiz.apache.org>
Delivered-To: apmail-ofbiz-user-archive@www.apache.org
Received: (qmail 54772 invoked from network); 12 Apr 2011 06:09:32 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 12 Apr 2011 06:09:32 -0000
Received: (qmail 14068 invoked by uid 500); 12 Apr 2011 06:09:31 -0000
Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org
Received: (qmail 13988 invoked by uid 500); 12 Apr 2011 06:09:31 -0000
Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ofbiz.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ofbiz.apache.org>
List-Post: <mailto:user@ofbiz.apache.org>
List-Id: <user.ofbiz.apache.org>
Reply-To: user@ofbiz.apache.org
Delivered-To: mailing list user@ofbiz.apache.org
Received: (qmail 13979 invoked by uid 99); 12 Apr 2011 06:09:29 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Apr 2011 06:09:29 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of Hardik.Handa@hcl.com
 designates 203.105.185.25 as permitted sender)
Received: from [203.105.185.25] (HELO gws06.hcl.com) (203.105.185.25)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Apr 2011 06:09:22 +0000
Received: from NDA-HCLIN-HT01.CORP.HCL.IN (10.248.64.35) by
 NDA-HCLIN-EDGE4.hcl.com (10.248.64.141) with Microsoft SMTP Server id
 8.2.254.0; Tue, 12 Apr 2011 11:34:59 +0530
Received: from NDA-HCLT-HT02.HCLT.CORP.HCL.IN (10.98.10.212) by
 NDA-HCLIN-HT01.CORP.HCL.IN (10.248.64.35) with Microsoft SMTP Server (TLS) id
 8.2.254.0; Tue, 12 Apr 2011 11:38:44 +0530
Received: from NDA-HCLT-EVS04.HCLT.CORP.HCL.IN ([169.254.2.80]) by
 NDA-HCLT-HT02.HCLT.CORP.HCL.IN ([::1]) with mapi; Tue, 12 Apr 2011 11:38:44
 +0530
From: Hardik Handa <Hardik.Handa@hcl.com>
To: "user@ofbiz.apache.org" <user@ofbiz.apache.org>
Date: Tue, 12 Apr 2011 11:38:44 +0530
Subject: RE: New OfBiz install with MySql 5.5: errors
Thread-Topic: New OfBiz install with MySql 5.5: errors
Thread-Index: Acv4f4gDKA50TUV9R+ubqj1wIh80kwACCpTgABP4elA=
Message-ID: 
 <ED04772581D6B147855C49C32D011B3D23D535786B@NDA-HCLT-EVS04.HCLT.CORP.HCL.IN>
References: <2A756F44A22D4FC8A46F1D93D6747317@tagmaster.net>
In-Reply-To: <2A756F44A22D4FC8A46F1D93D6747317@tagmaster.net>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_ED04772581D6B147855C49C32D011B3D23D535786BNDAHCLTEVS04H_"
MIME-Version: 1.0

--_000_ED04772581D6B147855C49C32D011B3D23D535786BNDAHCLTEVS04H_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi , I hope these setting help. Make sure everything is at place according =
to the below mentioned setting.

<connection-factory class=3D"org.ofbiz.entity.connection.DBCPConnectionFact=
ory"/>

    <delegator name=3D"default" entity-model-reader=3D"main" entity-group-r=
eader=3D"main" entity-eca-reader=3D"main" distributed-cache-clear-enabled=
=3D"false">
        <group-map group-name=3D"org.ofbiz" datasource-name=3D"localmysql"/=
>
        <group-map group-name=3D"org.ofbiz.olap" datasource-name=3D"localde=
rbyolap"/>
        <group-map group-name=3D"org.ofbiz.tenant" datasource-name=3D"local=
derbytenant"/>
    </delegator>
    <delegator name=3D"default-no-eca" entity-model-reader=3D"main" entity-=
group-reader=3D"main" entity-eca-reader=3D"main" entity-eca-enabled=3D"fals=
e" distributed-cache-clear-enabled=3D"false">
        <group-map group-name=3D"org.ofbiz" datasource-name=3D"localmysql"/=
>
        <group-map group-name=3D"org.ofbiz.olap" datasource-name=3D"localde=
rbyolap"/>
        <group-map group-name=3D"org.ofbiz.tenant" datasource-name=3D"local=
derbytenant"/>
    </delegator>

    <!-- be sure that your default delegator (or the one you use) uses the =
same datasource for test. You must run "ant run-install" before running "an=
t run-tests" -->
    <delegator name=3D"test" entity-model-reader=3D"main" entity-group-read=
er=3D"main" entity-eca-reader=3D"main">
        <group-map group-name=3D"org.ofbiz" datasource-name=3D"localmysql"/=
>
        <group-map group-name=3D"org.ofbiz.olap" datasource-name=3D"localde=
rbyolap"/>
        <group-map group-name=3D"org.ofbiz.tenant" datasource-name=3D"local=
derbytenant"/>
    </delegator>












    <datasource name=3D"localmysql"
            helper-class=3D"org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name=3D"mysql"
            check-on-start=3D"true"
            add-missing-on-start=3D"true"
            check-pks-on-start=3D"false"
            use-foreign-keys=3D"true"
            join-style=3D"ansi-no-parenthesis"
            alias-view-columns=3D"false"
            drop-fk-use-foreign-key-keyword=3D"true"
            table-type=3D"InnoDB"
            character-set=3D"latin1"
            collate=3D"latin1_general_cs">
        <read-data reader-name=3D"seed"/>
        <read-data reader-name=3D"seed-initial"/>
        <read-data reader-name=3D"demo"/>
        <read-data reader-name=3D"ext"/>
        <inline-jdbc
                jdbc-driver=3D"com.mysql.jdbc.Driver"
                jdbc-uri=3D"jdbc:mysql://localhost:3307/ofbiz?autoReconnect=
=3Dtrue"
                jdbc-username=3D"ofbiz"      <------ Make sure your usernam=
e and password are correct
                jdbc-password=3D"passw0rd"
                isolation-level=3D"ReadCommitted"
                pool-minsize=3D"5"
                pool-maxsize=3D"250"
            time-between-eviction-runs-millis=3D"600000"/>
    </datasource>



From: Bart Kolodziej [mailto:bart@tagmaster.net]
Sent: Tuesday, April 12, 2011 2:05 AM
To: user@ofbiz.apache.org
Subject: New OfBiz install with MySql 5.5: errors

List,

I am new to OfBiz and I'm trying to set it up with MySql 5.5.11.
I am getting errors during "ant run-install" and I don't know how to procee=
d to overcome them.

So far, I have created the databases (customofbiz,  customofbizolap), grant=
ed user rights, added mysql-connector in the lib/jdbc folder, and modified =
the entityengine.xml.

Attached you'll find the log files and entityengine.xml document.  Please a=
dvise if possible.

Thanks.

P.S. First time posting to this list.

Bart K.


________________________________
::DISCLAIMER::
---------------------------------------------------------------------------=
--------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and inte=
nded for the named recipient(s) only.
It shall not attach any liability on the originator or HCL or its affiliate=
s. Any views or opinions presented in
this email are solely those of the author and may not necessarily reflect t=
he opinions of HCL or its affiliates.
Any form of reproduction, dissemination, copying, disclosure, modification,=
 distribution and / or publication of
this message without the prior written consent of the author of this e-mail=
 is strictly prohibited. If you have
received this email in error please delete it and notify the sender immedia=
tely. Before opening any mail and
attachments please check them for viruses and defect.

---------------------------------------------------------------------------=
--------------------------------------------

--_000_ED04772581D6B147855C49C32D011B3D23D535786BNDAHCLTEVS04H_--