[rt-users] Upgrade problems

[Christopher A. Seward Sr.]

ps -ef....shows mysql listed 3 times

mysql.sock is in /var/lib/mysql

I ran make fixperms after the first time I couldn't access webrt.

I'm also getting an 'Access denied for user root', not just for rt.

According to the rt readme file, 'make upgrade' doesn't overwrite the user defined
settings.

I appreciate your patience.

Stephen Hauskins wrote:

> When you say check status is that via 'mysql' commnad?
> Try using  "ps -ef (or -agex) | grep sql
>
> See if it is listed.  Does the  /tmp/mysql.sock  file exist.
>
> But I note below that it says access denied for user 'rt'.  Maybe
> your permissions in the RT directory got changed to something inappropriate.
>
> I also note that since httpd error log returns a line that makes it look
> like MySQL is running.  Since it states  Mysql --> connect etc. but
> says the user rt is denied access.
>
> Did you overwrite your 'rt' database files (user defined,etc.) by accident?
>
> --Yes, it's in /etc/rc.d/init.d
> --When I cd'd to  /etc/rc.d/init.d/ and type ./mysql start, MySQL gives me:
> --    Starting mysql daemon with databases from /var/lib/mysql
> --But when I check the status of MySQL, it's not running.
> --
> --When looking at the httpd error log, I see the following:
> --[Mon Dec 4 14:40:19 2000][error][Client 192.X.X.X] Premature end of script
> --headers: /opt/rt/cgi/webrt.cgi
> --Mysql->connect(database=rt;host=localhost) failed: Access denied for user:
> --'rt at localhost'(using password: YES) at /opt/rt/lib/rt/database.pm line 24.
> --
> --I swear, all I did was un-tar rt and run "make upgrade" :-)
> --
> --
> --Stephen Hauskins wrote:
> --
> --> You need to restart MySQL.
> -->
> --> Where does the startup script live.  usually in /etc/init.d  and
> --> called mysql...
> -->
> --> just start it up by issuing...  ./mysql start
> -->
> --> --
> --> --MySQL is not running on your system - database list could not be
> --> --retrieved.
> --> --
> --> --
> --> --
> --> --Stephen Hauskins wrote:
> --> --
> --> --> Would be strange.  Rt should not have anything to do with MySQL.
> --> -->
> --> --> What is the error message from MySQL startup.
> --> -->
> --> --> --
> --> --> --I upgraded from rt-1.0.5 to 1.0.6, and now MySQL server won't start.
> --> --> --Any clues?
> --> --> --
> --> --> --TIA
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cseward.vcf
Type: text/x-vcard
Size: 341 bytes
Desc: Card for Christopher A. Seward Sr.
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20001204/825ccdbf/attachment.vcf>