phpMyAdmin problem after update from RC4 to RC5

[Solvik]

Hi,

I have just updated my ISPCP RC4 to RC5 by following the readme file.
When I try to login via phpMyAdmin I have this error:

Quote:Unknown MySQL server host '{HOSTNAME}' (1)

If someone could help me on that problem.. thanks in advance !

Solvik.

[Zothos]

your config seems to be messed. Please post your pma config here

[Solvik]

Quote:/* Servers configuration */
$i = 0;

/* Server 1 (cookie) [1] */
$i++;

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Parameters set by ispCP */
$cfg['Servers'][$i]['user'] = $_POST['pma_username'];
$cfg['Servers'][$i]['password'] = $_POST['pma_password'];
/* Server parameters */
$cfg['Servers'][$i]['host'] = '{HOSTNAME}';
$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_USER}';
$cfg['Servers'][$i]['controlpass'] = '{PMA_PASS}';
/* 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';

I have just replaced {HOSTNAME} by localhost. And it works.
thanks for the info

[Zothos]

also replace this two with the corresponding user/pw for the pma table

$cfg['Servers'][$i]['controluser'] = '{PMA_USER}';
$cfg['Servers'][$i]['controlpass'] = '{PMA_PASS}';

[invisible]

Hi there,

I did the update from ISPCP RC5 to RC5a (GUI) and I´ve got the same problem after installing RC5a. And beside this I now can´t login anymore to the adminstration panel. I get the message "ERROR: Unable to connect to SQL server ! SQL returned: Access denied for user 'root'@'localhost' (using password: YES)". But the sql-server runs and my password is the same as before. The ispcp.conf file wasn´t touched.

I read the included README file and did all exactly like it´s described there.
So what´s the problem?

Thx for your help!

invisible

[RatS]

you missed to copy the pma/config.inc.php file before updating GUI ... you have not read INSTALL careful enough

[invisible]

Quote:ispCP . (OMEGA) HowTo Install
================================================================================​

Table of Content
================
1) Version Info
2) Requirements
3) Introduction
4) Installation
5) Update
6) FAQ
7) Credits

================================================================================​
1) Version Info
---------------
ispCP . Version: 1.0.0 RC5a
INSTALL Script: 2.1
Homepage: http://www.isp-contol.net
Linux Distros: all supported

================================================================================​
2) Requirements
---------------
There is no must have for a system using ispCP .. This is only a recommendation:

Pentium III or K6-4 with 500 MHz
512 MB RAM
100 MB disk space (only for install of ispCP .)
Debian (or even any other *NIX-Distribution)
Installed ispCP . RC5

================================================================================​
3) Introduction
---------------
ispCP . delivers a complete hosting automation appliance by offering significant
security, total-cost-of-ownership, and performance advantages over competing
commercial solutions.

With ispCP . you can configure your server and applications, create user with
domains with a few point-and-click operations that take less than a minute.
There is no limit to the number of resellers, users and domains that can be
created. The core of ispCP . are 3 easy-to-use, web-based control panels. ispCP
provides graphic user interfaces for the administrators, resellers and users.

================================================================================​
4) Installation
---------------
Please make sure you downloaded and installed ispCP . RC5

================================================================================​
5) Update
---------
1. Copy all the directories into your system (you may make backups)
# cp -Rv /tmp/ispcp-omega-gui-1.0.0-rc5a/gui/* /var/www/ispcp/gui/
The path may differ.

2. Set permissions
# /var/www/ispcp/engine/setup/set-gui-permissions.sh

3. Clean the temporary folders:
# rm -fR /tmp/ispcp-omega-gui-1.0.0-rc5a

================================================================================​
6) FAQ
------

Please check http://www.isp-control.net for any questions not answered in this file.

================================================================================​
7) Credits
----------

ispCP . is a project of ispCP | isp Control Panel.
Please visit our site under http://isp-control.net for further information on
ispCP ., ispCP and other themes.

We hope you enjoy using ispCP .. If you like it, help us, to make it better. We
would be glad on any help provided!

Thanks for your reply, but could you please show me the hint you mentioned? Either I´m blind or we both have different README versions?

The only hint I can see above, is to the one wich reminds one to backup some files and folders. But there´s no single word about copying the pma/config.inc.php before updating.

Any idea?

Thx in advance!
invisible

[sci2tech]

http://www.isp-control.net/ispcp/browser...n/INSTALL: from line 177

Quote:6. Save key files
# cp -v /var/www/ispcp/engine/ispcp-db-keys.pl /tmp/ispcp/var/www/ispcp/engine/
# cp -v /var/www/ispcp/engine/messager/ispcp-db-keys.pl /tmp/ispcp/var/www/ispcp/engine/messager/
# cp -v /var/www/ispcp/gui/include/ispcp-db-keys.php /tmp/ispcp/var/www/ispcp/gui/include/

Refer to you distro in downloaded package.

[invisible]

@sci2tech:
your Link doesn´t work, but I found the file here:
http://www.isp-control.net/ispcp/browser...an/INSTALL

But thx anyway!

@ispcp-team:
this INSTALL file isn´t part of the RCa (GUI) package!
RCa (GUI) contains only a README file with an install/update section (take a look above).

Sorry guys, ISPCP is really great and I respect your work, the time and energy you´ve put in this project - but THIS makes no sense for me!

Why do you put a README file into an update package with incomplete install / update instructions? How can I - or any other user - know, that these instructions are incomplete and one should read the instructions of the base package too?

When I download an update package with an included README file, which contains an install section (Point 5), then I assume that this are the complete instructions and don´t have to read another INSTALL file too. Especially when there´s no hint to read the INSTALL of the base package!

It woudl be much better, to direct the user to the INSTALL file of the base package instead of publishing incomplete instructions within the README in RCa.

Or is my point of view so aside?

cheers,
invisible

[sci2tech]

That`s the link, i left a : next to link. Indeed in the Readme is nothing about saving conf files. Sorry for inconvenient but until ispcp will be stable this things will happend. In this phase ispcp is usable as productive environment only by people who can understand, assume and handle the risk of something going wrong.