You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Napoleon Esmundo C. Ramirez (JIRA)" <ji...@codehaus.org> on 2007/04/28 07:50:26 UTC

[jira] Commented: (CONTINUUM-1112) Unable to use DB without username and password

    [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_94395 ] 

Napoleon Esmundo C. Ramirez commented on CONTINUUM-1112:
--------------------------------------------------------

This isn't a Continuum issue.  To enable "null" users, or more known as anonymous users, privileges on the database must be granted to it.  To make your configuration work, you'll have to do something like:

mysql> GRANT ALL PRIVILEGES ON test TO ''@'localhost';
mysql> FLUSH PRIVILEGES;


> Unable to use DB without username and password
> ----------------------------------------------
>
>                 Key: CONTINUUM-1112
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-1112
>             Project: Continuum
>          Issue Type: Bug
>          Components: Database
>    Affects Versions: 1.1-alpha-1
>         Environment: mysql jdbc driver 5.0.3, mysql server 5.0.24
>            Reporter: Carlos Sanchez
>             Fix For: 1.1-alpha-#
>
>         Attachments: log.txt
>
>
> Changed plexus.conf database definition to use mysql db that anyone can access (no user / no password) and got an error because it's trying to use a null username.
> java.sql.SQLException: Access denied for user 'null'@'localhost' (using password: YES)
>           <resource> 
>             <name>jdbc/continuum</name>  
>             <type>javax.sql.DataSource</type>  
>             <properties> 
>               <property> 
>                 <name>driverClassName</name>  
>                 <value>com.mysql.jdbc.Driver</value> 
>               </property>  
>               <property> 
>                 <name>url</name>  
>                 <value>jdbc:mysql://localhost/test</value> 
>               </property>  
>               <property> 
>                 <name>username</name>  
>                 <value></value> 
>               </property>  
>               <property> 
>                 <name>password</name>  
>                 <value/> 
>               </property> 
>             </properties> 
>           </resource> 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira