Just upgraded to webhelpdesk 12. The administrator account has locked and been deactiavted as the password was changed and I was not advised.
I put in a tech support request but have been advised the tech support dont support administering the postgresql DB but was told that I need to:
What you will want to do is open the database using a web console, then find the "dbo.Tech" table, and within that find the "CLIENT_TYPE" column. Here you will be able to find your users and the main admin account. Change the type to a 1 for admin, or 2 for tech.
Can anyone advise how I open a web console (i have found the PGAdmin3 program but am not sure of what the setting for it are.
Can one help?
Not sure what OS you're running, but try this:
WHD_INSTALL_DIR/pgsql/bin/psql -p20293 -Uwhd whd (execute the psql binary, telling it to use port 20293, user=whd, pass=whd).
Then follow these instructions: