[Ejbca-develop] mysql-connector

[Ken G. <kgu...@te...>]

Greets:

Not strictly ejbca issue, as I've run into it before, but what is it=20
about the mysql java connector that always wants to append=20
domain compnent to name, e.g.:

<connection-url>jdbc:mysql://localhost:3306/foo_db

Yields erros along the lines of:

(java.sql.SQLException: Data source re
jected establishment of connection,  message from server: "Host=20
'localhost.teamcool.net' is not allowed to connect to this MySQL=20
server")))

Because Java/JBoss/Tomcat/MySQL-coonnector append "teamcool.net" to=20
localhost.  MySQL grant tables know nothing about=20
"localhost.teamcool.net", as they define localhost as localhost (as it=20
should be).

Is some kind of bone thrown to lazy users who want to only type in host=20
part of the hostname and have the remainded completed "automagically"?

I think this is broken behavior myself.  If I wanted=20
"localhost.teamcoo.net", then that's what I would have used for my=20
connection url.

Any thoughts?  Or am I the bonehead who's missing the obvious here?

TIA-

--=20
Best regards,

Ken Gunderson
GPG Key-- 9F5179FD

"Freedom begins between the ears."      -- Edward Abbey