<br><br><b><i>jay alvarez <rtb0y@yahoo.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> <br> Hi,<br> I have already installed RT3.4.5 and modified my RT_SiteConfig.pm<br> I have a postmaster being run by user "pgsql" (postgresql8 installed via Freebsd6 ports)<br> <br> Questions:<br> 1. Do I have to manually "createdb rt3" or will "make initialize-database" create one for me??<br> <br> 2. In my SiteConfig.pm:<br> <br> database = rt3<br> user = rt_user<br> password = rt_secret<br> <br> Now, if I "make initialize-database" as root, I got these:<br> <br> "In order to create or update your RT database,this script needs to connect to your Pg instance on localhost as root."<br> <br> What root is it referring to?? The system's root or the postgresql database' root??<br> <br> <br> "Please specify that user's database password below. If the user has no database<br> password, just press return."<br> <br>
After entering the system's root password I got:<br> <br> DBI connect('dbname=template1;host=localhost;port=5432','root',...) failed: FATAL: role "root" does not exist<br> at //usr/local/rt3/sbin/rt-setup-database line 101<br> Failed to connect to dbi:Pg:dbname=template1;host=localhost;port=5432 as root: FATAL: role "root" does not exist<br> <br> <br> What does this mean?<br> <br> 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??<br> <br> <br> Thanks!!<br> -jay<br> <br> <br> <br> <br> <br> <div> </div><hr size="1">Brings words and photos together (easily) with<br> <a href="http://us.rd.yahoo.com/mail_us/taglines/PMall/*http://photomail.mail.yahoo.com">PhotoMail </a> - it's free and works with Yahoo!
Mail._______________________________________________<br>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br><br>Community help: http://wiki.bestpractical.com<br>Commercial support: sales@bestpractical.com<br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br>Buy a copy at http://rtbook.bestpractical.com<br><br><br>We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html</blockquote><br><p>
<hr size=1> Yahoo! Mail<br>
<a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=38867/*http://photomail.mail.yahoo.com">Use Photomail</a> to share photos without annoying attachments.