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

[Mathew Snyder]

No need.  When installing MySQL via rpm or when installing Red Hat this is
automatically taken care of.  But to be sure, I connected to it using the mysql
shell from another host.

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


Drew Barnes wrote:
> Have you poked a hole for tcp 3306 in the firewall on your new db server?
> 
> 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
>>>>
>>>>   
>>>>       
>>>     
>> _______________________________________________
>> 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
>>   
>