How do I grant applications launched through JWS socket permission?

[Unnar Björnsson]

I have an application that needs two kinds of permissions, file permission to read from a text file
and a socket permission to connect to a SQL server.
I have solved the file permission by adding <all-permissions/> to my jnlp file but my application fails to connect to the SQL server.
I read somewhere that JWS doesn't allow custom policy files so I'm wondering how I can grant my application the permission. I also tried adding <j2ee-application-client-permissions/> to my jnlp file but with same results.
I'm using com.mysql.jdbc.Driver to connect to my SQL server and I have signed both the driver and my application's jar file.

[Paul Clapham]

It would help to see the stack trace of the exception which is thrown. Could you post that?

[Unnar Björnsson]

The trace file is considerably larger but I copy-pasted the bottom part.

  security: JAVAWS AppPolicy Permission requested for: http://localhost/hbverk1/games/tetris/mysql-connector-java-5.1.7-bin.jar
security: Loading certificates from Deployment session certificate store
security: Loaded certificates from Deployment session certificate store
security: Loading certificates from Internet Explorer TrustedPublisher certificate store
security: Loaded certificates from Internet Explorer TrustedPublisher certificate store
security: Validate the certificate chain using CertPath API
security: Obtain certificate collection in Root CA certificate store
security: Obtain certificate collection in Root CA certificate store
security: No timestamping info available
security: Found jurisdiction list file
security: No need to checking trusted extension for this certificate
security: The CRL support is disabled
security: The OCSP support is disabled
security: Checking if certificate is in Deployment denied certificate store
security: Checking if certificate is in Deployment permanent certificate store
Connecting to  ...
network: Connecting socket://localhost:3306 with proxy=DIRECT
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
	at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at DBdriver.connect(DBdriver.java:28)
	at DBdriver.getUsernameById(DBdriver.java:54)
	at Tetris.<init>(Tetris.java:55)
	at Tetris.main(Tetris.java:417)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.sun.javaws.Launcher.executeApplication(Unknown Source)
	at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
	at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
	at com.sun.javaws.Launcher.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
#### Java Web Start Error:
#### null
  

I tried running the application through command prompt with javaws tetris.jnlp and it works, but it won't if I run through the browser.

[Unnar Björnsson]

I figured it out, the problem was not permission issue. Webstart downloads the application from the server and then runs on the clients machine which causes a file not found exception since the logging information file required to connect to mysql could not be found in the firefox directory

I guess I need to rethink my approach as to how to connect to the database from the java application

[Paul Clapham]

What's this "logging information file"? I use MySQL and I never heard of such a thing.

[Unnar Björnsson]

It was supposed to say "login information file"
Its just a text file containing servername, databasename, username and password