[rt-users] make initialize-database error

[Tavernier, Clayton]

The 'make dropdb' just removes the rt3 database so you can try again.  I've
been dropping the database via Webmin anyway.  But when I look, there is no
'rt_user' to remove.  I made the 'rt' group, should I be making an 'rt_user'
too?
 

Clayton Tavernier 
IS Consultant 
Kennerly-Spratling, Inc. 
(510) 667-3795 

-----Original Message-----
From: Greg.Hering at bench.com [mailto:Greg.Hering at bench.com]
Sent: Tuesday, May 13, 2003 8:54 AM
To: CTavernier at ksplastic.com; rt-users at lists.fsck.com
Subject: RE: [rt-users] make initialize-database error



I think you are supposed to 'make dropdb' and try it again.

If you already created the rt3 user and reset the password you may have RT
and MySQL out of sync.

 

Greg

 

 

Gregory L. Hering

(256) 722-6420

4807 Bradford Dr

Benchmark Electronics, Inc.

Hunvtsville, Al 35805

 

-----Original Message-----
From: Tavernier, Clayton [mailto:CTavernier at ksplastic.com] 
Sent: Friday, May 09, 2003 4:44 PM
To: RT Users (E-mail)
Subject: [rt-users] make initialize-database error

 

I'm trying to install RT3 on an RH8 box using mysql and fastcgi.  I've
gotten through most of the process but I get the below error message when I
try 'make initialize-database'.  I've reset the password in RT_SiteConfig.pm
and I've tried to set the password for rt-user in mysql via Webmin.  What am
I missing or doing wrong?

Clayton 

[root at ksirh217 rt-3-0-1]# make initialize-database 
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
--prompt-for-dba-password 
In order to create a new database and grant RT access to that database, 
Use of uninitialized value in concatenation (.) or string at
//opt/rt3/sbin/rt-setup-database line 197. 
this script needs to connect to your mysql instance on  as root. 
Please specify that user's database password below. If the user has no
database 
password, just press return. 

Password: Now creating a database for RT. 
Creating mysql database rt3. 
Now populating database schema. 
Creating database schema. 
schema sucessfully inserted 
Now inserting database ACLs 
Now inserting RT core system objects 
[Fri May  9 00:04:03 2003] [crit]: Connect Failed Access denied for user:
'rt_user at localhost' (Using password: YES) 
 at //opt/rt3/sbin/rt-setup-database line 284 
 (/opt/rt3/lib/RT.pm:228) 
make: *** [initialize-database] Error 255 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030513/9d0f63c7/attachment.htm>