Confused newbie is back

If you recall in our last installent I was asking for some background info
on installing onto a RH9 platform. I got enough to bolster my confidence
so I soldiered through.

I am a complete newbie with both Perl and with CPAN. I am a complete
newbie with mysql (or postgresql for that matter). I am moderately
experienced with apache. (well once I was very up on it, but that was
several lifetimes ago. A bit rusty. And I decided to go with the default
RH installed apps to see if I could make them work, so this is my first
look at 2.0)

I seem to have done alright thus far. I got it downloaded and compiled.
came up with a bit of an issue trying to get the dependencies installed and
got past that. Set up my apache config okay. Made note to edit the
Makefile file before I ran make install, to set the rt_user account name
(simply ‘rt’ in my case) and the password for this account. Ran make
install. did httpd -t to double check the config (the error about the
docroot not existing had gone away as expected). did a reboot of the box,
just to make sure everything started up okay, and it all looked green and
started.

I tried to connect to my webserver. I get me an error. A 500 error
(internal misconfiguration) Usually means that the apache was trying to do
something that it couldn’t figure out how to do. Anyone who tries to tell
you that computers are smart doesn’t know beans about computers. This
apache of mine is trying to do stuff that jsut makes no sense to me. I
looked in the apache error log (/etc/httpd/logs/error_log) and found the
following set of errors relating to my hit on it.

[Fri Nov 14 23:45:42 2003] [error] [client 172.30.35.70] Connect Failed
Access denied for user: ‘rt@localhost’ (Using password: YES)! at
/usr/local/rt/lib/RT.pm line 149!
DBI connect(‘dbname=rt3;host=localhost’,‘rt’,…) failed: Access denied for
user: ‘rt@localhost’ (Using password: YES) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Fri Nov 14 23:45:42 2003] [error] [client 172.30.35.70] Connect Failed
Access denied for user: ‘rt@localhost’ (Using password: YES)! at
/usr/local/rt/lib/RT.pm line 149!

I do a check on the lists, the first post I came up with asks me to edit
the Makefile before I run make install, Well it is a bit late for that now,
but fortunately I did. Did my changing the name of the account make a
difference? Is there some more I have to do with mysql than setting up a
root account with a password?

I did change the RT_SiteConfig.pm file to reflect these values. in fact my
file now looks a lot like this:

2;
Set($rtname , “bleh.com.au”);
Set($Organization , “bleh.com.au”);
Set($DatabaseUser , ‘rt’);
Set($DatabasePassword , ‘bleh’);
Set($OwnerEmail , ‘nemir@hotmail.com’);
Set($MaxAttachmentSize , 10000000);
Set($CorrespondAddress , ‘issues@bleh.com.au’);
Set($CommentAddress , ‘issues@bleh.com.au’);
Set($WebBaseURL , “http://issues.blehl.com.au”);

Note that I found that number at the top and I assumed that I should
increment it, so I did. It started out as a 1;

It would be great to get past this and into the bit that means I get to
trial the thing. :slight_smile:

I am expecting that there is something in mysql that I need to do yet, but
that I haven’t seen documented anywhere, but I have been known to be very
wrong about these things.

I did run a command earlier that went something like:

mysqladmin -u nemir password ‘bleh’

to create an account for me. Should I have created an account called root
there? Is there a database created by default? what do I need to do to
create one if not…?

One other question that is more about site architecture… I am wanting to
create two very separate job types here, one for the development team to
track application bugs and enhancement requests, one for the support team
to track maintenance jobs. There is no real overlap there. Should I
create two separate Dbs for this, or just one? Is it easy to configure RT
to look at two separate DBs?

Thanks!

nemir

Hot chart ringtones and polyphonics. Go to
http://ninemsn.com.au/mobilemania/default.asp

Once you install MySQL you have the root account with no password (that you
should change, by the way).

It is possible to use the root account for RT (changing RT_Siteconfig.pm
accordingly), but I wouldn’t recommend so. Your apache log shows that there
is a problem with the user you are using to connect to the RT’s database.
If you’re newbie to MySQL, I think it will be better for you if you use
something like phpMyAdmin to administrate.

You have created the RT’s database if you executed the “make
initialize-database” during the installation. To check this out, you could
change this parameters:

Set($DatabaseUser , ‘rt’);
Set($DatabasePassword , ‘bleh’);

to “root” and leave the password field blank (you probably haven’t changed
it). If it works, then create a new user in mysql and use that instead of
the root account (remember to restart Apache so changes take effect).

Hope it helps you.
J.-----Original Message-----
From: nemir nemiria [mailto:nemir@hotmail.com]
Sent: Jueves, 13 de Noviembre de 2003 01:59 p.m.
To: rt-users@lists.fsck.com
Subject: [rt-users] confused newbie is back

If you recall in our last installent I was asking for some background info
on installing onto a RH9 platform. I got enough to bolster my confidence
so I soldiered through.

I am a complete newbie with both Perl and with CPAN. I am a complete
newbie with mysql (or postgresql for that matter). I am moderately
experienced with apache. (well once I was very up on it, but that was
several lifetimes ago. A bit rusty. And I decided to go with the default
RH installed apps to see if I could make them work, so this is my first
look at 2.0)

I seem to have done alright thus far. I got it downloaded and compiled.
came up with a bit of an issue trying to get the dependencies installed and
got past that. Set up my apache config okay. Made note to edit the
Makefile file before I ran make install, to set the rt_user account name
(simply ‘rt’ in my case) and the password for this account. Ran make
install. did httpd -t to double check the config (the error about the
docroot not existing had gone away as expected). did a reboot of the box,
just to make sure everything started up okay, and it all looked green and
started.

I tried to connect to my webserver. I get me an error. A 500 error
(internal misconfiguration) Usually means that the apache was trying to do
something that it couldn’t figure out how to do. Anyone who tries to tell
you that computers are smart doesn’t know beans about computers. This
apache of mine is trying to do stuff that jsut makes no sense to me. I
looked in the apache error log (/etc/httpd/logs/error_log) and found the
following set of errors relating to my hit on it.

[Fri Nov 14 23:45:42 2003] [error] [client 172.30.35.70] Connect Failed
Access denied for user: ‘rt@localhost’ (Using password: YES)! at
/usr/local/rt/lib/RT.pm line 149!
DBI connect(‘dbname=rt3;host=localhost’,‘rt’,…) failed: Access denied for
user: ‘rt@localhost’ (Using password: YES) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 132
[Fri Nov 14 23:45:42 2003] [error] [client 172.30.35.70] Connect Failed
Access denied for user: ‘rt@localhost’ (Using password: YES)! at
/usr/local/rt/lib/RT.pm line 149!

I do a check on the lists, the first post I came up with asks me to edit
the Makefile before I run make install, Well it is a bit late for that now,

but fortunately I did. Did my changing the name of the account make a
difference? Is there some more I have to do with mysql than setting up a
root account with a password?

I did change the RT_SiteConfig.pm file to reflect these values. in fact my
file now looks a lot like this:

2;
Set($rtname , “bleh.com.au”);
Set($Organization , “bleh.com.au”);
Set($OwnerEmail , ‘nemir@hotmail.com’);
Set($MaxAttachmentSize , 10000000);
Set($CorrespondAddress , ‘issues@bleh.com.au’);
Set($CommentAddress , ‘issues@bleh.com.au’);
Set($WebBaseURL , “http://issues.blehl.com.au”);

Note that I found that number at the top and I assumed that I should
increment it, so I did. It started out as a 1;

It would be great to get past this and into the bit that means I get to
trial the thing. :slight_smile:

I am expecting that there is something in mysql that I need to do yet, but
that I haven’t seen documented anywhere, but I have been known to be very
wrong about these things.

I did run a command earlier that went something like:

mysqladmin -u nemir password ‘bleh’

to create an account for me. Should I have created an account called root

there? Is there a database created by default? what do I need to do to
create one if not…?

One other question that is more about site architecture… I am wanting to
create two very separate job types here, one for the development team to
track application bugs and enhancement requests, one for the support team
to track maintenance jobs. There is no real overlap there. Should I
create two separate Dbs for this, or just one? Is it easy to configure RT
to look at two separate DBs?

Thanks!

nemir

Hot chart ringtones and polyphonics. Go to
http://ninemsn.com.au/mobilemania/default.asp

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm