Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th August 2011, 18:08
neobcn neobcn is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Angry PhpMyadmin 3.4.4 errors

Hi i upload the new version of Phpmyadmmin, i reupload de config.inc.php.

all ok but appear this errors, please see the attach capture.


Reply With Quote
Sponsored Links
  #2  
Old 26th August 2011, 19:38
ande ande is offline
Junior Member
 
Join Date: Jan 2008
Location: Freiburg, Germany
Posts: 29
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Looks like phpMyAdmin works fine, it complains only that you'll have to create the "Linked Tables Infrastructure" if you want to use SQL-History, Relations manager etc.

See http://www.phpmyadmin.net/documentation/#linked-tables

As far as I remember, you'll have to

- create a database mostly called "phpmyadmin" . There is a SQL file for that that you may import.
- create an underpriviledged user and give it (him?) only rights to that database, and SELECT rights on teh database "mysql".
- write user / password / database in the config.inc.php

It was always not very intuitive, but after RTFM it works mostly..

New phpMyAdmin version looks nice, BTW.
Reply With Quote
  #3  
Old 26th August 2011, 20:11
neobcn neobcn is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Very Thx ande but my novice in Linux, please is possible put a guide????

thx a new

i create user "pma" and "pass" the rights i select all in the columm "data"

i import the script create_tables.sql

i edit in : /etc/phpmyadmin/config.inc.php

<?php
/**
* Debian local configuration file
*
* This file overrides the settings made by phpMyAdmin interactive setup
* utility.
*
* For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz
*
* NOTE: do not add security sensitive data to this file (like passwords)
* unless you really know what you're doing. If you do, any user that can
* run PHP or CGI on your webserver will be able to read them. If you still
* want to do this, make sure to properly secure the access to this file
* (also on the filesystem level).
*/


$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;

/**
* Read configuration from dbconfig-common
* You can regenerate it using: dpkg-reconfigure -plow phpmyadmin

*/
if (is_readable('/etc/phpmyadmin/config-db.php')) {
require('/etc/phpmyadmin/config-db.php');
}

/* Configure according to dbconfig-common if enabled */
if (!empty($dbname)) {
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
if (empty($dbserver)) $dbserver = 'localhost';
$cfg['Servers'][$i]['host'] = $dbserver;

if (!empty($dbport)) {
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['port'] = $dbport;
}
//$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';
/* Optional: User for advanced features */
$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;
/* Optional: Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = $dbname;
$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]['tracking'] = 'pma_tracking';

/* Uncomment the following to enable logging in to passwordless accounts,
* after taking note of the associated security risks. */
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

/* Advance to next server for rest of config */
$i++;
}

how to add the new valors???

thx

Last edited by neobcn; 26th August 2011 at 21:01. Reason: editing
Reply With Quote
  #4  
Old 26th August 2011, 21:26
ande ande is offline
Junior Member
 
Join Date: Jan 2008
Location: Freiburg, Germany
Posts: 29
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Dear Barcelona guy

Quote:
Originally Posted by neobcn View Post
i create user "pma" and "pass"
That is fine as long as you use a much better password than "pass"!

Quote:
the rights i select all in the columm "data"
No, not necessary to select columns.

1. Create a user with NO rights at all, but password and host = localhost (not "%"!)

2. Grant that user SELECT, INSERT, DELETE, UPDATE permissions only for the database "pma".

That should already resolve most of the problems.

3. Grant that user SELECT permissions for database "mysql".

Quote:
import the script create_tables.sql
Very good, You've seen those tables have been created I assume.

Quote:
i edit in : /etc/phpmyadmin/config.inc.php
Yes, but you see that with Debian, it points to another file:

Quote:
if (is_readable('/etc/phpmyadmin/config-db.php')) {
require('/etc/phpmyadmin/config-db.php');
}
and as I have Debian as wll, I saw that even the other file is empty. So I have no idea right now where phpMyAdmin sits. :-/ Maybe inside /var/local/ispconfig - but please dont tinker there.. might break things.

Till?
Reply With Quote
  #5  
Old 26th August 2011, 21:35
neobcn neobcn is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes my install is dedian 6 , and i install ispconfig 3 , see the guide in howtooforge

any solution for solve this??
Reply With Quote
Reply

Bookmarks

Tags
ispconfig 3, phpmyadmin

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
FuzzyOcr Errors danielvm HOWTO-Related Questions 0 31st October 2010 18:05
phpmyadmin errors happz Installation/Configuration 7 14th April 2010 17:32
Fedora 10 - Virtual Users And Domains With Postfix, Courier etc j.smith1981 Server Operation 6 17th February 2010 02:01
Phpmyadmin update error code 1? treavle Installation/Configuration 1 16th December 2009 14:35
Getting MySql errors after uninstalling phpMyAdmin ProgressiveBastion General 1 2nd July 2006 19:15


All times are GMT +2. The time now is 20:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.