My LFS server and Airio works under linux. There is MySQL and i don't want install one more database. But ok i test this sqlite
Okram
My LFS server and Airio works under linux. There is MySQL and i don't want install one more database. But ok i test this sqlite
Okram
One file really isn't an installation is it?
Actually SQLite is already there on most servers, the Redhat Package Manager and/or Yum for example are dependent on SQLite.
In most cases it's sufficient enough to update the sqlite library file to a more recent version like the one EQ Worry provides.
Actually SQLite is already there on most servers, the Redhat Package Manager and/or Yum for example are dependent on SQLite.
In most cases it's sufficient enough to update the sqlite library file to a more recent version like the one EQ Worry provides.
The thing is that with tens of thousands of stored records the current internal Airio arrangement eats quite a lot of memory, because everything's always held in memory. For example Airio managing AirAttack demo servers can take over 100 MB of system memory. With so many records the delay when enumerating through data starts to be noticeable. While it is usually not a big problem, there are other considerations such as data integrity and code simplifications.
What I'm now trying to do is keep all the data in a database, using relatively simple queries to select what needs to be shown or insert/update what needs to be changed. Database also simplifies/enables external changes to the data, at least for everyone knowing SQL basics. For all this I need a database engine with specific properties. It needs to be simple, fast, portable, easily configurable.
SQLite has these properties. It is just one DLL file, no setup and configuration is necessary. The created database is in just one file, perfectly portable. There's no chance using MySQL as the primary data store, because 9 or 10 Airio users would fail miserably installing and configuring the system. (Count me among them.) SQLite support in Airio requires just one external file and that's it.
I'm afraid using MySQL as the primary data store is not possible. The question is if a sort of export to MySQL could be implemented, but I'm really not sure...
Aaaah, very good point (as always)! The journal file is not important, but the DB3 file should go to the daily backups. I'll see what can be done and will try to implement the functionality into almost finished Airio 2.4.5...
Found an error...
Airio 2.4.5
Uhm, that one looks nasty, but unfortunately I do not currently see the cause, partially because Airio 2.4.5 is released and the line numbers have changed. Please do the update and if the troubles reappear, let me know again.
As mentioned, new Airio is available. The most important thing is SQLite support also in the FREE version and the possibility not only to import data to the database (basically from the STA files) using !dbi, but also to export data from the SQLite database to the internal tables later saved as STA files using !dbe. That means admins can edit the database and transfer changes to the running Airio. See the changelog for more details.
Hi EQ
Have a problem with two different external add-ons that i want to run at the same time but LFS wont let me (up to yet), im hoping you will be able to help.
I currently run Aonio, which inside the LFS CFG file wants the outgauge UDP settings to be like this...
OutGauge Mode 0
OutGauge Delay 0
OutGauge IP 127.0.0.1
OutGauge Port 0
OutGauge ID 0
But i have just installed an external digital dashboard, which wants the UDP settings to be...
OutGauge Mode 1
OutGauge Delay 10
OutGauge IP 127.0.0.1
OutGauge Port 55
OutGauge ID 0
If i have the Outgauge Mode set to 0 Aonio runs but not the digi-dash, and if i set it to 1, the digi-dash works but aspects of Aonio stop working (fuel, speed, RPM and shift beep).
Is there any way around this so i can run both at once fully working?
Cheers mate
Have a problem with two different external add-ons that i want to run at the same time but LFS wont let me (up to yet), im hoping you will be able to help.
I currently run Aonio, which inside the LFS CFG file wants the outgauge UDP settings to be like this...
OutGauge Mode 0
OutGauge Delay 0
OutGauge IP 127.0.0.1
OutGauge Port 0
OutGauge ID 0
But i have just installed an external digital dashboard, which wants the UDP settings to be...
OutGauge Mode 1
OutGauge Delay 10
OutGauge IP 127.0.0.1
OutGauge Port 55
OutGauge ID 0
If i have the Outgauge Mode set to 0 Aonio runs but not the digi-dash, and if i set it to 1, the digi-dash works but aspects of Aonio stop working (fuel, speed, RPM and shift beep).
Is there any way around this so i can run both at once fully working?
Cheers mate
are you on steroids or something? Damn you are fast these days
Uhmmm. I'm afraid I have no idea what Outgauge Mode sets/means... Any more info available somewhere?
I need to have some stable and reliable version before summer holidays, that's why.
Not much new features, but no (serious) bugs either, that's why the updates.Is the new one official released..? My mailbox is still empty.
Hehe, just sent. I was waiting for a few hours to see if there's no big problem. Well, and in fact there was one, so it was worth the waiting...
Thx alot!
Found a new typo in the changelog....
Found a new typo in the changelog....
Hi EQ,
I have an error loading Airio...
I tried to register with regsvr32 System.Data.SQLite.dll library and my operating system does not allow it, any suggestions?
I have an error loading Airio...
10.06.28 21:33:52 AIRIO ERROR : Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_v2(Byte[] utf8Filename, IntPtr& db, Int32 flags, IntPtr vfs)
at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)
at System.Data.SQLite.SQLiteConnection.Open()
at LiveForSpeed.InSim.Airio.Datas.DBOpen() in D:\Development Files\LFS_Airio\Sqls.cs:line 32
I tried to register with regsvr32 System.Data.SQLite.dll library and my operating system does not allow it, any suggestions?
On Windows you'll need to copy sqlite3.dll into Airio or Windows\System32 directory, on Linux you'll need sqlite3.so in some system directory (renaming the SO file may be required). Click on the filename to download or get the file from here.
SQLite Linux
I use SQLite in linux. This was installed. Airio version is 2.4.5.
Running Airio and see this at console:
If Airio is running every minutes added
First time twice
Quit Airio with q key
Okram
Running Airio and see this at console:
Airio tracker [COLOR=red][B]v. 2.4.5 PROS[/B][/COLOR] by EQ Worry for My NAME
Opening connection : CONN OK
Airio connected to My SERVER - 0.5Z28 - S2
** Airio Logging **
Airio local logging is now turned on...
13:54:37 Received AIRW BL data : 825
13:54:44 Received LFSW WR data : 941
13:54:44 Renewed all LFSW WR data...
** Airio Version **
Airio tracker [B][COLOR=red]v. 2.4.5 FULL...[/COLOR][/B]
If Airio is running every minutes added
29
First time twice
29
29
Quit Airio with q key
** Quit Airio **
13:51:12 Leaving main loop...
13:51:12 Writing data...
13:51:12 Data written in : 0.01
13:51:12 #1 Airio tracker v. 2.4.5 disconnected from server...
13:51:12 #1 Closing connection...
13:51:12 #1 Stopping thread : Aegio - 192.168.0.1:29999 - TCP Sender
13:51:12 #1 Stopping thread : Aegio - 192.168.0.1:29999 - TCP Listener
Airio disconnected from My SERVER
13:51:14 #1 Disconnected from : My SERVER
Closing connection : DONE
13:51:15 #1 Closed connection...
13:51:15 AIRIO ERROR : sqlite3_next_stmt
at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods:sqlite3_next_stmt (intptr,intptr)
at System.Data.SQLite.SQLiteBase.ResetConnection (System.Data.SQLite.SQLiteConnectionHandle db) [0x00000]
at System.Data.SQLite.SQLiteBase.CloseConnection (System.Data.SQLite.SQLiteConnectionHandle db) [0x00000]
at System.Data.SQLite.SQLiteConnectionHandle.ReleaseHandle () [0x00000]
at System.Runtime.InteropServices.CriticalHandle.Dispose (Boolean disposing) [0x00000]
at System.Runtime.InteropServices.CriticalHandle.Dispose () [0x00000]
at System.Data.SQLite.SQLite3.Close () [0x00000]
at System.Data.SQLite.SQLiteConnection.Close () [0x00000]
at LiveForSpeed.InSim.Airio.Datas.DBClose () [0x00000]
at LiveForSpeed.InSim.Airio.Airio.Main () [0x00000]
ERROR : 10.06.29 10:51:15 - sqlite3_next_stmt
Okram
The FULL/PROS text is just display matter, but I corrected the output now... The number in console... Sorry! It was a debug info I forgot to remove from code. Also corrected now... The SQLite error on database close, hmmmm... I'm afraid I currently do not see the cause, but I improved error handling for this case, so that Airio closes properly.
All the updates are available in the same FREE/FULL files on airio.eu, just download again and update Airio.exe and Airio.pdb. Franky of 500servers will be installing Airio 2.4.5 soon.
Also, I added one more item to the SRV file that I forgot to mention in the changelog. It is supposed to restart race when leaving lobby screen after track change and thus achieve correct grid sorting, if custom sorting (e.g. by car type/speed) is used.
Replacing Airio.exe and Airio.pdb (downloaded airio.eu) and show version
Airio tracker v. 2.4.5 [B]FREE[/B] by EQ WorryThis not right?
Okram
Edit: Sorry, my mistake
(from e-mail must)It´s still there:
Just the line in Data.cs switched from 1001 to 977...
Wow, this one beats me. I can see where the error appears, but I do not know how it is possible. When you have a minute, could you please zip all the Airio config + stat files used and send them over? I'll need to take a closer look...
Ok, just a few minutes.
I´ve set "LogStats=true", "LogEvents=true" and "LogProcedures=true" for bughunting now...
I believe its something with new pb´s and the "driver IP address capturing"-thingie...
I´ve set "LogStats=true", "LogEvents=true" and "LogProcedures=true" for bughunting now...
I believe its something with new pb´s and the "driver IP address capturing"-thingie...
Hi Eq Worry,
one question.
I've setted my server that when race restart it reverse first 12 position on grid.
It works fine but ...
In my baby before race 1 i manual call driver and do the grid.
After i start race for a lag lap, just 3-4 corners and after i call restart.
Why when i call restart airio reverse the grid ?!?!?
one question.
I've setted my server that when race restart it reverse first 12 position on grid.
It works fine but ...
In my baby before race 1 i manual call driver and do the grid.
After i start race for a lag lap, just 3-4 corners and after i call restart.
Why when i call restart airio reverse the grid ?!?!?
Because it reverses grid depending on order of the grid before restarted
Great, so i can't use lag lap. DAMN.
Another questions. Why if a guys finish for example 15th ... sometime happens that he restart 21th and not 15th ?!?
From race 1 and race 2 people need to stay on track to do not loose his position ?
Another questions. Why if a guys finish for example 15th ... sometime happens that he restart 21th and not 15th ?!?
From race 1 and race 2 people need to stay on track to do not loose his position ?
U should just turn airio off for the test race.
I know, but i love automatism. 
Are you sure your GridPriCount= is set properly?
And yes, i do believe drivers need to be on grid in order to retain their positions...
Or, you could just use CustomGrid=false in Airio, and /start=reverse in LFS....
And yes, i do believe drivers need to be on grid in order to retain their positions...
Or, you could just use CustomGrid=false in Airio, and /start=reverse in LFS....
AIRIO - Advanced LFS Tracker
(2384 posts, started )
FGED GREDG RDFGDR GSFDG