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: [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 >> > _______________________________________________ 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
