Multitenant unable to establish connection Error

[Deepak Agarwal-2]

Hello All,

I followed
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support but
I am getting following error:

"DatabaseUtil.java:159:ERROR] Unable to establish a connection with the
database for helperName [localmysqlolap#DEMO1]
Unable to establish a connection with the database, no additional
information available.
Could not get table name information from the database, aborting."

and then :

Beginning import from URL:
file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
     [java] 2013-06-13 14:57:29,702 [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2013-06-13 14:57:29,707 [    EntitySaxReader.java:289:INFO ]
Finished 3 values from
file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
     [java] 2013-06-13 14:57:29,707 [    EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/D:/Project/project/framework/entityext/data/EntityExtTypeData.xml
     [java] 2013-06-13 14:57:29,708 [    EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2013-06-13 14:57:33,730 [   GenericDelegator.java:1468:ERROR]
     [java] ---- exception report
----------------------------------------------------------
     [java] Failure in storeAll operation:
org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
connection with the database. (Unable to acquire a new connection from the
pool). Rolling back transaction.
     [java] Exception: org.ofbiz.entity.GenericDataSourceException
     [java] Message: Unable to esablish a connection with the database.
(Unable to acquire a new connection from the pool)
     [java] ---- cause
---------------------------------------------------------------------
     [java] Exception: java.sql.SQLException
     [java] Message: Unable to acquire a new connection from the pool
     [java] ---- cause
---------------------------------------------------------------------
     [java] Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
     [java] Message: Could not create connection to database server.
Attempted reconnect 3 times. Giving up.
     [java] ---- cause
---------------------------------------------------------------------
     [java] Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
     [java] Message: Access denied for user ''@'localhost' to database
'ofbiz_demo1'

--
Thanks,
Deepak Agarwal,

Mobile: [phone]

[Deepak Agarwal-2]

My mistake. Switching db machine b/w linux and windows caused this problem
(Mysql lower_case_file_names settings effect). Deleted the newly created db
and re-installed multitenant.

On Thu, Jun 13, 2013 at 3:01 PM, Deepak Agarwal <[hidden email]>wrote:

> Hello All,
>
> I followed
> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support but
> I am getting following error:
>
> "DatabaseUtil.java:159:ERROR] Unable to establish a connection with the
> database for helperName [localmysqlolap#DEMO1]
> Unable to establish a connection with the database, no additional
> information available.
> Could not get table name information from the database, aborting."
>
> and then :
>
> Beginning import from URL:
> file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
>      [java] 2013-06-13 14:57:29,702 [    EntitySaxReader.java:270:INFO ]
> Transaction Timeout set to 2 hours (7200 seconds)
>      [java] 2013-06-13 14:57:29,707 [    EntitySaxReader.java:289:INFO ]
> Finished 3 values from
> file:/D:/Project/project/framework/entity/data/TenantDemoData.xml
>      [java] 2013-06-13 14:57:29,707 [    EntitySaxReader.java:220:INFO ]
> Beginning import from URL:
> file:/D:/Project/project/framework/entityext/data/EntityExtTypeData.xml
>      [java] 2013-06-13 14:57:29,708 [    EntitySaxReader.java:270:INFO ]
> Transaction Timeout set to 2 hours (7200 seconds)
>      [java] 2013-06-13 14:57:33,730 [   GenericDelegator.java:1468:ERROR]
>      [java] ---- exception report
> ----------------------------------------------------------
>      [java] Failure in storeAll operation:
> org.ofbiz.entity.GenericDataSourceException: Unable to esablish a
> connection with the database. (Unable to acquire a new connection from the
> pool). Rolling back transaction.
>      [java] Exception: org.ofbiz.entity.GenericDataSourceException
>      [java] Message: Unable to esablish a connection with the database.
> (Unable to acquire a new connection from the pool)
>      [java] ---- cause
> ---------------------------------------------------------------------
>      [java] Exception: java.sql.SQLException
>      [java] Message: Unable to acquire a new connection from the pool
>      [java] ---- cause
> ---------------------------------------------------------------------
>      [java] Exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
>      [java] Message: Could not create connection to database server.
> Attempted reconnect 3 times. Giving up.
>      [java] ---- cause
> ---------------------------------------------------------------------
>      [java] Exception:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
>      [java] Message: Access denied for user ''@'localhost' to database
> 'ofbiz_demo1'
>
> --
> Thanks,
> Deepak Agarwal,
>
> Mobile: [phone]
>

--
Thanks,
Deepak Agarwal,

Mobile: [phone]

Hi Deepak ,

Could you please tell me in details how you fixed the problem.
As I am facing the same issue , It will very helpful is you elaborate the issue.

Thanks
Amit
9945879755