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 ..
>
this is the block of error that comes up when trying to connect:
[Thu Oct 4 13:10:21 2007] [warning]: DBD::mysql::st execute failed: SELECT
command denied to user 'rt_user'@'rtdev01.company.com' for table 'Users' at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505,
line 3.
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 use
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
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 w
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
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 t
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
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 o
Most likely, RT can't talk to the database on the remote server. Have you
verified database rights on the remote server? Do you have Selinux enabled
on either server?
James Moseley
Mathew Snyder
Desk: x35221
Direct: 734-214-8221
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mathew
Snyder
Sent: Thursday, October 04, 2007 9:05 AM
To: Mathew Snyder
Cc: RT Users
Subject: Re: [rt-users] Moved Database, now cannot create sessions
I'm guessing
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 t
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
Mathew Snyder wrote:
> I'
I'm moving my devel database to a second server and separating it from the
server RT actually runs on. However, after doing so and updating the
RT_SiteConfig.pm I get the following:
error: RT couldn't store your session.
This may mean that that the directory '/usr/local/rt3/var/session_d
14 matches
Mail list logo