[Lvlug] Re: java and mysql permissions
dann s washko
dann at thelinuxlink.net
Fri Apr 8 21:30:18 EDT 2005
Faber Fedor wrote:
> On 08/04/05 18:02 -0500, Deep Kapadia wrote:
>>So, even if this person is trying to run an applet on the box hosting
>>the MySql server, he will not be able to do so since the current
>>security policy of the Java virtual machine on the box does not permit
>>him to connect/resolve/accept connections through an applet.
> So having a database username and password aren't enough? I'm thinking
> along the lines of a Perl DBI or ODBC connection: if you've got the
> database username and password correct, you can connect to the database.
> Whether the database accepts connections over the Internets [sic] or locally
> is a database configuration issue.
Right. I do believe the problem is the way I have permissions on the
> You're implying that there's another layer to consider when using a Java
I'm thinking there is a permissions difference when running an app that
accesses the database if that app is not run on the machine local to the
database, based upon the permissions I have suppled to each user.
A java applet or application can be run via the client-side version of
java. Thus, this requires external permissions on the database. I'm
basing my supposition on the fact that he is either using java on the
local machine or making use of java through a web browser, he has not
expressed otherwise. Running a java application on an external system
would require that said system would be granted access to the database
either explicity providing permission to the host name, network address,
subnet or everyone via '%'.
Dann S. Washko
The Linux Link Tech Show
Check Us Out Weekly: Live/Stream/Podcast
The Linux Link Web Radio Portal
TLLTS -- LUGRadio -- The LinuxBox Show
get slack (www.slackware.com) and get happy
More information about the Lvlug