http://ofbiz.116.s1.nabble.com/OFBiz-Users-Newbie-Installation-Website-URL-tp136564p136572.html
On Nov 24, 2005, at 3:32 AM, Firas A. wrote:
> 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:users-
>
[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