Posted by
Firas A.-2 on
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Newbie-Installation-Website-URL-tp136564p136571.html
Vinay,
The two xml erros are due to a qouple of typos in the
C:/Server/ofbiz_6140/applications/accounting/entitydef/entitymodel.xml which
makes this file an invalid xml document. There are two superfluous qutoation
marks in entitymodel.xml: one is on line 2386 (column 56) and the other on
the next line (column 60). Removing those two should get you pass these
errors.
Unfortunately I can't say anything about the third, connection, error.
Regards,
</Firas>
-----Original Message-----
From:
[hidden email] [mailto:
[hidden email]]
On Behalf Of Vinay Agarwal
Sent: den 24 november 2005 02:12
To: 'OFBiz Users / Usage Discussion'
Subject: [OFBiz] Users - Newbie: Error Installing OFBiz with PostgreSQL
Hello,
I am trying to get OFBiz working with PostgreSQL but have been unsuccessful
so far. I would appreciate any help. Here are the details.
SYSTEM: Win XP/SP2, OFBiz 6140, Ant 1.6.5, Java SDK 1.4.2_10
DOCUMENTS: Basic OFBiz Production Setup by: David E. Jones and Wiki Online
Administration Manual Database Setup Notes.
STEPS:
1. Installed PostgreSQL version 8.0.4, as Service,
Acct/Pass postgres/postgres
Port 5432
Superuser admin
Pass ofbiz
Installs ok, can access through pgAdmin.
2. Checked driver in ${ofbiz install dir}/framework/entity/lib/jdbc to be
postgresql-8.0-311.jdbc3.jar. Left is unchanged.
3. In ${ofbiz install dir}/framework/entity/config/entityengine.xml file,
changed
a. In <datasource name="localpostgres"
changed ------------
jdbc-username="ofbiz"
jdbc-password="ofbiz"
to -----------------------
jdbc-username="admin"
jdbc-password="ofbiz"
b. Changed------------------------------------------------------------
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
<group-map group-name="org.ofbiz.odbc"
datasource-name="localderbyodbc"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
<group-map group-name="org.ofbiz.odbc"
datasource-name="localderbyodbc"/>
</delegator>
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localderby"/>
</delegator>
<delegator name="other" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
to-----------------------------------------------------------------
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
<delegator name="other" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>
---------------------------------------------------------------------
4. To seed the data, set JAVA_HOME and ANT_HOME, changed command prompt
directory to ${ofbiz install dir} and ran
ant run-install
The output is very long and includes the following errors:
[java] 8250 (main) [UtilXml.java:634:ERROR] XmlFileLoader: File
C:/Server/ofbiz_6140/applications/accounting/entitydef/entitymodel.xml
process error. Line: 2398. Error message: cvc-complex-type.2.3: Element
'entity' cannot have character [children], because the type's content type
is element-only.
[java] 8250 (main) [UtilXml.java:634:ERROR] XmlFileLoader: File
C:/Server/ofbiz_6140/applications/accounting/entitydef/entitymodel.xml
process error. Line: 2398. Error message: cvc-complex-type.2.3: Element
'entity' cannot have character [children], because the type's content type
is element-only.
[java] 85829 (main) [XAConnectionFactory.java:371:ERROR] Can't get an
XAConnection [java] org.postgresql.util.PSQLException: The connection
attempt failed.
[java]at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFa
ctoryImpl.java:136)
In the end, no database is added.
What am I doing wrong? I would appreciate any guidance.
Regards,
Vinay Agarwal
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users