Intercept Database (SQL Database Extension)

[Terrano. 0]

is will be added a JSON support?

[Dedmen 2714]

14 hours ago, Terrano. said:

is will be added a JSON support?

Explain?

[Terrano. 0]

1 hour ago, Dedmen said:

Explain?

As i understand - JSON format needed to save a lot of data to mysql table (~100000 records)

[Dedmen 2714]

7 minutes ago, Terrano. said:

As i understand - JSON format needed to save a lot of data to mysql table (~100000 records)

No? json format is just a string.

 

[Terrano. 0]

I tryed to enable logging, but nothing changed, `dblog` folder is not created in `arma 3` directory. Can't find any logs 😞

here is config values

logging:
  directory: dbLog 
  querylog: true 
  threadlog: true 

@Dedmen, help please

[Dedmen 2714]

16 hours ago, Terrano. said:

I tryed to enable logging, but nothing changed

Logging is not in stable (steam workshop) yet.

Here is  the documentation for the stable version: https://intercept-database.readthedocs.io/en/stable/intro/config-file.html

I added logging and some other config values while trying to reproduce some bugs, it wasn't released yet, though I plan to release it till the weekend.

[Chewz 23]

Hi @Dedmen

 

Thank you for releasing this!

 

Please can you advice on what the dependencies are? I am having an issue where ArmA can't find the Intercept extension on both Headless Client and the server and I have absolutely no idea why!

EDIT: This problem is now resolved, I wasn't running the server or Headless Client as 64 bit!
 

Thanks in advance

 

Chewz

[Dedmen 2714]

19 hours ago, Chewz said:

Please can you advice on what the dependencies are?

Only dependency is having Intercept core mod.

Oh yeah and 64bit on windows, 32bit (currently) on linux.

I don't support 32bit anymore as its so uncommon nowadays.

[Chewz 23]

Hi again!

 

Apologies, but I seem to be having a couple issues with the use of SQL functions and stored procedures.

 

At the moment, I am running a DB Async query that executes a MySQL function or stored procedure and then returns the results in either an array or integer format. I am making use of the dbCallBack functionality you have implemented to handle these Async query executions, which works wonderfully. However, if I attempt to call a MySQL query shortly after the previous one, I receive the following error:

 

22:15:51 Error in expression <interceptOnFrame>
22:15:51   Error position: <interceptOnFrame>
22:15:51   Error Intercept-DB exception: Can't connect twice. Already connected
at
CALL StoredProcedureName(?, ?);

Do you have any ideas what may be causing this? If I do a simple select query, it seems to work at every execution no matter how quickly they are executed but as soon as I implement these functions and stored procedure calls it seems to hang.

 

Many thanks in advance

 

Chewz

[Dedmen 2714]

10 hours ago, Chewz said:

Can't connect twice. Already connected

huh... uh. That seems to be a issue with the mysql library I'm using. Interesting.
I'll see if I can do things on the weekend.

[Chewz 23]

10 minutes ago, Dedmen said:

huh... uh. That seems to be a issue with the mysql library I'm using. Interesting.
I'll see if I can do things on the weekend.

Cheers man! Appreciate it 🙂

[Chewz 23]

Hi man, you had any luck with this?

[Dedmen 2714]

12 hours ago, Chewz said:

Hi man, you had any luck with this?

No time. Currently pushing on crappy diploma project.

[Chewz 23]

4 hours ago, Dedmen said:

No time. Currently pushing on crappy diploma project.

No worries! 

[colinm9991 20]

Good to see an asynchronous database wrapper

[Nicer 10]

Hey,

is it possible that it is no longer working?

Upon server startup it writes this into the console:

 1:05:27 PhysX3 SDK Init started ...
 1:05:27 PhysX3 SDK Init ended.
 1:05:27 Initializing Intercept
Call extension 'intercept' could not be loaded
 1:05:27 Intercept initialization part 1/3: 
Call extension 'intercept' could not be loaded
Call extension 'intercept' could not be loaded
 1:05:27 Error in expression <interceptRegisterTypes parsingNamespace>
 1:05:27   Error position: <parsingNamespace>
 1:05:27   Error Missing ;
 1:05:27 Error in expression <interceptRegisterTypes parsingNamespace>
 1:05:27   Error position: <parsingNamespace>
 1:05:27   Error Missing ;
 1:05:27 Intercept initialization part 2/3: any
 1:05:27 Intercept Loading Plugin: intercept-database
Call extension 'intercept' could not be loaded
Call extension 'intercept' could not be loaded

Location of the mod folder is in arma3serverroot/@InterceptDB

Edit: running Linux 32bit profiling branch V0 server v2.02

 

Edit2: I didn't copy the clib into base server folder... Now it loads but when I click continue in map briefing the server crashes.

 

Edit3:

The log right before crash:

terminate called after throwing an instance of 'mariadb::exception::connection'
  what():  type error

 

Edited February 25, 2021 by Nicer

[mtt_asch 10]

Hello! Checking to see if there are plans regarding 64-bit Linux support for this?

[Dedmen 2714]

On 5/1/2021 at 6:00 PM, mtt_asch said:

Hello! Checking to see if there are plans regarding 64-bit Linux support for this?

Plans many, time not so much. intercept itself needs to be fixed up to work on x64 linux.

[ussrlongbow 116]

Hi! any plans/updates on 64-bit linux support?