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 17th January 2012, 22:15
djurhuus djurhuus is offline
Junior Member
 
Join Date: Nov 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multi Server setup and phpmyadmin

I haven't figured out how to get in contact with my mysql server through phpmyadmin.

My setup

web.my.domain (web/file server - master ISPConfig 3)
db.my.domain (mysql server)
mail.my.domain (mail server)
ns1.my.domain (dns server)
ns2.my.domain (dns server)

I can make databases on db.my.domain via master ISPConfig 3 interface but I can't contact the databases.
If I try in the ISPConfig 3 interface I hit the mysql on master ISPConfig 3 server which dosen't contain my databases - they are on the db.my.domain .
I can't go through db.my.domain/phpmyadmin while it seems like phpmyadmin isn't installed on db.my.domain!(I have used the Multiserver Setup With Dedicated Web, Email, DNS & MySQL Database Servers On Debian Squeeze With ISPConfig 3).
If I try via www.my.domain/phpmyadmin I will just hit the master ISPConfig 3 server again.

Is there something I missing here or have I totally missed how to contact my db.my.domain server using phpmyadmin ???

Regards
djurhuus
Reply With Quote
Sponsored Links
  #2  
Old 17th January 2012, 22:23
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 325
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

Well one way is to install phpmyadmin on the db server

The other one would be that you set it up correctly to work with a remote server, in this instance your db server
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3
Reply With Quote
  #3  
Old 17th January 2012, 22:30
djurhuus djurhuus is offline
Junior Member
 
Join Date: Nov 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It was my purpose to use phpmyadmin remotely on the db.my.domain.
I've followed the guide and can figure out what I'm doing wrong.

Have anybody got this to work - please tell me how it suppose to work.
Reply With Quote
  #4  
Old 17th January 2012, 22:36
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 325
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

Well thats my config for phpmyadmin

Code:
<?php
/* This is needed for cookie based authentication to encrypt password  */
$cfg['blowfish_secret'] = 'xuSdgfghjdfghfghdsfgdh'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
 
/* Servers configuration */
$i = 0;
 
/* 1 server */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'server1';
$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|phpmyadmin)';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';
 
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'password';
 
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

/* 2 server */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'server2';
$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|phpmyadmin)';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'password';
 
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

/* 3 server */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'server3';
$cfg['Servers'][$i]['hide_db'] = '(mysql|information_schema|phpmyadmin)';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'password';
 
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

$cfg['DisplayServersList']    = true;
$cfg['ThemeManager'] = false;
?>
But you have to remember that all dbs have to be accessible by the phpmyadmin server with the user (hint: remote_access)
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3
Reply With Quote
  #5  
Old 17th January 2012, 22:41
djurhuus djurhuus is offline
Junior Member
 
Join Date: Nov 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Where is your phpmyadmin config located?
Reply With Quote
  #6  
Old 17th January 2012, 22:44
Horfic Horfic is offline
Senior Member
 
Join Date: Mar 2009
Location: Austria
Posts: 325
Thanks: 55
Thanked 93 Times in 58 Posts
Send a message via Skype™ to Horfic
Default

In the phpmyadmin directory and the file is called config.inc.php when it isn't there just create it
__________________
web wack creations - We create your custom web application
Mailuser interface for ISPConfig 3
Reply With Quote
  #7  
Old 17th January 2012, 22:47
djurhuus djurhuus is offline
Junior Member
 
Join Date: Nov 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Super - I will try to compare the config.inc.php files tomorrow
Reply With Quote
  #8  
Old 19th January 2012, 21:36
PermaNoob PermaNoob is offline
Senior Member
 
Join Date: Jan 2007
Posts: 194
Thanks: 12
Thanked 5 Times in 5 Posts
Default

A lot easier to use adminer: http://www.adminer.org/#download

Just upload one file, http://downloads.sourceforge.net/adm...3-mysql-en.php, go to it in your web browser and login.

There was an error with logging in to php myadmin a long time ago and I started using adminer and used it ever since.

Last edited by PermaNoob; 19th January 2012 at 21:40.
Reply With Quote
  #9  
Old 11th July 2012, 22:56
flynns.br flynns.br is offline
Junior Member
 
Join Date: Oct 2011
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default Any one got it done??

Hi guys I'm having the same problem here too any one could help me?
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
Debian - The Perfect Server Setup micko_escalade Installation/Configuration 83 17th May 2011 21:52
Multi (Server, DB) PhpMyAdmin helfrez Installation/Configuration 0 3rd April 2011 04:19
phpmyadmin problem on ubuntu mail server virtual domains almeister9 HOWTO-Related Questions 1 19th September 2008 16:52
Moving to new server - lessons learned wpwood3 Tips/Tricks/Mods 0 5th November 2007 05:12
Single Server Setup mfiendd HOWTO-Related Questions 7 31st May 2006 21:32


All times are GMT +2. The time now is 18:23.


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