[rt-users] Re: mysql issue

[zhou jian]

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
> protection around 
> http://mail.yahoo.com 
> 


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