[rt-users] confused newbie is back

[nemir nemiria]

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 at 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 at 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 at 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 at hotmail.com');
Set($MaxAttachmentSize , 10000000);
Set($CorrespondAddress , 'issues at bleh.com.au');
Set($CommentAddress , 'issues at 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.  :-)


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