[rt-users] database on separate system

[John Doe]

Using this.

http://dev.mysql.com/doc/refman/4.1/en/grant.html

On 9/29/06, Paolo Supino <paolo at actcom.net.il> wrote:
>
> Hi Ruslan
>
>   And how to fix that?
>
>
>
> TIA
> Paolo
>
>
> Ruslan Zakirov wrote:
>
> > 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
> >>
> >
> >
>
> _______________________________________________
> 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
>