The password file should have AS_ADMIN_ADMINPASSWORD instead of
AS_ADMIN_PASSWORD.
HTH,
Shalini.
Arun Gupta wrote:
> 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
>>
>