Bug #83846 Connection fails on Mac OS X EL Capitan
Submitted: 16 Nov 2016 14:18 Modified: 26 Jun 2017 12:22
Reporter: Simon Buehlmann Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Connection Handling Severity:S3 (Non-critical)
Version:5.5.52 OS:Mac OS X (EL Capitan 10.11.3)
Assigned to: Assigned Account CPU Architecture:Any

[16 Nov 2016 14:18] Simon Buehlmann
Description:
Impossible to establish any connection independent the application used (JDBC / MySQL Workbench) The error message is:

lost connection to mysql server at 'reading initial communication packet' system error:0

Trying to connect to the mysql server using telnet on port 3306 seems to be OK

Connecting to the same server using Microsoft Windows is OK.

How to repeat:
Connect to the server using MySQL Workbench (current release)

Using the following java program:

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

import javax.sql.DataSource;

public class DataSourceTest {
    
    private DataSource ds;
    
    public DataSourceTest(){
        ds = getMySQLDataSource();
        try {
            Connection conn = ds.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * from table_t");
            while(rs.next()){
                System.out.println(rs.getString("id_nr"));
            }

            System.out.println("Done.");
            Scanner s = new Scanner(System.in);
            s.nextLine();
            s.close();
 
            conn.close();          
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
    
    public static void main(String[]
            args){
        new DataSourceTest();
    }
    
    public static DataSource getMySQLDataSource() {
        MysqlDataSource mysqlDS = null;
        mysqlDS = new MysqlDataSource();
        mysqlDS.setURL("jdbc:mysql://somehost.com/database");
        mysqlDS.setUser("username");
        mysqlDS.setPassword("password");
        return mysqlDS;
    }
}
[17 Nov 2016 11:14] Miguel Solorzano
Please provide the my.cnf file. Thanks.
[18 Dec 2016 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[20 Dec 2016 13:06] Simon Buehlmann
Unfortunately I have no access to the my.ini file but I copied the content  of server variables into a file. Hope that helps.
[26 May 2017 12:22] Chiranjeevi Battula
Hello Simon Buehlmann,

Thank you for the feedback.
Could you please provide more details like 
1. Full stack trace
2. where is MySQL installed?
3. Tests you did with windows were on the same machine the server is installed or a different machine?
4. What does you get from "telnet mysqlserver 3306" on your mac?
5. Can you connect using the MySQL client from your mac? (- - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[27 Jun 2017 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".