Restarting rt 1.0.7 after reboot

RT Users
1

Greetings,

I re-booted my server that rt resides on…i started mysql
(bin/safe_mysql --user=del &)

However no one is able to login…i think that the rt database is not
loaded…not being a database guru, what is the proper way of starting
either mysql/rt so that users can login…?

thanks
donnie

2

HELLO…

here is some additional info from the apache error_log file;;

Mysql->connect(database=rt1;host=localhost) failed: Can’t connect to local
MySQL server through socket ‘/tmp/mysql.sock’ (146) at
/usr/local/rt/lib/rt/database.pm line 24
[connectdb] Database connect failed: Can’t connect to local MySQL server
through socket ‘/tmp/mysql.sock’ (146)
[Mon Apr 30 09:12:14 2001] [error] [client XXX.YY.ZZ.111] Premature end
of
script headers: /usr/local/rt/bin/cgi/webrt.cgi
genie$ more /tmp/mysql.sock
/tmp/mysql.sock: Operation not supported on transport endpoint

as root, i restated the database server via::

bin/safe_mysql --user=dbadmin &

this is the msg written to the /mysql/data/hostname.err file:

010430 11:07:55 mysqld started
/home/database_user/tools/mysql-3.23.29a-gamma-sun-solaris2.8-sparc/bin/
mysqld: ready for connections

all that was done was initially reboot the server that hosted
rt/mysql…the database was not shutdown cleanly…

any suggestions would be appreciated…

donnieOn Mon, 30 Apr 2001, del wrote:

Greetings,

I re-booted my server that rt resides on…i started mysql
(bin/safe_mysql --user=del &)

However no one is able to login…i think that the rt database is not
loaded…not being a database guru, what is the proper way of starting
either mysql/rt so that users can login…?

thanks
donnie

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

3

Here’s my startup script, used on a FreeBSD box.
#!/bin/sh

if [ -x /usr/local/bin/safe_mysqld ]
then
/usr/local/bin/safe_mysqld & && echo -n ’ mysql’
fi

-Feargal.

_/_/_/ _/_/_/  _/_/_/  Feargal Reilly,

_/ _/ / / Systems Administrator,
/ / //// The Communications Interactive Agency.
/// /// _/ _/ Phone: +353-86-8732249.

 Greetings,
 
 I re-booted my server that rt resides on....i started mysql 
 (bin/safe_mysql  --user=del &)
 
 However no one is able to login..i think that the rt database is not 
 loaded..not being a database guru, what is the proper way of starting 
 either mysql/rt so that users can login...?
 
 thanks
 donnie
 
 
 rt-users mailing list
 rt-users@lists.fsck.com
 http://lists.fsck.com/mailman/listinfo/rt-users
4

what are the MySQL command to display the contents of a RT database…?

perhaps my RT database is corrupted although it does not appear so…

I have tried::
mysql> show tables

but it apparently doers not work…

donnie

At 03:03 PM 5/1/2001 +0000, Feargal Reilly wrote:

5

Greetings

…and thanks for responding…

At 03:03 PM 5/1/2001 +0000, Feargal Reilly wrote:

Here’s my startup script, used on a FreeBSD box.
#!/bin/sh

if [ -x /usr/local/bin/safe_mysqld ]
then
/usr/local/bin/safe_mysqld & && echo -n ’ mysql’

hmmm…

so a basic re-start of mysql via the wrapper script…nothing
special…perhaps my RT database is SOL…

"& && echo -n ‘mysql’ what is this for except to echo “mysql” to the
screen…?

donnie

6

| "& && echo -n ‘mysql’ what is this for except to echo “mysql” to the
| screen…?
±–>8

Exactly. It’s running as part of the boot time scripts in
/usr/local/etc/rc.d presumably so it displays “mysql” during the local
services startup.

brandon s. allbery [os/2][linux][solaris][japh] allbery@kf8nh.apk.net
system administrator [WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [“better check the oblivious first” -ke6sls]

7

what are the MySQL command to display the contents of a RT database…?

perhaps my RT database is corrupted although it does not appear so…

I have tried::
mysql> show tables

Don’t forget the ‘;’ after each command (ie: not ‘show tables’ but
‘show tables;’

(as root)

mysql -p rt

(enter root’s mysql password when prompted)

show tables; (in mysql)

select * from users; (will show all users created in RT etc…).

Hope thats enlightening.

weirD

Douglas Weir dweir@theochem.uwaterloo.ca
Chemical Physics Dept. Earth-Science & Chemistry 330A
University Of Waterloo (519) 888-4567 x6110
ANTI-SPAM Policy: Only mail addressed “To:” dweir (this excludes all of
‘undisclosed recipients’/Cc/Bcc/etc) and certain pre-authorised mailing
lists will survive the spam filtering process.

8

thanks for the info…it seems if it is reading stuff from when i first
created RT database about a few months ago not the lastest data…is
there a way to recover the RT database…?

i reviewed the database directory and it seems as it is intact…dunno why
RT is not reading the latest info…

Any ideals…?

donnie

At 02:34 PM 5/1/2001 -0400, Doug Weir wrote:>On Tue, 1 May 2001, del wrote:

what are the MySQL command to display the contents of a RT database…?

perhaps my RT database is corrupted although it does not appear so…

I have tried::
mysql> show tables

Don’t forget the ‘;’ after each command (ie: not ‘show tables’ but
‘show tables;’

(as root)

mysql -p rt

(enter root’s mysql password when prompted)

show tables; (in mysql)

select * from users; (will show all users created in RT etc…).

Hope thats enlightening.

weirD

Douglas Weir dweir@theochem.uwaterloo.ca
Chemical Physics Dept. Earth-Science & Chemistry 330A
University Of Waterloo (519) 888-4567 x6110

ANTI-SPAM Policy: Only mail addressed “To:” dweir (this excludes all of
‘undisclosed recipients’/Cc/Bcc/etc) and certain pre-authorised mailing
lists will survive the spam filtering process.

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users