Re: [Ejbca-develop] mysql-connector

[Tomas G. <to...@pr...>]

Are you sure your hostfile is correct? I'm pretty sure I have used only 
localhost.. can't test it right now though...
You hostfile must have a line like this I think...:
127.0.0.1 myhost localhost

Assuming you are working on linux off-course.

/Tomas

Ken Gunderson wrote:
> Greets:
> 
> Not strictly ejbca issue, as I've run into it before, but what is it 
> about the mysql java connector that always wants to append 
> 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 
> 'localhost.teamcool.net' is not allowed to connect to this MySQL 
> server")))
> 
> Because Java/JBoss/Tomcat/MySQL-coonnector append "teamcool.net" to 
> localhost.  MySQL grant tables know nothing about 
> "localhost.teamcool.net", as they define localhost as localhost (as it 
> should be).
> 
> Is some kind of bone thrown to lazy users who want to only type in host 
> part of the hostname and have the remainded completed "automagically"?
> 
> I think this is broken behavior myself.  If I wanted 
> "localhost.teamcoo.net", then that's what I would have used for my 
> connection url.
> 
> Any thoughts?  Or am I the bonehead who's missing the obvious here?
> 
> TIA-
>