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 <[EMAIL PROTECTED]> 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
>>>>
>>>>
><[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
_______________________________________________
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
