Friday, February 15, 2008

Apache http://localhost not working


After apache start, http://localhost not working for me..

My httpd.conf file is fine.

Actually i have commented following line on the file /etc/network/interfaces

auto lo
iface lo inet loopback

I have uncommented those lines and restarted network...

It Works now

(We can also give this command to up the loopback of the network...

#ifconfig lo up

)


Mantis - Admin password reset Problem


How can u reset admin password , if you get the following problem while resetting the password via mail?

I can't get the solution from google. But some tricks solves my problem.


APPLICATION ERROR #1901

The confirmation URL is invalid or has already been used. Please signup again.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were

identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.



1.) If you know ,normal user login and password ... get login


2.) Then open ... mantis_user_table table from the mantis database.

3.) Then copy the password and cookie_string values from normal user to admin user.

Before that u should change the cookie_string value for normal user. Otherwise it will show unique id problem.

4.) Then save everything and refresh browser ( where we logged in as normal user), Now u can get admin login. ;-)

Shell 1- A script to clean up the log files in /var/log

# Cleanup
# Run as root, of course.
cd /var/log
cat /dev/null > messages
cat /dev/null > wtmp
echo "Logs cleaned up."

Thursday, February 14, 2008

To kill the postgresql database

	ERROR:  database is being accessed by other users


If you get this error, you can kill the particular database using following command.


kill `ps auxww | grep 'postgres: username databasename' |grep -v 'grep' |awk '{ print $2 }'`