I can't connect to mysql of remote server though it works perfectly in localhost

Question

ankit.pandey3 -8 Junior Poster in Training

13 Years Ago

import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.TimerTask;

/**
 * @author Adrian BER (beradrian@yahoo.com)
 */
public class PopupAnkit extends JPanel implements ActionListener{

   private JToggleButton invokePopupButton;
    private JFrame popupWindow;
    Statement stmt=null;
    ResultSet rs=null;
   // int tempCount=0;
    
    
    public static int count=0;
    /**
     * Constructor.
     */
    public PopupAnkit() {
        init();
    }

    /**
     * Initialiser.
     */
    private void init() {

    	  invokePopupButton = new JToggleButton("Show popup");
    	try
		{
    	
    		int tempData=0;
    		Class.forName("com.mysql.jdbc.Driver");
    		String serverName = "173.255.216.128:3306"; 
        	String mydatabase = "chat"; 
        	String url = "jdbc:mysql://" + serverName + "/" + mydatabase; // a JDBC url 
        	String username = "root"; 
        	String password = "***"; 
        	Connection conn = DriverManager.getConnection(url, username, password); 
    		stmt= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    		rs=stmt.executeQuery("select count(*) from ajax_chat_messages");
    		
    		rs.next();
			
			count=Integer.parseInt(rs.getString(1));
    		
		}
    	catch(Exception e)
    	{
    		System.out.println("e-------"+e);
    	}
    	
    	Timer t=new Timer(1000*45,this);
    	TimerTask t1=new TimerTask(){
    		
			@Override
			public void run() 
			{
				
			}};
    	
    	
    	
      
       // invokePopupButton.addActionListener(this);
        
           

        // add components to main panel
        this.setLayout(new BorderLayout());
        this.add(invokePopupButton, BorderLayout.EAST);

        // use frame
        popupWindow = new JFrame();
        popupWindow.setUndecorated(true);

        popupWindow.addWindowFocusListener(new WindowFocusListener() {
            public void windowGainedFocus(WindowEvent e) {
            	
            }

            public void windowLostFocus(WindowEvent e) {
                SwingUtilities.invokeLater(new Runnable() {
                    public void run() {
                        if (popupWindow.isVisible())
                        	popupWindow.setVisible(false);
                    }
                });
            }
        });

        // add some components to window
        popupWindow.getContentPane().setLayout(new BorderLayout());
        ((JComponent)popupWindow.getContentPane()).setBorder(BorderFactory.createEtchedBorder());
        JTextField aTextField = new JTextField(10);
        popupWindow.getContentPane().add(new JLabel("New Message"), BorderLayout.WEST);
        t.start();
        //popupWindow.getContentPane().add(aTextField);
        popupWindow.pack();
    }

    public static void main(String[] args) {
        JFrame mainFrame = new JFrame("PopupWindow");
        mainFrame.getContentPane().add(new PopupAnkit());
        mainFrame.pack();
        mainFrame.setLocationRelativeTo(null);
        mainFrame.setVisible(false);
    }


    public void actionPerformed(ActionEvent e)
    {
    			
		try
		{
		
			rs=stmt.executeQuery("select count(*) from ajax_chat_messages");
    		rs.next();
    		int tempData = rs.getInt(1);
    		System.out.println("Temp---"+tempData);
    		System.out.println("Count---"+count);
    		
    		if(tempData>count)
    		{
    			
    			   if (!popupWindow.isVisible()) 
    			   {
    				  
    		            // set location relative to button
    		            Point location = invokePopupButton.getLocation();
    		            SwingUtilities.convertPointToScreen(location, invokePopupButton.getParent());
    		            location.translate(0, invokePopupButton.getHeight()
    		                    + (invokePopupButton.getBorder() == null ? 0
    		                        : invokePopupButton.getBorder().getBorderInsets(invokePopupButton).bottom));
    		            popupWindow.setLocation(location);

    		            // show the popup if not visible
    		            invokePopupButton.setText("Hide popup");
    		            popupWindow.setVisible(true);
    		            popupWindow.requestFocus();
    		            count++;
    		        } 
    			   else
    		        {
    		            // hide it otherwise
    		            invokePopupButton.setText("Show popup");
    		            popupWindow.setVisible(false);
    		        }
    			
    		}
    		
		}
		catch(Exception e1)
		{
		System.out.println("Error--"+e1);	
		}
    }
}

Hi friends....
I try to connect with mysql (port-3306). Above code works properly in localhost but when i try it with ip of my server (173.255.216.128) it gives following error

e-------com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.ConnectException
MESSAGE: Connection refused: connect

STACKTRACE:

java.net.ConnectException: Connection refused: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
	at java.net.Socket.connect(Socket.java:529)
	at java.net.Socket.connect(Socket.java:478)
	at java.net.Socket.<init>(Socket.java:375)
	at java.net.Socket.<init>(Socket.java:218)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at PopupAnkit.init(PopupAnkit.java:46)
	at PopupAnkit.<init>(PopupAnkit.java:27)
	at PopupAnkit.main(PopupAnkit.java:111)


** END NESTED EXCEPTION **



Last packet sent to the server was 16 ms ago.
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException
Error--java.lang.NullPointerException

I can't understand why it not connects with my remote mysql. Though same program works perfectly in localhost.
Any help???
Please....
Thanks in advance

java mysql

3 Contributors
4 Replies
417 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by ~s.o.s~

peter_budo 2,532 Code tags enforcer

13 Years Ago

Remove servers like your personal installation are by default these days enabled only for localhost. That mean that only application that is on that machine can access it. If you want to get remote access then you need to change configuration (danger of mistakenly exposing your database to whole world without proper security) or you need to build a service that will serve data on request (web services approach)

Edited 13 Years Ago by peter_budo because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ankit.pandey3 -8 Junior Poster in Training · Answer 1 · 2011-09-22T12:03:29+00:00

Remove servers like your personal installation are by default these days enabled only for localhost. That mean that only application that is on that machine can access it. If you want to get remote access then you need to change configuration (danger of mistakenly exposing your database to whole world without proper security) or you need to build a service that will serve data on request (web services approach)

Can you tell me how i can do it???/

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster · Answer 2 · 2011-09-22T12:06:49+00:00

peter_budo 2,532 Code tags enforcer

13 Years Ago

Do what? Config changes or web service?

~s.o.s~ 2,560 Failure as a human Team Colleague Featured Poster · Answer 3 · 2011-09-23T12:34:20+00:00

> I try to connect with mysql (port-3306). Above code works properly in localhost but when i try it with ip of my server (173.255.216.128) it gives following error

This seems like a configuration issue. Are you able to ping this host? Are you able to connect to this host via a SQL UI client like MySQL workbench? Is the server under your control or have you bought this MySQL hosting?