+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Cannot connect to MySQL with PMA (/thread-1972.html)
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 06:22 AM
well.. nvm i think i need to find another solution, as this particular one doesn't seem to be heading to a stable release any time soon. and it would appear to me that it has way more bugs than i had initially seen.
this was the 5th or 6th re-installation of the OS due to misdocumentation, and misconfiguration of packages in this particular project.
RE: Cannot connect to MySQL with PMA - rbtux - 12-11-2007 06:30 AM
well the project is not stable.. but there are a lot people that can handle this peace of software to work flawlessly... It's for sure not an out of the box solution (yet).
So I think its a bit easy to blame it to misdocumentation and misconfiguration of ispcp...
RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 06:33 AM
@ArcAiN6
could you post your /var/www/ispcp/gui/tools/pma/config.inc.php ? well, without the password for user pma...
Upd: or maybe you could post the whole file with the password - so we can exclude this...
And something important: what OS do you use, which ispcp version (what did you download)
/Joximu
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 08:50 AM
the ISPcp versions i've had this problem with are:
ispcp-omega-trunk-20071210 * this is current version. this is a fresh install of OS as well as this package as of 23 minutes ago
ispcp-omega-trunk-20071209
ispcp-omega-trunk-20071208
ispcp-omega-trunk-20071207
NOTE: all of these versions have also " hung " if autogenerate is used to passes, as well as if i manually type out passes, the install portion seems to take quite a while (this did not happen on previus nightly's)
Also i must select php4 on install, as php5 does not come pre-bundled with mysql support
------------
OS
------------
Linux debian 2.6.18-5-686 #1 SMP Fri Jun 1 00:47:00 UTC 2007 i686 GNU/Linux
------------
Complete config.inc.php file (replaced password with xxxxxx->
Code:
<?php
/* $Id: config.sample.inc.php 9673 2006-11-03 09:05:54Z nijel $ */
/**
* ispCP ω (OMEGA) a Virtual Hosting Control System
*
* @copyright 2006-2007 by ispCP | http://isp-control.net
* @link http://isp-control.net
* @author ispCP Team (2007)
*/
/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
* look http://your-server.com/ispcp/tools/pma/Documentation.html#authentication_modes
*/
/* Servers configuration */
$i = 0;
/* Server 1 (session) [1] */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'signon';
/*Server parameters */
$cfg['Servers'][$i]['verbose'] = ' ';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock';
$cfg['Servers'][$i]['compress'] = true;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'xxxxxx';
/* Advanced phpMyAdmin features */
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['hide_db'] = '(information_schema|phpmyadmin|mysql)';
/* Name of the Server displayed */
/*$cfg['Servers'][$i]['verbose'] = 'mysql.myserver.com';*/ // reactivate if domain is set in SETUP
$cfg['Servers'][$i]['SignonSession'] = 'ispCP';
$cfg['Servers'][$i]['SignonURL'] = './index.php?server=2'; //Access for all.
/* Server 2 (cookie) [2] */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock';
$cfg['Servers'][$i]['compress'] = true;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'xxxxxx';
/* Advanced phpMyAdmin features */
//$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['hide_db'] = '(information_schema|phpmyadmin|mysql)';
/* Name of the Server displayed */
/*$cfg['Servers'][$i]['verbose'] = 'mysql.myserver.com';*/ // reactivate if domain is set in SETUP
/*
* End of servers configuration
*/
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
/* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$cfg['blowfish_secret'] = 'iHbuVm[bpJZ8g-1Zyljm&u$p5z_$ar8W';
/* Layout preferences */
$cfg['LeftFrameLight'] = true;
$cfg['LeftFrameDBTree'] = true;
$cfg['LeftFrameDBSeparator'] = '_';
$cfg['LeftFrameTableSeparator'] = '__';
$cfg['LeftFrameTableLevel'] = 1;
$cfg['LeftDisplayLogo'] = true;
$cfg['LeftDisplayServers'] = false;
$cfg['LeftPointerEnable'] = true;
$cfg['QueryHistoryDB'] = true;
$cfg['QueryHistoryMax'] = 25;
$cfg['BrowseMIME'] = true;
$cfg['PDFDefaultPageSize'] = 'A4';
$cfg['ShowPhpInfo'] = false;
$cfg['ShowChgPassword'] = false;
$cfg['AllowArbitraryServer'] = false;
$cfg['LoginCookieRecall'] = 'something';
$cfg['LoginCookieValidity'] = 1800;
/* Directories for saving/loading files from server */
$cfg['UploadDir'] = '/var/www/ispcp/gui/phptmp';
$cfg['SaveDir'] = '/var/www/ispcp/gui/phptmp';
$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'utf-8';
$cfg['ForceSSL'] = false;
$cfg['RecodingEngine'] = 'iconv';
$cfg['IconvExtraParams'] = '//TRANSLIT';
$cfg['GD2Available'] = 'yes';
$cfg['BrowseMIME'] = true;
/* Changes the default Theme */
$cfg['ThemeDefault'] = 'omega';
?>RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 09:08 AM
Hi
ok, the config-file is ok - it worked in my installation (just copy&paste - no need to change anything). I hope there are no special characters in the password...
second: the "hung" in the installation is a sign that there are to few "random events" in the system (entropy - just search for this word in the forum). You have to do some keyboard entries (maybe on a second ssh connection).
IMPORTANT: do not Ctrl-C the process!!! better put a self made password in...
Third: Of course there is mysql-support in PHP5 in debian etch. You have to install all pakets which are in the package-list - just follow the installation documentation exactly.
If just pma does not work - well I'm afraid there still is something wrong on your system...
/Joximu
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 09:20 AM
yeppers.. everything works with the exception of pma..
RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 10:14 AM
Maybe a cookie thing?
Your browser must accept cookies - otherwise you cannot log in.
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 10:27 AM
well.. i've managed to sort out one problem in exchange for another...
by granting the pma user select_priv i no longer get " connot connect " now i get:
Code:
#1045 - Access denied for user 'admin'@'localhost' (using password: YES)the password i'm using i am POSITIVE is the correct one...
i've never had this much trouble... *sigh*...
RE: Cannot connect to MySQL with PMA - joximu - 12-11-2007 10:41 AM
is this the mysql user that exists?
admin?
There is a user root in MySQL... it's possible you also installed a user admin in MySQL but normally this user only is installed in ispCP (during setup if you don't name it different).
The priviledge settings for user pma should be ok - but maybe they have not been set correctly...
/J
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 11:01 AM
ok.... so it's a sessions / cookies problem... launched it and logged in perfectly on another machine... i'm not sure why a session / cookie would last through a fresh install though... generic cookie / session naming could be the culprit, perhaps a generated session / cookie name could be added to the installation to bypass this sort of thing?