Make sure you have the mysql-connector jar from 'framework\entity\lib\jdbc'. Check (via mySql Workbench) you are able to connect to the DB in the new environment.
In your Client-Deployment.properties Verify these are correct for the new environment: main.datasource.name=localmysql database.name=[DB_SCHEMA] database.server=[127.0.0.1] database.serverPort=[3306] jdbc.driver=com.mysql.jdbc.Driver jdbc.username=[ofbiz] jdbc.password=[ofbiz] Check the username and password have proper access to your MySql DB. Check the server and server port are accessible in the new environment. Try changing the default [127.0.0.1] to the IP of the new environment. Regards Len -----Original Message----- From: Barou [mailto:zsba...@gmail.com] Sent: Tuesday, November 10, 2015 5:03 AM To: user@ofbiz.apache.org Subject: I can not connect to mysql db I am using BigFish v-23. for over a month now. I have made mysql dump form the environment where the app is running fine. Then restore that in an other environment. Then move all my BigFish app on the same machine. Then rebuild BigFish that went fine. when I launch bigfish I get connection error. I have used some time in it now. Barou 2015-11-10 11:05:31,221 (main) [DelegatorFactoryImpl.java:30 :INFO ] Creating new delegator [default] (main) 2015-11-10 11:05:31,286 (main) [ UtilXml.java:1060:ERROR] XmlFileLoader: File file:/home/barou/appServers/Calis09172015_2/framework/entity/config/entityen gine.xml process error. Line: 52. Error message: cvc-complex-type.2.4.a: Invalid content was found starting with element 'delegator'. One of '{debug-xa-resources}' is expected. 2015-11-10 11:05:33,568 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered 2015-11-10 11:05:33,569 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen 2015-11-10 11:05:33,569 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered 2015-11-10 11:05:33,570 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen 2015-11-10 11:05:33,577 (main) [ ModelViewEntity.java:551:WARN ] [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered 2015-11-10 11:05:33,586 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered 2015-11-10 11:05:33,586 (main) [ ModelViewEntity.java:551:WARN ] [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable 2015-11-10 11:05:33,656 (main) [ ModelReader.java:436:INFO ] FINISHED LOADING ENTITIES - ALL FILES; #Entities=858 #ViewEntities=255 #Fields=9030 #Relationships=2914 #AutoRelationships=2162 2015-11-10 11:05:33,693 (main) [ GenericDelegator.java:234:INFO ] Doing entity definition check... 2015-11-10 11:05:33,699 (main) [ ModelEntityChecker.java:508:INFO ] [initReservedWords] array length=1023 2015-11-10 11:05:34,071 (main) [ GenericDelegator.java:237:WARN ] =-=-=-=-= Found 7 warnings when checking the entity definitions: 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name PASSWORD of entity PaymentGatewayPayNetz is a reserved word. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name STATE of entity BlueDartCodpin is a reserved word. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name ZONE of entity BlueDartCodpin is a reserved word. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name STATE of entity BlueDartPrepaid is a reserved word. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name ZONE of entity BlueDartPrepaid is a reserved word. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [RelFKNameGT18] The foreign key named EMAIL_SETTING_STATUS (length:20) was greater than 18 characters in length for relation StatusItem of entity ProductStoreEmailSetting. 2015-11-10 11:05:34,072 (main) [ GenericDelegator.java:239:WARN ] [FieldNameRW] Column name FORMAT of entity ShipmentGatewayBlueDart is a reserved word. 2015-11-10 11:05:34,189 (OFBiz-config-0) [ GenericDelegator.java:262:INFO ] Delegator "default" initializing helper "localmysql" for entity group "org.ofbiz". 2015-11-10 11:05:34,189 (OFBiz-config-1) [ GenericDelegator.java:262:INFO ] Delegator "default" initializing helper "localderbyolap" for entity group "org.ofbiz.olap". 2015-11-10 11:05:34,198 (OFBiz-config-0) [ GenericDelegator.java:273:INFO ] Doing database check as requested in entityengine.xml with addMissing=true 2015-11-10 11:05:34,198 (OFBiz-config-1) [ GenericDelegator.java:273:INFO ] Doing database check as requested in entityengine.xml with addMissing=true 2015-11-10 11:05:34,360 (OFBiz-config-1) [ DatabaseUtil.java:159:ERROR] Unable to establish a connection with the database for helperName [localderbyolap]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool 2015-11-10 11:05:34,361 (OFBiz-config-1) [ DatabaseUtil.java:986:ERROR] Unable to establish a connection with the database, no additional information available. 2015-11-10 11:05:34,361 (OFBiz-config-1) [ DatabaseUtil.java:197:ERROR] Could not get table name information from the database, aborting. 2015-11-10 11:05:34,362 (OFBiz-config-1) [ GenericDelegator.java:262:INFO ] Delegator "default" initializing helper "localderbytenant" for entity group "org.ofbiz.tenant". 2015-11-10 11:05:34,362 (OFBiz-config-1) [ GenericDelegator.java:273:INFO ] Doing database check as requested in entityengine.xml with addMissing=true -- View this message in context: http://ofbiz.135035.n4.nabble.com/I-can-not-connect-to-mysql-db-tp4674282.ht ml Sent from the OFBiz - User mailing list archive at Nabble.com.
