[rt-users] confused newbie is back

[Jaime Diaz]

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 at hotmail.com]
Sent: Jueves, 13 de Noviembre de 2003 01:59 p.m.
To: rt-users at 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 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($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

_______________________________________________
rt-users mailing list
rt-users at 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