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
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
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
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
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?
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?
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
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
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
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?
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?
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
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
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
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?
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?
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
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
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
[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.
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?
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