Any1 running offsite databases? EXTDB3 Issues...

  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Any1 running offsite databases? EXTDB3 Issues...

« posted: Apr 02, 2018, 09:02 PM »
What's up guys, long time no see. Decided to take a break for a bit.

Long story short, I switched providers, can't have 100% access to database, tried running offsite DB, can connect, but extdb3 can't find the tables, tables are there, user has all permissions.

Code: [Select]
[13:53:15:971662 -05:00] [Thread 4420] extDB3: Locked
[13:53:16:022527 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.DBInfo' doesn't exist
[13:53:16:022564 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: getDBVersion
[13:53:16:079095 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerInstance' doesn't exist
[13:53:16:079123 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: checkServerInstance:2
[13:53:16:120942 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerMap' doesn't exist
[13:53:16:120980 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: getServerMapID:Stratis:normal
[13:53:16:281697 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerVehicles' doesn't exist
[13:53:16:281723 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: deleteExpiredServerVehicles:2:any:12:48
[13:53:17:149453 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBQueryException: Table 'techmokey_a3w_stratis.ServerVehicles' doesn't exist
[13:53:17:149481 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBQueryException: Input: getServerVehicles:2:any:,Class,Position,Direction,Velocity,Flying,Damage,Fuel,HitPoints,OwnerUID,LockState,Variables,Textures,Weapons,Magazines,Items,Backpacks,TurretMagazines,TurretMagazines2,TurretMagazines3,AmmoCargo,FuelCargo,RepairCargo
[13:53:17:293974 -05:00] [Thread 9136] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerTime' doesn't exist
[13:53:17:294003 -05:00] [Thread 9136] extDB3: SQL: Error MariaDBStatementException0: Input: getServerTime:2:any
[13:53:17:309487 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerMines' doesn't exist
[13:53:17:309526 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: deleteExpiredServerMines:2:any:48
[13:53:17:432703 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBQueryException: Table 'techmokey_a3w_stratis.ServerMines' doesn't exist
[13:53:17:432734 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBQueryException: Input: getServerMines:2:any:,Class,Position,Direction,Damage,OwnerUID,Variables
[13:53:37:595201 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Table 'techmokey_a3w_stratis.ServerTime' doesn't exist
[13:53:37:595236 -05:00] [Thread 7380] extDB3: SQL: Error MariaDBStatementException0: Input: insertOrUpdateServerTime

Anyone using and external DB? can ExtDB3 connect externally?
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Any1 running offsite databases? EXTDB3 Issues...

« Reply #1 posted: Apr 02, 2018, 09:06 PM »
whoops wrong topic. Can some1 move it to tech support plz.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Any1 running offsite databases? EXTDB3 Issues...

« Reply #2 posted: Apr 02, 2018, 11:51 PM »
So, I re-ran the query to create the tables rather than import my whole table. My new database is being ran with MariaDB and not MySQL. So the structure is off. Now I can connect.

The issue now is that I cannot import my data. Duplicate Key Entry

(v2.05 )
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Any1 running offsite databases? EXTDB3 Issues...

« Reply #3 posted: Apr 03, 2018, 06:01 AM »
Ok, so I was able to get the database to connect...

So when you go from MySQL to MariaDB, you need to recreate the tables. Then if you want to save your data, you need to import the data with keys disabled. ensure your character casing matches the table you are moving to and viola!

But once I connected I get chopped off at the nuts.

RPT:

Code: [Select]
22:57:11 BEServer: registering a new player #1286133345
22:57:29 Unaccessible
22:57:29 "Player connected: [FRAC] Mokey (76561198008596823)"
22:57:29 "[extDB3] Sleep [4]: 120.338"
22:57:30 Scripting function 'bis_fnc_execvm' is not allowed to be remotely executed
22:57:30 "updateConnectingClients [Player: R Alpha 1-3:1 ([FRAC] Mokey) REMOTE] [JIP: true]"

After this, it disconnects me. I believe it's cutting me off from calling the db from A3W? But I could be completely wrong @AgentRev but I'm not quite sure.

EXTDB Logs:
Code: [Select]
extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
 
 
[22:55:46:336192 -05:00] [Thread 7956] extDB3: Locked
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!
  • Offline Mokey
  • Fractured Wasteland
  • Elite
  • ******
  • Posts: 606
  • Https://Fractured-Gaming.com

Re: Any1 running offsite databases? EXTDB3 Issues...

« Reply #4 posted: Apr 03, 2018, 11:04 PM »
So, I went ahead and did everything from scratch. It's working now. same steps. Must of been a fluke.
Posts once, edits post 40 times in 60 seconds. STUPID FAT FINGERS!