[rt-users] Moved Database, now cannot create sessions

[Mathew Snyder]

I have no idea what happened but I pointed the RT host to the new database
server again and restarted httpd again.  This time it seems to have worked.

I wish I knew what I did that fixed it.

Keep up with me and what I'm up to: http://theillien.blogspot.com


Roy El-Hames wrote:
> Ah ok sorry ..
> When you logged in via sql from another host did you login as the rt
> user and the rt password??
> Have you got logging enabled on your sql server and debug level logging
> on RT? what is in the log files??
> Roy
> 
> Mathew Snyder wrote:
>> Let me clarify.  I ran that query and added the user.  However, this
>> did not
>> make RT work.  The query itself did, though.
>>
>> Keep up with me and what I'm up to: http://theillien.blogspot.com
>>
>>
>> Roy El-Hames wrote:
>>  
>>> Well thats your answer Mathew, unless you grant the permissions RT is
>>> not going to work for you..
>>> What errors are you getting when you granting permissions??
>>>
>>> Roy
>>>
>>>
>>> Mathew Snyder wrote:
>>>    
>>>> I ran
>>>> GRANT ALL ON rt_database.* to 'rt_user'@'rt_server' IDENTIFIED BY
>>>> 'rt_password'
>>>> when I first migrated it.  It didn't work.  I then actually went
>>>> through the
>>>> process of installing RT on the database server in order to utilize
>>>> `make
>>>> initialize-database`.  This didn't work either.
>>>>
>>>> Keep up with me and what I'm up to: http://theillien.blogspot.com
>>>>
>>>>
>>>> Roy El-Hames wrote:
>>>>  
>>>>      
>>>>> Matthew;
>>>>> It sounds to me you forgot to :
>>>>>
>>>>> GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON
>>>>> ${RT::DatabaseName}.*
>>>>> TO ${RT::DatabaseUser}\@'${RT::DatabaseRTHost}' IDENTIFIED BY
>>>>> '${RT::DatabasePassword}'
>>>>> ;");
>>>>>
>>>>> Roy
>>>>>
>>>>>
>>>>> Mathew Snyder wrote:
>>>>>           
>>>>>> I figured out that I need to use the session file instead of the
>>>>>> database.  I
>>>>>> linked the error together with what I found in RT_SiteConfig.pm.
>>>>>>
>>>>>> Now I can get the login screen but can't login.  I'm guessing that
>>>>>> the
>>>>>> remote
>>>>>> database isn't being located/connected to.
>>>>>>
>>>>>> Keep up with me and what I'm up to: http://theillien.blogspot.com
>>>>>>
>>>>>>
>>>>>> Mathew Snyder wrote:
>>>>>>  
>>>>>>               
>>>>>>> I'm guessing the problem here is that MySQL is trying to write the
>>>>>>> session data
>>>>>>> to this directory.  However, with the database now on another server
>>>>>>> it clearly
>>>>>>> doesn't have access to it.  Is this correct?
>>>>>>>
>>>>>>> Keep up with me and what I'm up to: http://theillien.blogspot.com
>>>>>>>
>>>>>>>
>>>>>>>                         
>>>>>> _______________________________________________
>>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>>
>>>>>> Community help: http://wiki.bestpractical.com
>>>>>> Commercial support: sales at bestpractical.com
>>>>>>
>>>>>>
>>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>>>>>> Buy a copy at http://rtbook.bestpractical.com
>>>>>>
>>>>>>                   
>>>>>             
>>>>         
>>>     
>>
>>   
> 
>