[rt-users] make initialize-database error

[Greg.Hering at bench.com]

I think you have something empty when it needs a value, probably in the RT_Config.pm or RT_SiteConfig.pm.

 

I tried letting 'DatabaseHost' and 'DatabaseRTHost' be empty (i.e. '') like it suggested but that caused this error for me.

 

Try putting them back to 'localhost' and making the db again.  Would somebody smarter than me comment on this please?

 

Look at this error message in your first post:

 

"Use of uninitialized value in concatenation (.) or string at //opt/rt3/sbin/rt-setup-database line 197. "



right after the statement

 

"In order to create a new database and grant RT access to that database, "



 

Make sure you separate things:  You have Unix users and passwords and groups, RT users and passwords (in MySQL) and you have the user you run the web server as.

If you drop the 'rt3' database, that doesn't change the users in the system table.

The 'rt' group is a Unix thing

rt_user at localhost is a MySQL connect string.

 

Try listing the user table 

 

#mysql -u root (-p if you have a password)

>show tables;

(should see 'user')

>select Host, User, Password from user;

(list of users and their passwords)

 

mine looks like

 

+Host ------------  User --- Password

localhost           root

localhost.dom    root

localhost

localhost.dom

localhost           rt_user  1234abcd

 

Does the root account have a password?  If so you have to use it to connect and make tables.

Is there a rt_user in the mysql.user table?  The script should create it, not you.

 

I think you got logged in as root and created the tables, but without a 'localhost' entry in the config file you didn't get a useable entry for 'rt_user' in the system user table.

 

Sincerely,

 

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: Tuesday, May 13, 2003 5:21 PM
To: RT Users (E-mail)
Cc: Hering, Greg
Subject: RE: [rt-users] make initialize-database error

 

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/20030514/017a3dcd/attachment.htm>