Mysql issue

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

///////////////////////////////////////////////////

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@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@osg-tg2 rt-3.4.5]# mysql -u rt_user -h localhost
-p
/////////////////////////////////////////////////////

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

Thanks for all of your helps on the permission denied
problem. I have solved that issue. I simply changed
the '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?

///////////////////////////////////////////////////

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@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@osg-tg2 rt-3.4.5]# mysql -u rt_user -h
localhost
-p

/////////////////////////////////////////////////////

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

Since the mysql database doesn’t work, I am trying to
reinstall the database. However, I failed in this
attempts.

[root@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,
line 1.
Can’t create database ‘rt3’; database exists at
//opt/rt3/sbin/rt-setup-database line 281,
line 1.
make: *** [initialize-database] Error 255

Thanks for all of your helps on the permission
denied
problem. I have solved that issue. I simply changed
the '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?

///////////////////////////////////////////////////

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@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@osg-tg2 rt-3.4.5]# mysql -u rt_user -h
localhost
-p

/////////////////////////////////////////////////////

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

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)

Since the mysql database doesn’t work, I am trying
to
reinstall the database. However, I failed in this
attempts.

[root@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,
line 1.
Can’t create database ‘rt3’; database exists at
//opt/rt3/sbin/rt-setup-database line 281,
line 1.
make: *** [initialize-database] Error 255

Thanks for all of your helps on the permission
denied
problem. I have solved that issue. I simply
changed
the '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?

///////////////////////////////////////////////////

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@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@osg-tg2 rt-3.4.5]# mysql -u rt_user -h
localhost
-p

/////////////////////////////////////////////////////

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

[root@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@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@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com]On
Behalf Of zhou jian
Sent: Tuesday, 28 February 2006 10:16 AM
To: zhou jian; rt-users@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@yahoo.com wrote:

Since the mysql database doesn’t work, I am trying
to
reinstall the database. However, I failed in this
attempts.

[root@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,
line 1.
Can’t create database ‘rt3’; database exists at
//opt/rt3/sbin/rt-setup-database line 281,
line 1.
make: *** [initialize-database] Error 255

— zhou jian sunzhoujian@yahoo.com wrote:

Thanks for all of your helps on the permission
denied
problem. I have solved that issue. I simply
changed
the '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@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