Problems with sql.data and photon crashing.
Options
So I recently downloaded a unity package asset that used photon to do some pretty neat things. Unfortunately the documentation is so poorly written I cant get a server up to do any of the stuff its meant to do. I have literally no experience with this and the asset maker isn't responding so I must ask for help.
You can check the documentation here : http://zerano-unity3d.com/Photon%203.0% ... %20Kit.pdf
They parts I don't really get are:
1: "I am running xampp, but you can install any solution, also only the
mysql server. What you only need to do is to run the unitydb.sql
script." - Can some one explain how you run a sql script?
2:"Now you need to compile the source files and put the bin files into" - How do you compile source files? There is something called MMOServer_source, I assume it has something to do with that so I put that in the src-server folder and then linked deploy.prompter to it and just got a flurry of errors.
And this is the Log for when the server crashes.
Thanks a ton to any one that helps me.
You can check the documentation here : http://zerano-unity3d.com/Photon%203.0% ... %20Kit.pdf
They parts I don't really get are:
1: "I am running xampp, but you can install any solution, also only the
mysql server. What you only need to do is to run the unitydb.sql
script." - Can some one explain how you run a sql script?
2:"Now you need to compile the source files and put the bin files into" - How do you compile source files? There is something called MMOServer_source, I assume it has something to do with that so I put that in the src-server folder and then linked deploy.prompter to it and just got a flurry of errors.
And this is the Log for when the server crashes.
4548: 21:18:42.130 - Service: "Photon Socket Server" starting 4548: 21:18:42.130 - Config File: C:\Users\Follett\Desktop\Server\deploy\deploy\bin_Win64\PhotonServer.config 4548: 21:18:42.131 - Will produce at most: 10 crash dumps 4548: 21:18:42.132 - Server Starting... 4548: 21:18:42.132 - Tick count: 21819937 (wraps in: 49.4577 days) 4548: 21:18:42.132 - Tick count 64: 21819937 4548: 21:18:42.132 - Photon Version: 3.0.15.1343 4548: 21:18:42.132 - PID: 6540 4548: 21:18:42.132 - Config File: C:\Users\Follett\Desktop\Server\deploy\deploy\bin_Win64\PhotonServer.config 4548: 21:18:42.146 - Max message size: 512000 4548: 21:18:42.146 - S2S: MaxInboundMessageSize: 512000 4548: 21:18:42.146 - S2S: MaxOutboundMessageSize: 512000 4548: 21:18:42.146 - S2S: No inactivity timeout 4548: 21:18:42.149 - Max Reliable Data In Transit (awaiting ACKs) per peer : 51200 bytes 4548: 21:18:42.149 - Per peer bandwidth limit 4548: 21:18:42.149 - Transmit Rate Limit: 256 KB/Sec 4548: 21:18:42.149 - Limit period: 200ms 4548: 21:18:42.149 - Limit per period: 52428 bytes 4548: 21:18:42.149 - Max queued data for transmission per peer: 512000 bytes 4548: 21:18:42.149 - Minimum retransmit timeout: 200 4548: 21:18:42.149 - Minimum ENet timeout: 5000ms 4548: 21:18:42.149 - Maximum ENet timeout: 30000ms 4548: 21:18:42.149 - Outbound ENet: MaxInboundMessageSize: 512000 4548: 21:18:42.149 - Outbound ENet: MaxOutboundMessageSize: 512000 4548: 21:18:42.154 - About to load runtime: PhotonHostRuntime.PhotonDomainManager from PhotonHostRuntime, Culture=neutral, PublicKeyToken=02C301B61B060C4D 4548: 21:18:42.154 - Optimising event broadcast for 20 or more peers 4548: 21:18:42.155 - About to load CLR - versions available: 4548: 21:18:42.155 - v2.0.50727 4548: 21:18:42.155 - v4.0.30319 4548: 21:18:42.155 - No preference in configuration file, will load latest. 4548: 21:18:42.155 - About to load version: "v4.0.30319" 4548: 21:18:42.156 - Loaded version: "v4.0.30319" 4548: 21:18:47.800 - Photon host runtime loaded 4548: 21:18:47.824 - License is valid. 4548: 21:18:47.824 - Licensed for 100 concurrent connections. 4548: 21:18:47.824 - Max Reliable Data In Transit (awaiting ACKs) per peer : 51200 bytes 4548: 21:18:47.824 - Per peer bandwidth limit 4548: 21:18:47.824 - Transmit Rate Limit: 256 KB/Sec 4548: 21:18:47.824 - Limit period: 200ms 4548: 21:18:47.824 - Limit per period: 52428 bytes 4548: 21:18:47.824 - Max queued data for transmission per peer: 512000 bytes 4548: 21:18:47.824 - Minimum retransmit timeout: 200 4548: 21:18:47.824 - Minimum ENet timeout: 5000ms 4548: 21:18:47.824 - Maximum ENet timeout: 30000ms 4548: 21:18:47.824 - CENetHost: Using Timer Wheel 4548: 21:18:47.824 - About to load application: Lite from Lite 4548: 21:18:47.824 - Auto restart is enabled for application 4548: 21:18:47.824 - Application will restart 1000ms after the last change detected 4548: 21:18:47.824 - Application will restart if files matching the following are changed: "dll;config" 4548: 21:18:47.824 - Application will NOT restart if files matching the following are changed: "log4net.config" 4548: 21:18:54.269 - Application: "Lite" started in app domain: 2 4548: 21:18:54.270 - About to load application: LiteLobby from LiteLobby 4548: 21:18:54.270 - Auto restart is enabled for application 4548: 21:18:54.270 - Application will restart 1000ms after the last change detected 4548: 21:18:54.270 - Application will restart if files matching the following are changed: "dll;config" 4548: 21:18:54.270 - Application will NOT restart if files matching the following are changed: "log4net.config" 4548: 21:18:59.975 - Application: "LiteLobby" started in app domain: 3 4548: 21:18:59.975 - About to load application: MmoDemo from Photon.MmoDemo.Server 4548: 21:18:59.975 - Auto restart is enabled for application 4548: 21:18:59.975 - Application will restart 1000ms after the last change detected 4548: 21:18:59.975 - Application will restart if files matching the following are changed: "dll;config" 4548: 21:18:59.975 - Application will NOT restart if files matching the following are changed: "log4net.config" 4548: 21:19:05.641 - Application: "MmoDemo" started in app domain: 4 4548: 21:19:05.641 - About to load application: MMOServer from MMOServer 4548: 21:19:05.641 - Auto restart is enabled for application 4548: 21:19:05.641 - Application will restart 1000ms after the last change detected 4548: 21:19:05.641 - Application will restart if files matching the following are changed: "dll;config" 4548: 21:19:05.641 - Application will NOT restart if files matching the following are changed: "log4net.config" 4548: 21:19:11.297 - Application: "MMOServer" started in app domain: 5 4548: 21:19:11.298 - About to load application: CounterPublisher from CounterPublisher 4548: 21:19:11.298 - Auto restart is enabled for application 4548: 21:19:11.298 - Application will restart 1000ms after the last change detected 4548: 21:19:11.298 - Application will restart if files matching the following are changed: "dll;config" 4548: 21:19:11.298 - Application will NOT restart if files matching the following are changed: "log4net.config" 4548: 21:19:16.940 - Application: "CounterPublisher" started in app domain: 6 4548: 21:19:16.940 - About to load application: Policy from Policy.Application 4548: 21:19:22.365 - Application: "Policy" started in app domain: 7 4548: 21:19:22.365 - Adding TCP listener on :0.0.0.0: 4530 with a listen backlog of: 150 4548: 21:19:22.365 - TCP inactivity timeout: 5000ms 4548: 21:19:22.365 - MaxInboundMessageSize: 512000 4548: 21:19:22.365 - MaxOutboundMessageSize: 512000 4548: 21:19:22.365 - MaxInboundMessageSize: 512000 4548: 21:19:22.365 - MaxOutboundMessageSize: 512000 4548: 21:19:22.365 - UDP address specified as:0.0.0.0 adding listener to each available IPv4 address 4548: 21:19:22.366 - Adding UDP listener on :10.0.0.12: 5055 with a listen backlog of: 500 4548: 21:19:22.366 - Adding UDP listener on :127.0.0.1: 5055 with a listen backlog of: 500 4548: 21:19:22.366 - Adding TCP Policy listener on :0.0.0.0: 843 with a listen backlog of: 150 and routing to application: "Policy" 4548: 21:19:22.366 - TCP inactivity timeout: 1000ms 4548: 21:19:22.366 - Adding TCP Policy listener on :0.0.0.0: 943 with a listen backlog of: 150 and routing to application: "Policy" 4548: 21:19:22.366 - TCP inactivity timeout: 1000ms 4548: 21:19:22.366 - Adding WebSocket TCP listener on :0.0.0.0: 9090 with a listen backlog of: 150 4548: 21:19:22.366 - Nagle disabled 4548: 21:19:22.366 - TCP inactivity timeout: 10000ms 4548: 21:19:22.366 - MaxInboundMessageSize: 512000 4548: 21:19:22.366 - MaxOutboundMessageSize: 512000 4548: 21:19:22.366 - Forcing all applications ids to: "Lite" 4548: 21:19:22.386 - Service is running... 4548: 21:19:24.151 - CService::OnException() - Exception: CManagedHost::PhotonRunning() - Failed in AppDomain: 5 - The system cannot find the file specified. 4548: 21:19:24.151 - Server shutting down... 4548: 21:19:24.151 - Notifying CLR applications of shutdown... 4548: 21:19:24.167 - Shutting down TCP Outbound Connection Manager... 4548: 21:19:24.167 - Shutting down ENet Outbound Connection Manager... 4548: 21:19:24.167 - Disconnecting all outbound peers... 4548: 21:19:24.167 - Shutting down ENet host... 4548: 21:19:24.167 - Disconnecting all peers... 4548: 21:19:24.167 - Shutting down socket servers... 4548: 21:19:24.177 - Shutting down ENet thread pool... 4548: 21:19:24.177 - Shutting down TCP inactivity timers... 4548: 21:19:24.177 - WaitingForShutdownToComplete: TCP:0.0.0.0:4530 4548: 21:19:24.177 - OnShutdownCompleted: TCP:0.0.0.0:4530 4548: 21:19:24.177 - WaitingForShutdownToComplete: TCPPolicy:0.0.0.0:843 4548: 21:19:24.177 - OnShutdownCompleted: TCPPolicy:0.0.0.0:843 4548: 21:19:24.177 - WaitingForShutdownToComplete: TCPPolicy:0.0.0.0:943 4548: 21:19:24.177 - OnShutdownCompleted: TCPPolicy:0.0.0.0:943 4548: 21:19:24.177 - WaitingForShutdownToComplete: UDP:10.0.0.12:5055 4548: 21:19:24.177 - OnShutdownCompleted: UDP:10.0.0.12:5055 4548: 21:19:24.177 - WaitingForShutdownToComplete: UDP:127.0.0.1:5055 4548: 21:19:24.177 - OnShutdownCompleted: UDP:127.0.0.1:5055 4548: 21:19:24.177 - WaitingForShutdownToComplete: WebSocket:0.0.0.0:9090 4548: 21:19:24.177 - OnShutdownCompleted: WebSocket:0.0.0.0:9090 4548: 21:19:24.177 - Shutting down CLR applications... 4548: 21:19:24.192 - Shutting down business logic thread pool... 4548: 21:19:24.192 - Shutting down I/O thread pool... 4548: 21:19:24.193 - Flushing ENET buffer allocator... 4548: 21:19:24.193 - Flushing TCP buffer allocator... 4548: 21:19:24.194 - Flushing TCP buffer handle allocator... 4548: 21:19:24.194 - Flushing stream socket allocator... 4548: 21:19:24.194 - Flushing inbound datagram socket allocator... 4548: 21:19:24.195 - Flushing outbound datagram socket allocator... 4548: 21:19:24.195 - Destroying ENet thread pool 4548: 21:19:24.195 - Destroying Business logic thread pool 4548: 21:19:24.195 - Destroying servers 4548: 21:19:24.195 - Destroying TCP Outbound Connection Manager 4548: 21:19:24.195 - Destroying resolver 4548: 21:19:24.195 - Destroying TCP Proxy Connection Manager 4548: 21:19:24.195 - Destroying TCP inactivity timer 4548: 21:19:24.195 - Destroying ENet host 4548: 21:19:24.195 - Destroying ENet host 4548: 21:19:24.195 - Destroying CLR dispatcher 4548: 21:19:24.195 - Destroying CLR applications 4136: 21:19:24.195 - CManagedHost::OnDomainUnload() - 6 4548: 21:19:24.278 - Destroying I/O thread pool 4548: 21:19:24.278 - Destroying ENet buffer allocator 4548: 21:19:24.278 - Destroying TCP buffer allocator 4548: 21:19:24.278 - Destroying TCP socket allocator 4548: 21:19:24.278 - Destroying ENet inbound socket allocator 4548: 21:19:24.278 - Destroying ENet outbound socket allocator 4548: 21:19:24.278 - Destroying performance counters 4548: 21:19:24.278 - Shutdown complete...
Thanks a ton to any one that helps me.
0
Comments
-
The problem here is that Photon can't start the MMO application. See:
"Application: "MMOServer" started in app domain: 5"
and
"Failed in AppDomain: 5 - The system cannot find the file specified."
The SDK comes with a pre-build application that "just works". It comes with code as well, which is in sdk/src-server/mmo.
You can compile that code but to run it, Photon needs the binaries in the /deploy folder. Have a look where the files are in the SDK and compile your project to override it. Check if the PhotonServer.config fits the DLL names you produced.0
