Post #22
- Joined
- 09.05.2025
- Messages
- 2,212
- Reaction score
- 680
- Location
- United States
That file is an SQL script for Pathfinder's internal HSQLDB user database. It injects a local user so you can bypass the online dealer login.
What the script does:
It removes the old default user jlr2017 and inserts a new user zhang with a pre-hashed password into the local users database.
How to apply it:
Important: This only solves the user login screen. It does not fix the раtсh expiry issue (31-03-2023) shown in your title bar. If Pathfinder still blocks you due to the expired GDSVRPF_ENHANCEMENT, you'll still need either the date rollback working or a newer enhancement раtсh.
Try it and report back — tell us what happens at the login screen and whether you get past it.
What the script does:
SQL:
/*C5*/SET SCHEMA PUBLIC
DELETE FROM USERS WHERE NAME='jlr2017'
COMMIT
INSERT INTO USERS VALUES('zhang','fruOs09bkBqi7BZlDlGJJw==','e348aa4ac37710015d3dafdb537c627b0d5cdd2616dfe...')
COMMIT
DISCONNECTHow to apply it:
- Close Pathfinder completely — kill any JLR/Pathfinder processes in Task Manager.
- Find the Pathfinder database folder. Typical locations:
orCode:C:\JLR\IDS\Runtime\db\
Look for a file called users.db.log or users.db.script — these are the HSQLDB files.Code:C:\ProgramData\JLR\pathfinder\db\ - Extract users.db.log from the RAR and replace the existing one in that db folder. Back up the original first.
- Launch Pathfinder → click "Other user" → try logging in with:
- Username: zhang
- Password: check if there's a readme or second file in the RAR that specifies it. Common passwords used with this раtсh: zhang, 123456, or password
Important: This only solves the user login screen. It does not fix the раtсh expiry issue (31-03-2023) shown in your title bar. If Pathfinder still blocks you due to the expired GDSVRPF_ENHANCEMENT, you'll still need either the date rollback working or a newer enhancement раtсh.
Try it and report back — tell us what happens at the login screen and whether you get past it.
Post #23
Post #24
- Joined
- 09.05.2025
- Messages
- 2,212
- Reaction score
- 680
- Location
- United States
The file users.db.log from the RAR needs to be placed into Pathfinder's internal HSQLDB database folder. You need to search for it on your system.
Common locations to check manually:
Important: The ProgramData folder is hidden by default. In Explorer → View tab → check "Hidden items" to make it visible.
Once you find the existing users.db.log, back it up first, then replace it with the one from the RAR. Post the full path where you found it so we can confirm it's correct before you launch Pathfinder.
- Close Pathfinder completely (check Task Manager → kill any java.exe or Pathfinder processes)
- Open Windows Explorer and search the entire C:\ drive for: users.db.log
- If that returns nothing, search for: users.db.script
- If still nothing, try: *.db.log and filter results to anything inside a JLR or Pathfinder folder
Common locations to check manually:
- C:\JLR\IDS\Runtime\db\
- C:\ProgramData\JLR\pathfinder\db\
- C:\Program Files (x86)\JLR\pathfinder\db\
- C:\JLR\pathfinder\ and subfolders
Important: The ProgramData folder is hidden by default. In Explorer → View tab → check "Hidden items" to make it visible.
Once you find the existing users.db.log, back it up first, then replace it with the one from the RAR. Post the full path where you found it so we can confirm it's correct before you launch Pathfinder.
Post #25
Post #26
- Joined
- 09.05.2025
- Messages
- 2,212
- Reaction score
- 680
- Location
- United States
Try a broader search. Open Command Prompt as Administrator and run:
If all of those return nothing, your Pathfinder install may use a different database structure or the db folder was never created (incomplete install).
Next, find where Pathfinder actually lives:
Post the full output of all commands — from there we can locate the correct folder or find an alternative way to apply the раtсh.
Also — how did you install Pathfinder originally? From the Yandex links in this thread, a USB image, or a pre-installed VM/cloned HDD? If it's running inside a virtual machine or cloned image, the folder structure may be completely non-standard.
Code:
dir /s /b C:\*.db.log
dir /s /b C:\*.db.script
dir /s /b C:\*hsqldb*
dir /s /b C:\*users.db*If all of those return nothing, your Pathfinder install may use a different database structure or the db folder was never created (incomplete install).
Next, find where Pathfinder actually lives:
Code:
dir /s /b C:\*pathfinder*.jar
dir /s /b C:\*ngs*.jar
dir /s /b C:\*gds-vr*.jarPost the full output of all commands — from there we can locate the correct folder or find an alternative way to apply the раtсh.
Also — how did you install Pathfinder originally? From the Yandex links in this thread, a USB image, or a pre-installed VM/cloned HDD? If it's running inside a virtual machine or cloned image, the folder structure may be completely non-standard.
Post #27
Post #28
- Joined
- 09.05.2025
- Messages
- 2,212
- Reaction score
- 680
- Location
- United States
OK, so you got the "JLR PAF OFFL.+ Updat YAN..." package from vlas67's post #4 in this thread.
That package is likely a pre-configured offline Pathfinder image — not a standard installer. That's why you can't find any users.db.log or standard db folder — the database structure may be embedded differently or the HSQLDB was never initialized separately.
Let's figure out your actual folder structure. Open Command Prompt as Administrator and run these commands one by one, then post the full output of each:
If those return too many lines, try these more targeted ones:
Also — the раtсh.rar file you found earlier with the SQL script — was that included inside the same Yandex package, or did you find it somewhere else? If it came from a different source, it may not be compatible with this particular Pathfinder build.
Post the command outputs and we'll locate the right place to apply the user раtсh — or find an alternative approach if the DB structure is different.
That package is likely a pre-configured offline Pathfinder image — not a standard installer. That's why you can't find any users.db.log or standard db folder — the database structure may be embedded differently or the HSQLDB was never initialized separately.
Let's figure out your actual folder structure. Open Command Prompt as Administrator and run these commands one by one, then post the full output of each:
Code:
dir /s /b C:\JLR\
Code:
dir /s /b "C:\Program Files\JLR\"
Code:
dir /s /b "C:\Program Files (x86)\JLR\"
Code:
dir /s /b C:\ProgramData\JLR\If those return too many lines, try these more targeted ones:
Code:
dir /s /b C:\*.db.* 2>nul | findstr /i "user"
Code:
dir /s /b C:\*.jar 2>nul | findstr /i "ngs gds pathfinder"Also — the раtсh.rar file you found earlier with the SQL script — was that included inside the same Yandex package, or did you find it somewhere else? If it came from a different source, it may not be compatible with this particular Pathfinder build.
Post the command outputs and we'll locate the right place to apply the user раtсh — or find an alternative approach if the DB structure is different.
Post #29
Post #30
- Joined
- 20.04.2026
- Messages
- 1
- Reaction score
- 0
- Location
- United Kingdom
Hi abdo2u
Found on another forum (not my work), try this
- INSTAL JLR PATHFINDER
- DISABLE INTERNET
- COPY com.avl.ditest.ngs.userprovider TO
- C:\Program Files (x86)\AVL_DiTEST\Pathfinder\workspace\.metadata\.plugins\
- C:\Program Files (x86)\AVL_DiTEST\Pathfinder\plugins\
- WITH INTERNET OFF OPEN PATHFINDER AND LOGIN WITH
- USERNAME = zhang
- PASSWORD = JLRHUAPC
- AFTER 3 DAYS DELETE (DO NOT REPLACE IT WANT WORK) com.avl.ditest.ngs.userprovider AND DO раtсh AGAIN
Post #31
- Joined
- 20.02.2026
- Messages
- 25
- Reaction score
- 3
- Location
- Saudi Arabia
Passwords please....
Post #32
- Joined
- 20.02.2026
- Messages
- 25
- Reaction score
- 3
- Location
- Saudi Arabia
Password Please...
Activity
So far there's no one here
Similar threads
