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: [EMAIL PROTECTED] >>>>>> >>>>>> >>>>>> 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: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
