w4wx/sso_server

sso_server

• 更新MySQL连接池
• 连接redis
• 逻辑调整
• 生成GUID
• 接入GRPC

g++ -std=c++11 /usr/local/mariadb/bin/mysql_config --cflags --libs -I/root/_test/libbcrypt/include -I/usr/local/mariadb/include -I/usr/include/mysql/include/jdbc -L/usr/local/lib -lcpp_redis -ltacopie -L/usr/lib64/mysql/lib64 -Wl,-rpath=/usr/lib64/mysql/lib64 -lhiredis -lbcrypt -lmysqlcppconn mysql.cpp DBPool.cpp -o mysql

g++ -std=c++11 -L/usr/local/lib pkg-config --libs protobuf grpc++ grpc -I/usr/include -lgrpc -lgpr -lgrpc++_reflection -lprotobuf -ldl -lpthread -lprotoc -lprotobuf-lite sso.grpc.pb.cc sso.pb.cc sso_server.cc -o sso_server

g++ -std=c++11 -L/usr/local/lib pkg-config --libs protobuf grpc++ grpc -I/usr/include -lgrpc -lgpr -lgrpc++_reflection -lprotobuf -ldl -lpthread -lprotoc -lprotobuf-lite sso.grpc.pb.cc sso.pb.cc sso_client.cc -o sso_client

g++ -std=c++11 /usr/local/mariadb/bin/mysql_config --cflags --libs pkg-config --libs protobuf grpc++ grpc -I/root/_test/libbcrypt/include -I/usr/local/mariadb/include -I/usr/include/mysql/include/jdbc -L/usr/local/lib -lcpp_redis -ltacopie -L/usr/lib64/mysql/lib64 -Wl,-rpath=/usr/lib64/mysql/lib64 -lhiredis -lbcrypt -lmysqlcppconn -lgrpc -lgpr -lgrpc++_reflection -lprotobuf -ldl -lpthread -lprotoc -lprotobuf-lite DBPool.cpp sso.grpc.pb.cc sso.pb.cc sso_server.cc -o sso_server

g++ -std=c++11 -L/usr/local/lib pkg-config --libs protobuf grpc++ grpc -I/usr/include -lgrpc -lgpr -lgrpc++_reflection -lprotobuf -ldl -lpthread -lprotoc -lprotobuf-lite sso.grpc.pb.cc sso.pb.cc sso_server.cc -o sso_server

protoc -I protos --grpc_out=. --plugin=protoc-gen-grpc=which grpc_cpp_plugin protos/sso.proto protoc -I protos --cpp_out=. protos/sso.proto

登录存储过程 CREATE PROCEDURE update_login (IN user_id INT(3), IN user_name VARCHAR(50), IN device_id VARCHAR(100), IN status INT(30)) BEGIN UPDATE t_login_his SET status=1 WHERE userID=user_id and deviceID <> device_id; INSERT INTO t_login_his (userID, userName, deviceID, status) SELECT user_id, user_name, device_id, status FROM dual WHERE not exists(select userID from t_login_his as a where a.userID = user_id and a.deviceID = device_id); UPDATE t_login_his SET status=0 WHERE userID=user_id and deviceID = device_id; END;