dart - Dart-SqlJocky-无法解析类 'SHA1'

Question

我正在尝试使用以下代码在Amazon RDS上连接MySQL Server:

 var pool = new ConnectionPool(
      host: "xxxx.rds.amazonaws.com",
      port: 3306,
      user: "root",
      password: "123456",
      db: "crm",
      max: 5);
  try {
    var results = await pool.query("show tables;");
    results.forEach((row) {
      print(row);
    });
  } catch (exception) {
    print(exception);
  }

我遇到了这个:

2017-07-13 19:14:11.556440: ConnectionPool: Running query: show tables;
2017-07-13 19:14:11.562390: ConnectionPool: Getting a connection
2017-07-13 19:14:11.562800: ConnectionPool: Number of in-use connections: 0
2017-07-13 19:14:11.563133: ConnectionPool: Creating new pooled cnx#0
2017-07-13 19:14:11.565475: Connection.Lifecycle: Use connection #0
2017-07-13 19:14:11.566736: Connection: opening connection to xxxx.rds.amazonaws.com:3306/portea_crm
2017-07-13 19:14:11.653693: BufferedSocket: WRITE data
2017-07-13 19:14:11.689824: BufferedSocket: READ data
2017-07-13 19:14:11.689943: BufferedSocket: READ data: no buffer
2017-07-13 19:14:11.690250: Connection: readPacket readyForHeader=true
2017-07-13 19:14:11.690613: BufferedSocket: readBuffer, length=4
2017-07-13 19:14:11.690815: BufferedSocket: readBuffer, data already ready
2017-07-13 19:14:11.693935: BufferedSocket: read 4 bytes
2017-07-13 19:14:11.694517: Connection: about to read 78 bytes for packet 0
2017-07-13 19:14:11.694662: Connection: buffer size=78
2017-07-13 19:14:11.694714: BufferedSocket: readBuffer, length=78
2017-07-13 19:14:11.694755: BufferedSocket: readBuffer, data already ready
2017-07-13 19:14:11.694969: BufferedSocket: read 78 bytes
2017-07-13 19:14:11.702610: Connection: completing with exception: 'package:sqljocky/src/auth/auth_handler.dart': malformed type: line 24 pos 24: cannot resolve class 'SHA1' from '_AuthHandler@16306938'
      var hasher = new SHA1();
                       ^

与在库中调用SHA1的crypto lib依赖关系有关系吗？

另外，我的SQLjocky版本是0.6.1。我在发布站点上看到的是0.14.1。为什么我不能更新？

Answer 1

最后，

我在Sqljocky中使用RPC。

他们有不同版本的加密软件包。

解决，

dependencies:
  rpc: "^0.5.7+1"
  sqljocky: "^0.14.1"
  crypto: '>=0.9.0 <0.10.0'

dependency_overrides:
  crypto: '>=0.9.0 <0.10.0'