You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Carlos Sanchez (JIRA)" <ji...@codehaus.org> on 2007/01/04 12:08:09 UTC

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

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
         Environment: mysql jdbc driver 5.0.3, mysql server 5.0.24
            Reporter: Carlos Sanchez
         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

        

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

Posted by "Emmanuel Venisse (JIRA)" <ji...@codehaus.org>.
     [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Emmanuel Venisse closed CONTINUUM-1112.
---------------------------------------

         Assignee: Emmanuel Venisse
       Resolution: Won't Fix
    Fix Version/s:     (was: Future)

> 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
>            Assignee: Emmanuel Venisse
>         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

        

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

Posted by "Napoleon Esmundo C. Ramirez (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_94421 ] 

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

Oh I see, the database received a connection request from "null" when it should've been "".  Btw, I tried it using the code from trunk, but I can't seem to reproduce the issue.  Is there anything else to consider?

> 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

        

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

Posted by "Carlos Sanchez (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_94399 ] 

Carlos Sanchez commented on CONTINUUM-1112:
-------------------------------------------

the problem was that it was trying to use the string "null" as username

> 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

        

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

Posted by "Jesse McConnell (JIRA)" <ji...@codehaus.org>.
     [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesse McConnell updated CONTINUUM-1112:
---------------------------------------

    Fix Version/s: 1.1-alpha-#

> 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

        

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

Posted by "Carlos Sanchez (JIRA)" <ji...@codehaus.org>.
    [ http://jira.codehaus.org/browse/CONTINUUM-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_94422 ] 

Carlos Sanchez commented on CONTINUUM-1112:
-------------------------------------------

it could have been fixed already

> 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

        

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

Posted by "Napoleon Esmundo C. Ramirez (JIRA)" <ji...@codehaus.org>.
    [ 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