/etc/httpd/conf/httpd.confor directly edit it
vi /etc/httpd/conf/httpd.confin this file search for Directory “/var/www/html” this can be on line 290-320
AllowOveride NoneJust change it to
AllowOveride AllSave it, and exit, mod_rewrite is enabled on your server.
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.i386.rpm rpm -Uhv rpmforge-release-0.5.1-1.el5.rf.i386.rpm
wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm rpm -Uhv rpmforge-release-0.5.1-1.el5.rf.x86_64.rpm
yum update
yum install phpmyadmin
You will see:nano /etc/httpd/conf.d/phpmyadmin.conf
Order Deny,Allow Deny from all Allow from 127.0.0.1
service httpd restart
Forbidden
You don't have permission to access /phpmyadmin/ on this server.
nano /etc/httpd/conf.d/phpmyadmin.conf
Remove or comment the first two lines in bold.
Restart the apache server.#Order Allow,Deny#Deny from allAllow from 112.213.90.120
service httpd restart
ErrorTo make it work, you will need to edit config.inc.php. To do so, type in:
The configuration file now needs a secret passphrase (blowfish_secret).
nano /usr/share/phpmyadmin/config.inc.php
and then save it.Fill in any secret keyword there, eg mysecretpassphrase, so that it looks like:$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$cfg['blowfish_secret'] = 'mysecretpassphrase'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
ErrorTo install mysql-server, just run:
#2002 – The server is not responding (or the local MySQL server’s socket is not correctly configured)
yum install mysql-server
service mysqld start
mysqladmin -u root password PASSWORD_HERE
yum remove phpmyadmin
yum install phpmyadmin
$cfg['Servers'][$i]['host'] = 'localhost';
C:\Documents and Settings\Administrator>nslookup
Default Server: dc1.store.com
Address: 10.10.10.10
> dc1
Server: dc1.store.com
Address: 10.10.10.10
Name: dc1.store.com
Address: 10.10.10.10
>
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LC_ALL = "En_US",
LANG = (unset)
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
With a quick Google search I found an answer in this Rubify post. Basically the solution / fix is to make sure the following is set in either your ~/.profile or ~/.bashrc or ~/.cshrc# This setting is for the new UTF-8 terminal support export LC_CTYPE=en_US.UTF-8 export LC_ALL=en_US.UTF-8
use DBI;
use strict;
use POSIX qw(setsid);
# daemonize the program
&daemonize;
$| = 1;
#------------------------------------------------------------------------------
# !!! Configure check time and timeout. These are both in seconds.
my $check = 5; # check processes every $check seconds
my $slow_time = 30; # stop processes that run for >= $slow_time seconds
# !!! Configure log file - All slow queries also get logged to this file
my $logfile = "/var/log/check_mysql_query.log"; # log slow queries to this file
# !!! Configure the database connection parameters
my $db_string = "dbi:mysql:mysql"; # DBI resource to connect to
my $db_user = "root"; # DBI username to connect as
my $db_pass = "root"; # DBI password to connect with
# !!! Configure path to sendmail program
my $sendmail_bin = "/usr/sbin/sendmail";
#
#------------------------------------------------------------------------------
my ($dbh,$sth,$sth2,$thread,$state,$time,$query,$explain);
print "connecting\n";
my $opt = {
'RaiseError'=>0,
'PrintError'=>0
};
$dbh = DBI->connect($db_string,$db_user,$db_pass,$opt);
unless ($dbh) {
print "Error: Unable to connect to database: $DBI::errstr\n";
exit 1;
}
$SIG{'TERM'} = sub {
print "caught sig TERM!\nexiting!\n";
$dbh->disconnect;
exit 1;
};
print "preparing\n";
unless ($sth = $dbh->prepare("show full processlist")) {
print "error preparing query: $DBI::errstr\nexiting!\n";
$dbh->disconnect;
exit 1;
}
print "initialized.. starting loop\n";
while(1) {
unless ($sth->execute) {
print "statement execute failed: ".$sth->errstr."\nexiting!\n";
last;
}
while(my @tmp = $sth->fetchrow) {
$thread = $tmp[0];
$state = $tmp[4];
$time = $tmp[5];
$query = $tmp[7];
if ($state eq "Query" && $query =~ /^SELECT/ && $time >= $slow_time) {
print "killing slow query thread=$thread state=$state time=$time\n";
$dbh->do("kill $thread");
unless (log_query($logfile,$query)) {
print "log_query failed! exiting!\n";
last;
}
}
}
sleep($check);
}
$sth->finish;
$dbh->disconnect;
exit 1;
sub log_query {
my ($file,$query) = @_;
unless (open(O,">>".$file)) {
print "error opening log file '$file': $!\n";
return undef;
}
print O $query."\n-----\n";
close(O);
return 1;
}
sub daemonize {
chdir '/'or die "Can't chdir to /: $!";
open STDIN, '/dev/null' or die "Can't read /dev/null: $!";
open STDOUT, '>>/dev/null' or die "Can't write to /dev/null: $!";
open STDERR, '>>/dev/null' or die "Can't write to /dev/null: $!";
defined(my $pid = fork) or die "Can't fork: $!";
exit if $pid;
setsid or die "Can't start a new session: $!";
umask 0;
}
use POSIX qw(setsid);
chdir '/' or die "Can't chdir to /: $!";
umask 0;
open STDIN, '/dev/null' or die "Can't read /dev/null: $!";
#open STDOUT, '>/dev/null' or die "Can't write to /dev/null: $!";
open STDERR, '>/dev/null' or die "Can't write to /dev/null: $!";
defined(my $pid = fork) or die "Can't fork: $!";
exit if $pid;
setsid or die "Can't start a new session: $!";
while(1) {
sleep(5);
print "Hello...\n";
}
# load required modules
use strict;
use POSIX qw(setsid);
use LWP::Simple;
# set costants
my $URL = 'http://www.webreference.com/perl/';
my $FILE = '/tmp/motherofperl.html';
# flush the buffer
$| = 1;
# daemonize the program
&daemonize;
# our infinite loop
while(1) {
# mirror the file
mirror($URL,$FILE);
# wait for 60 seconds
sleep(60);
}
sub daemonize {
chdir '/' or die "Can't chdir to /: $!";
open STDIN, '/dev/null' or die "Can't read /dev/null: $!";
open STDOUT, '>>/dev/null' or die "Can't write to /dev/null: $!";
open STDERR, '>>/dev/null' or die "Can't write to /dev/null: $!";
defined(my $pid = fork) or die "Can't fork: $!";
exit if $pid;
setsid or die "Can't start a new session: $!";
umask 0;
}
#!/bin/bash
RESTART="/root/auto_kill_slow_mysql.pl"
#path to pgrep command
PGREP="/usr/bin/pgrep"
# Httpd daemon name,
HTTPD="auto_kill_slow"
# find httpd pid
$PGREP ${HTTPD}
if [ $? -ne 0 ] # if auto_kill not running
then
# restart apache
$RESTART
fi
