View Full Version : Admin Login
pbaker
06-16-2009, 06:37 AM
i have managed to install OSTicket fine. But i have got to the admin login screen and it wont reconize my username or password.
What table is it in Mysql that stores the usernames and passwords as i have tried the ost_staff table and it doesnt like the username or password in there and says autorization failure.
This is running on Ubuntu Server.
Corey
06-25-2009, 07:01 AM
i have managed to install OSTicket fine. But i have got to the admin login screen and it wont reconize my username or password.
What table is it in Mysql that stores the usernames and passwords as i have tried the ost_staff table and it doesnt like the username or password in there and says autorization failure.
This is running on Ubuntu Server.
Hey,
The table is ost_staff.
What version of MySQL do you have osTicket installed on?
What version of PHP do you have osTicket installed on?
What version of osTicket do you have installed?
pickupcash
07-05-2009, 04:07 PM
I'm having the same problem. I just did a fresh install of 1.6 RC5. When I try to login to the admin area it keeps giving me an Invalid Login error. I know the username and password is correct. I even deleted everything, including the database, recreated the db and went through the installation again. Every time I try to login and get that error it also sends an email to me with this in it...
Subject: DB Error #1143
[SELECT * FROM ost_staff LEFT JOIN ost_groups USING(group_id) WHERE username='' ]
SELECT command denied to user 'mlextrem_helpme'@'localhost' for column 'group_id' in table 'ost_staff'
This is running on a Linux server with PHP v5.2.9, MySQL v5.0.81
I have another website running 1.6 RC4 and never had any problems installing it or using it.
Clay M.