| View previous topic :: View next topic |
| Author |
Message |
kdvgent
Guru
Joined: 29 Sep 2004
Posts: 352
Location: Belgium
|
 Posted: Sat Apr 28, 2007 3:17 pm Post subject: "The server is not responding" with phpmyadmin [SO |
 |
|
I have a problem with phpmyadmin. I have various mysql instances running in various vhosts.
The mysql instances run OK (I am running drupal sites that use these databases)
However, I cannot get phpmyadmin to work. When trying to log on to phpmyadmin, I get the "#2003 - The server is not responding" error message. (but with the same socket and port, drupal uses the database)
Any suggestion on what I can do? I have already removed phpmyadmin, the phpmyadmin directory in the vhost, reinstalled phpmyadmin, removed pmadb from database, recreated pmadb - nothing helps.
| Quote: | cat /etc/mysql/my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-4.1,v 1.3 2006/05/05 19:51:40 chtekk Exp $
# changes made by KDV to use mysqlmanager and various databases (21/01/2007)
# KDV: removed [client] section
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# KDV: add [mysql.server] and [manager] sections
[mysql.server]
user-manager
[manager]
default-mysqld-path = /usr/sbin/mysqld
socket = /var/run/mysqld/manager.sock
pid-file = /var/run/mysqld/manager.pid
password-file = /etc/mysql/mysqlmanager.passwd
monitoring-interval = 2
port = 1999
bind-address = 127.0.0.1
# KDV: remove [mysqld] section
# KDV: add [mysqldx] section per virtual host
[mysqld1]
mysqld-path = /usr/sbin/mysqld
character-set-server = utf8
default-character-set = utf8
user = mysql
# KDV: server-id, port, socket, pid-file, log-error, datadir different for each vhost
server-id = 1
port = 3307
socket = /var/run/mysqld/mysqld_stax-ac.sock
pid-file = /var/run/mysqld/mysqld_stax-ac.pid
log-error = /var/log/mysql/mysqld_stax-ac.err
datadir = /srv/stax-ac.be/mysql
bind-address = 127.0.0.1
[mysqld2]
mysqld-path = /usr/sbin/mysqld
character-set-server = utf8
default-character-set = utf8
user = mysql
# KDV: server-id, port, socket, pid-file, log-error, datadir different for each vhost
server-id = 1
port = 3306
socket = /var/run/mysqld/mysqld_staxmax.sock
pid-file = /var/run/mysqld/mysqld_staxmax.pid
log-error = /var/log/mysql/mysqld_staxmax.err
datadir = /srv/staxmax.homedns.org/mysql
bind-address = 127.0.0.1
|
And the phpmyadmin configuration file
| Quote: | cat /srv/staxmax.homedns.org/www/htdocs/phpmyadmin/config.inc.php
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 2.10.0.2 setup script by Michal Čihař <michal@cihar.com>
* Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $
* Date: Sat, 28 Apr 2007 14:45:45 GMT
*/
/* Servers configuration */
$i = 0;
/* Server staxmax.homedns.org (cookie) [1] */
$i++;
$cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark';
$cfg['Servers'][$i]['relation'] = 'PMA_relation';
$cfg['Servers'][$i]['table_info'] = 'PMA_table_info';
$cfg['Servers'][$i]['table_coords'] = 'PMA_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'PMA_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'PMA_column_info';
$cfg['Servers'][$i]['designer_coords'] = 'PMA_designer_coords';
$cfg['Servers'][$i]['history'] = 'PMA_history';
$cfg['Servers'][$i]['host'] = 'staxmax.homedns.org';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld_staxmax.sock';
$cfg['Servers'][$i]['connect_type'] = 'socket';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['controluser'] = '@@@@@@';
$cfg['Servers'][$i]['controlpass'] = '@@@@@@';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['pmadb'] = 'pmadb';
/* End of servers configuration */
$cfg['blowfish_secret'] = '46335e1230baf3.25715197';
?>
|
If you want more information, please ask
Last edited by kdvgent on Sun Apr 29, 2007 6:12 pm; edited 1 time in total |
|
| Back to top |
|
 |
!equilibrium
Bodhisattva
Joined: 06 Jun 2004
Posts: 2109
Location: MI/BG/LC
|
| Posted: Sun Apr 29, 2007 12:07 am Post subject: |
|
|
your mysql is configured to reply only to 'localhost' but in your phpmyadmin config file you used 'staxmax.homedns.org', try yo use 'localhost' or '127.0.0.1' instead.
_________________
Arch Tester for Gentoo/FreeBSD
Equilibrium's Universe
all my contents are released under the Creative Commons Licence by-nc-nd 2.5 |
|
| Back to top |
|
|
kdvgent
Guru
Joined: 29 Sep 2004
Posts: 352
Location: Belgium
|
| Posted: Sun Apr 29, 2007 6:11 pm Post subject: That did it |
|
|
| Thanks |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
