[rt-users] database on separate system

[Paolo Supino]

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
>>
>
>