Jump to content
Dedmen

Intercept Database (SQL Database Extension)

Recommended Posts

14 hours ago, Terrano. said:

is will be added a JSON support?

Explain?

Share this post


Link to post
Share on other sites
1 hour ago, Dedmen said:

Explain?

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

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

  • Like 2

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

  • Like 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

  • Like 1

Share this post


Link to post
Share on other sites
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 🙂

Share this post


Link to post
Share on other sites
12 hours ago, Chewz said:

Hi man, you had any luck with this?

No time. Currently pushing on crappy diploma project.

  • Like 1

Share this post


Link to post
Share on other sites
4 hours ago, Dedmen said:

No time. Currently pushing on crappy diploma project.

No worries! 

Share this post


Link to post
Share on other sites

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 by Nicer

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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.

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

×