Ask not what osTicket community can do for you - ask what you can do for osTicket community

Go Back   osTicket Forums > osTicket 1.6 (Latest Release) > General Discussions

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 03-27-2008, 05:31 PM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default Upgrade to RC4

I did the upgrade but now I cannot log in, how do I fix this, any ideas? Thanks.

AskJuba
Reply With Quote
  #2  
Old 03-27-2008, 05:33 PM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default

Sorry I cannot login to the admin, thanks.

AskJuba
Reply With Quote
  #3  
Old 03-27-2008, 05:58 PM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default

Did this:

Admin Password

and it still no go, any idea? Thanks.

Julius
Reply With Quote
  #4  
Old 03-28-2008, 01:46 AM
Corey Corey is offline
Senior Member
 
Join Date: Jan 2008
Location: St.Louis, Missouri USA
Posts: 393
Send a message via AIM to Corey Send a message via MSN to Corey Send a message via Yahoo to Corey Send a message via Skype™ to Corey
Default

Can you tell us some server stats? Operating system, MySQL version, PHP version... etc

Last edited by Corey; 03-28-2008 at 01:49 AM.
Reply With Quote
  #5  
Old 03-28-2008, 09:11 AM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default

Would this be what you need:

Apache/1.3.39 (Unix)
PHP/5.2.3
MySQL version 4.1.22-standard

Thanks.

Julius
Reply With Quote
  #6  
Old 03-28-2008, 09:35 AM
Corey Corey is offline
Senior Member
 
Join Date: Jan 2008
Location: St.Louis, Missouri USA
Posts: 393
Send a message via AIM to Corey Send a message via MSN to Corey Send a message via Yahoo to Corey Send a message via Skype™ to Corey
Default

Quote:
Originally Posted by askjuba View Post
Would this be what you need:

Apache/1.3.39 (Unix)
PHP/5.2.3
MySQL version 4.1.22-standard

Thanks.

Julius
Are you positive you tried this?

Run this SQL query:
Quote:
UPDATE `ost_staff` SET `passwd` = '21232f297a57a5a743894a0e4a801fc3' WHERE `ost_staff`.`staff_id` =1 LIMIT 1 ;
This sets the password to 'admin'.

So when you login, use the first account you made and login with the password admin.

If that doesn't work try this:
Quote:
UPDATE `ost_staff` SET `passwd` = '21232f297a57a5a743894a0e4a801fc3' WHERE `username` = 'admin' LIMIT 1 ;
Again, you would login with the following information:
Username: admin
Password: admin

Once you are able to login, I suggest to change your password to something else.

If you don't mind, what's your site?
Reply With Quote
  #7  
Old 03-28-2008, 09:57 AM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default

Did that and uploaded again the upgrade and nothing, still the same problem, any ideas? Thanks.

AskJuba
Reply With Quote
  #8  
Old 03-31-2008, 01:11 PM
askjuba askjuba is offline
Junior Member
 
Join Date: Jan 2008
Posts: 11
Default

Had to install the complete package to fix the problem but almost overwrite the ostconfig.php have to be carefull with this, thanks Corey for all the help, take care,

Julius
Reply With Quote
  #9  
Old 05-02-2008, 04:53 PM
Sleepy Cat Hosting Sleepy Cat Hosting is offline
Junior Member
 
Join Date: Apr 2008
Location: Henderson, NV
Posts: 6
Default

How do you run this query from the command line. I have been trying to get this figured out for days.

Same goes for this query: UPDATE ost_config SET ostversion = '1.6 RC4',updated=NOW() WHERE id =1 LIMIT 1;



Quote:
Originally Posted by Corey View Post
Are you positive you tried this?

Run this SQL query:

This sets the password to 'admin'.

So when you login, use the first account you made and login with the password admin.

If that doesn't work try this:


Again, you would login with the following information:
Username: admin
Password: admin

Once you are able to login, I suggest to change your password to something else.

If you don't mind, what's your site?
Reply With Quote
  #10  
Old 05-05-2008, 03:26 AM
4ice 4ice is offline
Senior Member
 
Join Date: Jan 2008
Posts: 531
Default

If you have access to phpMyAdmin it's very easy. Here you will find a tab called SQL and you can run both queries there.
__________________
Ask not what osTicket community can do for you - ask what you can do for osTicket community
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:38 AM.