• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help to solve 2003 (10061) error with MySql

 
Emanuele Mazzante
Ranch Hand
Posts: 59
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I need to accomplish a project for final examination at school. My idea is to present a java desktop application for family management. All the information and expenses are stored in a MySql database. Unfortunately I don't have any administration rights in the computer at school.  This implies two main problems: I can't install neither the JVM nor the MySql database. To solve the first one, I download the JRE.tar.gz and ran the app through the command: start javaw.exe -jar myapp.jar, and it worked correctly. For the second one, I tried to use a MySql instance in my home server and also another MySql instance provided by Amazon Web Services. I tested my app in many computers of my friend and both the connection to MySql database worked correctly, but not in the computer at school. I receive error 2003 (10061). I'm quite sure to have granted the right permissions to the user so I was wondering if it could be a sort of problem with the school firewall. In both MySql instances I set the 3306 port. I have a very very basic knowledge of networking but I suppose that, when I try to connect to MySql, the server port is the 3306...but when the server send data to the client, which port in the client is used? Maybe it could be firewalled?
Someone can help me to understand the way to solve this problem? Thank you for the help and sorry for my bad English.
 
K. Tsang
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does the school need a proxy IP to access the internet? If so you need to specify that proxy when running your java app
 
Emanuele Mazzante
Ranch Hand
Posts: 59
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank yor for your kind attention. Sincerely I don't. Is there a way to know that without asking to system administrator? Maybe via command line or using some simple exe without installing it.
Thank you again
 
K. Tsang
Bartender
Posts: 3583
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Checking browser setting is one way. But of course you may not able to see it depending on your access right.
 
Dave Tolls
Ranch Hand
Posts: 2091
15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As a thought, do you have to use MySQL?
I was thinking, if this is to be pure desktop, maybe an in memory db, like Derby, would be OK.  That way there's nothing to actually install.
 
Emanuele Mazzante
Ranch Hand
Posts: 59
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
K. Tsang wrote:Checking browser setting is one way. But of course you may not able to see it depending on your access right.


Thank you again, I'm quite sure that I haven't access to browser setting but tomorrow I'll check

Dave Tolls wrote:As a thought, do you have to use MySQL?
I was thinking, if this is to be pure desktop, maybe an in memory db, like Derby, would be OK.  That way there's nothing to actually install.


Thank you for your suggestion. It could be a solution, I didn't know that derby doesn't require to be installed. However my app has other online functions and the proxy could be a problem
 
Dave Tolls
Ranch Hand
Posts: 2091
15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Emanuele Mazzante wrote:
Thank you for your suggestion. It could be a solution, I didn't know that derby doesn't require to be installed. However my app has other online functions and the proxy could be a problem


Ah, well that won't solve that issue then.
You need to talk to the sysadmin and your tutor to get this sorted rather than trying to go around the current set up.
 
Emanuele Mazzante
Ranch Hand
Posts: 59
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dave Tolls wrote:Ah, well that won't solve that issue then.
You need to talk to the sysadmin and your tutor to get this sorted rather than trying to go around the current set up.


Ok, thank you. Tomorrow I'll try to contact the sysadmin to get the proxy address and proxy port.
 
Emanuele Mazzante
Ranch Hand
Posts: 59
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I spoke with the sysadmin and he confirmed to me that they use a Microsoft proxy. Unfortunately he doesn't seem to have much knowledge of the subject but next Tuesday he'll give me a bit of time with him to do some test. In the pc at school I saw the options like showed in attachments. I tryed to uncheck the proxy but the connection to mysql db still doesn't work.
Now I would like to prepare one or more simple procedure to test next Sunday. In my program the connection object is created as following:

Can someone tell me how to adapt this code for that proxy?

One thing that sounds strange to me is that in my application there is a very simple scraper that it also doesn't work:

Could the proxy block also this kind of connection?
Thanks for your help
Cattura1.JPG
[Thumbnail for Cattura1.JPG]
Cattura2.JPG
[Thumbnail for Cattura2.JPG]
Cattura3.JPG
[Thumbnail for Cattura3.JPG]
 
Wilson Scott
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You'll probably have to grant 'localhost' privileges to on the table to the user. See the 'GRANT' syntax documentation.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic