老师我是看了泰斗破坏神的服务器,但是在利用Phtonserver从数据库中获取服务器的列表,它无法获取,哪个说ssl主机本地主机不支持 //实现父类的抽象方法 处理收到客户端的请求的方法 ...
追评
老师我是看了泰斗破坏神的服务器,但是在利用Phtonserver从数据库中获取服务器的列表,它无法获取,哪个说ssl主机本地主机不支持
//实现父类的抽象方法 处理收到客户端的请求的方法
public override OperationResponse OnHandlerMassage(OperationRequest request)
{
log.Debug("执行处理客户端请求的方法 OnHandlerMassage()");
//调用GetServerList()方法,得到服务器列表
List list = manager.GetServerList();
log.Debug("执行得到服务器列表" );
//把list对象转化成json的字符串
string json = JsonMapper.ToJson(list);
log.Debug("转化成json");
//我们用字典来传递参数 parameters翻译参数
Dictionary parameters = new Dictionary();
log.Debug("存到字典里");
//添加到字典,它的key(键)是枚举类型,区分传递的参数,值(valu)是我们要传递的数据json
parameters.Add((byte)ParameterCode.ServerList,json);
//存储给客户端的响应,就是ClientPeer类里的响应客户端发起的请求方法里的参数
OperationResponse response = new OperationResponse();
#region OperationResponse里的属性
//OperationCode byte 类型
//DebugMessage string类型
//ReturnCode short 类型 int占四字节,short占两字节 整数类型
// 我们用ReturnCode来表示服务器连接的状态
#endregion
response.ReturnCode =(short)ReturnCode.Success;//因为是枚举,所以强转成short
log.Debug("参数类型"+response.ReturnCode);
log.Debug("给参数赋值");
//把参数赋值指定给response对象里的Parameters字典
response.Parameters = parameters; //Parameters是它里面字典类型的属性 按F12查看
log.Debug("指定操作代码");
#region 指定给response对象什么样的操作代码
// 客户端发来的是什么样的操作代码我们就返回什么样的操作代码
// 比如是登陆的,还是加载服务器列表的操作代码等
// request参数存取的是客户端里的一些信息
#endregion
response.OperationCode = request.OperationCode;
log.Debug("执行到最后"+ response==null);
return response;//把这个OperationResponse的对象 response 返回到客户端
}
如下面的日志;日志log.Debug("执行处理客户端请求的方法 OnHandlerMassage()");下的都执行不了,没有输出日志,
是怎么回事,就是这里我无法加载到数据库里的数据
我想知道是不是ssl的问题,我才无法从数据库里获取,还是其他报错
如果是ssl的问题,该怎么解决?
下面是我的日志:
2018-07-02 09:45:05,903 [1] DEBUG TaidouServer.TaidouAppliaction [(null)] - 工程启动完成:Application setup conplete
2018-07-02 09:45:05,938 [1] INFO Photon.SocketServer.ApplicationBase [(null)] - Application start: AppId=TaidouServer; AppPath=C:\PhotonServer\deploy\TaidouServer, Type=TaidouServer.TaidouAppliaction
2018-07-02 09:45:11,595 [14] DEBUG TaidouServer.ClientPeer [(null)] - 执行到响应客户端发起的请求;OnOperationRequest()
2018-07-02 09:45:11,599 [14] DEBUG TaidouServer.ClientPeer [(null)] - 响应客户端的信息123
2018-07-02 09:45:11,679 [14] DEBUG TaidouServer.Handlers.ServerHandler [(null)] - 执行处理客户端请求的方法 OnHandlerMassage()
2018-07-02 09:45:12,041 [14] INFO NHibernate.Cfg.Environment [(null)] - NHibernate 5.1.1 (assembly 5.1.0.0)
2018-07-02 09:45:12,044 [14] INFO NHibernate.Cfg.Environment [(null)] - hibernate-configuration section not found in application configuration file
2018-07-02 09:45:12,053 [14] INFO NHibernate.Cfg.Environment [(null)] - Bytecode provider name : lcg
2018-07-02 09:45:12,060 [14] INFO NHibernate.Cfg.Environment [(null)] - Using reflection optimizer
2018-07-02 09:45:12,453 [14] DEBUG NHibernate.Cfg.Configuration [(null)] - Mapping XML:
2018-07-02 09:45:13,473 [14] INFO NHibernate.Dialect.Dialect [(null)] - Using dialect: NHibernate.Dialect.MySQLDialect
2018-07-02 09:45:13,589 [14] INFO NHibernate.Cfg.XmlHbmBinding.Binder [(null)] - Mapping class: TaidouCommon.Model.ServerProperty -> serverproperty
2018-07-02 09:45:13,688 [14] DEBUG NHibernate.Cfg.XmlHbmBinding.Binder [(null)] - Mapped property: ID -> id, type: Int32
2018-07-02 09:45:13,733 [14] DEBUG NHibernate.Cfg.XmlHbmBinding.Binder [(null)] - Mapped property: IP -> ip, type: String
2018-07-02 09:45:13,737 [14] DEBUG NHibernate.Cfg.XmlHbmBinding.Binder [(null)] - Mapped property: Name -> naem, type: String
2018-07-02 09:45:13,740 [14] DEBUG NHibernate.Cfg.XmlHbmBinding.Binder [(null)] - Mapped property: Count -> count, type: Int32
2018-07-02 09:45:13,763 [14] INFO NHibernate.Cfg.Configuration [(null)] - checking mappings queue
2018-07-02 09:45:13,766 [14] INFO NHibernate.Cfg.Configuration [(null)] - processing one-to-many association mappings
2018-07-02 09:45:13,772 [14] INFO NHibernate.Cfg.Configuration [(null)] - processing one-to-one association property references
2018-07-02 09:45:13,773 [14] INFO NHibernate.Cfg.Configuration [(null)] - processing foreign key constraints
2018-07-02 09:45:13,777 [14] INFO NHibernate.Cfg.Configuration [(null)] - processing filters (second pass)
2018-07-02 09:45:13,826 [14] INFO NHibernate.Dialect.Dialect [(null)] - Using dialect: NHibernate.Dialect.MySQLDialect
2018-07-02 09:45:13,861 [14] INFO NHibernate.Dialect.Dialect [(null)] - Using dialect: NHibernate.Dialect.MySQLDialect
2018-07-02 09:45:14,081 [14] INFO NHibernate.Exceptions.SQLExceptionConverterFactory [(null)] - Using dialect defined converter
2018-07-02 09:45:14,083 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Generate SQL with comments: disabled
2018-07-02 09:45:14,089 [14] INFO NHibernate.Connection.ConnectionProviderFactory [(null)] - Initializing connection provider: NHibernate.Connection.DriverConnectionProvider
2018-07-02 09:45:14,094 [14] INFO NHibernate.Connection.ConnectionProvider [(null)] - Configuring ConnectionProvider
2018-07-02 09:45:14,215 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Transaction factory: NHibernate.Transaction.AdoNetWithSystemTransactionFactory
2018-07-02 09:45:14,218 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Optimize cache for minimal puts: False
2018-07-02 09:45:14,221 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Connection release mode: auto
2018-07-02 09:45:14,223 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Default batch fetch size: 1
2018-07-02 09:45:14,226 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Statistics: disabled
2018-07-02 09:45:14,228 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Deleted entity synthetic identifier rollback: disabled
2018-07-02 09:45:14,231 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Query translator: NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory
2018-07-02 09:45:14,234 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Query provider: NHibernate.Linq.DefaultQueryProvider
2018-07-02 09:45:14,240 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Query language substitutions: {}
2018-07-02 09:45:14,244 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - cache provider: NHibernate.Cache.NoCacheProvider, NHibernate, Version=5.1.0.0, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2018-07-02 09:45:14,246 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Order SQL inserts for batching: disabled
2018-07-02 09:45:14,247 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Order SQL updates for batching: disabled
2018-07-02 09:45:14,249 [14] DEBUG NHibernate.Cfg.SettingsFactory [(null)] - Wrap result sets: disabled
2018-07-02 09:45:14,250 [14] DEBUG NHibernate.Cfg.SettingsFactory [(null)] - Batch versioned data: disabled
2018-07-02 09:45:14,256 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Batcher factory: NHibernate.AdoNet.NonBatchingBatcherFactory, NHibernate, Version=5.1.0.0, Culture=neutral, PublicKeyToken=aa95f207798dfdb4
2018-07-02 09:45:14,260 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Default flush mode: Auto
2018-07-02 09:45:14,261 [14] INFO NHibernate.Cfg.SettingsFactory [(null)] - Named query checking : enabled
2018-07-02 09:45:14,264 [14] DEBUG NHibernate.Cfg.SettingsFactory [(null)] - Track session id: enabled
2018-07-02 09:45:14,314 [14] INFO NHibernate.Impl.SessionFactoryImpl [(null)] - building session factory
2018-07-02 09:45:14,315 [14] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] - Session factory constructed with filter configurations : {}
2018-07-02 09:45:14,319 [14] DEBUG NHibernate.Impl.SessionFactoryImpl [(null)] - instantiating session factory with properties: {'use_reflection_optimizer'='True', 'connection.provider'='NHibernate.Connection.DriverConnectionProvider', 'connection.driver_class'='NHibernate.Driver.MySqlDataDriver, NHibernate, Version=5.1.0.0, Culture=neutral, PublicKeyToken=aa95f207798dfdb4', 'dialect'='NHibernate.Dialect.MySQLDialect, NHibernate, Version=5.1.0.0, Culture=neutral, PublicKeyToken=aa95f207798dfdb4', 'hibernate.dialect'='NHibernate.Dialect.MySQLDialect, NHibernate, Version=5.1.0.0, Culture=neutral, PublicKeyToken=aa95f207798dfdb4', 'connection.connection_string'='Server=localhost;Database=taidouserver;User ID=root;Password=root'}
2018-07-02 09:45:14,326 [14] DEBUG NHibernate.Connection.DriverConnectionProvider [(null)] - Obtaining DbConnection from Driver
2018-07-02 09:45:14,629 [14] ERROR Photon.SocketServer.PeerBase [(null)] - FluentNHibernate.Cfg.FluentConfigurationException: An invalid or incomplete configuration was used while creating a SessionFactory. Check PotentialReasons collection, and InnerException for more detail.
---> MySql.Data.MySqlClient.MySqlException: The host localhost does not support SSL connections.
在 MySql.Data.MySqlClient.NativeDriver.Open()
在 MySql.Data.MySqlClient.Driver.Open()
在 MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
在 MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
在 MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
在 MySql.Data.MySqlClient.MySqlPool.GetConnection()
在 MySql.Data.MySqlClient.MySqlConnection.Open()
在 NHibernate.Connection.DriverConnectionProvider.GetConnection()
在 NHibernate.Tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.Prepare()
在 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.GetReservedWords(Dialect dialect, IConnectionHelper connectionHelper)
在 NHibernate.Tool.hbm2ddl.SchemaMetadataUpdater.Update(ISessionFactoryImplementor sessionFactory)
在 NHibernate.Impl.SessionFactoryImpl..ctor(Configuration cfg, IMapping mapping, Settings settings, EventListeners listeners)
在 NHibernate.Cfg.Configuration.BuildSessionFactory()
在 FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory()
--- 内部异常堆栈跟踪的结尾 ---
在 FluentNHibernate.Cfg.FluentConfiguration.BuildSessionFactory()
在 TaidouServer.DB.NHibernateHelper.InitializeSessionFactory() 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\DB\NHibernateHelper.cs:行号 55
在 TaidouServer.DB.NHibernateHelper.get_SessionFactory() 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\DB\NHibernateHelper.cs:行号 66
在 TaidouServer.DB.NHibernateHelper.OpenSession() 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\DB\NHibernateHelper.cs:行号 77
在 TaidouServer.DB.Manager.ServerPropertyManager.GetServerList() 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\DB\Manager\ServerPropertyManager.cs:行号 19
在 TaidouServer.Handlers.ServerHandler.OnHandlerMassage(OperationRequest request) 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\Handlers\ServerHandler.cs:行号 39
在 TaidouServer.ClientPeer.OnOperationRequest(OperationRequest operationRequest, SendParameters sendParameters) 位置 C:\Users\24273\Desktop\程序\Photon网络\TaidouServer\TaidouServer\ClientPeer.cs:行号 47
在 Photon.SocketServer.PeerBase.OnReceive(Byte[] data, SendParameters sendParameters) 位置 h:\svncontent\photon-socketserver-sdk_3.4\src\Photon.SocketServer\PeerBase.cs:行号 962
在 Photon.SocketServer.PeerBase.OnReceiveInternal(Byte[] data, SendParameters sendParameters, Int32 rtt, Int32 rttVariance, Int32 numFailures) 位置 h:\svncontent\photon-socketserver-sdk_3.4\src\Photon.SocketServer\PeerBase.cs:行号 749
追评