[rt-users] RT user login not possible after Ubuntu 11.04 uprade

[Ruslan Zakirov]

http://requesttracker.wikia.com/wiki/RecoverRootPassword


On Wed, Aug 21, 2013 at 4:31 PM, Alex Decalli <alexdecalli71 at gmail.com>wrote:

> Ok, found the problem but really didn't know how to fix, so have to reset
> password...
>
> UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';
>
> It is the password encryption method, it is changed.
> Any comments?
>
>
>
>
> On Wed, Aug 21, 2013 at 11:34 AM, Alex Decalli <alexdecalli71 at gmail.com>wrote:
>
>> I just found out that RT time is not sync. I got it from RT log file, it
>> is 2 hours late, I am not sure why, my server time is correct (by command
>> date) people say it might be because of mod_perl, can it be possibly the
>> reason I can't login to RT?
>>
>>
>> On Wed, Aug 21, 2013 at 9:39 AM, Alex Decalli <alexdecalli71 at gmail.com>wrote:
>>
>>> Hi all,
>>>
>>> Yesterday, I upgraded my very old uUbuntu server and with that, mysql
>>> and apache2 were updated too, configuration files are still the same. I had
>>> some problems with some file names and locations and Perl modules, I fixed
>>> them all, now I can see RT login page, but I can't login to that with my rt
>>> user (already exists in rtdb) alex001. even not with root. I checked things
>>> like rtuser can access mysql and still has all privileges, rtdb is
>>> readable to anyone, mysql log says nothing about this problem, apache log
>>> just says "login for alex001 failed" and I have no idea where else I can
>>> check or what might cause this problem. Please tell me if you can think of
>>> anything, I mean what does RT do for user login, what might have been
>>> changed, what permissions it will need and anything else you might think
>>> of...
>>>
>>> PS: I am not even sure rt is querying mysql, how can I make sure??
>>>
>>> Thank you all
>>> Alex
>>>
>>>
>>
>


-- 
Best regards, Ruslan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130912/8f5ac1de/attachment.htm>