Current time: 11-26-2024, 02:24 PM Hello There, Guest! (LoginRegister)


Post Reply 
Cannot connect to MySQL with PMA
Author Message
ArcAiN6 Offline
Junior Member
*

Posts: 37
Joined: Apr 2007
Reputation: 0
Post: #11
RE: Cannot connect to MySQL with PMA
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.
(This post was last modified: 12-11-2007 06:23 AM by ArcAiN6.)
12-11-2007 06:22 AM
Find all posts by this user Quote this message in a reply
rbtux Offline
Moderator
*****
Moderators

Posts: 1,847
Joined: Feb 2007
Reputation: 33
Post: #12
RE: Cannot connect to MySQL with PMA
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...
12-11-2007 06:30 AM
Visit this user's website Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #13
RE: Cannot connect to MySQL with PMA
@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
(This post was last modified: 12-11-2007 06:36 AM by joximu.)
12-11-2007 06:33 AM
Visit this user's website Find all posts by this user Quote this message in a reply
ArcAiN6 Offline
Junior Member
*

Posts: 37
Joined: Apr 2007
Reputation: 0
Post: #14
RE: Cannot connect to MySQL with PMA
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';
?>
(This post was last modified: 12-11-2007 08:54 AM by ArcAiN6.)
12-11-2007 08:50 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #15
RE: Cannot connect to MySQL with PMA
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
12-11-2007 09:08 AM
Visit this user's website Find all posts by this user Quote this message in a reply
ArcAiN6 Offline
Junior Member
*

Posts: 37
Joined: Apr 2007
Reputation: 0
Post: #16
RE: Cannot connect to MySQL with PMA
yeppers.. everything works with the exception of pma..
12-11-2007 09:20 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #17
RE: Cannot connect to MySQL with PMA
Maybe a cookie thing?
Your browser must accept cookies - otherwise you cannot log in.
12-11-2007 10:14 AM
Visit this user's website Find all posts by this user Quote this message in a reply
ArcAiN6 Offline
Junior Member
*

Posts: 37
Joined: Apr 2007
Reputation: 0
Post: #18
RE: Cannot connect to MySQL with PMA
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*...
12-11-2007 10:27 AM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #19
RE: Cannot connect to MySQL with PMA
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
12-11-2007 10:41 AM
Visit this user's website Find all posts by this user Quote this message in a reply
ArcAiN6 Offline
Junior Member
*

Posts: 37
Joined: Apr 2007
Reputation: 0
Post: #20
RE: Cannot connect to MySQL with PMA
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?
12-11-2007 11:01 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 5 Guest(s)