Some clarifications with initializing rt database

RT Users
1

Hi,
I have already installed RT3.4.5 and modified my RT_SiteConfig.pm
I have a postmaster being run by user “pgsql” (postgresql8 installed via Freebsd6 ports)

Questions:

  1. Do I have to manually “createdb rt3” or will “make initialize-database” create one for me??

  2. In my SiteConfig.pm:

database = rt3
user = rt_user
password = rt_secret

Now, if I “make initialize-database” as root, I got these:

“In order to create or update your RT database,this script needs to connect to your Pg instance on localhost as root.”

What root is it referring to?? The system’s root or the postgresql database’ root??

“Please specify that user’s database password below. If the user has no database
password, just press return.”

After entering the system’s root password I got:

DBI connect(‘dbname=template1;host=localhost;port=5432’,‘root’,…) failed: FATAL: role “root” does not exist
at //usr/local/rt3/sbin/rt-setup-database line 101
Failed to connect to dbi:Pg:dbname=template1;host=localhost;port=5432 as root: FATAL: role “root” does not exist

What does this mean?

I’m thinking, perhaps I should manually “createdb rt3” then create a “rt_user” user for that database, set it’s password like what is set in the RT_SiteConfig.pm then grant a root role to it. Now run “make initialize-database” once more and enter the "rt_user’s password. Am I on the right track or not??

Thanks!!
-jay

Brings words and photos together (easily) with
PhotoMail - it’s free and works with Yahoo! Mail.

2

Hi,
I have already installed RT3.4.5 and modified my RT_SiteConfig.pm
I have a postmaster being run by user “pgsql” (postgresql8 installed via Freebsd6 ports)

Questions:

  1. Do I have to manually “createdb rt3” or will “make initialize-database” create one for me??

  2. In my SiteConfig.pm:

database = rt3
user = rt_user
password = rt_secret

Now, if I “make initialize-database” as root, I got these:

“In order to create or update your RT database,this script needs to connect to your Pg instance on localhost as root.”

What root is it referring to?? The system’s root or the postgresql database’ root??

“Please specify that user’s database password below. If the user has no database
password, just press return.”

After entering the system’s root password I got:

DBI connect(‘dbname=template1;host=localhost;port=5432’,‘root’,…) failed: FATAL: role “root” does not exist
at //usr/local/rt3/sbin/rt-setup-database line 101
Failed to connect to dbi:Pg:dbname=template1;host=localhost;port=5432 as root: FATAL: role “root” does not exist

What does this mean?

I’m thinking, perhaps I should manually “createdb rt3” then create a “rt_user” user for that database, set it’s password like what is set in the RT_SiteConfig.pm then grant a root role to it. Now run “make initialize-database” once more and enter the "rt_user’s password. Am I on the right track or not??

Thanks!!
-jay

Brings words and photos together (easily) with
PhotoMail - it’s free and works with Yahoo! Mail._______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

We’re hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html

Yahoo! Mail
Use Photomail to share photos without annoying attachments.

3
  1. Do I have to manually “createdb rt3” or will “make initialize-
    database” create one for me??

looks like you’re using the freebsd port to do this… it is assuming
mysql default values. you need to set the variable DB_DBA_USER=pgsql
in your make command:

make initialize-database DB_DBA_USER=pgsql

it looks like for you the default DB_DATABASE and DB_HOST are
sufficient.