Re: [Ejbca-develop] mysql-connector

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

Now I tried and I had a complete other phenomenon.
I must grant ejbca@myhost not ejbca@localhost, because it looks like the 
mysql-driver connects from the outside to mysql.

I had to do:
grant all on *.* to ejbca@localhost identified by 'ejbca';
to connect using the 'mysql' commend line tool.

And
grant all on *.* to ejbca@dilruba identified by 'ejbca';
to connect with JBoss.

But then all worked fine.
I'm using MySQL 4.0.18 and mysql.connector 3.0.14.

Cheers,
Tomas

Tomas Gustavsson wrote:
> 
> 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-
>>
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the new InstallShield X.
> 
>> From Windows to Linux, servers to mobile, InstallShield X is the one
> 
> installation-authoring solution that does it all. Learn more and
> evaluate today! http://www.installshield.com/Dev2Dev/0504
> _______________________________________________
> Ejbca-develop mailing list
> Ejb...@li...
> https://lists.sourceforge.net/lists/listinfo/ejbca-develop