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

[Roy El-Hames]

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
>>>>>
>>>>>         
>>>>>           
>>>>     
>>>>         
>>>   
>>>       
>>     
>
>