Apps stracker 3.5.1

[Jempy]

When modifying a server ( and only if a change of session name is required in the used Stracker.ini ) I'm not using your order to stop and start server and Stracker.

- closing the server first
- modify the server config
- stop Stracker if changes needed
- modify the used Stracker.ini in this case if needed ( we have 8 ones )
- restart Stracker ( if it needed some modif )
- start the modified server.

Never had any problem that way.... ( although we have 8 servers with 3 different databases ).

NB for each server a saved preset to avoid any mistake in the port numbers for each server and Stracker instance.
Just a good organization is required ... a mistake may always happen when things need to be done in a hurry.

 

[Jempy]

Hi!!

Glad to been using this marvelous plugin for my server from three months. But yesterday I changed the track from the server configuration. And after a while I have noticed that the live map it wasn't showing properly.

Then I saw that my data base was all erased. No previous times, no previous sessions, nor admin groups. So I checked the log file. I saw this:

Is the first time I see something like this in the log file. But I don't know how to restore the bakcup. Can you help me? What can I do? I want all the info back.

{2018-07-03 14:36:53}: stracker[INFO ]: Using database './stracker.db3'
{2018-07-03 14:36:53}: stracker[STDOUT]: Performing database backup before migration. This might take a while. You'd better not interrupt this process.
{2018-07-03 14:36:53}: stracker[INFO ]: Backup file already exists, skipping.
{2018-07-03 14:36:53}: stracker[STDOUT]: Performing database migration from version 0 to 23. You'd better not interrupt this process.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 2 to 3.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 3 to 4.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 4 to 5.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 5 to 6.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 6 to 7.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 7 to 8.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 8 to 9.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 9 to 10.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 10 to 11.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 11 to 12.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 12 to 13.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 13 to 14.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 14 to 15.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 15 to 16.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 16 to 17.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 17 to 18.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 18 to 19.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 19 to 20.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 20 to 21.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 21 to 22.
{2018-07-03 14:36:53}: stracker[STDOUT]: Database migration done.


Is the first time I see something like this in the log file. But I don't know how to restore the bakcup. Can you help me? What can I do? I want all the info back.

Thanks a lot!

Normally, this message seems to mean you modified your Stracker version and the database needed to migrate.

In this case, you need to wait that the migration is finished before starting a server.

Anyway, although I never encountered such a problem of database files deleted, ...
In order to get all your info back ....
1) stop all servers and Stracker instances
2) If you have the backup of the good database with all infos, delete the new database with problems
3) simply copy ( not move, else in case of problem ... this backup should be lost ) your previous database backup ... replacing the one you just deleted.
4) If your Stracker version was changed, just launch first the main Stracker instance and let the migration be completely done
5) check your infos are still there
6) now you can start a new server

It should work easily .... I already changed a database for another one that way just for a temporary use .... and it worked perfectly and also afterwards when I replaced this database with the previous one.

 

[Neys]

Hi!!

Glad to been using this marvelous plugin for my server from three months. But yesterday I changed the track from the server configuration. And after a while I have noticed that the live map it wasn't showing properly.

Then I saw that my data base was all erased. No previous times, no previous sessions, nor admin groups. So I checked the log file. I saw this:

Is the first time I see something like this in the log file. But I don't know how to restore the bakcup. Can you help me? What can I do? I want all the info back.

{2018-07-03 14:36:53}: stracker[INFO ]: Using database './stracker.db3'
{2018-07-03 14:36:53}: stracker[STDOUT]: Performing database backup before migration. This might take a while. You'd better not interrupt this process.
{2018-07-03 14:36:53}: stracker[INFO ]: Backup file already exists, skipping.
{2018-07-03 14:36:53}: stracker[STDOUT]: Performing database migration from version 0 to 23. You'd better not interrupt this process.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 2 to 3.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 3 to 4.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 4 to 5.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 5 to 6.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 6 to 7.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 7 to 8.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 8 to 9.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 9 to 10.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 10 to 11.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 11 to 12.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 12 to 13.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 13 to 14.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 14 to 15.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 15 to 16.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 16 to 17.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 17 to 18.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 18 to 19.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 19 to 20.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 20 to 21.
{2018-07-03 14:36:53}: stracker[INFO ]: Migrated from db version 21 to 22.
{2018-07-03 14:36:53}: stracker[STDOUT]: Database migration done.


Is the first time I see something like this in the log file. But I don't know how to restore the bakcup. Can you help me? What can I do? I want all the info back.

Thanks a lot!

This looks like that stracker creates a new database from scratch. Maybe you changed the directory layout or something.

Restoring a backup from a .db3 file: stop all stracker instances accessing it, replace the stracker.db3 with the backup and start stracker.

 

[Aranel Ciryatan]

how do I use stracker for a remote server? I have Linux and windows server. I have AC server on my Linux server and Stracker on my windows server. But stracker does not see my linux server.

 

[linsoo]

Bug report:
When I used GUID as primary key.

guids_based_on_driver_names = False

Player's name will never been modified when they changed thier name in game.
So, if someone want to change the nick name, I must change the database directly.
It's not a elegance way.

 

[Neys]

how do I use stracker for a remote server? I have Linux and windows server. I have AC server on my Linux server and Stracker on my windows server. But stracker does not see my linux server.

AFAIK this is not supported. stracker and ac server should run on the same machine.

Bug report:
When I used GUID as primary key.

guids_based_on_driver_names = False

Player's name will never been modified when they changed thier name in game.
So, if someone want to change the nick name, I must change the database directly.
It's not a elegance way.

Are there any errors in the log when these players join?

 

[linsoo]

AFAIK this is not supported. stracker and ac server should run on the same machine.



Are there any errors in the log when these players join?

There is no errors in the log.

I tested by myself:
1, I use name linsoo to join the serever(database is empty), run 2 laps
2, I left the server and change my name to ledel and run 2 laps

I found the broadcast message in game is still linsoo not ledel, but the name in the list is already ledel.

logs below:

{2018-07-11 12:34:17}: stracker[DEBUG]: GUIDMapper: guid 76561198086077921 seems to be orig already.
{2018-07-11 12:34:17}: stracker[DEBUG]: send_server_data(None)
{2018-07-11 12:34:30}: stracker[DEBUG]: removing carId=0 from cars
{2018-07-11 12:34:30}: stracker[INFO ]: Broadcast message: Player linsoo left the server.
{2018-07-11 12:35:14}: stracker[DEBUG]: ignoring event, because isConnected is false: <class 'acplugins4python.ac_server_protocol.NewConnection'>(driverName=ledel, driverGuid=76561198086077921, carId=0, carModel=ktm_xbow_r, carSkin=01_blue_01, )
{2018-07-11 12:35:14}: stracker[DEBUG]: ignoring event, because isConnected is false: <class 'acplugins4python.ac_server_protocol.CarInfo'>(carId=0, isConnected=False, carModel=ktm_xbow_r, carSkin=01_blue_01, driverName=ledel, driverTeam=, driverGuid=76561198086077921, )
{2018-07-11 12:35:24}: stracker[DEBUG]: adding carId=0 to cars
{2018-07-11 12:35:24}: stracker[DEBUG]: UDP: new connection
{2018-07-11 12:35:24}: stracker[INFO ]: Broadcast message: Player linsoo entered the server .
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: guid in =76561198086077921
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: len(pt_guids)=0 d=<stracker_lib.ac_monitor.ACDriver object at 0x0391C570>
{2018-07-11 12:35:24}: stracker[DEBUG]: Enabled realtime events
{2018-07-11 12:35:24}: stracker[DEBUG]: enableRealtimeReport: using new interval 200
{2018-07-11 12:35:24}: stracker[DEBUG]: Recording pit position (-228.358642578125, -5.372579574584961, 59.82902908325195) for car id 0
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: guid in =76561198086077921
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: len(pt_guids)=0 d=<stracker_lib.ac_monitor.ACDriver object at 0x0391C570>
{2018-07-11 12:35:24}: stracker[DEBUG]: GUIDMapper: guid 76561198086077921 seems to be orig already.
{2018-07-11 12:35:24}: stracker[DEBUG]: sendChatMessageToPlayer 76561198086077921 Welcome to stracker 3.5.1
{2018-07-11 12:35:24}: stracker[DEBUG]: GUIDMapper: guid 76561198086077921 seems to be orig already.
{2018-07-11 12:35:24}: stracker[INFO ]: Chat message to 76561198086077921: Welcome to stracker 3.5.1
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: guid in =76561198086077921
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: len(pt_guids)=0 d=<stracker_lib.ac_monitor.ACDriver object at 0x0391C570>
{2018-07-11 12:35:24}: stracker[DEBUG]: GUIDMapper: guid 76561198086077921 seems to be orig already.
{2018-07-11 12:35:24}: stracker[DEBUG]: sendChatMessageToPlayer 76561198086077921 Your activities on this server are tracked. By driving on this server you give consent to store and process
{2018-07-11 12:35:24}: stracker[DEBUG]: GUIDMapper: guid 76561198086077921 seems to be orig already.
{2018-07-11 12:35:24}: stracker[INFO ]: Chat message to 76561198086077921: Your activities on this server are tracked. By driving on this server you give consent to store and process
{2018-07-11 12:35:24}: stracker[DEBUG]: smtp: guid in =76561198086077921

 

[mano82]

Hallo

Is it possible to connect to stracker database from an external website other than ... /lapstats page with php in order to integrate stracker info with the website and eventually do further queries and calculations on the data?
Thanks

 

[mspusr]

Hi.
I try to ban a user in my server .
When i click the button "Ban this driver", "Chage ban period", "Remove ban" I get de following error:

500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Traceback (most recent call last):
  File "site-packages/cherrypy/_cprequest.py", line 670, in respond
  File "site-packages/cherrypy/lib/encoding.py", line 220, in __call__
  File "site-packages/cherrypy/_cpdispatch.py", line 60, in __call__
  File "stracker/stracker_lib/http_server.py", line 116, in new_f
  File "stracker/stracker_lib/http_server.py", line 449, in ban
AttributeError: 'BanListHandler' object has no attribute 'regenerateBlacklist'

Could you help me?
Thank you

 

[nanodrummer]

Your webpage is offline. Temporary?

 

[Neys]

Hallo

Is it possible to connect to stracker database from an external website other than ... /lapstats page with php in order to integrate stracker info with the website and eventually do further queries and calculations on the data?
Thanks

You might want to use postgres databases, you can connect to them over network.

Hi.
I try to ban a user in my server .
When i click the button "Ban this driver", "Chage ban period", "Remove ban" I get de following error:

500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Traceback (most recent call last):
  File "site-packages/cherrypy/_cprequest.py", line 670, in respond
  File "site-packages/cherrypy/lib/encoding.py", line 220, in __call__
  File "site-packages/cherrypy/_cpdispatch.py", line 60, in __call__
  File "stracker/stracker_lib/http_server.py", line 116, in new_f
  File "stracker/stracker_lib/http_server.py", line 449, in ban
AttributeError: 'BanListHandler' object has no attribute 'regenerateBlacklist'

Could you help me?
Thank you

I noticed that as well. However, when I tried it, at least the unban command was successful (beneath the annoying error page).

Your webpage is offline. Temporary?

No this is permanent. The documentation html page is now inside the stracker.zip file.

 

[Janne Lehtinen]

Hello. We have issue with shutting down stracker v3.5.1 (Windows 2008 server).

Stracker is starting fine, I can see live status on server, sessions are fine etc. so all looking good.
But when I hit 'ctrl + c' for shutting down stracker, it just stays there and won't proceed.
It won't come to that Y/N question phase.
I can kill cmd.exe, conhost.exe and one stracker.exe for this instance, but one stracker.exe (one which is using more memory) cannot be killed without server reboot.

These are last lines in stracker.log:
stracker[INFO ]: Keyboard interrupt
stracker[INFO ]: Shutting down acmonitor.
stracker[INFO ]: Shutting down the server.
stracker[INFO ]: Shutting down http.
stracker[STDOUT]: Stopping http server; please wait - this might take some time

Any idea where is the problem?

 

[Neys]

Hello. We have issue with shutting down stracker v3.5.1 (Windows 2008 server).

Stracker is starting fine, I can see live status on server, sessions are fine etc. so all looking good.
But when I hit 'ctrl + c' for shutting down stracker, it just stays there and won't proceed.
It won't come to that Y/N question phase.
I can kill cmd.exe, conhost.exe and one stracker.exe for this instance, but one stracker.exe (one which is using more memory) cannot be killed without server reboot.

These are last lines in stracker.log:
stracker[INFO ]: Keyboard interrupt
stracker[INFO ]: Shutting down acmonitor.
stracker[INFO ]: Shutting down the server.
stracker[INFO ]: Shutting down http.
stracker[STDOUT]: Stopping http server; please wait - this might take some time

Any idea where is the problem?

No idea why you are not able to kill a process - if you have admin privileges, you should be able to kill any process. Usually hitting Ctrl-Break is terminating a console application more reliably than Ctrl-C (in case it is unresponsive or so).

Please contact your OS support for more details

Greetings
Neys

 

[Janne Lehtinen]

Actually this issue is only when stopping stracker and not in general closing programs running on dos-boxes with ctrl+c. I would say what ever stracker is doing to database before it can be shutted down (getting to that Y/N question phase), it gets badly stuck.

I also noticed that if I just play around with stracker without doing any laps or connections to AC server, stracker seems to shutdown fine. So in that point nothing has written to database and closing is OK. Then I make few laps on server and stracker gets stuck on shutdown.

 

[mano82]

You might want to use postgres databases, you can connect to them over network.

Thank you Neys, I managed to install the Postgresql database and connect Stracker. It works. I also managed to remotely connect to the database and it works as well.

However I have two questions:
1. how to decrpyt the sha256 encryption of the players GUID in players table? (i.e. what's the salt?)
2. when I migrated the server from sqlite3 to postgresql I lost my standard html visualization of Stracker (i.e.: xx.xx.xx.xx:xxxx/lapstats). Is it possible to keep the classic lapstats visualization with the postgreSQL database migration?

Thanks

 

[mspusr]

Hello.
We have running stracker in our server. Our racers have installed ptracker.
In the server we have this parameters:

[LAP_VALID_CHECKS]
; if true, collisions with other cars will invalidate laps
invalidateOnCarCollisions = False
; if true, collisions with environment objects will invalidate laps
invalidateOnEnvCollisions = False
; if -1: use server penalty setting, if available, otherwise use 2. All other values are passed to ptracker.
ptrackerAllowedTyresOut = -1

We are analyzing the stracker results and we have some doubts:
Attach you can see race results for a racer:

His best lap is not valid (lap number 5). We deduce that is due to he had an enviroment collision..
But his lap could be valid because we have configurated our server that not invalidate Enviroment collions ....

In the other hand, sometimes we can see laps that there not cuts and neither car and enviroment collions and the lap is not valid...

Could you tell us why sometimes lap is valid and others it's not valid?
We had read the documentation about "How is the valid flag for laps calculated?" but for us it's not clear... Are the coditions nested?. You initialize valid=2 (what means 2? it's a neutral value?)

Thank you

 

[Jempy]

Could you check which value you have in the server_cfg.ini for those results ?

ALLOWED_TYRES_OUT=?????

As you have this in Stracker.ini
; if -1: use server penalty setting, if available, otherwise use 2. All other values are passed to ptracker.
ptrackerAllowedTyresOut = -1

That's the server_cfg.ini settings which should make the difference between a valid and invalid lap.

 

[Neys]

Thank you Neys, I managed to install the Postgresql database and connect Stracker. It works. I also managed to remotely connect to the database and it works as well.

However I have two questions:
1. how to decrpyt the sha256 encryption of the players GUID in players table? (i.e. what's the salt?)

It is not possible to decrypt the encryption. This is the whole point of it all, otherwise I wouldn't have spent this time.

2. when I migrated the server from sqlite3 to postgresql I lost my standard html visualization of Stracker (i.e.: xx.xx.xx.xx:xxxx/lapstats). Is it possible to keep the classic lapstats visualization with the postgreSQL database migration?

Thanks

If this does not work, it is a configuration issue on your side. Check for warnings and errors in the log file.

 

[mano82]

It is not possible to decrypt the encryption. This is the whole point of it all, otherwise I wouldn't have spent this time.

ok I understand. Indeed I read that the sha256 is undecryptable. So, let's see it from another point of view. On my server will have access only people subscribed to my website, who must include their GUID in the registration form of the website (so that is something I already know). I must be able to check the pilot's GUID on my users database table against the one on the stracker database in order to recover their statistica and so on...

I imagined to do that by doing the sha256 encryption of the Guid myself while inserting it in my players database and to compare it to the stracker database but without knowing the salt it is impossibile ti have the same result.
Is there a way I can know or modify the originale salt (as admin of the website and responsable of privacy information)?

 

[mano82]

If this does not work, it is a configuration issue on your side. Check for warnings and errors in the log file.

Thank you. Solved. It was a .ini problem indeed.