Current time: 09-27-2024, 10:05 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: #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
Post Reply 


Messages In This Thread
Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007, 03:39 AM
RE: Cannot connect to MySQL with PMA - ArcAiN6 - 12-11-2007 08:50 AM

Forum Jump:


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