[OPEN SOURCE PROJECT] NosOpen

Quote:

Originally Posted by 0Lucifer0 Yes its automaticaly in your mssql if your configuration is good

Quote:

Originally Posted by Skaterkeks when i update database, i become error massage not be set as expected. Use the -StartUpProjectName parameter to set one explicitly. Use the -Verbose switch for more information. Geben Sie das Flag '-Verbose' an, um die auf die Zieldatenbank angewendeten SQL-Anweisungen anzuzeigen. System.Data.SqlClient.SqlException (0x80131904): Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server. Der Server wurde nicht gefunden, oder auf ihn kann nicht zugegriffen werden. Überprüfen Sie, ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zulässt. (provider: Named Pipes Provider, error: 40 - Verbindung mit SQL Server konnte nicht geöffnet werden) ---> System.ComponentModel.Win32Exception (0x80004005): Das System kann die angegebene Datei nicht finden bei System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) bei System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) bei System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) bei System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) bei System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) bei System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) bei System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) bei System.Data.ProviderBase.DbConnectionFactory.TryGe tConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) bei System.Data.ProviderBase.DbConnectionInternal.TryO penConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) bei System.Data.ProviderBase.DbConnectionClosed.TryOpe nConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) bei System.Data.SqlClient.SqlConnection.TryOpenInner(T askCompletionSource`1 retry) bei System.Data.SqlClient.SqlConnection.TryOpen(TaskCo mpletionSource`1 retry) bei System.Data.SqlClient.SqlConnection.Open() bei System.Data.Entity.Infrastructure.Interception.DbC onnectionDispatcher.<Open>b__36(DbConnection t, DbConnectionInterceptionContext c) bei System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) bei System.Data.Entity.Infrastructure.Interception.DbC onnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) bei System.Data.Entity.SqlServer.SqlProviderServices.< >c__DisplayClass33.<UsingConnection>b__32() bei System.Data.Entity.SqlServer.DefaultSqlExecutionSt rategy.<>c__DisplayClass1.<Execute>b__0() bei System.Data.Entity.SqlServer.DefaultSqlExecutionSt rategy.Execute[TResult](Func`1 operation) bei System.Data.Entity.SqlServer.DefaultSqlExecutionSt rategy.Execute(Action operation) bei System.Data.Entity.SqlServer.SqlProviderServices.U singConnection(DbConnection sqlConnection, Action`1 act) bei System.Data.Entity.SqlServer.SqlProviderServices.U singMasterConnection(DbConnection sqlConnection, Action`1 act) bei System.Data.Entity.SqlServer.SqlProviderServices.C reateDatabaseFromScript(Nullable`1 commandTimeout, DbConnection sqlConnection, String createDatabaseScript) bei System.Data.Entity.SqlServer.SqlProviderServices.D bCreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection) bei System.Data.Entity.Core.Common.DbProviderServices. CreateDatabase(DbConnection connection, Nullable`1 commandTimeout, StoreItemCollection storeItemCollection) bei System.Data.Entity.Core.Objects.ObjectContext.Crea teDatabase() bei System.Data.Entity.Migrations.Utilities.DatabaseCr eator.Create(DbConnection connection) bei System.Data.Entity.Migrations.DbMigrator.EnsureDat abaseExists(Action mustSucceedToKeepDatabase) bei System.Data.Entity.Migrations.Infrastructure.Migra torBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) bei System.Data.Entity.Migrations.DbMigrator.Update(St ring targetMigration) bei System.Data.Entity.Migrations.Infrastructure.Migra torBase.Update(String targetMigration) bei System.Data.Entity.Migrations.Design.ToolingFacade .UpdateRunner.Run() bei System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate) bei System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate) bei System.Data.Entity.Migrations.Design.ToolingFacade .Run(BaseRunner runner) bei System.Data.Entity.Migrations.Design.ToolingFacade .Update(String targetMigration, Boolean force) bei System.Data.Entity.Migrations.UpdateDatabaseComman d.<>c__DisplayClass2.<.ctor>b__0() bei System.Data.Entity.Migrations.MigrationsDomainComm and.Execute(Action command) ClientConnectionId:00000000-0000-0000-0000-000000000000 Fehlernummer (Error Number):2,Status (State):0,Klasse (Class):20

Quote:

Originally Posted by Goblousek how to i can connect new versione on db?

Quote:

Originally Posted by Marvin341 Where to "inject" the file to the server? Is it done automaticly?

Quote:

Originally Posted by Freaky423 Can anyone help me? [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Marvin341 Error again after installing everything "update-database : The term 'update-database' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:1 + update-database -verbose + ~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (update-database:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException " Solution: do Update-Package EntityFramework restart vs enter Update-Database -Verbose

Quote:

Originally Posted by DuckDuckGoose0815 Try to restore your Nu-Get packages and also be sure you selected "OpenNos.DAL.EF" when you try to update your DB :)

Quote:

Originally Posted by Marvin341 already got it working ^^ After restarting vs it worked How to get now the Files which got mentioned in the video and in that " - Can we have other files for parser? : Yes, simply by extracting them from your client : nslangdata.dat, nsgtddata.dat, nstcdata.dat - Item/Monster Name isn't in my language : please do your own parser files... get them from your client and you will have the correct language." Found them. The error now while starting the server like OpenNos.World.exe  Spoiler [ERROR] 15:59:07 -- General Error System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at [Only registered and activated users can see links. Click Here To Register...] that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte 127.0.0.1:60205 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Bool ean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(Transpo rtContext& context) at System.Net.HttpWebRequest.GetRequestStream() at System.ServiceModel.Channels.HttpOutput.WebRequest HttpOutput.GetOutputStream() --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Security.IssuanceTokenProvider Base`1.DoNegotiation(TimeSpan timeout) at System.ServiceModel.Security.SspiNegotiationTokenP rovider.OnOpen(TimeSpan timeout) at System.ServiceModel.Security.WrapperSecurityCommun icationObject.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) at System.ServiceModel.Security.CommunicationObjectSe curityTokenProvider.Open(TimeSpan timeout) at System.ServiceModel.Security.SymmetricSecurityProt ocol.OnOpen(TimeSpan timeout) at System.ServiceModel.Security.WrapperSecurityCommun icationObject.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) at System.ServiceModel.Channels.SecurityChannelFactor y`1.ClientSecurityChannel`1.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionSecuri tyTokenProvider.DoOperation(SecuritySessionOperati on operation, EndpointAddress target, Uri via, SecurityToken currentToken, TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionSecuri tyTokenProvider.GetTokenCore(TimeSpan timeout) at System.IdentityModel.Selectors.SecurityTokenProvid er.GetToken(TimeSpan timeout) at System.ServiceModel.Security.SecuritySessionClient Settings`1.ClientSecuritySessionChannel.OnOpen(Tim eSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) at System.ServiceModel.Channels.ReliableChannelBinder `1.ChannelSynchronizer.SyncWaiter.TryGetChannel() at System.ServiceModel.Channels.ReliableChannelBinder `1.ChannelSynchronizer.SyncWaiter.TryWait(TChannel & channel) at System.ServiceModel.Channels.ReliableChannelBinder `1.ChannelSynchronizer.TryGetChannel(Boolean canGetChannel, Boolean canCauseFault, TimeSpan timeout, MaskingMode maskingMode, TChannel& channel) at System.ServiceModel.Channels.ReliableChannelBinder `1.Send(Message message, TimeSpan timeout, MaskingMode maskingMode) at System.ServiceModel.Channels.SendReceiveReliableRe questor.OnRequest(Message request, TimeSpan timeout, Boolean last) at System.ServiceModel.Channels.ReliableRequestor.Req uest(TimeSpan timeout) at System.ServiceModel.Channels.ClientReliableSession .Open(TimeSpan timeout) at System.ServiceModel.Channels.ClientReliableDuplexS essionChannel.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.OnOpen (TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.O pen(TimeSpan timeout) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type) at System.ServiceModel.ICommunicationObject.Open(Time Span timeout) at System.ServiceModel.ClientBase`1.System.ServiceMod el.ICommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.ClientBase`1.Open() at OpenNos.ServiceRef.Internal.ServiceFactory.Initial ize() in C:\Users\Marvi\Documents\GitHub\OpenNos\OpenNos.Se rviceRef.Internal\ServiceFactory.cs:line 115 at OpenNos.World.Program.Main(String[] args) in C:\Users\Marvi\Documents\GitHub\OpenNos\OpenNos.Wo rld\Program.cs:line 101 Whats that? okay i need to do that [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Skaterkeks Kann mir einer evtl helfen? [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Marvin341 When did you Download it from github ? Because it Looks like its a Bit old because mysql isnt anymore used , its now mssql

Quote:

Originally Posted by Skaterkeks Yes, i download the latest version from github..