Re: Problem: mysql with ofbiz 10.4
Hi, Following is complete log when i run ./ant run-install command... [subant] No sub-builds to iterate on clean-svninfo: [echo] Resetting svninfo... [echo] Done! [echo] [build] == Done Building (Compile) == run-install: [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz [java] Admin socket not configured; set to port 0 [java] 2011-06-29 16:01:59,398 (main) [ContainerLoader.java:50 :INFO ] [Startup] Loading containers... [java] 2011-06-29 16:01:59,656 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/framework] [java] 2011-06-29 16:01:59,681 (main) [ ComponentContainer.java:238:INFO ] Loading component : [geronimo] [java] 2011-06-29 16:01:59,696 (main) [ ComponentContainer.java:238:INFO ] Loading component : [sql] [java] 2011-06-29 16:01:59,715 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entity] [java] 2011-06-29 16:01:59,726 (main) [ ComponentContainer.java:238:INFO ] Loading component : [catalina] [java] 2011-06-29 16:01:59,740 (main) [ ComponentContainer.java:238:INFO ] Loading component : [security] [java] 2011-06-29 16:01:59,750 (main) [ ComponentContainer.java:238:INFO ] Loading component : [datafile] [java] 2011-06-29 16:01:59,760 (main) [ ComponentContainer.java:238:INFO ] Loading component : [minilang] [java] 2011-06-29 16:01:59,776 (main) [ ComponentContainer.java:238:INFO ] Loading component : [common] [java] 2011-06-29 16:01:59,787 (main) [ ComponentContainer.java:238:INFO ] Loading component : [service] [java] 2011-06-29 16:01:59,794 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entityext] [java] 2011-06-29 16:01:59,800 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bi] [java] 2011-06-29 16:01:59,814 (main) [ ComponentContainer.java:238:INFO ] Loading component : [birt] [java] 2011-06-29 16:01:59,829 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webapp] [java] 2011-06-29 16:01:59,840 (main) [ ComponentContainer.java:238:INFO ] Loading component : [guiapp] [java] 2011-06-29 16:01:59,847 (main) [ ComponentContainer.java:238:INFO ] Loading component : [widget] [java] 2011-06-29 16:01:59,852 (main) [ ComponentContainer.java:238:INFO ] Loading component : [appservers] [java] 2011-06-29 16:01:59,859 (main) [ ComponentContainer.java:238:INFO ] Loading component : [testtools] [java] 2011-06-29 16:01:59,864 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webtools] [java] 2011-06-29 16:01:59,870 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webslinger] [java] 2011-06-29 16:01:59,884 (main) [ ComponentContainer.java:238:INFO ] Loading component : [images] [java] 2011-06-29 16:01:59,895 (main) [ ComponentContainer.java:238:INFO ] Loading component : [example] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:238:INFO ] Loading component : [exampleext] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/themes] [java] 2011-06-29 16:01:59,907 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] [java] 2011-06-29 16:01:59,913 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bluelight] [java] 2011-06-29 16:01:59,926 (main) [ ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] [java] 2011-06-29 16:01:59,936 (main) [ ComponentContainer.java:238:INFO ] Loading component : [flatgrey] [java] 2011-06-29 16:01:59,941 (main) [ ComponentContainer.java:238:INFO ] Loading component : [multiflex] [java] 2011-06-29 16:01:59,946 (main) [ ComponentContainer.java:238:INFO ] Loading component : [tomahawk] [java] 2011-06-29 16:01:59,947 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/applications] [java] 2011-06-29 16:01:59,957 (main) [ ComponentContainer.java:238:INFO ] Loading component : [party] [java] 2011-06-29 16:01:59,962 (main) [ ComponentContainer.java:238:INFO ] Loading component : [securityext] [java] 2011-06-29 16:01:59,980 (main) [ ComponentContainer.java:238:INFO ] Loading component : [content] [java] 2011-06-29 16:01:59,989 (main) [ ComponentContainer.java:238:INFO ] Loading component : [workeffort] [java] 2011-06-29 16:02:00,004 (main) [ ComponentContainer.java:238:INFO ] Loading component : [product] [java] 2011-06-29 16:02:00,010 (main) [ ComponentContainer.java:238:INFO ] Loading component : [manufacturing] [java] 2011-06-29 16:02:00,021 (main) [ ComponentContainer.java:238:INFO ] Loading component : [accounting] [java] 2011-06-29 16:02:00,022 (main) [ ComponentContainer.java:276:WARN ] Location '/opt/Radical/ofbiz/applications/accounting/lib/cybersource' does not exist [java]
RE: Problem: mysql with ofbiz 10.4
Try to clean cache of the application first. May be this should work -Original Message- From: Rakesh_Ists [mailto:rake...@istsinc.com] Sent: Wednesday, June 29, 2011 11:01 AM To: user@ofbiz.apache.org Subject: Re: Problem: mysql with ofbiz 10.4 Hi, Following is complete log when i run ./ant run-install command... [subant] No sub-builds to iterate on clean-svninfo: [echo] Resetting svninfo... [echo] Done! [echo] [build] == Done Building (Compile) == run-install: [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz [java] Admin socket not configured; set to port 0 [java] 2011-06-29 16:01:59,398 (main) [ContainerLoader.java:50 :INFO ] [Startup] Loading containers... [java] 2011-06-29 16:01:59,656 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/framework] [java] 2011-06-29 16:01:59,681 (main) [ ComponentContainer.java:238:INFO ] Loading component : [geronimo] [java] 2011-06-29 16:01:59,696 (main) [ ComponentContainer.java:238:INFO ] Loading component : [sql] [java] 2011-06-29 16:01:59,715 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entity] [java] 2011-06-29 16:01:59,726 (main) [ ComponentContainer.java:238:INFO ] Loading component : [catalina] [java] 2011-06-29 16:01:59,740 (main) [ ComponentContainer.java:238:INFO ] Loading component : [security] [java] 2011-06-29 16:01:59,750 (main) [ ComponentContainer.java:238:INFO ] Loading component : [datafile] [java] 2011-06-29 16:01:59,760 (main) [ ComponentContainer.java:238:INFO ] Loading component : [minilang] [java] 2011-06-29 16:01:59,776 (main) [ ComponentContainer.java:238:INFO ] Loading component : [common] [java] 2011-06-29 16:01:59,787 (main) [ ComponentContainer.java:238:INFO ] Loading component : [service] [java] 2011-06-29 16:01:59,794 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entityext] [java] 2011-06-29 16:01:59,800 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bi] [java] 2011-06-29 16:01:59,814 (main) [ ComponentContainer.java:238:INFO ] Loading component : [birt] [java] 2011-06-29 16:01:59,829 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webapp] [java] 2011-06-29 16:01:59,840 (main) [ ComponentContainer.java:238:INFO ] Loading component : [guiapp] [java] 2011-06-29 16:01:59,847 (main) [ ComponentContainer.java:238:INFO ] Loading component : [widget] [java] 2011-06-29 16:01:59,852 (main) [ ComponentContainer.java:238:INFO ] Loading component : [appservers] [java] 2011-06-29 16:01:59,859 (main) [ ComponentContainer.java:238:INFO ] Loading component : [testtools] [java] 2011-06-29 16:01:59,864 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webtools] [java] 2011-06-29 16:01:59,870 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webslinger] [java] 2011-06-29 16:01:59,884 (main) [ ComponentContainer.java:238:INFO ] Loading component : [images] [java] 2011-06-29 16:01:59,895 (main) [ ComponentContainer.java:238:INFO ] Loading component : [example] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:238:INFO ] Loading component : [exampleext] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/themes] [java] 2011-06-29 16:01:59,907 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] [java] 2011-06-29 16:01:59,913 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bluelight] [java] 2011-06-29 16:01:59,926 (main) [ ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] [java] 2011-06-29 16:01:59,936 (main) [ ComponentContainer.java:238:INFO ] Loading component : [flatgrey] [java] 2011-06-29 16:01:59,941 (main) [ ComponentContainer.java:238:INFO ] Loading component : [multiflex] [java] 2011-06-29 16:01:59,946 (main) [ ComponentContainer.java:238:INFO ] Loading component : [tomahawk] [java] 2011-06-29 16:01:59,947 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/applications] [java] 2011-06-29 16:01:59,957 (main) [ ComponentContainer.java:238:INFO ] Loading component : [party] [java] 2011-06-29 16:01:59,962 (main) [ ComponentContainer.java:238:INFO ] Loading component : [securityext] [java] 2011-06-29 16:01:59,980 (main) [ ComponentContainer.java:238:INFO ] Loading component : [content] [java] 2011-06-29 16:01:59,989 (main) [ ComponentContainer.java:238:INFO ] Loading component : [workeffort] [java] 2011-06-29 16:02:00,004 (main) [ ComponentContainer.java:238:INFO ] Loading component : [product] [java] 2011-06-29 16:02:00,010 (main) [ ComponentContainer.java:238:INFO ] Loading component : [manufacturing] [java] 2011-06-29 16:02:00,021 (main
Re: Problem: mysql with ofbiz 10.4
I see a typo: collate=utf8_general_ci should be (on both): collate=utf8_general_ci/ On Tue, Jun 28, 2011 at 10:31 PM, Rakesh_Ists rake...@istsinc.com wrote: Hi, Following is complete log when i run ./ant run-install command... [subant] No sub-builds to iterate on clean-svninfo: [echo] Resetting svninfo... [echo] Done! [echo] [build] == Done Building (Compile) == run-install: [java] Set OFBIZ_HOME to - /opt/Radical/ofbiz [java] Admin socket not configured; set to port 0 [java] 2011-06-29 16:01:59,398 (main) [ ContainerLoader.java:50 :INFO ] [Startup] Loading containers... [java] 2011-06-29 16:01:59,656 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/framework] [java] 2011-06-29 16:01:59,681 (main) [ ComponentContainer.java:238:INFO ] Loading component : [geronimo] [java] 2011-06-29 16:01:59,696 (main) [ ComponentContainer.java:238:INFO ] Loading component : [sql] [java] 2011-06-29 16:01:59,715 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entity] [java] 2011-06-29 16:01:59,726 (main) [ ComponentContainer.java:238:INFO ] Loading component : [catalina] [java] 2011-06-29 16:01:59,740 (main) [ ComponentContainer.java:238:INFO ] Loading component : [security] [java] 2011-06-29 16:01:59,750 (main) [ ComponentContainer.java:238:INFO ] Loading component : [datafile] [java] 2011-06-29 16:01:59,760 (main) [ ComponentContainer.java:238:INFO ] Loading component : [minilang] [java] 2011-06-29 16:01:59,776 (main) [ ComponentContainer.java:238:INFO ] Loading component : [common] [java] 2011-06-29 16:01:59,787 (main) [ ComponentContainer.java:238:INFO ] Loading component : [service] [java] 2011-06-29 16:01:59,794 (main) [ ComponentContainer.java:238:INFO ] Loading component : [entityext] [java] 2011-06-29 16:01:59,800 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bi] [java] 2011-06-29 16:01:59,814 (main) [ ComponentContainer.java:238:INFO ] Loading component : [birt] [java] 2011-06-29 16:01:59,829 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webapp] [java] 2011-06-29 16:01:59,840 (main) [ ComponentContainer.java:238:INFO ] Loading component : [guiapp] [java] 2011-06-29 16:01:59,847 (main) [ ComponentContainer.java:238:INFO ] Loading component : [widget] [java] 2011-06-29 16:01:59,852 (main) [ ComponentContainer.java:238:INFO ] Loading component : [appservers] [java] 2011-06-29 16:01:59,859 (main) [ ComponentContainer.java:238:INFO ] Loading component : [testtools] [java] 2011-06-29 16:01:59,864 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webtools] [java] 2011-06-29 16:01:59,870 (main) [ ComponentContainer.java:238:INFO ] Loading component : [webslinger] [java] 2011-06-29 16:01:59,884 (main) [ ComponentContainer.java:238:INFO ] Loading component : [images] [java] 2011-06-29 16:01:59,895 (main) [ ComponentContainer.java:238:INFO ] Loading component : [example] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:238:INFO ] Loading component : [exampleext] [java] 2011-06-29 16:01:59,901 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/themes] [java] 2011-06-29 16:01:59,907 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bizznesstime] [java] 2011-06-29 16:01:59,913 (main) [ ComponentContainer.java:238:INFO ] Loading component : [bluelight] [java] 2011-06-29 16:01:59,926 (main) [ ComponentContainer.java:238:INFO ] Loading component : [droppingcrumbs] [java] 2011-06-29 16:01:59,936 (main) [ ComponentContainer.java:238:INFO ] Loading component : [flatgrey] [java] 2011-06-29 16:01:59,941 (main) [ ComponentContainer.java:238:INFO ] Loading component : [multiflex] [java] 2011-06-29 16:01:59,946 (main) [ ComponentContainer.java:238:INFO ] Loading component : [tomahawk] [java] 2011-06-29 16:01:59,947 (main) [ ComponentContainer.java:177:INFO ] Auto-Loading component directory : [/opt/Radical/ofbiz/applications] [java] 2011-06-29 16:01:59,957 (main) [ ComponentContainer.java:238:INFO ] Loading component : [party] [java] 2011-06-29 16:01:59,962 (main) [ ComponentContainer.java:238:INFO ] Loading component : [securityext] [java] 2011-06-29 16:01:59,980 (main) [ ComponentContainer.java:238:INFO ] Loading component : [content] [java] 2011-06-29 16:01:59,989 (main) [ ComponentContainer.java:238:INFO ] Loading component : [workeffort] [java] 2011-06-29 16:02:00,004 (main) [ ComponentContainer.java:238:INFO ] Loading component : [product] [java] 2011-06-29 16:02:00,010 (main) [ ComponentContainer.java:238:INFO ] Loading component : [manufacturing] [java] 2011-06-29 16:02:00,021 (main) [ ComponentContainer.java:238:INFO ]
Re: Problem: mysql with ofbiz 10.4
If someone hasn't suggested it already then get rid of this section: 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 You don't have a localpostgres datasource defined so you're going to get errors there. Regards Scott HotWax Media http://www.hotwaxmedia.com On 27/06/2011, at 7:33 PM, Rakesh_Ists wrote: Hi, It started proper with derby. my entityEngine.xml look likes as folows ?xml version=1.0 encoding=UTF-8 ? entity-config xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=http://ofbiz.apache.org/dtds/entity-config.xsd; resource-loader name=fieldfile class=org.ofbiz.base.config.FileLoader prepend-env=ofbiz.home prefix=/framework/entity/fieldtype// transaction-factory class=org.ofbiz.geronimo.GeronimoTransactionFactory/ connection-factory class=org.ofbiz.entity.connection.DBCPConnectionFactory/ 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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /delegator delegator name=test entity-model-reader=main entity-group-reader=main entity-eca-reader=main group-map group-name=org.ofbiz datasource-name=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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 entity-model-reader name=main/ entity-group-reader name=main/ entity-eca-reader name=main/ entity-data-reader name=seed/ entity-data-reader name=seed-initial/ entity-data-reader name=demo/ entity-data-reader name=ext/ entity-data-reader name=ext-test/ entity-data-reader name=ext-demo/ field-type name=hsql loader=fieldfile location=fieldtypehsql.xml/ field-type name=derby loader=fieldfile location=fieldtypederby.xml/ field-type name=cloudscape loader=fieldfile location=fieldtypecloudscape.xml/ field-type name=daffodil loader=fieldfile location=fieldtypedaffodil.xml/ field-type name=axion loader=fieldfile location=fieldtypeaxion.xml/ field-type name=mysql loader=fieldfile location=fieldtypemysql.xml/ field-type name=postgres loader=fieldfile location=fieldtypepostgres.xml/ field-type name=postnew loader=fieldfile location=fieldtypepostnew.xml/ field-type name=oracle loader=fieldfile location=fieldtypeoracle.xml/ field-type name=sapdb loader=fieldfile location=fieldtypesapdb.xml/ field-type name=sybase loader=fieldfile location=fieldtypesybase.xml/ field-type name=firebird loader=fieldfile location=fieldtypefirebird.xml/ field-type name=mssql loader=fieldfile location=fieldtypemssql.xml/ field-type name=advantage loader=fieldfile location=fieldtypeadvantage.xml/ datasource name=localmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true jdbc-username=root jdbc-password=abc isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250/ /datasource datasource name=odbcmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8
Re: Problem: mysql with ofbiz 10.4
Hi Scott, I removed section suggested by you.. but still getting the same problem. Regards, Rakesh Chandra Pandey -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3632495.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
Mike, This is correct... anything else you can help to get out of it. Thanks in advance Regards, Rakesh Chnadra Pandey -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3632424.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
The exception you posted is not complete, post full exception. -- Thanks and Regards Santosh Malviya On Tue, Jun 28, 2011 at 10:40 AM, Rakesh_Ists rake...@istsinc.com wrote: HI, I am getting following exceptions. [java] 2011-06-28 16:24:06,503 (main) [ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-28 16:24:06,570 (main) [ ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157 [java] 2011-06-28 16:24:06,583 (main) [ GenericDelegator.java:244:INFO ] Doing entity definition check... [java] 2011-06-28 16:24:06,587 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread main java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.init(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-28 16:24:06,644 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 BUILD SUCCESSFUL -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3629471.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
A couple of things I noticed. When I used mysql (I don't anymore, I use PG) I had this: 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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=localmysql/ /delegator I used localmysql for both (even olap). Maybe this is wrong, but it seemed to work for me. For my localmysql, it looked like this (I noticed you used UTF8, which is good). datasource name=localmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://10.2.10.101/ofbiz?autoReconnect=true;characterEncoding=UTF-8 jdbc-username=ofbiz jdbc-password=ofbizpass isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250/ /datasource 10.2.10.101 is my DB server. Yours may be 127.0.0.1 I believe you need the characterEncoding=UTF-8 to the URI. On another note, I noticed that you are using root as your login to mysql. This is not considered a good practice. In the above example, you should create a user login for mysql for the user ofbiz and assign a password to it. The user ofbiz has to have sufficient credentials (i.e. grant all) as to allow creation of a database. If your mysql database is on a separate machine, then you need to make sure you are able to login remotely, which is what ofbiz does. Example(s): mysql grant all on *.* to 'ofbiz'@'host_where_ofbiz_runs' identified by 'ofbizpass'; mysql drop database ofbiz; mysql create database ofbiz; You can test whether you can login remotely by doing something like this: # mysql -u ofbiz -h dbhost -pofbizpass -A -D ofbiz -e show databases ++ | Database | ++ | information_schema | | mysql | | ofbiz | ++ There are a lot of examples on the web on how to configure mysql for this. To restart, you probably have to drop the ofbiz database to restart the whole process. Also, ofbiz has over 800 tables, so you must optimize mysql. If you don't, it will be dog-slow. The table_cache is real important. This is what I used to use (probably overkill). bind-address= 0.0.0.0 # # * Fine Tuning # key_buffer = 64M max_allowed_packet = 640M thread_stack= 192K thread_cache_size = 8 max_connections= 50 table_cache= 2400 table_definition_cache = 2400 max_heap_table_size = 512M tmp_table_size = 512M join_buffer_size= 5M query_cache_limit = 64M query_cache_size= 128M Good luck. On Mon, Jun 27, 2011 at 12:33 AM, Rakesh_Ists rake...@istsinc.com wrote: Hi, It started proper with derby. my entityEngine.xml look likes as folows ?xml version=1.0 encoding=UTF-8 ? entity-config xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=http://ofbiz.apache.org/dtds/entity-config.xsd; resource-loader name=fieldfile class=org.ofbiz.base.config.FileLoader prepend-env=ofbiz.home prefix=/framework/entity/fieldtype// transaction-factory class=org.ofbiz.geronimo.GeronimoTransactionFactory/ connection-factory class=org.ofbiz.entity.connection.DBCPConnectionFactory/ 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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /delegator delegator name=test entity-model-reader=main entity-group-reader=main entity-eca-reader=main group-map group-name=org.ofbiz datasource-name=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /delegator delegator name=other entity-model-reader=main entity-group-reader=main
Re: Problem: mysql with ofbiz 10.4
Hi you don't need to include jar file for derby because derby is an ASF product setup defaultly with OFBiz i will suggest you first take svn update and then start working with OFBiz project Regards Ricky Khatri
Re: Problem: mysql with ofbiz 10.4
Hi It was runinng with default derby. I have already placed the jar ..and also did all the steps ... but still not able to run ofbiz.. Any other mistake which i can committ during configuration. Please do let me know Regards Rakesh -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627022.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
Hi, It started proper with derby. my entityEngine.xml look likes as folows ?xml version=1.0 encoding=UTF-8 ? entity-config xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation=http://ofbiz.apache.org/dtds/entity-config.xsd; resource-loader name=fieldfile class=org.ofbiz.base.config.FileLoader prepend-env=ofbiz.home prefix=/framework/entity/fieldtype// transaction-factory class=org.ofbiz.geronimo.GeronimoTransactionFactory/ connection-factory class=org.ofbiz.entity.connection.DBCPConnectionFactory/ 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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /delegator delegator name=test entity-model-reader=main entity-group-reader=main entity-eca-reader=main group-map group-name=org.ofbiz datasource-name=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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 entity-model-reader name=main/ entity-group-reader name=main/ entity-eca-reader name=main/ entity-data-reader name=seed/ entity-data-reader name=seed-initial/ entity-data-reader name=demo/ entity-data-reader name=ext/ entity-data-reader name=ext-test/ entity-data-reader name=ext-demo/ field-type name=hsql loader=fieldfile location=fieldtypehsql.xml/ field-type name=derby loader=fieldfile location=fieldtypederby.xml/ field-type name=cloudscape loader=fieldfile location=fieldtypecloudscape.xml/ field-type name=daffodil loader=fieldfile location=fieldtypedaffodil.xml/ field-type name=axion loader=fieldfile location=fieldtypeaxion.xml/ field-type name=mysql loader=fieldfile location=fieldtypemysql.xml/ field-type name=postgres loader=fieldfile location=fieldtypepostgres.xml/ field-type name=postnew loader=fieldfile location=fieldtypepostnew.xml/ field-type name=oracle loader=fieldfile location=fieldtypeoracle.xml/ field-type name=sapdb loader=fieldfile location=fieldtypesapdb.xml/ field-type name=sybase loader=fieldfile location=fieldtypesybase.xml/ field-type name=firebird loader=fieldfile location=fieldtypefirebird.xml/ field-type name=mssql loader=fieldfile location=fieldtypemssql.xml/ field-type name=advantage loader=fieldfile location=fieldtypeadvantage.xml/ datasource name=localmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true jdbc-username=root jdbc-password=abc isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250/ /datasource datasource name=odbcmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true jdbc-username=root jdbc-password=abc isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250/ /datasource /entity-config -- View
Re: Problem: mysql with ofbiz 10.4
hi, please update what error/exception you are getting. Thanks prasath rajan On Mon, Jun 27, 2011 at 11:41 AM, Rakesh_Ists rake...@istsinc.com wrote: Hi It was runinng with default derby. I have already placed the jar ..and also did all the steps ... but still not able to run ofbiz.. Any other mistake which i can committ during configuration. Please do let me know Regards Rakesh -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3627022.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
Hello Rakesh, Try with mysql port on which you are working like: - jdbc-uri=jdbc:mysql://127.0.0.1:3309/ofbiz?autoReconnect=truehttp://127.0.0.1/ofbiz?autoReconnect=true -- Thanks and Regards Santosh Malviya On Mon, Jun 27, 2011 at 1:03 PM, Rakesh_Ists rake...@istsinc.com wrote: Hi, It started proper with derby. my entityEngine.xml look likes as folows ?xml version=1.0 encoding=UTF-8 ? entity-config xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; xsi:noNamespaceSchemaLocation= http://ofbiz.apache.org/dtds/entity-config.xsd; resource-loader name=fieldfile class=org.ofbiz.base.config.FileLoader prepend-env=ofbiz.home prefix=/framework/entity/fieldtype// transaction-factory class=org.ofbiz.geronimo.GeronimoTransactionFactory/ connection-factory class=org.ofbiz.entity.connection.DBCPConnectionFactory/ 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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /delegator delegator name=test entity-model-reader=main entity-group-reader=main entity-eca-reader=main group-map group-name=org.ofbiz datasource-name=localmysql/ group-map group-name=org.ofbiz.olap datasource-name=odbcmysql/ /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 entity-model-reader name=main/ entity-group-reader name=main/ entity-eca-reader name=main/ entity-data-reader name=seed/ entity-data-reader name=seed-initial/ entity-data-reader name=demo/ entity-data-reader name=ext/ entity-data-reader name=ext-test/ entity-data-reader name=ext-demo/ field-type name=hsql loader=fieldfile location=fieldtypehsql.xml/ field-type name=derby loader=fieldfile location=fieldtypederby.xml/ field-type name=cloudscape loader=fieldfile location=fieldtypecloudscape.xml/ field-type name=daffodil loader=fieldfile location=fieldtypedaffodil.xml/ field-type name=axion loader=fieldfile location=fieldtypeaxion.xml/ field-type name=mysql loader=fieldfile location=fieldtypemysql.xml/ field-type name=postgres loader=fieldfile location=fieldtypepostgres.xml/ field-type name=postnew loader=fieldfile location=fieldtypepostnew.xml/ field-type name=oracle loader=fieldfile location=fieldtypeoracle.xml/ field-type name=sapdb loader=fieldfile location=fieldtypesapdb.xml/ field-type name=sybase loader=fieldfile location=fieldtypesybase.xml/ field-type name=firebird loader=fieldfile location=fieldtypefirebird.xml/ field-type name=mssql loader=fieldfile location=fieldtypemssql.xml/ field-type name=advantage loader=fieldfile location=fieldtypeadvantage.xml/ datasource name=localmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ read-data reader-name=seed-initial/ read-data reader-name=demo/ read-data reader-name=ext/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true jdbc-username=root jdbc-password=abc isolation-level=ReadCommitted pool-minsize=2 pool-maxsize=250/ /datasource datasource name=odbcmysql helper-class=org.ofbiz.entity.datasource.GenericHelperDAO field-type-name=mysql check-on-start=true add-missing-on-start=true check-pks-on-start=false use-foreign-keys=true join-style=ansi-no-parenthesis alias-view-columns=false drop-fk-use-foreign-key-keyword=true table-type=InnoDB character-set=utf8 collate=utf8_general_ci read-data reader-name=seed/ inline-jdbc jdbc-driver=com.mysql.jdbc.Driver jdbc-uri=jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true
Re: Problem: mysql with ofbiz 10.4
HI, I am getting following exceptions. [java] 2011-06-28 16:24:06,503 (main) [ModelViewEntity.java:532:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable of view-entity OrderItemAndShipGrpInvResAndItemSum [java] 2011-06-28 16:24:06,570 (main) [ ModelReader.java:389:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267 #Fields=8870 #Relationships=2925 #AutoRelationships=2157 [java] 2011-06-28 16:24:06,583 (main) [ GenericDelegator.java:244:INFO ] Doing entity definition check... [java] 2011-06-28 16:24:06,587 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread main java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.init(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-28 16:24:06,644 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 BUILD SUCCESSFUL -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3629471.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Problem: mysql with ofbiz 10.4
What does your framework/entity/config/entityengine.xml look like? What steps did you take to set up ofbiz with mysql? Does it start ok with the default Derby config? On Wed, Jun 22, 2011 at 2:52 AM, Rakesh_Ists rake...@istsinc.com wrote: I am running commond ./ant run-install with ofbiz 10.4 but it is not running... I am getting following message [java] 2011-06-22 20:39:46,192 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread main java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.init(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-22 20:39:46,253 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 Please suggest any solution. Thanks in advance Rakesh -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3616546.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- James McGill Phoenix AZ
Re: Problem: mysql with ofbiz 10.4
hi... if u want to configure mysql with ofbiz10.4 first u have to download mysql jar file . which u have to placed in the directory structure named- component name---lib--jdbcmysql jar file. now reconfigure entityengine.xml of entity directry . and then recreate the database then start server. surely it will run . try it. Thanks Vishal Agrawal Hotwax Media Pvt. Ltd. On Wed, Jun 22, 2011 at 3:22 PM, Rakesh_Ists rake...@istsinc.com wrote: I am running commond ./ant run-install with ofbiz 10.4 but it is not running... I am getting following message [java] 2011-06-22 20:39:46,192 (main) [ ModelEntityChecker.java:502:INFO ] [initReservedWords] array length=1023 [java] Exception in thread main java.lang.NullPointerException [java] at org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548) [java] at org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101) [java] at org.ofbiz.entity.GenericDelegator.init(GenericDelegator.java:245) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33) [java] at org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25) [java] at org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202) [java] at org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47) [java] at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230) [java] at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100) [java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272) [java] at org.ofbiz.base.start.Start.startServer(Start.java:322) [java] at org.ofbiz.base.start.Start.start(Start.java:326) [java] at org.ofbiz.base.start.Start.main(Start.java:411) [java] 2011-06-22 20:39:46,253 (OFBiz_Shutdown_Hook) [ ContainerLoader.java:113:INFO ] Shutting down containers [java] Java Result: 1 Please suggest any solution. Thanks in advance Rakesh -- View this message in context: http://ofbiz.135035.n4.nabble.com/Problem-mysql-with-ofbiz-10-4-tp3616546p3616546.html Sent from the OFBiz - User mailing list archive at Nabble.com.