#5 App only works with mysql where root user needs no password

[Anonymous]

mboatman@pacbell.net

Downloaded download1.0 with artimus_1_0.war and
artimus_1_1.war a couple of weeks ago. Errant behavior occurs
with both app versions. I'm running mac 0S X, tomcat, mysql and
also postgres.

Change the user privileges on the user "root" in mysql to require a
password.
Enter password info in the connection section of struts-config.xml
and poolman.xml
Start up the app and try to "create resources".

Clip of servler log.

Caused by:
java.sql.SQLException: SQLException occurred in JDBCPool:
java.sql.SQLException: Invalid authorization specification:
Access denied for user: 'root@192.168.1.100' (Using password:
NO)
params: org.gjt.mm.mysql.Driver, jdbc:mysql://localhost:3306/
artimus. Please check your username, password and other
connectivity info.

Observation:
Appears app is not using the password even when it is present.

Other behaviors:

Change the jdbc driver to postgres and remove the mysql jdbc jar
from the classpath. Put postgres driver in the classpath. Start
app.
You get exceptions at startup saying that the app cannot find the
mysql driver.

Work around:
You must be using mysql with the user "root" being allowed to
login without a password.

[Kaolin Fire]

Logged In: YES
user_id=193551

fix -- move your poolman.xml into your classpath. by
default, the build/war doesn't do that. I don't know why.
That took me about 3 hours to figure out (I don't have mysql
installed... converting everything to postgresql).

I just moved it into WEB-INF/classes and it finally started
paying attention to me.