I created the pool as:
-- cut here --
C:\testbed\glassfish\rc4\glassfish\bin>asadmin
create-jdbc-connection-pool --datasourceclassname
com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource --r
estype javax.sql.DataSource --property
User=arun:Password=noway:URL=jdbc\:mysql\
://localhost/railstest_development jdbc/railstestpool
Command create-jdbc-connection-pool executed successfully.
-- cut here --
and created password.file as:
-- cut here --
C:\testbed\glassfish\rc4\glassfish\bin>more password.file
AS_ADMIN_PASSWORD=noway
-- cut here --
I'm not sure this is right because the admin password is "adminadmin".
Then tried pinging the pool gives the following error:
-- cut here --
C:\testbed\glassfish\rc4\glassfish\bin>asadmin ping-connection-pool
--user arun --passwordfile password.file jdbc/railstestpool
Invalid user or password
CLI137 Command ping-connection-pool failed.
-- cut here --
The server log shows
-- cut here --
[#|2007-09-11T06:09:16.294-0700|INFO|sun-appserver9.1|javax.enterprise.system.co
re.security|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;arun;|SEC5046:
Audi
t: Authentication refused for [arun].|#]
[#|2007-09-11T06:09:16.295-0700|WARNING|sun-appserver9.1|javax.enterprise.system
.container.web|_ThreadID=16;_ThreadName=httpWorkerThread-4848-1;_RequestID=a7ced
555-42d4-4477-ae4f-f6331f99b59c;|Web login failed: Login failed:
javax.security.
auth.login.LoginException: Failed file login for arun.|#]
-- cut here --
What's missing ?
-Arun
Jagadish Prasath Ramu wrote:
> AS_ADMIN_PASSWORD=ADMINPASSWORD
>
> On Mon, 2007-09-10 at 23:36 -0700, Arun Gupta wrote:
>> A follow up question is that ping-connection-pool command is failing.
>>
>> C:\testbed\glassfish\rc4\glassfish\bin>asadmin ping-connection-pool
>> --user arun
>> --interactive=true jdbc/railstestpool
>> Invalid user or password
>> CLI137 Command ping-connection-pool failed.
>>
>> The doc says --passwordfile should refer to a file with all keys
>> starting from AS_ADMIN_. What suffix do I use for specifying this password ?
>>
>> -Arun
>>
>> Jagadish Prasath Ramu wrote:
>>> I'm assuming the URL that you want to set is :
>>> jdbc:mysql:://localhost/railstest_development
>>>
>>> Following syntax will help to create the connection pool.
>>>
>>> asadmin create-jdbc-connection-pool --datasourceclassname
>>> com.mysql.jdbc.jdbc2.optional.MyqlConnectionPoolDataSource --restype
>>> javax.sql.DataSource --property "User=root:Password=root:URL=jdbc\:mysql
>>> \:\://localhost/railstest_development" jdbc/railstestpool
>>>
>>> Thanks,
>>> -Jagadish
>>>
>>>
>>>
>>> On Mon, 2007-09-10 at 21:28 -0700, Arun Gupta wrote:
>>>> I'm tyring to create a JDBC connection pool through command line and
>>>> getting the following error:
>>>>
>>>> -- cut here --
>>>> C:\glassfish\bin>asadmin create-jdbc-connection-pool
>>>> --datasourceclassname
>>>> com.mysql.jdbc.jdbc2.optional.MyqlConnectionPoolDataSource --restype
>>>> javax.sql.DataSource --property
>>>> User=root:Password=root:URL=jdbc\\:mysql:\\://localhost/railstest_development
>>>> jdbc/railstestpool
>>>> Usage: create-jdbc-connection-pool --datasourceclassname classname
>>>> [--terse=fals
>>>> e] [--echo=false] [--interactive=true] [--host localhost] [--port
>>>> 4848|4849] [--
>>>> secure | -s] [--user admin_user] [--passwordfile file_name] [--restype
>>>> res_type]
>>>> [--steadypoolsize 8] [--maxpoolsize 32] [--maxwait 60000]
>>>> [--poolresize 2] [--i
>>>> dletimeout 300] [--isolationlevel isolation_level]
>>>> [--isisolationguaranteed] [--
>>>> isconnectvalidatereq=false] [--validationmethod auto-commit]
>>>> [--validationtable
>>>> tablename] [--failconnection=false] [--allownoncomponentcallers=false]
>>>> [--nontra
>>>> nsactionalconnections=false] [--description text] [--property
>>>> (name=value)[:name
>>>> =value]*] jdbc_connection_pool_id
>>>> CLI131 Invalid property syntax.
>>>> -- cut here --
>>>>
>>>> The error message is probably valid but of no help. What's missing ?
>>>>
>>>> -Arun
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
>>> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>
--
Web Technologies and Standards
Sun Microsystems, Inc.
Blog: http://blogs.sun.com/arungupta