[rt-users] Default password

Raed El-Hames r at elhames.co.uk
Wed Aug 1 17:47:59 EDT 2007


Yes all you need is ~]# /usr/sbin/rt-setup-database  and all mysql related
stuff as per the read me ..
have a look at the wiki installation document it explains how to deal with
your error.
Roy
----- Original Message -----
From: "John Oliver" <joliver at john-oliver.net>
To: <rt-users at lists.bestpractical.com>
Sent: Wednesday, August 01, 2007 6:41 PM
Subject: Re: [rt-users] Default password


> On Wed, Aug 01, 2007 at 06:09:42PM +0100, Roy El-Hames wrote:
> > Have you any users in your Users table, if not then I would recommend
> > re-installing RT, cause you need more than just the root user like the
> > user Nobody and RT_System.
>
> Reinstall???
>
> Wouldn't dropping the database and re-running rt-setup-database, in
> theory, be sufficient?
>
> Which leads to another problem...
>
> [root at rt3 ~]# /usr/sbin/rt-setup-database --action init --dba rt_user
> --prompt-for-dba-password
> In order to create or update your RT database,this script needs to
> connect to your mysql instance on 10.12.14.149 as rt_user.
> 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.
> readline() on closed filehandle SCHEMA_LOCAL at
> /usr/sbin/rt-setup-database line 192.
> Done setting up database schema.
> Now inserting database ACLs
> DBD::mysql::st execute failed: Access denied for user
> 'rt_user'@'10.12.14.164' to database 'mysql' at
> /usr/sbin/rt-setup-database line 345.
> Problem with statement:
>  USE mysql;
> Access denied for user 'rt_user'@'10.12.14.164' to database 'mysql' at
> /usr/sbin/rt-setup-database line 346.
>
>
> rt-setup-database apparantly can start setting up the database, but runs
> into a problem because it tries to access the 'mysql' database.  I
> dropped the rt3 database and granted all to rt_user, but it still fails.
> So... what is the correct way to initialize the rt3 database?
>
> --
> ***********************************************************************
> * John Oliver                             http://www.john-oliver.net/ *
> *                                                                     *
> ***********************************************************************
> _______________________________________________
> 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




More information about the rt-users mailing list