[rt-users] Re: mysql issue

zhou jian sunzhoujian at yahoo.com
Mon Feb 27 18:16:17 EST 2006


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?
> > > 
> > > 
> > > 
> > >
> >
>
//////////////////////////////////////////////////////
> > > [root at osg-tg2 rt-3.4.5]# mysql -u rt_user -h
> > > localhost
> > > -p
> > > Enter password:
> > > ERROR 1045 (28000): Access denied for user
> > > 'rt_user'@'localhost' (using password: YES)
> > > [root at osg-tg2 rt-3.4.5]# mysql -u rt_user -h
> > > localhost
> > > -p
> > >
> >
>
/////////////////////////////////////////////////////
> > > 
> > > --- zhou jian <sunzhoujian at yahoo.com> wrote:
> > > 
> > > > Hello, everyone,
> > > > 
> > > > I have to ask question again. I just want to
> > > install
> > > > a
> > > > very simple RT to play with. So I did minimial
> > > > change
> > > > to the RT_SiteConfig.pm. I didn't change the
> > > > password
> > > > for rt database. However, I still encountered
> > the
> > > > problems here. I checked the error.log file. 
> > > > 
> > > > Do you have any hints to solve this issue?
> > > > 
> > > > 
> > > > 
> > > > 
> > > > [Sun Feb 26 19:31:28 2006] [notice]
> Apache/2.2.0
> > > > (Unix) mod_ssl/2.2.0 OpenSSL/0.9.7a
> > mod_perl/2.0.2
> > > > Perl/v5.8.8 configured -- resuming normal
> > > operations
> > > > 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
> > > > [Sun Feb 26 19:31:33 2006] [error] [client
> > > > 128.255.163.105] Connect Failed Access denied
> > for
> > > > user
> > > > 'rt_user'@'localhost' (using password: YES)\n
> at
> > > > /opt/rt3/lib/RT.pm line 176\n
> > > > 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
> > > > [Sun Feb 26 19:31:35 2006] [error] [client
> > > > 128.255.163.105] Connect Failed Access denied
> > for
> > > > user
> > > > 'rt_user'@'localhost' (using password: YES)\n
> at
> > > > /opt/rt3/lib/RT.pm line 176\n
> > > > 
> > > >
> > __________________________________________________
> > > > Do You Yahoo!?
> > > > Tired of spam?  Yahoo! Mail has the best spam
> > > > protection around 
> > > > http://mail.yahoo.com 
> > > > 
> > > 
> > > 
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > > protection around 
> > > http://mail.yahoo.com 
> > > 
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> 
=== 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