How to Reset the Admin password (PostgreSQL Backend)
If you don't know what back end DB you are running, see here first:
for SQL backend see here:
Search for PGAdmin and run
Select PPAdminIII and run
Click on “postgreSQL Database….” And enter “amber” for the password (withoutquotes).
Expand till you see tables
Find x1_useraccount table and select “view top 100 rows”
Find the x_login account and click once in the x_password and change it to1B2M2Y8AsgTpgAmY7PhCfg==
Restart passagepoint server service. Admin password is now reset to blank.
***NOTE***
This is for the PostgreSQL Backend.
If you are using MS SQL server, use this document instead:
Search for PGAdmin and run
Select PPAdminIII and run
Click on “postgreSQL Database….” And enter “amber” for the password (without
quotes).
Expand till you see tables
Find x1_useraccount table and select “view top 100 rows”
Find the x_login account and click once in the x_password and change it to
1B2M2Y8AsgTpgAmY7PhCfg==
Restart passagepoint server service. Admin password is now reset to blank.
***NOTE***
This is for the PostgreSQL Backend.
If you are using MS SQL server, use this document instead:
Related Articles
Reset passagepoint Admin password with SQL server Backend
If you don't know what back end DB you are running, see here first: https://support.stopware.com/portal/en/kb/articles/what-backend-database-am-i-running If PassagePoint is running Postgresql, see this: ...How to connect to Microsoft SQL database and encyrpt user password
Note: For windows authentication see KB article https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...Use MSSQL database instead of PostgreSQL
If you want to use SQL, after PassagePoint has been installed >> go to \PPGlobal\config delete the first 'sqlcontext.xml' file. Then rename the 'sqlcontext.xml.mssql' to 'sqlcontext.xml' Here - edit the new updated 'sqlcontext.xml' You will need to ...What Backend Database am I running
if you don't know what backend DB, check the sqlContext.xml file on the server C:\PPGlobal\Config\sqlcontext.xml The example below is going out to MS SQL server as the red circle indicates The example below is for postgresqlWhat should I do if I get a "The Administrator needs to assign the station using the "Control Center" " error when launching PassagePoint?
On the client On the Client workstation that is getting the message "The Administrator needs to assign the station using the "Control Center 1) Log in with a user with 'admin' privileges 2) Go to home>> station preferences>> hit edit>> change ...