Unhandled Exception: SocketException: Socket has been closed

[ThitSarNyanLynn]

When I run this simple codes, I found the following error log.

import 'dart:async';
import 'package:sqljocky5/sqljocky.dart';

Future<void> createTables(MySqlConnection conn) async {
  print("Creating tables ...");
  await conn.execute('CREATE TABLE people (id INTEGER NOT NULL auto_increment, '
      'name VARCHAR(255), '
      'age INTEGER, '
      'PRIMARY KEY (id))');
  await conn.execute('CREATE TABLE pets (id INTEGER NOT NULL auto_increment, '
      'name VARCHAR(255), '
      'species TEXT, '
      'owner_id INTEGER, '
      'PRIMARY KEY (id),'
      'FOREIGN KEY (owner_id) REFERENCES people (id))');
  print("Created table!");
}

main() async {
  var s = ConnectionSettings(
    user: "root",
    password: "",
    host: "192.168.1.3",
    port: 3306,
    db: "ppms",
  );

  // create a connection
  print("Opening connection ...");
  var conn = await MySqlConnection.connect(s);
  print("Opened connection!");

  await createTables(conn);

  await conn.close();
}

E/flutter ( 4153): [ERROR:flutter/lib/ui/ui_dart_state.cc(148)] Unhandled Exception: SocketException: Socket has been closed
E/flutter ( 4153): #0 Comm.connect (package:sqljocky5/comm/comm.dart:182:5)
E/flutter ( 4153):
E/flutter ( 4153): #1 MySqlConnectionImpl.connect (package:sqljocky5/connection/impl.dart:102:27)
E/flutter ( 4153):
E/flutter ( 4153): #2 MySqlConnection.connect (package:sqljocky5/connection/connection.dart:36:27)
E/flutter ( 4153): #3 main (package:f_sqljocky_test/main.dart:28:36)
E/flutter ( 4153):
E/flutter ( 4153): #4 _runMainZoned.. (dart:ui/hooks.dart:189:25)
E/flutter ( 4153): #5 _rootRun (dart:async/zone.dart:1124:13)
E/flutter ( 4153): #6 _CustomZone.run (dart:async/zone.dart:1021:19)
E/flutter ( 4153): #7 _runZoned (dart:async/zone.dart:1516:10)
E/flutter ( 4153): #8 runZoned (dart:async/zone.dart:1500:12)
E/flutter ( 4153): #9 _runMainZoned. (dart:ui/hooks.dart:180:5)
E/flutter ( 4153): #10 _startIsolate. (dart:isolate/runtime/libisolate_patch.dart:300:19)
E/flutter ( 4153): #11 _RawReceivePortImpl._handleMessage (dart:isolate/runtime/libisolate_patch.dart:171:12)
E/flutter ( 4153):
Syncing files to device Android SDK built for x86...

[tejainece]

Thanks for reporting. I will try to reproduce it.

Are you trying to connect to mysql server on desktop from Flutter?

[YuanTianyang]

I had the same problem

[jinfei]

I had the same problem,too

[ctcx]

@tejainece
when your password is error,you can catch this exception.

`
file sqljocky5-2.2.1/lib/comm/buffered_socket.dart
line 92: replace to onDataReady()
} else if (event == RawSocketEvent.readClosed) {
if (this.onClosed != null) {
onDataReady();
//this.onClosed();
}
}

`
Run again after modification！
I can catch this exception:
Error 1045 (28000): Access denied for user 'user'@'ip' (using password: YES)

[yusufnadar]

Is there any solution?

[4stern]

this repo is down ..

[mastgaurav001]

I also had the same problem.