[rt-users] Re: mysql issue

zhou jian sunzhoujian at yahoo.com
Mon Feb 27 18:24:22 EST 2006


[root at osg-tg2 sbin]# ./rt-dump-database
DBI connect('dbname=rt3;host=localhost','rt_user',...)
failed: Access denied for user 'rt_user'@'localhost'
(using password: YES) at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 108
Connect Failed Access denied for user
'rt_user'@'localhost' (using password: YES)
 at /opt/rt3/lib/RT.pm line 176
[root at osg-tg2 sbin]# pwd
/home/jzhou9/rt/rt-3.4.5/sbin

I tried to use this one, but it seems not work. At the
same time, I am also carefully reading the book RT
Eessential again to get some clues. However, there is
no information about that. Could you access your rt
database? Could you share with me your command?


--- Anthony Gabila <agabila at con.mdsnews.com> wrote:

> theres a script for it, rather than running make
> initialize database,
> theres a drop database too.... read the manual its
> just right after
> that. it will say something like, if the database
> exist already,
> try running drop something... not quite sure, but
> its in the manual
> installation guide.
> 
> 
> anthony g
> 
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com]On
> Behalf Of zhou jian
> Sent: Tuesday, 28 February 2006 10:16 AM
> To: zhou jian; rt-users at lists.bestpractical.com
> Subject: [rt-users] Re: mysql issue
> 
> 
> When I checked the mysql with root user. I can find
> th
> e rt3 database and got the tables affiliated with
> rt3.
> However, I couldn't connnect to that through
> mysql -h localhost -u rt_user -p rt3? why?
> 
> mysql> SHOW DATABASES
>     -> ;
> +--------------------+
> | Database           |
> +--------------------+
> | information_schema |
> | mysql              |
> | rt3                |
> | test               |
> +--------------------+
> 4 rows in set (0.05 sec)
> 
> mysql> DATABASE rt3;
> ERROR 1064 (42000): You have an error in your SQL
> syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use
> near
> 'DATABASE rt3' at line 1
> mysql> use rt3
> Database changed
> mysql> show tables
>     -> ;
> +-------------------------+
> | Tables_in_rt3           |
> +-------------------------+
> | ACL                     |
> | Attachments             |
> | Attributes              |
> | CachedGroupMembers      |
> | CustomFieldValues       |
> | CustomFields            |
> | GroupMembers            |
> | Groups                  |
> | Links                   |
> | ObjectCustomFieldValues |
> | ObjectCustomFields      |
> | Principals              |
> | Queues                  |
> | ScripActions            |
> | ScripConditions         |
> | Scrips                  |
> | Templates               |
> | Tickets                 |
> | Transactions            |
> | Users                   |
> | sessions                |
> +-------------------------+
> 21 rows in set (0.00 sec)
> 
> 
> --- zhou jian <sunzhoujian at yahoo.com> wrote:
> 
> > Since the mysql database doesn't work, I am trying
> > to
> > reinstall the database. However, I failed in this
> > attempts.
> >
> >
> > [root at osg-tg2 rt-3.4.5]# make initialize-database
> > /usr/local/bin/perl
> //opt/rt3/sbin/rt-setup-database
> > --action init --dba root --prompt-for-dba-password
> > "my" variable $id masks earlier declaration in
> same
> > scope at /opt/rt3/lib/RT/CustomField_Overlay.pm
> line
> > 879.
> > "my" variable $id masks earlier declaration in
> same
> > scope at /opt/rt3/lib/RT/CustomField_Overlay.pm
> line
> > 914.
> > In order to create or update your RT database,this
> > script needs to connect to your mysql instance on
> > localhost 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.
> > DBD::mysql::db do failed: Can't create database
> > 'rt3';
> > database exists at
> //opt/rt3/sbin/rt-setup-database
> > line 281, <STDIN>
> > line 1.
> > Can't create database 'rt3'; database exists at
> > //opt/rt3/sbin/rt-setup-database line 281, <STDIN>
> > line 1.
> > make: *** [initialize-database] Error 255
> >
> >
> > --- zhou jian <sunzhoujian at yahoo.com> wrote:
> >
> > > Thanks for all of your helps on the permission
> > > denied
> > > problem. I have solved that issue. I simply
> > changed
> > > the <Directory>'s original settting to
> > > /opt/rt3/share/html. And it works.  Right now,
> the
> > > problem is about mysql issue. I searched over
> the
> > > internet and found that other people also had
> such
> > > problems before. However, there are no solution
> > > yet!Do
> > > you have any hints for that?
> > >
> > > --- zhou jian <sunzhoujian at yahoo.com> wrote:
> > >
> > > >
> > >
> >
> ///////////////////////////////////////////////////
> > > > #  Modification time never checked.
> > > >
> > > > #  File has not been updated.
> > > >
> > > > regression: regression-install dirs
> > files-install
> > > > libs-install sbin-install bin-install
> > > > regression-instruct regression-reset-db
> > > testify-pods
> > > > fixperms apachectl run-regression
> > > > #  Implicit rule search has not been done.
> > > > #  Modification time never checked.
> > > > #  File has not been updated.
> > > >
> > > > # 107 files in 1007 hash buckets.
> > > > # average 0.106 files per bucket, max 2 files
> in
> > > one
> > > > bucket.
> > > >
> > > > # VPATH Search Paths
> > > >
> > > > # No `vpath' search paths.
> > > >
> > > > # No general (`VPATH' variable) search path.
> > > >
> > > > # Finished Make data base on Sun Feb 26
> 20:04:33
> > > > 2006
> > > >
> > > >
> > /////////////////////////////////////////////////
> > > >
> > > >
> > > >
> > > > I tried to drop off the rt3 database. And
> > > recreated
> > > > it
> > > > again, however, I tried to use mysql -u
> rt_user
> > -h
> > > > localhost -p to connect to that, but failed. I
> > > used
> > > > "rt_pass" as password. Actually, I didn't
> change
> > > > anything for the configuration files. Any
> ideas?
> > > >
> > > >
> > > >
> > > >
> > >
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the rt-users mailing list