Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 1.1-alpha-1
-
Fix Version/s: None
-
Component/s: Database
-
Labels:None
-
Environment:mysql jdbc driver 5.0.3, mysql server 5.0.24
-
Complexity:Intermediate
Description
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>
Issue Links
- is related to
-
CONTINUUM-1113
Continuum doesn't work with MySQL
-
-
CONTINUUM-1368
CLONE -Continuum doesn't work with MySQL
-
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;