Hi Tim
I noticed that option after I wrote the email. I tried it and it
indeed created the database but it fails further down the line when it
tries to grant access. It's probably more an issue of mysql than RT.
Please take a look at the log below and see if you can help solve the
problem.
# make initialize-database
/usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba root
--prompt-for-dba-password
In order to create or update your RT database,this script needs to
connect to your mysql instance on rtdb.quicklook.local 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.
Done setting up database schema.
Now inserting database ACLs
DBD::mysql::st execute failed: Access denied for user
'root'@'rt.idssite.com' to database 'rt3' at
//opt/rt3/sbin/rt-setup-database line 345.
Problem with statement:
GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3.* TO
rt_user@'rtdb.quicklook.local' IDENTIFIED BY 'rt_pass';
Access denied for user 'root'@'rt.idssite.com' to database 'rt3' at
//opt/rt3/sbin/rt-setup-database line 346.
make: *** [initialize-database] Error 255
TIA
Paolo
Tim Wilson wrote:
On Tue, Sep 26, 2006 at 6:26 PM, in message
<[EMAIL PROTECTED]>,
Paolo Supino <[EMAIL PROTECTED]> wrote:
I have a mysql database server already running on my lan and I want
to
use it for my RT system too. From whay I saw thus far the
installation
process assumes the database is local and I didn't see any
documentation
on setting up the RT database on a remote installation of mysql.
I just installed RT 3.6.1 from source with the DB running on a separate
server. As long as you specify the remote server properly when you do
the ./configure it will work just fine. Do
$ ./configure --help
to get a list of all the available options. I installed on Ubuntu 6.06,
but I followed the directions at
http://wiki.bestpractical.com/index.cgi?DebianStableInstallGuide
which worked quite well with only minor modifications.
-Tim
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
