分布式数据库中间件–(2)Cobar与客户端的握手认证

 private void read(NIOConnection c) {
 try {
 c.read();
 } catch (Throwable e) {
 c.error(ErrorCode.ERR_READ, e);
 }
 }

 public void handle(final byte[] data) {
 // 从线程池获取一个线程,异步处理前端数据
 	// 从processor中的线程池中获取一个可以执行的线程,执行Runnable任务
 processor.getHandler().execute(new Runnable() {
 @Override
 public void run() {
 try {
 //调用具体NIOHandler子类的handle函数
 handler.handle(data);
 } catch (Throwable t) {
 error(ErrorCode.ERR_HANDLE_DATA, t);
 }
 }
 });
 }

 public FrontendConnection(SocketChannel channel) {
 super(channel);
 .....................
 //前端认证处理器
 this.handler = new FrontendAuthenticator(this);
 }

 public void handle(byte[] data) {
 // check quit packet
 if (data.length == QuitPacket.QUIT.length && data[4] == MySQLPacket.COM_QUIT) {
 source.close();
 return;
 }
 //新建认证包对象
 AuthPacket auth = new AuthPacket();
 //读取认证包到对象
 auth.read(data);
 // check user
 if (!checkUser(auth.user, source.getHost())) {
 failure(ErrorCode.ER_ACCESS_DENIED_ERROR, "Access denied for user '" + auth.user + "'");
 return;
 }
 // check password
 if (!checkPassword(auth.password, auth.user)) {
 failure(ErrorCode.ER_ACCESS_DENIED_ERROR, "Access denied for user '" + auth.user + "'");
 return;
 }
 // check schema
 switch (checkSchema(auth.database, auth.user)) {
 case ErrorCode.ER_BAD_DB_ERROR:
 failure(ErrorCode.ER_BAD_DB_ERROR, "Unknown database '" + auth.database + "'");
 break;
 case ErrorCode.ER_DBACCESS_DENIED_ERROR:
 String s = "Access denied for user '" + auth.user + "' to database '" + auth.database + "'";
 failure(ErrorCode.ER_DBACCESS_DENIED_ERROR, s);
 break;
 default:
 //认证成功,向客户端发送认证结果消息
 success(auth);
 }
 }

 protected void success(AuthPacket auth) {
 	//认证通过,设置连接属性:已认证\用户\数据库\处理器
 source.setAuthenticated(true);
 source.setUser(auth.user);
 source.setSchema(auth.database);
 source.setCharsetIndex(auth.charsetIndex);
 //设置该连接的连接处理器为前端命令处理器
 source.setHandler(new FrontendCommandHandler(source));
 .......
 ByteBuffer buffer = source.allocate();
 source.write(source.writeToBuffer(AUTH_OK, buffer));
 }

16:59:19,388 INFO ===============================================
16:59:19,389 INFO Cobar is ready to startup ...
16:59:19,389 INFO Startup processors ...
16:59:19,455 INFO Startup connector ...
16:59:19,460 INFO Initialize dataNodes ...
16:59:19,506 INFO dnTest1:0 init success
16:59:19,514 INFO dnTest3:0 init success
16:59:19,517 INFO dnTest2:0 init success
16:59:19,527 INFO CobarServer is started and listening on 8066
16:59:19,527 INFO ===============================================
16:59:23,459 DEBUG 1>>NIOReactor接受连接数:0
16:59:23,464 DEBUG 2>>NIOReactor接受连接数:1
16:59:23,465 DEBUG select读事件
16:59:23,465 INFO com.alibaba.cobar.net.handler.FrontendAuthenticator接收的请求长度:62
58 0 0 1 5 166 15 0 0 0 0 1 33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 114 111 111 116 0 20 169 171 247 102 133 96 158 224 121 22 226 229 88 244 119 238 185 61 124 219 
16:59:23,468 INFO [thread=Processor1-H0,class=ServerConnection,host=192.168.137.8,port=46101,schema=null]'root' login success

yan@yan-Z400:~$ mysql -uroot -p** -P8066 -h192.168.137.8
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.48-cobar-1.2.7 Cobar Server (ALIBABA)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>