Jump to content
Altroot

Needing help with Altis Life - MySQL - Not connecting to server.

Recommended Posts

So below if the thread is created correctly is a step by step introduction of how I'm trying to setup mySQL, 
 
 
CPU:
Intel Core i7 5930K @ 3.50GHz 
Cores 6 Threads 12 
Virtualization Supported, 
Enabled Hyperthreading Supported,
 
OS:
Windows 10 Home 64-bit
 
RAM:
32.0GB
 
 
WP.LOG
00:46:23 [ERR][      Workbench]: Console redirection failed.
00:46:23 [INF][      WBContext]: Parsing application arguments.
00:46:23 [INF][      WBContext]:     C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
00:46:23 [INF][      Workbench]: Starting up Workbench
00:46:23 [INF][      Workbench]: Current environment:
Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" 
CurrentDirectory: C:\Users\Altro\AppData\Local\Temp\MSID88F.tmp-
HasShutdownStarted: False
OSVersion: Microsoft Windows NT 6.2.9200.0
SystemDirectory: C:\WINDOWS\system32
TickCount: 1941046
UserInteractive: True
Version: 4.0.30319.42000
WorkingSet: 35024896
00:46:23 [INF][      Workbench]: Environment variables:
COMPUTERNAME = BADGER
USERPROFILE = C:\Users\Altro
HOMEPATH = \Users\Altro
LOCALAPPDATA = C:\Users\Altro\AppData\Local
PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
PROCESSOR_ARCHITECTURE = AMD64
Path = C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\Altro\AppData\Local\Microsoft\WindowsApps;C:\Users\Altro\AppData\Local\atom\bin
CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
ProgramFiles(x86) = C:\Program Files (x86)
PROCESSOR_LEVEL = 6
LOGONSERVER = \\BADGER
PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
HOMEDRIVE = C:
SystemRoot = C:\WINDOWS
ALLUSERSPROFILE = C:\ProgramData
PUBLIC = C:\Users\Public
ProgramData = C:\ProgramData
PROCESSOR_REVISION = 3f02
USERNAME = Admin
CommonProgramW6432 = C:\Program Files\Common Files
CommonProgramFiles = C:\Program Files\Common Files
OS = Windows_NT
USERDOMAIN_ROAMINGPROFILE = BADGER
PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 63 Stepping 2, GenuineIntel
ComSpec = C:\WINDOWS\system32\cmd.exe
SystemDrive = C:
TEMP = C:\Users\Altro\AppData\Local\Temp
ProgramFiles = C:\Program Files
NUMBER_OF_PROCESSORS = 12
APPDATA = C:\Users\Altro\AppData\Roaming
TMP = C:\Users\Altro\AppData\Local\Temp
ProgramW6432 = C:\Program Files
windir = C:\WINDOWS
USERDOMAIN = BADGER
__COMPAT_LAYER = Installer
00:46:23 [INF][      Workbench]: Current version given by meta info is: 6.3.7
00:46:23 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\Altro\AppData\Local\Microsoft\WindowsApps;C:\Users\Altro\AppData\Local\atom\bin
00:46:23 [INF][ mforms managed]: Initializing mforms wrapper
00:46:23 [INF][   WBContext UI]: Initializing workbench context UI with these values:
base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
struct path: 
module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules
library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
user data dir: C:\Users\Altro\AppData\Roaming\MySQL\Workbench
open at start: 
open type: 
run at startup: 
run type: 
Force SW rendering: No
Force OpenGL: No
quit when done: No
00:46:23 [INF][      WBContext]: WbContext::init
00:46:23 [INF][            grt]: Scanning module directory C:\Users\Altro\AppData\Roaming\MySQL\Workbench\modules.
00:46:23 [INF][            grt]: Scanning module directory ..
00:46:23 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.
00:46:23 [INF][            WBA]: Looking for extension modules for WBA...
00:46:23 [INF][            WBA]: 0 extension modules found
00:46:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
00:46:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
00:46:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
00:46:23 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.
00:46:23 [WRN][            grt]: C:\Users\Altro\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{4D0DE103-4420-49A7-8EBE-BA53EB20F3C8}' <object GrtObject> key=owner could not be resolved
00:46:23 [INF][      WBContext]: System info:
  MySQL Workbench Community (GPL) for Windows version 6.3.7 CE build 1199 (64 bit)
Configuration Directory: C:\Users\Altro\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
Cairo Version: 1.10.2
OS: Microsoft Windows 10 Home
CPU: 12x Intel(R) Core(TM) i7-5930K CPU @ 3.50GHz, 31.9 GiB RAM
Active video adapter NVIDIA GeForce GTX 970
Installed video RAM: -1 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 21.21.13.7290
Installed display drivers: C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvd3dumx,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2umx,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2umx,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2umx,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvd3dum,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2um,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2um,C:\WINDOWS\System32\DriverStore\FileRepository\nv_desktop_ref4i.inf_amd64_35540330911d388c\nvwgf2um
Current user language: English (United Kingdom)

00:46:23 [INF][      Workbench]: UI is up
00:46:24 [INF][      Workbench]: Running the application
00:47:25 [INF][      SqlEditor]: Opened connection 'altislife' to MySQL Community Server (GPL) version 5.7.15-log
00:47:26 [INF][     AutoCCache]: Initializing autocompletion cache for altislife
00:47:26 [INF][        WQE.net]: Launching SQL IDE
00:47:26 [INF][        WQE.net]: SQL IDE UI is ready
00:51:21 [INF][        WQE.net]: Shutting down SQL editor (altislife)
00:51:21 [INF][      Workbench]: Shutting down Workbench
00:51:21 [INF][ mforms managed]: Shutting down mforms wrapper
00:51:21 [INF][      Workbench]: Done

 

The issue I'm having occurs before launching the arma3 server itself. But I'm asking in this forums to see if anyone has a fix or a workaround?

 
extdb-config.ini: (I will be changing PW if fixed)
[altislife]
Type = MySQL
Name = altislife

Username = root
Password = password

IP = 127.0.0.1
Port = 3306

;minSessions = 2
idleTime = 60

compress = false
; Really should only use this if MySQL server is external. Also only for MySQL

Secure Auth = true
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth

 

Here is the end of my .rpt for the arma server:

Altis Life RPG v4.5: string @STR_MISC_overviewText cannot be localized client-side - move to global stringtable
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Server error: Player without identity Atlroot (id 880500283)
Starting mission:
 Mission file: Altis_Life (__cur_mp)
 Mission world: Altis
 Mission directory: mpmissions\__cur_mp.Altis\
Strange convex component145 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView
Strange convex component149 in a3\plants_f\tree\t_pinuss2s_b_f.p3d:geometryView
Attempt to override final function - bis_functions_list
Attempt to override final function - bis_functions_listpreinit
Attempt to override final function - bis_functions_listpostinit
Attempt to override final function - bis_functions_listrecompile
Attempt to override final function - bis_fnc_missiontaskslocal
Attempt to override final function - bis_fnc_missionconversationslocal
Attempt to override final function - bis_fnc_missionflow
Loading movesType CfgGesturesMale
MovesType CfgGesturesMale load time 362 ms
Loading movesType CfgMovesMaleSdr
MovesType CfgMovesMaleSdr load time 6593 ms
No speaker given for Ali Ngige
No speaker given for Ali Okonkwo
No speaker given for Dixon Walker
No speaker given for Hamidi Azikiwe
No speaker given for Hu Chang
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
No speaker given for Tavish Anderson
No speaker given for Donald Warren
No speaker given for Mike Thompson
No speaker given for Spencer Bennett
No speaker given for Muhammad Okeke
No speaker given for Mike White
No speaker given for Connor Hill
No speaker given for Kyle Young
No speaker given for Dong Yeung
No speaker given for Lu Chen
No speaker given for Samuel Newton
No speaker given for Luke O'Sullivan
No speaker given for Jamie Taylor
No speaker given for Lu Kung
No speaker given for Archie Conrad
No speaker given for Matthew White
No speaker given for Oliver Clark
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
No speaker given for Max Jones
No speaker given for Katungi Sesse-Seko
No speaker given for Jake Anderson
No speaker given for Dwan Smith
No speaker given for Greer Nelson
No speaker given for Keith Harris
No speaker given for Greer Moore
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 1c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 2c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 3c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 4c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 5c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 6c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 7c not found
Wrong vertex mapping for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Selection 8c not found
Wrong geometry convex component mapping  for person collision geometry found in a3\characters_f_epc\civil\c_nikos_aged.p3d. Convex component number 3. not found
No speaker given for Evangelos Costas
No speaker given for Vasilis Karmanlis
No speaker given for Evripidis Karmanlis
No speaker given for Michalis Mastori
No speaker given for Vasilis Zenon
No speaker given for Kouris Manelia
No speaker given for Angelos Nicolau
No speaker given for Michalis Petridis
No speaker given for Samaras Athanasiadis
No speaker given for Biton Christou
No speaker given for Fotini Dimitriadis
No speaker given for Militiadis Manelia
No speaker given for Sotiris Gikas
No speaker given for Thanos Kammenou
No speaker given for Sotiris Stanis
No speaker given for Evripidis Manetta
No speaker given for Nicolo Nicolau
No speaker given for Costa Stanis
No speaker given for Militiadis Papadopoulos
No speaker given for Thamos Malas
No speaker given for Panos Ioannou
No speaker given for Thanos Ioannou
No speaker given for Vasilis Elias
No speaker given for Gamba Achebe
Error: Object(2 : 664) not found
c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
"extDB2: Error with Database Connection"
 Mission id: f39333a6db3a66404bdaa345e16dcbcf7ebc8868
Ragdoll - loading of ragdoll source "Soldier" started.
Ragdoll - loading of ragdoll source "Soldier" finished successfully.

I have done the following to try and fix:

 

Googled till the cows come home for fix,

Installed MySQL as Local Admin User,

Downgraded MySQL to previous versions (same error persists in WP.log),
Reinstalled Windows, (extreme I know, had to be sure before posting here though)

Added exceptions to folders MySQL in firewall,
Turned firewall off, (back on now :P)

Changed Compatibility mode for MySQl workbench.

Tried using extdb3 rather then 2. (I know this wasn't going to fix, had to try though)

Side notes:

 

I have had exile servers using MySQL when OS was 8.1.

I will be making the same thread to MySQL forums, and other sites aswell.

Sorry if this post looks a mess, first time poster.

 

Share this post


Link to post
Share on other sites

You should go to https://www.altisliferpg.com/and sign up for support.
They also have a discord channel, you will need to wait after connecting to get added to the channels.

 

Sidenote:
If you have extDB2 installed correctly i.e vc2013/2015 x86 redist installed. It will have its own log files with info.
I still recommend you to go altisliferpg for support/help

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×