Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th March 2010, 20:15
jnsc jnsc is offline
rotaredoM
 
Join Date: Mar 2006
Location: Lausanne, Switzerland
Posts: 531
Thanks: 11
Thanked 175 Times in 79 Posts
Default phpMyAdmin 3.3.0 default configuration

Hi,

In the phpMyAdmin package we had a huge configuration file with many options, but as it is quite difficult to maintain, I was trying to remove all the options that had the default value set. I checked every option, and now I want to discuss every option in this forum. There are not so much, so please give me your feedback, especially for the tricky ones. The default value and explanation can be found over here http://wiki.phpmyadmin.net/pma/Config, So here we GO:

$cfg['PmaAbsoluteUri'] = $go_info["server"]["server_url"].'/phpmyadmin/'; (Default is empty, and should work. As it's a package we know where it's gone be installed, but does someone know why we use this value?)

$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|pmadb|test)'; (Quite obvious, does someone want to change anything?)

$cfg['ServerDefault'] = 1; (We should not touch this one)

$cfg['DisplayDatabasesList'] = FALSE; (default value in 2.10.0, Has been changed to 'auto' since 2.11.0, what should we use?)

$cfg['DefaultTabDatabase'] = 'db_structure.php'; (Default is 'tbl_structure.php')

$cfg['DefaultTabDatabase'] = 'db_structure.php'; (Default is 'db_details_structure.php')

$cfg['Export']['csv_enclosed'] = '"'; we will use the default value as this is an error.

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en'; (Maybe we should use the new URL?)

$cfg['MySQLManualType'] = 'searchable'; (Default is 'viewable', which one should we choose?)

$cfg['DefaultPropDisplay'] = 3; (Since 2.10.0 the default is 'horizontal')

$cfg['AttributeTypes'] = array(
'',
'BINARY',
'UNSIGNED',
'UNSIGNED ZEROFILL'
); ('on update CURRENT_TIMESTAMP' has been added since 3.0.0)

In some other types we had 'HEX', 'UNHEX', they are not listed in the wiki should we keep them? why?

Now, the hard Part :
$cfg['DefaultLang'] = 'en-iso-8859-1'; (Since 3.0.0 'en-utf-8', which one, and why?)

$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci'; (Since 3.0.0 'utf8_general_ci', which one, and why?)

$cfg['DefaultCharset'] = 'iso-8859-1'; (Since 3.0.0 'en-utf-8', which one, and why?)

So thanks in advance for your input.

Last edited by jnsc; 10th March 2010 at 11:28.
Reply With Quote
The Following User Says Thank You to jnsc For This Useful Post:
till (10th March 2010)
Sponsored Links
  #2  
Old 10th March 2010, 10:23
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

I must say that I'am mostly a bit lazy when I install phpmyadmin manually somewhere, I just keep the default falues except of enabling authentication. So I'am not of a big help here. I hope someone which is more familar with these phpmyadmin settings can help you out here
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 10th March 2010, 11:27
jnsc jnsc is offline
rotaredoM
 
Join Date: Mar 2006
Location: Lausanne, Switzerland
Posts: 531
Thanks: 11
Thanked 175 Times in 79 Posts
Default

I got a reply for this one :
$cfg['Export']['csv_enclosed'] = '"';

This is an error, it maybe was replaced automatically by a texteditor.
Reply With Quote
  #4  
Old 16th March 2010, 10:21
jnsc jnsc is offline
rotaredoM
 
Join Date: Mar 2006
Location: Lausanne, Switzerland
Posts: 531
Thanks: 11
Thanked 175 Times in 79 Posts
Default

As I did not get many comments, here is my plan. I will wait until 3.3.1 is released (rc1 was released one week ago), and make a test package with default values except for $cfg['PmaAbsoluteUri'], $cfg['Servers'][$i]['hide_db'], $cfg['ServerDefault']

Is this ok for everybody?
Reply With Quote
The Following User Says Thank You to jnsc For This Useful Post:
falko (17th March 2010)
  #5  
Old 22nd January 2012, 08:46
linux-romania linux-romania is offline
Junior Member
 
Join Date: Nov 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Nice job !
However , ispconfig php should be instructed to symlink phpmyadmin and /webmail in every newly added site .
Aint nice to force clients to remeber server IP or server hostname to acces the above as http://xx.xx.xx.xx/webmail or phpmyadmin instead of their domains.
And yes , How do i enable clients to modify theis databases permissions ( Select , Alter , Insert )
As far as i can see , only sql root user can do that.
Reply With Quote
Reply

Bookmarks

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
All my mail is going to /var/mail/vmail _sluimers_ Installation/Configuration 21 10th January 2011 14:21
Intel 82815 Video Card & Ubuntu 8.10 harvey527 Kernel Questions 8 5th November 2010 15:51
Admin Program for Virtual Users and Domains Postfix courier etc...(Ubuntu 8.04)? the1rob HOWTO-Related Questions 11 4th August 2009 05:54
Postfix not responding to telnet CarbonCopy Server Operation 6 8th May 2009 06:39
Exim MTA dazblade Server Operation 4 16th July 2007 19:42


All times are GMT +2. The time now is 19:58.


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