[rt-users] database on separate system

[Ruslan Zakirov]

You must connect as dba, see --with-db-dba option of the configure
script. I see you're using root and this user has rights to create
databases. In the error below mysql says that "user 'root' who is
connecting from 'rt.idssite.com' has no access to database 'rt3'"
which means that rt3 DB is there but root has no rights to access it
even he's created it few seconds ago.

On 9/28/06, Paolo Supino <paolo at actcom.net.il> wrote:
> 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
> >>>>
> >>>>
> ><4519B723.7090307 at actcom.net.il>,
> >Paolo Supino <paolo at actcom.net.il> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>


-- 
Best regards, Ruslan.