streize

Black screen, DB issue

7 posts in this topic

Hello everyone, We ve got some issue with our server.
When we try to connect, we've got blackscreen with music and must alt F4 to exit, I see when my friends Alt f4 to leave the server.

When i shut off the mysql, the problem is the same so i suspect it to be the problem

Here is the log DB and some screens, if you can help me :)

All the installation was done with

TTW6p2d.png

fe7NxPi.png

ugilUv0.png

uIrFVCl.png

jhxZDjI.png

 

Sql Logs:

Spoiler

2016-03-02T00:13:19.005661Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-02T00:13:19.005661Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2016-03-02T00:13:19.006661Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.10-log) starting as process 11588 ...
2016-03-02T00:13:19.013669Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-02T00:13:19.014669Z 0 [Note] InnoDB: Uses event mutexes
2016-03-02T00:13:19.014669Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-02T00:13:19.014669Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-02T00:13:19.015670Z 0 [Note] InnoDB: Number of pools: 1
2016-03-02T00:13:19.015670Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-02T00:13:19.029685Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-02T00:13:19.034689Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-02T00:13:19.052168Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-02T00:13:19.072188Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-02T00:13:19.073189Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-02T00:13:19.098879Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-02T00:13:19.101883Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-02T00:13:19.102884Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-02T00:13:19.102884Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-02T00:13:19.153954Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 2491156
2016-03-02T00:13:19.153954Z 0 [Note] InnoDB: not started
2016-03-02T00:13:19.153954Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-03-02T00:13:19.153954Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-02T00:13:19.157958Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-02T00:13:19.157958Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160302  1:13:19
2016-03-02T00:13:19.158959Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-02T00:13:19.158959Z 0 [Note] IPv6 is available.
2016-03-02T00:13:19.158959Z 0 [Note]   - '::' resolves to '::';
2016-03-02T00:13:19.159960Z 0 [Note] Server socket created on IP: '::'.
2016-03-02T00:13:19.183284Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-02T00:13:19.184285Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.10-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-03-02T00:13:20.047586Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2016-03-02T00:14:15.211085Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown

2016-03-02T00:14:15.211085Z 0 [Note] Giving 0 client threads a chance to die gracefully
2016-03-02T00:14:15.212086Z 0 [Note] Shutting down slave threads
2016-03-02T00:14:15.212086Z 0 [Note] Forcefully disconnecting 0 remaining clients
2016-03-02T00:14:15.212086Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-03-02T00:14:15.212086Z 0 [Note] Binlog end
2016-03-02T00:14:15.220094Z 0 [Note] Shutting down plugin 'ngram'
2016-03-02T00:14:15.220094Z 0 [Note] Shutting down plugin 'partition'
2016-03-02T00:14:15.220094Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-02T00:14:15.221095Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-02T00:14:15.221095Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-02T00:14:15.221095Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-02T00:14:15.221095Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-02T00:14:15.221095Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-02T00:14:15.222095Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-02T00:14:15.222095Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-02T00:14:15.222095Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-02T00:14:15.222095Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-02T00:14:15.222095Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-02T00:14:15.223097Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-02T00:14:15.223097Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-02T00:14:15.223097Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-02T00:14:15.223097Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-02T00:14:15.224098Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-02T00:14:15.224098Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-02T00:14:15.224098Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-02T00:14:15.224098Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-02T00:14:15.224098Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-02T00:14:15.225099Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-02T00:14:15.225099Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-02T00:14:15.225099Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-02T00:14:15.225099Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-02T00:14:15.226100Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-02T00:14:15.226100Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-02T00:14:15.226100Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-02T00:14:15.226100Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-02T00:14:15.226100Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-02T00:14:15.227100Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-02T00:14:15.227100Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-02T00:14:15.227100Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-02T00:14:15.227100Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-02T00:14:15.227100Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-02T00:14:15.228101Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-02T00:14:15.228101Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-02T00:14:15.236110Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-02T00:14:15.237111Z 0 [Note] InnoDB: Starting shutdown...
2016-03-02T00:14:15.337990Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-03-02T00:14:15.340993Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160302  1:14:15
2016-03-02T00:14:16.610914Z 0 [Note] InnoDB: Shutdown completed; log sequence number 10808625
2016-03-02T00:14:16.611915Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-02T00:14:16.611915Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-02T00:14:16.611915Z 0 [Note] Shutting down plugin 'CSV'
2016-03-02T00:14:16.611915Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-02T00:14:16.611915Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-02T00:14:16.612916Z 0 [Note] Shutting down plugin 'binlog'
2016-03-02T00:14:16.618923Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

2016-03-02T00:14:59.474247Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-02T00:14:59.474247Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2016-03-02T00:14:59.475248Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.10-log) starting as process 2644 ...
2016-03-02T00:14:59.480253Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-02T00:14:59.480253Z 0 [Note] InnoDB: Uses event mutexes
2016-03-02T00:14:59.481254Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-02T00:14:59.481254Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-02T00:14:59.481254Z 0 [Note] InnoDB: Number of pools: 1
2016-03-02T00:14:59.482255Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-02T00:14:59.495269Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-02T00:14:59.500273Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-02T00:14:59.523295Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-02T00:14:59.596200Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-02T00:14:59.597202Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-02T00:14:59.633312Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-02T00:14:59.637316Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-02T00:14:59.637316Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-02T00:14:59.638317Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-02T00:14:59.688868Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 10808625
2016-03-02T00:14:59.688868Z 0 [Note] InnoDB: not started
2016-03-02T00:14:59.688868Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-03-02T00:14:59.688868Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-02T00:14:59.693873Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-02T00:14:59.694873Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-02T00:14:59.694873Z 0 [Note] IPv6 is available.
2016-03-02T00:14:59.695874Z 0 [Note]   - '::' resolves to '::';
2016-03-02T00:14:59.695874Z 0 [Note] Server socket created on IP: '::'.
2016-03-02T00:14:59.724212Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160302  1:14:59
2016-03-02T00:14:59.725214Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-02T00:14:59.726215Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.10-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-03-02T01:30:12.034946Z 9 [Note] Aborted connection 9 to db: 'unconnected' user: 'busybee' host: 'localhost' (Got an error reading communication packets)
2016-03-02T03:06:29.661932Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown

2016-03-02T03:06:29.662932Z 0 [Note] Giving 1 client threads a chance to die gracefully
2016-03-02T03:06:29.662932Z 0 [Note] Shutting down slave threads
2016-03-02T03:06:31.663783Z 0 [Note] Forcefully disconnecting 1 remaining clients
2016-03-02T03:06:31.663783Z 0 [Warning] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Forcing close of thread 11  user: 'busybee'

2016-03-02T03:06:31.663783Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-03-02T03:06:31.663783Z 0 [Note] Binlog end
2016-03-02T03:06:31.666787Z 0 [Note] Shutting down plugin 'ngram'
2016-03-02T03:06:31.666787Z 0 [Note] Shutting down plugin 'partition'
2016-03-02T03:06:31.666787Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-03-02T03:06:31.667788Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-03-02T03:06:31.667788Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-03-02T03:06:31.667788Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-03-02T03:06:31.667788Z 0 [Note] Shutting down plugin 'MyISAM'
2016-03-02T03:06:31.667788Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-03-02T03:06:31.668788Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-03-02T03:06:31.668788Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-03-02T03:06:31.668788Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-03-02T03:06:31.668788Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-03-02T03:06:31.668788Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-03-02T03:06:31.669789Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-03-02T03:06:31.669789Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-03-02T03:06:31.669789Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-03-02T03:06:31.669789Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-03-02T03:06:31.670790Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-03-02T03:06:31.670790Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-03-02T03:06:31.670790Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-03-02T03:06:31.670790Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-03-02T03:06:31.670790Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-03-02T03:06:31.671791Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-03-02T03:06:31.671791Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-03-02T03:06:31.671791Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-03-02T03:06:31.671791Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-03-02T03:06:31.672792Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-03-02T03:06:31.672792Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-03-02T03:06:31.672792Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-03-02T03:06:31.672792Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-03-02T03:06:31.672792Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-03-02T03:06:31.673793Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-03-02T03:06:31.673793Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-03-02T03:06:31.673793Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-03-02T03:06:31.673793Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-03-02T03:06:31.673793Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-03-02T03:06:31.674795Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-03-02T03:06:31.674795Z 0 [Note] Shutting down plugin 'InnoDB'
2016-03-02T03:06:31.674795Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-03-02T03:06:31.674795Z 0 [Note] InnoDB: Starting shutdown...
2016-03-02T03:06:31.776487Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-03-02T03:06:31.778489Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160302  4:06:31
2016-03-02T03:06:32.516792Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11539142
2016-03-02T03:06:32.517793Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-03-02T03:06:32.517793Z 0 [Note] Shutting down plugin 'MEMORY'
2016-03-02T03:06:32.517793Z 0 [Note] Shutting down plugin 'CSV'
2016-03-02T03:06:32.517793Z 0 [Note] Shutting down plugin 'sha256_password'
2016-03-02T03:06:32.517793Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-03-02T03:06:32.518794Z 0 [Note] Shutting down plugin 'binlog'
2016-03-02T03:06:32.522770Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

2016-03-02T03:07:50.848337Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-03-02T03:07:50.849338Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.10-log) starting as process 10292 ...
2016-03-02T03:07:50.853341Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-02T03:07:50.854342Z 0 [Note] InnoDB: Uses event mutexes
2016-03-02T03:07:50.854342Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-03-02T03:07:50.854342Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-02T03:07:50.855343Z 0 [Note] InnoDB: Number of pools: 1
2016-03-02T03:07:50.855343Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-02T03:07:50.868357Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-03-02T03:07:50.873361Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-03-02T03:07:50.896901Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-02T03:07:50.964275Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-03-02T03:07:50.965277Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-03-02T03:07:50.994283Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-03-02T03:07:50.997287Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-03-02T03:07:50.998288Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-03-02T03:07:50.998288Z 0 [Note] InnoDB: Waiting for purge to start
2016-03-02T03:07:51.049232Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 11539142
2016-03-02T03:07:51.049232Z 0 [Note] InnoDB: not started
2016-03-02T03:07:51.049232Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-03-02T03:07:51.049232Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-03-02T03:07:51.054238Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2016-03-02T03:07:51.054238Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-02T03:07:51.054238Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160302  4:07:51
2016-03-02T03:07:51.055239Z 0 [Note] IPv6 is available.
2016-03-02T03:07:51.055239Z 0 [Note]   - '::' resolves to '::';
2016-03-02T03:07:51.055239Z 0 [Note] Server socket created on IP: '::'.
2016-03-02T03:07:51.082544Z 0 [Note] Event Scheduler: Loaded 0 events
2016-03-02T03:07:51.083545Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.10-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2016-03-02T03:45:05.788427Z 5 [Note] Aborted connection 5 to db: 'unconnected' user: 'busybee' host: 'localhost' (Got an error reading communication packets)
2016-03-02T03:45:05.788427Z 10 [Note] Aborted connection 10 to db: 'unconnected' user: 'busybee' host: 'localhost' (Got an error reading communication packets)

 

 

2 people like this

Share this post


Link to post
Share on other sites

I am have the same issue. I ran the DB update

ALTER TABLE container ADD `abandoned` DATETIME DEFAULT NULL;
ALTER TABLE vehicle ADD `vehicle_texture` text NOT NULL;
ALTER TABLE `player` ADD `temperature` DOUBLE NOT NULL DEFAULT '37' AFTER `alcohol`, ADD `wetness` DOUBLE UNSIGNED NOT NULL DEFAULT '0' AFTER `temperature`;

UPDATE player SET temperature = 37;
UPDATE player SET wetness = 0;

 

And updated the server, I could log on once as a new spawn, but I cannot connect after and just get the black screen as well.  So frustrating! Let me know if you find anything out. Thanks!

 

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement

OK I saw this twice, once with AVS script which I took out and problem solved, 2nd was I forgot to update the server with the Exile client files.

Share this post


Link to post
Share on other sites

Check/remove any mods that are overriding core Exile SQFs.  Specifically, in my experience, my vehicle protection scripts are overriding ExileServer_object_player_database_load.sqf; however, there were changes in this SQF due to the new temperature system.  As-is, my override from the last version caused a black screen at login since it was missing the new 0.9.6 changes.

Share this post


Link to post
Share on other sites

Solved for me, i forgot one step

Server setting in "config.cpp" and:

Spoiler
SERVER SETTINGS
:
Line
3129
-
3191
serverPassword =
*
(Use servercommandpassword set in point 4)
useAutoLock = 1
(
Autolocks
server until its ready to accept players
)
restartAutoLock = 3
(
Server will autoLock at that time before restart
)
restartTime
r
[] = {
3
,0}
(
Number of hours and minutes of your restart period
)
useAutoKick = 1
(
Kicks players before restart to prevent gear
loss
)
kickTime = 2
(
Time before restart that server kicks players
)
useRestartMessages = 0
(Notifies players of server restart)
restartWaringTime
[] = {15, 10, 5, 3}
(
Number of minutes before the restart to inform your players
)
useShutdown
=
1
(Forces s
erver to shut down and close completely)
Startup script provided in this guide will restart the server!!!!

Hope it can help someone.

 

Share this post


Link to post
Share on other sites
On 3/7/2016 at 1:04 AM, Janine Renee said:

I am have the same issue. I ran the DB update

ALTER TABLE container ADD `abandoned` DATETIME DEFAULT NULL;
ALTER TABLE vehicle ADD `vehicle_texture` text NOT NULL;
ALTER TABLE `player` ADD `temperature` DOUBLE NOT NULL DEFAULT '37' AFTER `alcohol`, ADD `wetness` DOUBLE UNSIGNED NOT NULL DEFAULT '0' AFTER `temperature`;

UPDATE player SET temperature = 37;
UPDATE player SET wetness = 0;

 

And updated the server, I could log on once as a new spawn, but I cannot connect after and just get the black screen as well.  So frustrating! Let me know if you find anything out. Thanks!

 

i have the same problem!!!! please DEVS take loot to fix this problem!

Share this post


Link to post
Share on other sites

After a full week of testing and building servers for my community and helping out others, this is not an EXILE developer problem. This has everything to do with custom work done to your server.

I had similar issues with all my builds, to correct my problem with black screen logins, I rebuilt my servers from the ground up. It worked.

The problem with current servers tryingto update is your current overrides. Somewhere in there you are overriding one of the db loads or createplayer, somewhere in there you are not generating the proper info for your character to spawn in, hence the black screens. 

If you run, humanity, vehicle protection or a few others from what I've read, you will get this black screen...

 

Hope this helps good luck

1 person likes this

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.