Hi all

Apologies if this is a thread that's been posted here before but I have searched first and can't find anything

So here's my problem

I recently added osticket to one of my domains but have mislaid my admin login details for the backend of the support ticket system (mydomain.com/support/scp) and unlike most sites, there doesn't seem to be any way to recover usernames and/or passwords

Help!!!

Thanks in advance

if you´re the Administrator you can run this SQL directly on the database.

UPDATE `ost_staff` SET `passwd` = MD5( 'password' ) WHERE `staff_id`='1';

This has actually been covered multiple times (I'm being polite, it's a lot more than multiple times) here on the forums. You are correct that there is no way to "recover" your password. With that being said equisde's answer will allow you to reset your password to something that you do know. It requires some form of access directly to the database though. (such as phpmyadmin, Mysql WorkBench, MySQLAdmin, mysql cli, or some other third party application that does similar such as Navicat). If for some reason you do not have admin or root access to your database you should be able to look at your ost-config and get and use the username and password from that to run the MySQL query he suggests.

Please let us know if this resolves this for you.

reset password

this mod by masino works if this happens to you in the future.

Still need to get in add add those fields.

http://osticket.com/forums/showthread.php?t=2890&highlight=reset+password(http://osticket.com/forums/showthread.php?t=2890&highlight=reset+password)

http://www.openscriptsolution.com/2009/10/12/add-forgot-password-feature-for-helpdesk-officer-into-osticket-v1-6-rc5(http://www.openscriptsolution.com/2009/10/12/add-forgot-password-feature-for-helpdesk-officer-into-osticket-v1-6-rc5)

I have it setup on my 1.6ST build

Thank you for your replies

Thank you to all the contributors t hat have been kind enough to reply

Unfortunately, I'm not technical and have no knowledge at all of SQL

Therefore, although I'm extremely grateful, these replies don't really help

I was hoping for a very simple solution but that's obviously not the case

Thanks anyway

Keith,

If you´re the Admin or the person who implemented the system, you should know the database engine which your osTicket system is running on. As ntozier told, it could be phpMyAdmin, Mysql WorkBench, MySQLAdmin..etc and can be accessed via web browser (e.g: http://yourdomain.com/phpmyadmin(http://yourdomain.com/phpmyadmin))

The credentials for this access should be at your server which is hosting the website. Take a look at osTicket folder>ost-config.php

Once you´re logged on the database engine, you should be able to execute SQL statements.

But.. doh! I should not being explaining this. Are you really the person who implemented the system?

Write a Reply...