Before asking me to paste XML, make sure that your forum software will
display it. [quote=ajeh]Thank you for considering me a complete idiot who
does not understand that database name, user and password have to be valid.
This gives me ping error: An error has occurred Ping Connection Pool failed
for blanketBuilderDBPool. Connection could not be allocated because: Access
denied for user 'jdbcGF'@'localhost' (using password: YES) Please check the
server.log for more details. An error has occurred Ping Connection Pool
failed for blanketBuilderDBPool. Connection could not be allocated because:
Access denied for user 'jdbcGF'@'localhost' (using password: YES) Please
check the server.log for more details. Now if we connected with the same
parameters on the command line, they would work fine. $ mysql
--host=10.10.10.2 --user=jdbcGF --password=jdbc Welcome to the MySQL monitor.
Commands end with ; or \g. Your MySQL connection id is 31234 Server version:
5.5.8 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or
its affiliates. All rights reserved. Oracle is a registered trademark of
Oracle Corporation and/or its affiliates. Other names may be trademarks of
their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear
the current input statement. mysql> use test Reading table information for
completion of table and column names You can turn off this feature to get a
quicker startup with -A Database changed mysql> select * from test.color;
+----------+----------+-----+-------+------+ | color_id | color | red | green
| blue | +----------+----------+-----+-------+------+ | 1 | White | 255 | 255
| 255 | | 2 | Yellow | 255 | 255 | 0 | | 3 | Pink | 250 | 105 | 180 | | 4 |
Red | 255 | 0 | 0 | +----------+----------+-----+-------+------+ 4 rows in
set (0.00 sec) mysql> So how does it sound now? [quote=emailnbw]It sounds
like your connection pool properties are misconfigured for your environment
or you haven't got MySQL setup correctly. Have you created the DB with the
correct user and password in MySQL prior to pinging it from the connection
pool? Can you access the DB using that user name and password from the mysql
cmd line tool from the mysql distro? If you can get that far check your
connection pool properties to make sure they are also in good shape. Those
are in the In the "Additional properties" tab of the JDBC Connection Pools
area in the admin GUI for your blankeyBuilderDBPool. Also, if you open
$GF_HOME/glassfish/domains1/domain1/config/domain.xml and find the with the
pool-name attr of your pool and the with the name attr of the associated
jdbc-resource and copy/paste them to the list and we can help verify your
settings. -Noah On Sat, Oct 5, 2013 at 9:22 AM, wrote: > New error: Ping
Connection Pool failed for blanketBuilderDBPool. Connection > could not be
allocated because: Access denied for user 'jdbcGB'@ > 'localhost' > (using
password: YES) Please check the server.log for more details. GF is >
appending @'localhost' to the user name and that fails the logins. What >
now? > > > -- > > [Message sent by forum member 'ajeh'] > > View Post:
http://forums.java.net/node/**899077 > > >[/quote][/quote]
--
[Message sent by forum member 'ajeh']
View Post: http://forums.java.net/node/899077