[rt-users] RT 3.6.1 install question
Frank Saxton
frankie at easyrider.com
Thu Sep 7 15:05:51 EDT 2006
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 *******
[root at patrol 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 ***********
[root at patrol etc]# mysqladmin drop rt3
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
[root at patrol etc]#
******** This failed too... files are still in /var/lib/mysql/rt3
**************
[root at patrol 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: sales at bestpractical.com
>>>>
>>>>
>>>>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
More information about the rt-users
mailing list