That's very good information. Thanks very much for the concise
step-by-step Roy.
I do plan to "import" the rt 3.0.? database into this new
installation but I figured it would be better to get the vanilla
3.6.1 install on the new server working first. Did as you suggested
and to no one's surprise, there is no root account in mysql. The
following "using password: NO" is the same error message I got when I
did a make initialize-database so that's the smoking gun. Before I
break it again, any ideas on what I did wrong during the install phase?
By starting the installation fresh, do you mean configure, make
install, make initialize-database?
For RT_SiteConfig.pm, understood about rt_user. What should I put in
the DatabasePassword setting? Set($DatabasePassword , 'rt_pass');
? That's the way it is on my original RT server. I built a backup
RT server last year on 3.4.something and that has a null ( ' ' )
entry in the Password field. Both RT servers are working fine.
Since the "drop rt3" command didn't work, can I just delete the
subdirectory or will that cause additional problems?
Output follows: TIA!
******* This is why I can't log on to RT *******
[EMAIL PROTECTED] etc]# mysql rt3 -p -u root
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.7
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select id,Name,Password from Users where Name like 'root';
Empty set (0.00 sec)
mysql> exit
Bye
******** This is similar to the error I got when doing make
database-initialize ***********
[EMAIL PROTECTED] etc]# mysqladmin drop rt3
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[EMAIL PROTECTED] etc]#
******** This failed too... files are still in /var/lib/mysql/rt3
**************
[EMAIL PROTECTED] mysql]# mysqladmin -u root --password=xxxxxxxx drop rt3
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'rt3' database [y/N] y
mysqladmin: DROP DATABASE rt3 failed;
error: 'Error dropping database (can't rmdir './rt3', errno: 39)'
*********** mysql versions currently installed ******************
MYSQL versions installed (just did an apt-get upgrade yesterday so
I'm surprised there is something newer out there. I presume 4.1.7 is
fine though
mysql-devel-4.1.7-4.RHEL4.1
mysql-4.1.7-4.RHEL4.1
mysqlclient10-devel-3.23.58-4.RHEL4.1
mod_auth_mysql-2.6.1-2.1
php-mysql-4.3.11-2.8
mysql-bench-4.1.7-4.RHEL4.1
mysqlclient10-3.23.58-4.RHEL4.1
mysql-server-4.1.7-4.RHEL4.1
freeradius-mysql-1.0.1-2.RHEL4
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
At 09:16 AM 9/7/2006, you wrote:
refereing back to your original question, I though you were doing an
upgrade, in that case as I mention before you 'll need to upgrade
the your rt-3.0.1 DB to rt-3.6.1 DB (there are few db schema changes
in between), Now I assume you have a new rt3 db , to check for root
user do the following ,
from your shell do : mysql rt3 -p -u root
you'll be prompted for a password type in the mysqdadmin root
password and hit return, you'll get the mysql prompt something similar to :
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
from there execute this sql query:
mysql> select id,Name,Password from Users where Name like 'root';
You'll should get back something similar to :
+----+------+------------------------+
| id | Name | Password |
+----+------+------------------------+
| 12 | root | w50cYSF0UwmfMFu0LDRyMg |
+----+------+------------------------+
1 row in set (0.01 sec)
Now bare in mind the root user above is an rt root user which you
can login through the web interface with user: root and
password:password, that is not the same user you configure on
RT_SiteConfig, the Config user is the sql user that allow the
communication between the web interface and mysql.
If you get nothing back, then something went wrong with your
installation and the best thing to do is to drop the database:
mysqladmin drop rt3
and start you installation from fresh ..BTW what version of mysql
are you using , in mysql 5 there are changes to the password encryption.
Going back to your config user you'll need to make sure that this
user have access to the mysql and rt3 db, by default its rt_user and
rt installation will take care of setting the right permissions for
it, however because you change it , you should have flagged that
when you did ./configure for the rt installation, from the rt source
code do ./configure --help for the various options..
Just remember upgrading your rt instance is different process ..
Good luck,
Roy
Frank Saxton wrote:
Thanks for responding
I followed the installation instructions pretty much to the letter.
I'm pretty comfortable with most areas of the process except for
mysql of which I know nothing.
When I created the MySQL root password I used an actual password,
not "newpass" as it says in the instructions. I presume that was OK.
Then I was fine until editing RT_SiteConfig.pm
Instead of DatabaseUser 'rt_user' I made it 'root' and
DatabasePassword 'the_mysqladmin_root_password given above'
I did a make initialize-database and it complained after I gave it
the password. I can't say if I just hit return as instructed or if
I gave it the myaqladmin root password. It did create
/var/lib/mysql/rt3 and put a pile of stuff in there. If I re-run
make initialize-database it complains that the directory already
exists. I thought about removing the subdirectory and running make
again but wanted to wait to get some advice first. Would that be a
sensible next step?
I don't know how to check to see if the root account exists in mysql.
I went to the Wiki page but the info for that topic has been
defaced by a spammer :(
Please bear in mind when offering advice that I don't know jack about mysql.
At 02:16 AM 9/7/2006, you wrote:
In addition to Andrew suggestion, login to mysql and query the
Users table to see if the root user exist, if not you may have
forgotten to run the initdb stuff ..
When moving databases, you'll be better of doing a mysqldump, copy
the dump file to your new host then restore it into the new
server, I often found that works better than copying the mysql/db
files .., after you restored the database go back to your rt-3.6.1
source and do make upgrade? (can't remember but the instructions
are in the README and UPGRADING) ..
Good luck ;
Roy
Frank Saxton wrote:
This is my fourth or fifth time installing RT and I see that the
process continues to improve! I have it just about installed
thanks to some really good Wiki instructions. I'm just about done
but have a final question or two.
RT 3.6.1 on RHEL 4.0
I was confused when it came to setting up the mysql database stuff.
I got error messages because it didn't like the password but it
seems to have gotten over it. /var/lib/mysql/rt3 has what looks
like everything in it but I cannot log in as root. No matter
what I give it, I get a "username or password incorrect" message.
This is not a huge problem (I don't think) because I have 3.0.1
running on another LInux box and what I'd really like to do is
just copy over all of the accounts, tickets, settings, etc from
that environment and put them on the new box.
Someone advised me on how to do this a year or so ago and it was
very simple. So simple, that I've forgotten what to do. I tried
a tar of everything on the only /var/lib/mysql/rt3 onto the new
machine but then I get text instead of the GUI when I try to bring up RT.
I think if someone can just tell what to copy to the new machine
to make it just like the old RT server, I should be good to go. TIA!
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly
Media. Buy a copy at http://rtbook.bestpractical.com
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.1/440 - Release Date: 9/6/2006
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.1/440 - Release Date: 9/6/2006
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
