I can not connect to mysql db

[hoboy1]

CONTENTS DELETED

The author has deleted this message.

[Len Shein-3]

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:[hidden email]]
Sent: Tuesday, November 10, 2015 5:03 AM
To: [hidden email]
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.

[hoboy1]

CONTENTS DELETED

The author has deleted this message.